Company: Packt Publishing Author: Rob Percival, Jose Salvatierra Full Title: The Complete Python And PostgreSQL Developer Course Year: 2019 Language: English Genre: Educational: Web Development Skill Level: - Price: €112.99 - Files: MP4 Time: 21:32:50 Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 750 kbps Audio: AAC at 124 Kbps, 2 channels, 48.0 KHz Build 9 projects and master two essential and modern technologies: Python and PostgreSQL. This course will take you on a journey where you will learn and understand software and programming with Python from beginning to end. This course will take you from an absolute Python and PostgreSQL beginner to an experienced software developer. Python and SQL are used by many technology companies, small and large. That's because they are powerful, yet extremely flexible. Python is used in the industry for purposes such as embedded software, web development, desktop applications, and even mobile apps. PostgreSQL allows your applications to become even more powerful by storing, retrieving, and filtering large data sets easily. Style and Approach: This course adopts a practical approach whereby you'll learn about the core concepts of Angular and Laravel by building a real-world web application. Learn: ✓ Understand software and programming with Python from beginning to end ✓ Create Python applications ranging from beginner-level, basic applications to advanced, useful, and engaging applications ✓ Learn how to extend Python applications by using professional data storage: PostgreSQL ✓ Understand advanced concepts, such as data structures and algorithms, that are extremely useful in jobs and interviews Features: ✓ Learn to build projects in Python and PostgreSQL ✓ Learn to extend Python applications by using professional data storage: PostgreSQL. Lessons: 1. Installing Python 01. Introduction 02. Installing Python on Windows 03. Installing Python on Mac 2. Python 101 04. The Python interactive shell (IDLE) 05. Numbers and Strings in Python 06. Variables in Python 07. The str() method to convert to Strings 08. Running a Python file from the IDLE 09. Getting user input in Python 10. The int() method to convert to Integers 11. The format() method to simplify String formatting 3. Magic Numbers in Python 12. Lists in Python 13. The for loop in Python 14. Boolean expressions, True and False 15. If statements in Python 16. The 'in' keyword to check whether a list contains an element 17. Giving the user multiple chances in our program 18. Generating random integers in Python 19. Defining our own methods in Python 20. Returning values from our methods in Python 4. A Lottery app 21. The String split() method 22. List comprehension in Python 23. Python Sets - what is a Set? 24. Set comprehension in Python 25. Creating our lottery numbers 26. Calculating the lottery winnings 5. More complex applications: a student registration system 27. Installing PyCharm, a professional Python tool 28. Setting up PyCharm on Mac 29. Setting up PyCharm on Windows 30. Dictionaries in Python 31. Advanced Dictionary usage in Python 32. Methods returning dictionaries 33. Appending to a list in Python 34. Adding marks to our student data structure 35. The sum() method in Python 36. Iterating over a dictionary's keys and values 37. Creating the application menu 6. Object-Oriented Programming: a movie rental system 38. What are classes Classes in Python 39. The Movie Class 40. The User Class (and the __repr__ method) 41. The filter() method in Python 42. More Movie operations and methods 43. Writing to a file in Python 44. Saving CSV files with our data 45. Loading our data from CSV files 46. Saving JSON files with our data 47. Loading our data from JSON files 48. Argument unpacking in Python (the two asterisks) 49. Creating the menu for our application 7. Introduction to PostgreSQL 50. Introduction to databases 51. Installing PostgreSQL on Windows 52. Using PostgreSQL on Windows 53. Executing SQL queries on Windows 54. Installing PostgreSQL on Mac 55. Using PostgreSQL on Mac 56. Executing SQL commands on Mac 57. Using the sample data provided 58. SQL: The SELECT command 59. SQL: filtering with WHERE 60. SQL: LIMIT for limiting the number of results 61. SQL: UPDATE data in a table 62. SQL: DELETE data from a table 63. SQL: Wildcards for filtering unknowns 64. What is a JOIN? 65. SQL: JOINs and JOIN examples 66. SQL: GROUP BY for aggregation of data 67. SQL: ORDER BY for sorting data 68. SQL: CREATE TABLE 69. SQL: INSERT INTO for adding data to a table 70. SQL: SEQUENCE for auto-incrementing fields 71. SQL: CREATE INDEX and advanced information about indexes 72. SQL: DROP TABLE for deleting tables and data 8. Advanced PostgreSQL 73. SQL: VIEWs and what they are used for.mp4 74. SQL: built-in functions and the HAVING construct 75. Dates in SQL: an old problem 76. Other data types in SQL (including JSON in PostgreSQL) 77. Nested SELECT statements for complex queries 78. The PostgreSQL SERIAL type 9. Python and PostgreSQL 79. Installing psycopg2 on Windows (2018 update) 80. Installing psycopg2 on Windows (older versions) 81. Installing psycopg2 on Mac 82. Verifying everything works—don't proceed if it doesn't! 83. Mac OS X: Fixing psycopg2 'library not loaded' error 84. What is a virtual environment? 85. psycopg2 on a virtualenv on Windows (2018 update) 86. Psycopg2 on a virtualenv on Windows (older versions) 87. Setting up the app structure, pip, and requirements.txt 88. Recap on classes and object-oriented programming 89. Saving to database from Python 90. Loading from the database from Python 91. Removing some duplicate code from our app 92. Connection pooling and why it is important 93. Creating the ConnectionPool class 94. Creating the ConnectionFromPool class 95. Obtaining a cursor from the ConnectionFromPool class 96. The Database class and selective initialisation 97. Cleaning up the Database class 98. End of section review 10. Python Web and APIs 099. What is an API?? 100. Making requests in Python 101. What is OAuth? 102. Creating a Twitter app 103. Setting up Twitter login 104. Getting the OAuth request token 105. More on the Python debugger—an essential tool 106. Getting authorization by the user 107. Getting the OAuth access token 108. Performing Twitter requests: getting images 109. Reusing code from the last section to save users 110. Creating users in our app 111. Retrieving users in our app 112. Cleaning up the code—extremely important! 113. Introduction to Flask and Python Web Development 114. Adding a Twitter login endpoint 115. Creating the user profile 116. The Flask before_request decorator 117. Checking if a user is already logged in 118. Searching tweets and displaying them 119. Searching for different things 120. What is Bootstrap? 121. Writing our own CSS 122. Allowing users to perform custom searches 123. Adding sentiment analysis with another API 11. Introduction to Git and GitHub 124. What is Git? 125. Installing Git on Mac and Windows 126. Introduction to the UNIX terminal 127. The VIM text editor, a powerful terminal editor 128. Dealing with files in the UNIX terminal 129. What is a Git repository? 130. git init — create a Git repository 131. git add and git commit — staging and committing 132. git log — viewing past commits 133. Creating a repository on GitHub 134. git remote — managing remote repositories 135. Adding your SSH key to GitHub 136. What is a README file? Introduction to Markdown 137. git pull — pulling other's changes 12. Advanced Python 138. OOP Inheritance 139. OOP: Multiple Inheritance in Python 140. OOP: What is composition? 141. OOP: What is encapsulation? 142. Introduction to Exceptions in Python 143. Creating our own Exceptions 144. Some of the available built-in Exceptions 145. Python built-in methods 146. Assertions in Python 147. Lambda expressions in Python 148. More uses of lambda expressions 149. Lambda expressions in the wild 150. Introduction to unit testing with unittest 13. Data Structures and Algorithms 151. What are data structures? 152. What is a Linked List? 153. Introduction to Linked List Assignment 154. Programming our own Linked List in Python 155. Creating a Queue 156. Introduction to Queue Assignment 157. Programming our own Queue in Python 158. Creating a Stack 159. Introduction to Stack Assignment 160. Programming our own Stack in Python 161. Creating a Binary Tree 162. Introduction to Binary Tree Assignment 163. Programming our own Binary Tree in Python Damnant quod non intellegunt! ------------- Damnant quod non intellegunt!