GigaCourse com Udemy - The Complete Python & PostgreSQL Developer Course

1. 1. Installing Python/1. Introduction.mp46.9MB
2. 1. Installing Python/2. Installing Python on Windows.mp46.77MB
3. 1. Installing Python/3. Installing Python on Mac.mp44.01MB
4. 10. Python Web and APIs/1. What is an API.mp445.46MB
5. 10. Python Web and APIs/10. Performing Twitter requests getting images.mp450.75MB
6. 10. Python Web and APIs/11. Reusing code from the last section to save users.mp430.77MB
7. 10. Python Web and APIs/12. Creating users in our app.mp424.11MB
8. 10. Python Web and APIs/13. Retrieving users in our app.mp444.93MB
9. 10. Python Web and APIs/14. Cleaning up the code—extremely important!.mp457MB
10. 10. Python Web and APIs/15. Introduction to Flask and Python Web Development.mp434.09MB
11. 10. Python Web and APIs/16. Adding a Twitter login endpoint.mp425.24MB
12. 10. Python Web and APIs/17. Adding Twitter authorization.mp459.98MB
13. 10. Python Web and APIs/18. Creating the user profile.mp423.38MB
14. 10. Python Web and APIs/19. The Flask before_request decorator.mp424.24MB
15. 10. Python Web and APIs/2. Making requests in Python.mp429.58MB
16. 10. Python Web and APIs/20. Checking if a user is already logged in.mp48.48MB
17. 10. Python Web and APIs/21. Searching tweets and displaying them.mp419.51MB
18. 10. Python Web and APIs/22. Searching for different things.mp410.12MB
19. 10. Python Web and APIs/23. What is Bootstrap.mp424.77MB
20. 10. Python Web and APIs/24. Writing our own CSS.mp415.18MB
21. 10. Python Web and APIs/25. Allowing users to perform custom searches.mp416.7MB
22. 10. Python Web and APIs/26. Adding sentiment analysis with another API.mp437.25MB
23. 10. Python Web and APIs/3. What is OAuth.mp414.67MB
24. 10. Python Web and APIs/4. Creating a Twitter app.mp411.56MB
25. 10. Python Web and APIs/5. Setting up Twitter login.mp411.76MB
26. 10. Python Web and APIs/6. Getting the OAuth request token.mp436.47MB
27. 10. Python Web and APIs/7. More on the Python debugger—an essential tool.mp414.26MB
28. 10. Python Web and APIs/8. Getting authorization by the user.mp421.3MB
29. 10. Python Web and APIs/9. Getting the OAuth access token.mp417.97MB
30. 11. Introduction to Git and GitHub/1. What is Git.mp412.78MB
31. 11. Introduction to Git and GitHub/10. Creating a repository on GitHub.mp47.75MB
32. 11. Introduction to Git and GitHub/11. git remote — managing remote repositories.mp47.02MB
33. 11. Introduction to Git and GitHub/12. Adding your SSH key to GitHub.mp414.03MB
34. 11. Introduction to Git and GitHub/13. What is a README file Introduction to Markdown.mp416.02MB
35. 11. Introduction to Git and GitHub/14. git pull — pulling other's changes.mp46.28MB
36. 11. Introduction to Git and GitHub/2. Installing Git on Mac and Windows.mp423.04MB
37. 11. Introduction to Git and GitHub/3. Introduction to the UNIX terminal.mp414.84MB
38. 11. Introduction to Git and GitHub/4. The VIM text editor, a powerful terminal editor.mp410.92MB
39. 11. Introduction to Git and GitHub/5. Dealing with files in the UNIX terminal.mp47.74MB
40. 11. Introduction to Git and GitHub/6. What is a Git repository.mp411.79MB
41. 11. Introduction to Git and GitHub/7. git init — create a Git repository.mp47.92MB
42. 11. Introduction to Git and GitHub/8. git add and git commit — staging and committing.mp418.22MB
43. 11. Introduction to Git and GitHub/9. git log — viewing past commits.mp44.93MB
44. 12. Advanced Python/1. OOP Inheritance.mp430.39MB
45. 12. Advanced Python/10. Lambda expressions in Python.mp416.85MB
46. 12. Advanced Python/11. More uses of lambda expressions.mp421.01MB
47. 12. Advanced Python/12. Lambda expressions in the wild.mp440.18MB
48. 12. Advanced Python/13. Introduction to unit testing with unittest.mp448.97MB
49. 12. Advanced Python/2. OOP Multiple Inheritance in Python.mp412.12MB
50. 12. Advanced Python/3. OOP What is composition.mp49.66MB
51. 12. Advanced Python/4. OOP What is encapsulation.mp436.38MB
52. 12. Advanced Python/5. Introduction to Exceptions in Python.mp426.34MB
53. 12. Advanced Python/6. Creating our own Exceptions.mp416.77MB
54. 12. Advanced Python/7. Some of the available built-in Exceptions.mp415.02MB
55. 12. Advanced Python/8. Python built-in methods.mp446.96MB
56. 12. Advanced Python/9. Assertions in Python.mp415.95MB
57. 13. Data Structures and Algorithms/1. What are data structures.mp411.79MB
58. 13. Data Structures and Algorithms/10. Creating a Stack.mp48.04MB
59. 13. Data Structures and Algorithms/11. Introduction to Stack Assignment.mp413.55MB
60. 13. Data Structures and Algorithms/13. Programming our own Stack in Python.mp417.54MB
61. 13. Data Structures and Algorithms/14. Creating a Binary Tree.mp416.29MB
62. 13. Data Structures and Algorithms/15. Introduction to Binary Tree Assignment.mp417.7MB
63. 13. Data Structures and Algorithms/17. Programming our own Binary Tree in Python.mp421.19MB
64. 13. Data Structures and Algorithms/2. What is a Linked List.mp418.39MB
65. 13. Data Structures and Algorithms/3. Introduction to Linked List Assignment.mp423.64MB
66. 13. Data Structures and Algorithms/5. Programming our own Linked List in Python.mp420.01MB
67. 13. Data Structures and Algorithms/6. Creating a Queue.mp413.45MB
68. 13. Data Structures and Algorithms/7. Introduction to Queue Assignment.mp425.68MB
69. 13. Data Structures and Algorithms/9. Programming our own Queue in Python.mp433.61MB
70. 2. Python 101/10. The format() method to simplify String formatting.mp414.8MB
71. 2. Python 101/3. The Python interactive shell (IDLE).mp46.75MB
72. 2. Python 101/4. Numbers and Strings in Python.mp49.88MB
73. 2. Python 101/5. Variables in Python.mp411.33MB
74. 2. Python 101/6. The str() method to convert to Strings.mp47.6MB
75. 2. Python 101/7. Running a Python file from the IDLE.mp411.74MB
76. 2. Python 101/8. Getting user input in Python.mp410.54MB
77. 2. Python 101/9. The int() method to convert to Integers.mp45.44MB
78. 3. Magic Numbers in Python/1. Lists in Python.mp49.91MB
79. 3. Magic Numbers in Python/2. The for loop in Python.mp46.98MB
80. 3. Magic Numbers in Python/3. Boolean expressions, True and False.mp410.99MB
81. 3. Magic Numbers in Python/4. If statements in Python.mp49.42MB
82. 3. Magic Numbers in Python/5. The 'in' keyword to check whether a list contains an element.mp49.94MB
83. 3. Magic Numbers in Python/6. Giving the user multiple chances in our program.mp419.48MB
84. 3. Magic Numbers in Python/7. Generating random integers in Python.mp419.36MB
85. 3. Magic Numbers in Python/8. Defining our own methods in Python.mp416.93MB
86. 3. Magic Numbers in Python/9. Returning values from our methods in Python.mp412.37MB
87. 4. A Lottery app/1. The String split() method.mp47.42MB
88. 4. A Lottery app/2. List comprehension in Python.mp413.22MB
89. 4. A Lottery app/3. Python Sets — what is a Set.mp414.69MB
90. 4. A Lottery app/4. Set comprehension in Python.mp411.98MB
91. 4. A Lottery app/5. Creating our lottery numbers.mp417.86MB
92. 4. A Lottery app/6. Calculating the lottery winnings.mp415.83MB
93. 5. More complex applications a student registration system/1. Installing PyCharm, a professional Python tool.mp47.76MB
94. 5. More complex applications a student registration system/10. Iterating over a list and using the dictionaries inside it.mp414.02MB
95. 5. More complex applications a student registration system/11. Creating the application menu.mp433.72MB
96. 5. More complex applications a student registration system/2. Setting up PyCharm on Mac.mp425.36MB
97. 5. More complex applications a student registration system/3. Setting up PyCharm on Windows.mp448.41MB
98. 5. More complex applications a student registration system/4. Dictionaries in Python.mp418.47MB
99. 5. More complex applications a student registration system/5. Advanced Dictionary usage in Python.mp415.86MB
100. 5. More complex applications a student registration system/6. Methods returning dictionaries.mp415.36MB
101. 5. More complex applications a student registration system/7. Appending to a list in Python.mp411.5MB
102. 5. More complex applications a student registration system/8. Adding marks to our student data structure.mp418.24MB
103. 5. More complex applications a student registration system/9. The sum() method in Python.mp417.6MB
104. 6. Object-Oriented Programming a movie rental system/1. What are classes Classes in Python.mp427.9MB
105. 6. Object-Oriented Programming a movie rental system/10. Saving JSON files with our data.mp415.15MB
106. 6. Object-Oriented Programming a movie rental system/11. Loading our data from JSON files.mp419.21MB
107. 6. Object-Oriented Programming a movie rental system/12. Argument unpacking in Python (the two asterisks).mp413.06MB
108. 6. Object-Oriented Programming a movie rental system/13. Creating the menu for our application.mp437.72MB
109. 6. Object-Oriented Programming a movie rental system/2. The Movie Class.mp419.94MB
110. 6. Object-Oriented Programming a movie rental system/3. The User Class (and the __repr__ method).mp413.74MB
111. 6. Object-Oriented Programming a movie rental system/4. The filter() method in Python.mp420.13MB
112. 6. Object-Oriented Programming a movie rental system/5. More Movie operations and methods.mp414.72MB
113. 6. Object-Oriented Programming a movie rental system/6. Writing to a file in Python.mp49.5MB
114. 6. Object-Oriented Programming a movie rental system/7. Saving CSV files with our data.mp421.48MB
115. 6. Object-Oriented Programming a movie rental system/8. Loading our data from CSV files.mp428.23MB
116. 7. Introduction to PostgreSQL/1. Introduction to databases.mp423.91MB
117. 7. Introduction to PostgreSQL/10. SQL filtering with WHERE.mp48.52MB
118. 7. Introduction to PostgreSQL/11. SQL LIMIT for limiting the number of results.mp44.03MB
119. 7. Introduction to PostgreSQL/12. SQL UPDATE data in a table.mp410.74MB
120. 7. Introduction to PostgreSQL/13. SQL DELETE data from a table.mp49.2MB
121. 7. Introduction to PostgreSQL/14. SQL Wildcards for filtering unknowns.mp49.71MB
122. 7. Introduction to PostgreSQL/15. What is a JOIN.mp426.07MB
123. 7. Introduction to PostgreSQL/16. SQL JOINs and JOIN examples.mp419.09MB
124. 7. Introduction to PostgreSQL/17. SQL GROUP BY for aggregation of data.mp417.9MB
125. 7. Introduction to PostgreSQL/18. SQL ORDER BY for sorting data.mp49.86MB
126. 7. Introduction to PostgreSQL/19. SQL CREATE TABLE.mp420.75MB
127. 7. Introduction to PostgreSQL/2. Installing PostgreSQL on Windows.mp411.55MB
128. 7. Introduction to PostgreSQL/20. SQL INSERT INTO for adding data to a table.mp418.02MB
129. 7. Introduction to PostgreSQL/21. SQL SEQUENCE for auto-incrementing fields.mp412.69MB
130. 7. Introduction to PostgreSQL/22. SQL CREATE INDEX and advanced information about indexes.mp421.07MB
131. 7. Introduction to PostgreSQL/23. SQL DROP TABLE for deleting tables and data.mp411.69MB
132. 7. Introduction to PostgreSQL/3. Using PostgreSQL on Windows.mp415.94MB
133. 7. Introduction to PostgreSQL/4. Executing SQL queries on Windows.mp45.4MB
134. 7. Introduction to PostgreSQL/5. Installing PostgreSQL on Mac.mp412.8MB
135. 7. Introduction to PostgreSQL/6. Using PostgreSQL on Mac.mp418.45MB
136. 7. Introduction to PostgreSQL/7. Executing SQL commands on Mac.mp43.78MB
137. 7. Introduction to PostgreSQL/8. Using the sample data provided.mp48.53MB
138. 7. Introduction to PostgreSQL/9. SQL The SELECT command.mp414.34MB
139. 8. Advanced PostgreSQL/1. SQL VIEWs and what they are used for.mp436.65MB
140. 8. Advanced PostgreSQL/2. SQL built-in functions and the HAVING construct.mp421.72MB
141. 8. Advanced PostgreSQL/3. Dates in SQL an old problem.mp425.5MB
142. 8. Advanced PostgreSQL/4. Other data types in SQL (including JSON in PostgreSQL).mp419.57MB
143. 8. Advanced PostgreSQL/5. Nested SELECT statements for complex queries.mp418.24MB
144. 8. Advanced PostgreSQL/6. The PostgreSQL SERIAL type.mp46.6MB
145. 9. Python and PostgreSQL/1. Installing psycopg2 on Windows (2018 update).mp448.36MB
146. 9. Python and PostgreSQL/10. Recap on classes and object-oriented programming.mp420.38MB
147. 9. Python and PostgreSQL/11. Saving to database from Python.mp438.76MB
148. 9. Python and PostgreSQL/12. Loading from the database from Python.mp436.43MB
149. 9. Python and PostgreSQL/13. Removing some duplicate code from our app.mp411.65MB
150. 9. Python and PostgreSQL/14. Connection pooling and why it is important.mp432.08MB
151. 9. Python and PostgreSQL/15. Creating the ConnectionPool class.mp423.24MB
152. 9. Python and PostgreSQL/16. Creating the ConnectionFromPool class.mp423.2MB
153. 9. Python and PostgreSQL/17. Obtaining a cursor from the ConnectionFromPool class.mp420.26MB
154. 9. Python and PostgreSQL/18. The Database class and selective initialisation.mp445.08MB
155. 9. Python and PostgreSQL/19. Cleaning up the Database class.mp415.85MB
156. 9. Python and PostgreSQL/20. End of section review.mp410.08MB
157. 9. Python and PostgreSQL/3. Installing psycopg2 on Mac.mp410.3MB
158. 9. Python and PostgreSQL/4. Verifying everything works—don't proceed if it doesn't!.mp47.61MB
159. 9. Python and PostgreSQL/5. Mac OS X Fixing psycopg2 'library not loaded' error.mp412MB
160. 9. Python and PostgreSQL/6. What is a virtual environment.mp425.55MB
161. 9. Python and PostgreSQL/7. psycopg2 on a virtualenv on Windows (2018 update).mp441.64MB
162. 9. Python and PostgreSQL/8. Psycopg2 on a virtualenv on Windows (older versions).mp416.58MB
163. 9. Python and PostgreSQL/9. Setting up the app structure, pip, and requirements.txt.mp49.54MB