589689.xyz

[Udemy] Полный Python PostgreSQL Курс 2.0 (2020)

  • 收录时间:2020-09-11 05:17:14
  • 文件大小:5GB
  • 下载次数:31
  • 最近下载:2021-01-04 04:30:43
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 6. Building a Poll App & Advanced SQL/15. How to read the PostgreSQL documentation.mp4 116MB
  2. 2. A Full Python Refresher/25. Object-Oriented Programming in Python.mp4 90MB
  3. 2. A Full Python Refresher/33. Errors in Python.mp4 88MB
  4. 2. A Full Python Refresher/27. @classmethod and @staticmethod.mp4 81MB
  5. 6. Building a Poll App & Advanced SQL/14. SQL VIEW virtual tables.mp4 79MB
  6. 7. Working with dates and times/4. Changes needed in app.py.mp4 75MB
  7. 7. Working with dates and times/11. How to handle timezones with pytz.mp4 72MB
  8. 6. Building a Poll App & Advanced SQL/7. GROUP BY and calculating vote percentages.mp4 69MB
  9. 5. Introduction to PostgreSQL Migrating our App/4. psycopg2 vs psycopg2-binary.mp4 68MB
  10. 4. A Movie Watchlist App with Python & SQL/16. Stage 3 adding new watched movies.mp4 65MB
  11. 7. Working with dates and times/13. Add the vote date to our polling app.mp4 65MB
  12. 4. A Movie Watchlist App with Python & SQL/8. Write our user menu and functions.mp4 63MB
  13. 7. Working with dates and times/3. Changes needed in database.py.mp4 63MB
  14. 7. Working with dates and times/1. How to separate our database entities into models.mp4 62MB
  15. 6. Building a Poll App & Advanced SQL/3. Essential queries we'll need for this project.mp4 59MB
  16. 3. Build a Programming Journal with Python & SQL/9. How to connect to a SQLite database with Python.mp4 59MB
  17. 2. A Full Python Refresher/31. Imports in Python.mp4 58MB
  18. 3. Build a Programming Journal with Python & SQL/4. Using Python lists as an in-memory database.mp4 58MB
  19. 9. Charting data from our tables using matplotlib/8. How to draw a pie chart with matplotlib.mp4 57MB
  20. 2. A Full Python Refresher/32. Relative imports in Python.mp4 54MB
  21. 5. Introduction to PostgreSQL Migrating our App/5. How to store (and not store!) sensitive information in your code.mp4 54MB
  22. 8. Python and Advanced PostgreSQL with psycopg2/6. Locking in PostgreSQL.mp4 54MB
  23. 2. A Full Python Refresher/28. Class inheritance.mp4 54MB
  24. 2. A Full Python Refresher/13. Loops in Python.mp4 53MB
  25. 4. A Movie Watchlist App with Python & SQL/12. Stage 2 watching movies.mp4 53MB
  26. 6. Building a Poll App & Advanced SQL/16. Adding type hinting to our application.mp4 52MB
  27. 4. A Movie Watchlist App with Python & SQL/20. Use JOINs to retrieve the movies a user has watched.mp4 52MB
  28. 6. Building a Poll App & Advanced SQL/5. Nested queries getting the latest poll.mp4 52MB
  29. 2. A Full Python Refresher/23. Unpacking arguments.mp4 51MB
  30. 6. Building a Poll App & Advanced SQL/8. PostgreSQL window functions.mp4 51MB
  31. 4. A Movie Watchlist App with Python & SQL/24. LIKE flexible searching.mp4 50MB
  32. 2. A Full Python Refresher/36. Simple decorators in Python.mp4 50MB
  33. 3. Build a Programming Journal with Python & SQL/18. WHERE search with SQL.mp4 50MB
  34. 2. A Full Python Refresher/35. First-class functions.mp4 49MB
  35. 8. Python and Advanced PostgreSQL with psycopg2/3. Composite types and sets in functions.mp4 46MB
  36. 6. Building a Poll App & Advanced SQL/12. SQL DISTINCT and DISTINCT ON.mp4 45MB
  37. 2. A Full Python Refresher/24. Unpacking keyword arguments.mp4 45MB
  38. 2. A Full Python Refresher/10. If statements.mp4 45MB
  39. 2. A Full Python Refresher/17. Functions in Python.mp4 45MB
  40. 3. Build a Programming Journal with Python & SQL/3. What is SQL.mp4 44MB
  41. 8. Python and Advanced PostgreSQL with psycopg2/2. User-defined functions in PostgreSQL.mp4 43MB
  42. 2. A Full Python Refresher/12. If statements with the in keyword.mp4 42MB
  43. 6. Building a Poll App & Advanced SQL/4. RETURNING data from modified rows.mp4 42MB
  44. 2. A Full Python Refresher/34. Custom error classes.mp4 42MB
  45. 4. A Movie Watchlist App with Python & SQL/5. Write the database.py file.mp4 42MB
  46. 3. Build a Programming Journal with Python & SQL/11. What is a cursor.mp4 42MB
  47. 1. Introduction/1. Welcome to this course!.mp4 40MB
  48. 7. Working with dates and times/12. How to save dates to PostgreSQL.mp4 40MB
  49. 2. A Full Python Refresher/21. Lambda functions in Python.mp4 39MB
  50. 2. A Full Python Refresher/18. Function arguments and parameters.mp4 38MB
  51. 3. Build a Programming Journal with Python & SQL/17. Retrieving results from a cursor.mp4 38MB
  52. 3. Build a Programming Journal with Python & SQL/5. A SQLite data viewer.mp4 38MB
  53. 6. Building a Poll App & Advanced SQL/9. PostgreSQL window functions (part 2).mp4 38MB
  54. 4. A Movie Watchlist App with Python & SQL/25. What is an index in SQL.mp4 37MB
  55. 7. Working with dates and times/7. Reduce pooling duplication with context managers.mp4 37MB
  56. 2. A Full Python Refresher/26. Magic methods _str_ and _repr_.mp4 37MB
  57. 2. A Full Python Refresher/15. Dictionaries.mp4 36MB
  58. 2. A Full Python Refresher/39. Decorators with parameters.mp4 36MB
  59. 6. Building a Poll App & Advanced SQL/6. SQL built-in functions.mp4 36MB
  60. 3. Build a Programming Journal with Python & SQL/14. How to insert data into SQLite with Python.mp4 36MB
  61. 9. Charting data from our tables using matplotlib/12. How to draw a stacked bar chart with matplotlib.mp4 35MB
  62. 2. A Full Python Refresher/20. Functions returning values.mp4 35MB
  63. 2. A Full Python Refresher/29. Class composition.mp4 35MB
  64. 9. Charting data from our tables using matplotlib/14. How to export an image with matplotlib.mp4 34MB
  65. 2. A Full Python Refresher/16. Destructuring variables.mp4 34MB
  66. 6. Building a Poll App & Advanced SQL/2. What is ACID.mp4 34MB
  67. 5. Introduction to PostgreSQL Migrating our App/6. Psycopg2 cursors and query parameters.mp4 34MB
  68. 4. A Movie Watchlist App with Python & SQL/2. Three development stages of our project.mp4 33MB
  69. 2. A Full Python Refresher/3. Variables in Python.mp4 32MB
  70. 2. A Full Python Refresher/30. Type hinting in Python 3.5+.mp4 32MB
  71. 7. Working with dates and times/6. How to create a connection pool with psycopg2.mp4 31MB
  72. 8. Python and Advanced PostgreSQL with psycopg2/4. Stored procedures in PostgreSQL.mp4 31MB
  73. 7. Working with dates and times/9. The Python datetime module.mp4 31MB
  74. 2. A Full Python Refresher/14. List comprehensions in Python.mp4 31MB
  75. 5. Introduction to PostgreSQL Migrating our App/1. SQLite vs. PostgreSQL.mp4 31MB
  76. 6. Building a Poll App & Advanced SQL/11. How to use PARTITION with window functions.mp4 31MB
  77. 7. Working with dates and times/5. What is connection pooling.mp4 30MB
  78. 4. A Movie Watchlist App with Python & SQL/17. Auto-incrementing row IDs.mp4 29MB
  79. 2. A Full Python Refresher/37. The 'at' syntax for decorators.mp4 29MB
  80. 4. A Movie Watchlist App with Python & SQL/26. Adding an index to our table for more efficient searching.mp4 28MB
  81. 3. Build a Programming Journal with Python & SQL/6. CREATE TABLE new tables with SQL.mp4 28MB
  82. 8. Python and Advanced PostgreSQL with psycopg2/8. SQL string composition with psycopg2.mp4 28MB
  83. 2. A Full Python Refresher/4. String formatting in Python.mp4 28MB
  84. 3. Build a Programming Journal with Python & SQL/12. INSERT INTO add data to a table.mp4 28MB
  85. 6. Building a Poll App & Advanced SQL/10. How to use ORDER BY with window functions.mp4 28MB
  86. 4. A Movie Watchlist App with Python & SQL/13. Relational data primary and foreign keys.mp4 28MB
  87. 4. A Movie Watchlist App with Python & SQL/6. UPDATE changing data with SQL.mp4 28MB
  88. 7. Working with dates and times/2. Creating our Option model class.mp4 26MB
  89. 2. A Full Python Refresher/7. Lists, tuples and sets.mp4 26MB
  90. 9. Charting data from our tables using matplotlib/11. How to adjust the x axis tick labels so they fit in the screen.mp4 26MB
  91. 3. Build a Programming Journal with Python & SQL/2. Creating our user menu.mp4 26MB
  92. 8. Python and Advanced PostgreSQL with psycopg2/7. Asynchronous psycopg2.mp4 26MB
  93. 9. Charting data from our tables using matplotlib/9. How to draw a bar chart with matplotlib.mp4 26MB
  94. 2. A Full Python Refresher/40. Mutability in Python.mp4 25MB
  95. 2. A Full Python Refresher/22. Dictionary comprehensions.mp4 24MB
  96. 3. Build a Programming Journal with Python & SQL/22. What is a SQL injection attack.mp4 24MB
  97. 8. Python and Advanced PostgreSQL with psycopg2/5. Connections vs transactions in psycopg2.mp4 24MB
  98. 6. Building a Poll App & Advanced SQL/1. Overview of the project.mp4 24MB
  99. 4. A Movie Watchlist App with Python & SQL/4. Queries we'll need for the project to begin with.mp4 23MB
  100. 2. A Full Python Refresher/9. Booleans in Python.mp4 23MB
  101. 7. Working with dates and times/8. Reduce cursor creation duplication with context managers.mp4 23MB
  102. 4. A Movie Watchlist App with Python & SQL/19. JOIN access two tables at once with SQL.mp4 23MB
  103. 2. A Full Python Refresher/41. Mutable default parameters (and why they're a bad idea).mp4 22MB
  104. 2. A Full Python Refresher/5. Getting user input.mp4 22MB
  105. 2. A Full Python Refresher/1. Introduction to this section.mp4 20MB
  106. 2. A Full Python Refresher/8. Advanced set operations.mp4 20MB
  107. 9. Charting data from our tables using matplotlib/16. How to create a custom legend with matplotlib.mp4 20MB
  108. 5. Introduction to PostgreSQL Migrating our App/2. How to install PostgreSQL.mp4 20MB
  109. 9. Charting data from our tables using matplotlib/7. How to add multiple subplots to a figure.mp4 20MB
  110. 3. Build a Programming Journal with Python & SQL/1. Overview of the project.mp4 19MB
  111. 8. Python and Advanced PostgreSQL with psycopg2/1. Composite primary keys.mp4 19MB
  112. 4. A Movie Watchlist App with Python & SQL/15. Watched movies final approach.mp4 19MB
  113. 7. Working with dates and times/10. How to calculate new dates with timedelta.mp4 19MB
  114. 3. Build a Programming Journal with Python & SQL/15. SELECT retrieve data from a table.mp4 18MB
  115. 2. A Full Python Refresher/19. Default parameter values.mp4 18MB
  116. 9. Charting data from our tables using matplotlib/6. The Object-Oriented Approach with matplotlib.mp4 17MB
  117. 9. Charting data from our tables using matplotlib/10. How to adjust the size of a matplotlib plot.mp4 17MB
  118. 9. Charting data from our tables using matplotlib/5. Matplotlib figures, axes, and plots.mp4 17MB
  119. 9. Charting data from our tables using matplotlib/3. How to draw a line graph with matplotlib.mp4 17MB
  120. 4. A Movie Watchlist App with Python & SQL/1. Overview of the project.mp4 17MB
  121. 2. A Full Python Refresher/6. Writing our first Python app.mp4 16MB
  122. 3. Build a Programming Journal with Python & SQL/10. Connecting to SQLite in our app.mp4 16MB
  123. 5. Introduction to PostgreSQL Migrating our App/8. Our changed code, and finding differences between files.mp4 16MB
  124. 5. Introduction to PostgreSQL Migrating our App/3. How to run and access PostgreSQL.mp4 16MB
  125. 9. Charting data from our tables using matplotlib/1. Overview creating graphs from poll data.mp4 15MB
  126. 4. A Movie Watchlist App with Python & SQL/10. DELETE FROM removing rows with SQL.mp4 15MB
  127. 2. A Full Python Refresher/38. Decorating functions with parameters.mp4 14MB
  128. 9. Charting data from our tables using matplotlib/13. How to create a legend from your graphed data.mp4 14MB
  129. 4. A Movie Watchlist App with Python & SQL/22. ORDER BY sort the returned table.mp4 13MB
  130. 6. Building a Poll App & Advanced SQL/13. The SQL HAVING clause.mp4 13MB
  131. 9. Charting data from our tables using matplotlib/15. How to create one document with multiple matplotlib plots.mp4 13MB
  132. 5. Introduction to PostgreSQL Migrating our App/7. Auto-incrementing columns SEQUENCE and SERIAL in PostgreSQL.mp4 13MB
  133. 3. Build a Programming Journal with Python & SQL/20. DROP TABLE deleting entire tables.mp4 12MB
  134. 2. A Full Python Refresher/11. The in keyword in Python.mp4 11MB
  135. 4. A Movie Watchlist App with Python & SQL/9. Watched movies second approach.mp4 8MB
  136. 4. A Movie Watchlist App with Python & SQL/23. LIMIT getting a certain number of rows.mp4 8MB
  137. 4. A Movie Watchlist App with Python & SQL/3. Our starting code for this project.mp4 7MB
  138. 8. Python and Advanced PostgreSQL with psycopg2/6.2 PostgreSQL Conflicting Lock Modes.png 111KB
  139. 2. A Full Python Refresher/25. Object-Oriented Programming in Python.srt 28KB
  140. 2. A Full Python Refresher/27. @classmethod and @staticmethod.srt 28KB
  141. 9. Charting data from our tables using matplotlib/8. How to draw a pie chart with matplotlib.srt 27KB
  142. 3. Build a Programming Journal with Python & SQL/4. Using Python lists as an in-memory database.srt 26KB
  143. 4. A Movie Watchlist App with Python & SQL/8. Write our user menu and functions.srt 25KB
  144. 2. A Full Python Refresher/33. Errors in Python.srt 24KB
  145. 6. Building a Poll App & Advanced SQL/7. GROUP BY and calculating vote percentages.srt 24KB
  146. 5. Introduction to PostgreSQL Migrating our App/4. psycopg2 vs psycopg2-binary.srt 23KB
  147. 7. Working with dates and times/1. How to separate our database entities into models.srt 23KB
  148. 7. Working with dates and times/4. Changes needed in app.py.srt 23KB
  149. 2. A Full Python Refresher/13. Loops in Python.srt 23KB
  150. 2. A Full Python Refresher/17. Functions in Python.srt 21KB
  151. 7. Working with dates and times/11. How to handle timezones with pytz.srt 20KB
  152. 6. Building a Poll App & Advanced SQL/3. Essential queries we'll need for this project.srt 20KB
  153. 8. Python and Advanced PostgreSQL with psycopg2/6. Locking in PostgreSQL.srt 20KB
  154. 6. Building a Poll App & Advanced SQL/14. SQL VIEW virtual tables.srt 19KB
  155. 8. Python and Advanced PostgreSQL with psycopg2/2. User-defined functions in PostgreSQL.srt 19KB
  156. 2. A Full Python Refresher/23. Unpacking arguments.srt 18KB
  157. 5. Introduction to PostgreSQL Migrating our App/5. How to store (and not store!) sensitive information in your code.srt 18KB
  158. 2. A Full Python Refresher/31. Imports in Python.srt 18KB
  159. 4. A Movie Watchlist App with Python & SQL/20. Use JOINs to retrieve the movies a user has watched.srt 17KB
  160. 7. Working with dates and times/13. Add the vote date to our polling app.srt 17KB
  161. 4. A Movie Watchlist App with Python & SQL/16. Stage 3 adding new watched movies.srt 17KB
  162. 6. Building a Poll App & Advanced SQL/15. How to read the PostgreSQL documentation.srt 17KB
  163. 9. Charting data from our tables using matplotlib/14. How to export an image with matplotlib.srt 17KB
  164. 2. A Full Python Refresher/10. If statements.srt 16KB
  165. 2. A Full Python Refresher/24. Unpacking keyword arguments.srt 16KB
  166. 2. A Full Python Refresher/32. Relative imports in Python.srt 16KB
  167. 2. A Full Python Refresher/3. Variables in Python.srt 16KB
  168. 8. Python and Advanced PostgreSQL with psycopg2/3. Composite types and sets in functions.srt 16KB
  169. 7. Working with dates and times/12. How to save dates to PostgreSQL.srt 16KB
  170. 2. A Full Python Refresher/15. Dictionaries.srt 16KB
  171. 3. Build a Programming Journal with Python & SQL/17. Retrieving results from a cursor.srt 16KB
  172. 2. A Full Python Refresher/28. Class inheritance.srt 16KB
  173. 3. Build a Programming Journal with Python & SQL/9. How to connect to a SQLite database with Python.srt 16KB
  174. 4. A Movie Watchlist App with Python & SQL/12. Stage 2 watching movies.srt 15KB
  175. 2. A Full Python Refresher/21. Lambda functions in Python.srt 15KB
  176. 2. A Full Python Refresher/16. Destructuring variables.srt 15KB
  177. 3. Build a Programming Journal with Python & SQL/14. How to insert data into SQLite with Python.srt 15KB
  178. 2. A Full Python Refresher/35. First-class functions.srt 15KB
  179. 7. Working with dates and times/3. Changes needed in database.py.srt 15KB
  180. 2. A Full Python Refresher/12. If statements with the in keyword.srt 15KB
  181. 6. Building a Poll App & Advanced SQL/16. Adding type hinting to our application.srt 15KB
  182. 2. A Full Python Refresher/18. Function arguments and parameters.srt 15KB
  183. 2. A Full Python Refresher/20. Functions returning values.srt 15KB
  184. 4. A Movie Watchlist App with Python & SQL/5. Write the database.py file.srt 14KB
  185. 3. Build a Programming Journal with Python & SQL/18. WHERE search with SQL.srt 14KB
  186. 4. A Movie Watchlist App with Python & SQL/24. LIKE flexible searching.srt 14KB
  187. 6. Building a Poll App & Advanced SQL/12. SQL DISTINCT and DISTINCT ON.srt 14KB
  188. 2. A Full Python Refresher/14. List comprehensions in Python.srt 14KB
  189. 2. A Full Python Refresher/36. Simple decorators in Python.srt 13KB
  190. 6. Building a Poll App & Advanced SQL/4. RETURNING data from modified rows.srt 13KB
  191. 9. Charting data from our tables using matplotlib/12. How to draw a stacked bar chart with matplotlib.srt 13KB
  192. 3. Build a Programming Journal with Python & SQL/2. Creating our user menu.srt 13KB
  193. 3. Build a Programming Journal with Python & SQL/11. What is a cursor.srt 12KB
  194. 2. A Full Python Refresher/26. Magic methods _str_ and _repr_.srt 12KB
  195. 2. A Full Python Refresher/4. String formatting in Python.srt 12KB
  196. 7. Working with dates and times/6. How to create a connection pool with psycopg2.srt 12KB
  197. 6. Building a Poll App & Advanced SQL/5. Nested queries getting the latest poll.srt 12KB
  198. 2. A Full Python Refresher/7. Lists, tuples and sets.srt 12KB
  199. 3. Build a Programming Journal with Python & SQL/3. What is SQL.srt 11KB
  200. 5. Introduction to PostgreSQL Migrating our App/6. Psycopg2 cursors and query parameters.srt 11KB
  201. 5. Introduction to PostgreSQL Migrating our App/2. How to install PostgreSQL.srt 11KB
  202. 8. Python and Advanced PostgreSQL with psycopg2/4. Stored procedures in PostgreSQL.srt 11KB
  203. 2. A Full Python Refresher/29. Class composition.srt 11KB
  204. 4. A Movie Watchlist App with Python & SQL/4. Queries we'll need for the project to begin with.srt 11KB
  205. 9. Charting data from our tables using matplotlib/11. How to adjust the x axis tick labels so they fit in the screen.srt 11KB
  206. 2. A Full Python Refresher/40. Mutability in Python.srt 11KB
  207. 2. A Full Python Refresher/5. Getting user input.srt 11KB
  208. 3. Build a Programming Journal with Python & SQL/5. A SQLite data viewer.srt 11KB
  209. 6. Building a Poll App & Advanced SQL/8. PostgreSQL window functions.srt 11KB
  210. 7. Working with dates and times/7. Reduce pooling duplication with context managers.srt 11KB
  211. 9. Charting data from our tables using matplotlib/9. How to draw a bar chart with matplotlib.srt 11KB
  212. 2. A Full Python Refresher/9. Booleans in Python.srt 10KB
  213. 2. A Full Python Refresher/30. Type hinting in Python 3.5+.srt 10KB
  214. 9. Charting data from our tables using matplotlib/3. How to draw a line graph with matplotlib.srt 10KB
  215. 5. Introduction to PostgreSQL Migrating our App/1. SQLite vs. PostgreSQL.srt 10KB
  216. 2. A Full Python Refresher/34. Custom error classes.srt 10KB
  217. 4. A Movie Watchlist App with Python & SQL/2. Three development stages of our project.srt 10KB
  218. 4. A Movie Watchlist App with Python & SQL/26. Adding an index to our table for more efficient searching.srt 10KB
  219. 9. Charting data from our tables using matplotlib/7. How to add multiple subplots to a figure.srt 10KB
  220. 6. Building a Poll App & Advanced SQL/9. PostgreSQL window functions (part 2).srt 9KB
  221. 7. Working with dates and times/9. The Python datetime module.srt 9KB
  222. 6. Building a Poll App & Advanced SQL/6. SQL built-in functions.srt 9KB
  223. 2. A Full Python Refresher/39. Decorators with parameters.srt 9KB
  224. 3. Build a Programming Journal with Python & SQL/6. CREATE TABLE new tables with SQL.srt 9KB
  225. 3. Build a Programming Journal with Python & SQL/12. INSERT INTO add data to a table.srt 9KB
  226. 4. A Movie Watchlist App with Python & SQL/25. What is an index in SQL.srt 9KB
  227. 5. Introduction to PostgreSQL Migrating our App/3. How to run and access PostgreSQL.srt 9KB
  228. 8. Python and Advanced PostgreSQL with psycopg2/8. SQL string composition with psycopg2.srt 9KB
  229. 7. Working with dates and times/2. Creating our Option model class.srt 9KB
  230. 9. Charting data from our tables using matplotlib/5. Matplotlib figures, axes, and plots.srt 8KB
  231. 6. Building a Poll App & Advanced SQL/11. How to use PARTITION with window functions.srt 8KB
  232. 4. A Movie Watchlist App with Python & SQL/13. Relational data primary and foreign keys.srt 8KB
  233. 2. A Full Python Refresher/41. Mutable default parameters (and why they're a bad idea).srt 8KB
  234. 7. Working with dates and times/5. What is connection pooling.srt 8KB
  235. 2. A Full Python Refresher/8. Advanced set operations.srt 8KB
  236. 6. Building a Poll App & Advanced SQL/2. What is ACID.srt 8KB
  237. 2. A Full Python Refresher/19. Default parameter values.srt 8KB
  238. 6. Building a Poll App & Advanced SQL/10. How to use ORDER BY with window functions.srt 8KB
  239. 4. A Movie Watchlist App with Python & SQL/6. UPDATE changing data with SQL.srt 7KB
  240. 3. Build a Programming Journal with Python & SQL/22. What is a SQL injection attack.srt 7KB
  241. 4. A Movie Watchlist App with Python & SQL/17. Auto-incrementing row IDs.srt 7KB
  242. 2. A Full Python Refresher/22. Dictionary comprehensions.srt 7KB
  243. 9. Charting data from our tables using matplotlib/6. The Object-Oriented Approach with matplotlib.srt 7KB
  244. 3. Build a Programming Journal with Python & SQL/10. Connecting to SQLite in our app.srt 7KB
  245. 8. Python and Advanced PostgreSQL with psycopg2/5. Connections vs transactions in psycopg2.srt 7KB
  246. 2. A Full Python Refresher/37. The 'at' syntax for decorators.srt 7KB
  247. 9. Charting data from our tables using matplotlib/10. How to adjust the size of a matplotlib plot.srt 7KB
  248. 6. Building a Poll App & Advanced SQL/1. Overview of the project.srt 7KB
  249. 9. Charting data from our tables using matplotlib/16. How to create a custom legend with matplotlib.srt 7KB
  250. 4. A Movie Watchlist App with Python & SQL/19. JOIN access two tables at once with SQL.srt 7KB
  251. 7. Working with dates and times/10. How to calculate new dates with timedelta.srt 6KB
  252. 2. A Full Python Refresher/6. Writing our first Python app.srt 6KB
  253. 8. Python and Advanced PostgreSQL with psycopg2/1. Composite primary keys.srt 6KB
  254. 9. Charting data from our tables using matplotlib/15. How to create one document with multiple matplotlib plots.srt 6KB
  255. 3. Build a Programming Journal with Python & SQL/1. Overview of the project.srt 6KB
  256. 7. Working with dates and times/8. Reduce cursor creation duplication with context managers.srt 6KB
  257. 4. A Movie Watchlist App with Python & SQL/15. Watched movies final approach.srt 6KB
  258. 9. Charting data from our tables using matplotlib/13. How to create a legend from your graphed data.srt 5KB
  259. 9. Charting data from our tables using matplotlib/1. Overview creating graphs from poll data.srt 5KB
  260. 3. Build a Programming Journal with Python & SQL/15. SELECT retrieve data from a table.srt 5KB
  261. 4. A Movie Watchlist App with Python & SQL/1. Overview of the project.srt 5KB
  262. 2. A Full Python Refresher/38. Decorating functions with parameters.srt 5KB
  263. 4. A Movie Watchlist App with Python & SQL/10. DELETE FROM removing rows with SQL.srt 5KB
  264. 7. Working with dates and times/13.1 completed-poll-4-with-dates.zip 5KB
  265. 7. Working with dates and times/7.2 completed-poll-3-with-context-managers.zip 4KB
  266. 7. Working with dates and times/1.1 completed-poll-2-with-models.zip 4KB
  267. 7. Working with dates and times/1.3 completed-poll-2-with-models.zip 4KB
  268. 5. Introduction to PostgreSQL Migrating our App/7. Auto-incrementing columns SEQUENCE and SERIAL in PostgreSQL.srt 4KB
  269. 4. A Movie Watchlist App with Python & SQL/22. ORDER BY sort the returned table.srt 4KB
  270. 2. A Full Python Refresher/11. The in keyword in Python.srt 4KB
  271. 1. Introduction/1. Welcome to this course!.srt 4KB
  272. 3. Build a Programming Journal with Python & SQL/20. DROP TABLE deleting entire tables.srt 4KB
  273. 4. A Movie Watchlist App with Python & SQL/3. Our starting code for this project.srt 3KB
  274. 5. Introduction to PostgreSQL Migrating our App/8. Our changed code, and finding differences between files.srt 3KB
  275. 4. A Movie Watchlist App with Python & SQL/9.1 watchlist-complete-stage-2.zip 3KB
  276. 8. Python and Advanced PostgreSQL with psycopg2/7. Asynchronous psycopg2.srt 3KB
  277. 6. Building a Poll App & Advanced SQL/13. The SQL HAVING clause.srt 3KB
  278. 6. Building a Poll App & Advanced SQL/3.1 completed-poll-1.zip 2KB
  279. 6. Building a Poll App & Advanced SQL/3.2 completed-poll-1.zip 2KB
  280. 4. A Movie Watchlist App with Python & SQL/23. LIMIT getting a certain number of rows.srt 2KB
  281. 4. A Movie Watchlist App with Python & SQL/7. UPDATE exercises.html 2KB
  282. 4. A Movie Watchlist App with Python & SQL/15.1 watchlist-complete-stage-3.zip 2KB
  283. 6. Building a Poll App & Advanced SQL/3.1 poll-starter.zip 2KB
  284. 6. Building a Poll App & Advanced SQL/3.2 poll-starter.zip 2KB
  285. 4. A Movie Watchlist App with Python & SQL/9. Watched movies second approach.srt 2KB
  286. 2. A Full Python Refresher/1. Introduction to this section.srt 2KB
  287. 4. A Movie Watchlist App with Python & SQL/11. DELETE FROM exercises.html 2KB
  288. 4. A Movie Watchlist App with Python & SQL/8.1 watchlist-complete-stage-1.zip 2KB
  289. 4. A Movie Watchlist App with Python & SQL/8.2 watchlist-complete-stage-1.zip 2KB
  290. 3. Build a Programming Journal with Python & SQL/13. INSERT INTO exercises.html 2KB
  291. 3. Build a Programming Journal with Python & SQL/16. SELECT exercises.html 2KB
  292. 4. A Movie Watchlist App with Python & SQL/18. Auto-incrementing exercise.html 1KB
  293. 3. Build a Programming Journal with Python & SQL/19. WHERE exercises.html 1KB
  294. 1. Introduction/2. Initial setup (for newer Pythonistas).html 1KB
  295. 4. A Movie Watchlist App with Python & SQL/14. Relational data exercise.html 1KB
  296. 3. Build a Programming Journal with Python & SQL/8. CREATE TABLE exercises.html 1KB
  297. 9. Charting data from our tables using matplotlib/4. Matplotlib backends.html 870B
  298. 9. Charting data from our tables using matplotlib/2. How to install matplotlib.html 813B
  299. 4. A Movie Watchlist App with Python & SQL/3.1 progdiary-starter.zip 812B
  300. 4. A Movie Watchlist App with Python & SQL/3.2 progdiary-starter.zip 812B
  301. 4. A Movie Watchlist App with Python & SQL/21. Types of JOINs with examples.html 790B
  302. 2. A Full Python Refresher/2. Access the code for this section here.html 768B
  303. 3. Build a Programming Journal with Python & SQL/7. How to write comments in SQL.html 700B
  304. 3. Build a Programming Journal with Python & SQL/21. DROP TABLE exercise.html 435B
  305. 1. Introduction/3. Get the complete e-book here.html 392B
  306. 3. Build a Programming Journal with Python & SQL/17.1 What is the purpose of row_factory (StackOverflow).html 201B
  307. 4. A Movie Watchlist App with Python & SQL/5.1 [ebook] Using context managers for automatic commit and rollback.html 192B
  308. 3. Build a Programming Journal with Python & SQL/11.1 Why do you need to create cursors (StackOverflow).html 189B
  309. 3. Build a Programming Journal with Python & SQL/12.1 Single quotes vs. Double quotes in databases (StackOverflow).html 185B
  310. 3. Build a Programming Journal with Python & SQL/12.2 Single quotes vs. Double quotes in databases (StackOverflow).html 185B
  311. 8. Python and Advanced PostgreSQL with psycopg2/5.1 PostgreSQL - If I run multiple queries concurrently... (StackOverflow).html 184B
  312. 8. Python and Advanced PostgreSQL with psycopg2/5.2 PostgreSQL - If I run multiple queries concurrently... (StackOverflow).html 184B
  313. 6. Building a Poll App & Advanced SQL/13.1 How to avoid invoking functions twice when using GROUP BY and HAVING (StackOverflow).html 176B
  314. 6. Building a Poll App & Advanced SQL/2.1 Can a database support atomicity but not consistency.html 171B
  315. 8. Python and Advanced PostgreSQL with psycopg2/4.1 PostgreSQL Stored Procedures (carto.com).html 151B
  316. 8. Python and Advanced PostgreSQL with psycopg2/4.4 PostgreSQL Stored Procedures (carto.com).html 151B
  317. 2. A Full Python Refresher/3.1 How to set up VSCode with Python.html 146B
  318. 3. Build a Programming Journal with Python & SQL/3.1 How to set up VSCode with Python.html 146B
  319. 4. A Movie Watchlist App with Python & SQL/4.1 Why does Unix time start at 1970-01-01.html 146B
  320. 5. Introduction to PostgreSQL Migrating our App/3.1 [eBook] How to run and access PostgreSQL.html 146B
  321. 8. Python and Advanced PostgreSQL with psycopg2/1.1 Primary Keys (PostgreSQL Official Documentation).html 146B
  322. 8. Python and Advanced PostgreSQL with psycopg2/1.2 Primary Keys (PostgreSQL Official Documentation).html 146B
  323. 9. Charting data from our tables using matplotlib/3.1 matplotlib.pyplot.plot (Official Documentation).html 146B
  324. 7. Working with dates and times/7.1 The Curious Case of Python's Context Manager.html 143B
  325. 7. Working with dates and times/7.4 The Curious Case of Python's Context Manager.html 143B
  326. 8. Python and Advanced PostgreSQL with psycopg2/5.1 How to work with PostgreSQL transactions (EnterpriseDB).html 141B
  327. 8. Python and Advanced PostgreSQL with psycopg2/5.2 How to work with PostgreSQL transactions (EnterpriseDB).html 141B
  328. 5. Introduction to PostgreSQL Migrating our App/1.1 Foreign Key Constraints (official documentation).html 140B
  329. 4. A Movie Watchlist App with Python & SQL/6.1 [eBook] Setting movies to watched.html 139B
  330. 4. A Movie Watchlist App with Python & SQL/6.3 [eBook] Setting movies to watched.html 139B
  331. 5. Introduction to PostgreSQL Migrating our App/2.1 [eBook] How to install PostgreSQL.html 139B
  332. 6. Building a Poll App & Advanced SQL/10.1 Interactive database fiddle for this chapter.html 139B
  333. 7. Working with dates and times/1.1 [eBook] Separating into models.html 139B
  334. 7. Working with dates and times/1.2 [eBook] Separating into models.html 139B
  335. 8. Python and Advanced PostgreSQL with psycopg2/2.1 Interactive database for this lecture.html 139B
  336. 8. Python and Advanced PostgreSQL with psycopg2/2.2 Interactive database for this lecture.html 139B
  337. 8. Python and Advanced PostgreSQL with psycopg2/3.1 Interactive database for this lecture.html 139B
  338. 8. Python and Advanced PostgreSQL with psycopg2/1.1 Foreign Keys (PostgreSQL Official Documentation).html 136B
  339. 8. Python and Advanced PostgreSQL with psycopg2/1.2 Foreign Keys (PostgreSQL Official Documentation).html 136B
  340. 4. A Movie Watchlist App with Python & SQL/8.1 How to work with dates and times in Python.html 135B
  341. 4. A Movie Watchlist App with Python & SQL/8.2 How to work with dates and times in Python.html 135B
  342. 7. Working with dates and times/9.1 How to work with dates and times in Python.html 135B
  343. 8. Python and Advanced PostgreSQL with psycopg2/6.3 Deadlocks (PostgreSQL Official Documentation).html 135B
  344. 8. Python and Advanced PostgreSQL with psycopg2/6.5 Deadlocks (PostgreSQL Official Documentation).html 135B
  345. 5. Introduction to PostgreSQL Migrating our App/6.1 The with statement (psycopg2 Official Documentation).html 134B
  346. 8. Python and Advanced PostgreSQL with psycopg2/6.6 Advisory Locks (PostgreSQL Official Documentation).html 132B
  347. 4. A Movie Watchlist App with Python & SQL/3.1 Our starting code for this project.html 131B
  348. 4. A Movie Watchlist App with Python & SQL/3.2 Our starting code for this project.html 131B
  349. 2. A Full Python Refresher/5.1 Formatting numbers for printing in Python.html 129B
  350. 4. A Movie Watchlist App with Python & SQL/13.1 [eBook] Relational data.html 129B
  351. 4. A Movie Watchlist App with Python & SQL/13.2 [eBook] Relational data.html 129B
  352. 6. Building a Poll App & Advanced SQL/3.3 Formatting numbers for printing in Python.html 129B
  353. 6. Building a Poll App & Advanced SQL/14.2 VIEW Examples (PostgreSQL Official Documentation).html 129B
  354. 4. A Movie Watchlist App with Python & SQL/6.2 [eBook] UPDATE updating rows.html 127B
  355. 4. A Movie Watchlist App with Python & SQL/6.3 [eBook] UPDATE updating rows.html 127B
  356. 5. Introduction to PostgreSQL Migrating our App/4.3 Psycopg2 2.7.4 released (initd.org).html 126B
  357. 5. Introduction to PostgreSQL Migrating our App/4.5 Psycopg2 2.7.4 released (initd.org).html 126B
  358. 8. Python and Advanced PostgreSQL with psycopg2/4.1 What is Acid (our e-book).html 126B
  359. 8. Python and Advanced PostgreSQL with psycopg2/4.2 What is Acid (our e-book).html 126B
  360. 8. Python and Advanced PostgreSQL with psycopg2/6.1 PostgreSQL rocks, except when it blocks Understanding locks (Citusdata).html 126B
  361. 8. Python and Advanced PostgreSQL with psycopg2/6.4 PostgreSQL rocks, except when it blocks Understanding locks (Citusdata).html 126B
  362. 8. Python and Advanced PostgreSQL with psycopg2/7.1 Thread and process safety (psycopg2 Official Documentation).html 126B
  363. 9. Charting data from our tables using matplotlib/4.1 Usage Guide - Backends (Official Documentation).html 126B
  364. 5. Introduction to PostgreSQL Migrating our App/4.2 How to set up your local environment.html 125B
  365. 5. Introduction to PostgreSQL Migrating our App/4.5 How to set up your local environment.html 125B
  366. 8. Python and Advanced PostgreSQL with psycopg2/4.2 PostgreSQL Stored Procedures (PostgreSQL Tutorial).html 125B
  367. 8. Python and Advanced PostgreSQL with psycopg2/4.3 PostgreSQL Stored Procedures (PostgreSQL Tutorial).html 125B
  368. 5. Introduction to PostgreSQL Migrating our App/7.1 CREATE SEQUENCE (Official Documentation).html 124B
  369. 6. Building a Poll App & Advanced SQL/4.1 Fast Execution Helpers (psycopg2 Official Documentation).html 124B
  370. 8. Python and Advanced PostgreSQL with psycopg2/2.2 PLpgSQL Function Parameters (PostgreSQL Tutorial).html 124B
  371. 8. Python and Advanced PostgreSQL with psycopg2/2.4 PLpgSQL Function Parameters (PostgreSQL Tutorial).html 124B
  372. 6. Building a Poll App & Advanced SQL/11.1 More PostgreSQL Window Functions.html 123B
  373. 8. Python and Advanced PostgreSQL with psycopg2/3.2 PostgreSQL CREATE FUNCTION Statement (PostgreSQL Tutorial).html 123B
  374. 8. Python and Advanced PostgreSQL with psycopg2/3.3 PostgreSQL CREATE FUNCTION Statement (PostgreSQL Tutorial).html 123B
  375. 5. Introduction to PostgreSQL Migrating our App/4.1 Binary install from PyPI (Official Documentation).html 122B
  376. 5. Introduction to PostgreSQL Migrating our App/4.4 Binary install from PyPI (Official Documentation).html 122B
  377. 3. Build a Programming Journal with Python & SQL/9.1 SQL Transaction (w3resource).html 120B
  378. 6. Building a Poll App & Advanced SQL/6.1 Aggregate functions in PostgreSQL (Official Documentation).html 120B
  379. 6. Building a Poll App & Advanced SQL/6.2 Aggregate functions in PostgreSQL (Official Documentation).html 120B
  380. 6. Building a Poll App & Advanced SQL/7.1 Aggregate functions in PostgreSQL (Official Documentation).html 120B
  381. 6. Building a Poll App & Advanced SQL/16.1 Type hinting in Python 3.5+.html 120B
  382. 8. Python and Advanced PostgreSQL with psycopg2/2.3 CREATE FUNCTION (PostgreSQL Official Documentation).html 119B
  383. 8. Python and Advanced PostgreSQL with psycopg2/2.5 CREATE FUNCTION (PostgreSQL Official Documentation).html 119B
  384. 5. Introduction to PostgreSQL Migrating our App/4.3 What is a virtual environment.html 118B
  385. 5. Introduction to PostgreSQL Migrating our App/4.6 What is a virtual environment.html 118B
  386. 8. Python and Advanced PostgreSQL with psycopg2/6.5 Viewing Locks (PostgreSQL Official Documentation).html 117B
  387. 8. Python and Advanced PostgreSQL with psycopg2/6.7 Viewing Locks (PostgreSQL Official Documentation).html 117B
  388. 6. Building a Poll App & Advanced SQL/6.1 Mathematical functions in PostgreSQL (Official Documentation).html 115B
  389. 6. Building a Poll App & Advanced SQL/6.2 Mathematical functions in PostgreSQL (Official Documentation).html 115B
  390. 6. Building a Poll App & Advanced SQL/14.1 CREATE VIEW (PostgreSQL Official Documentation).html 115B
  391. 2. A Full Python Refresher/16.1 Destructuring in Python - Teclado Blog.html 114B
  392. 4. A Movie Watchlist App with Python & SQL/16.1 Destructuring in Python.html 114B
  393. 6. Building a Poll App & Advanced SQL/4.2 Returning Data From Modified Rows (PostgreSQL Official Documentation).html 114B
  394. 6. Building a Poll App & Advanced SQL/15.2 SQL Commands Reference.html 113B
  395. 6. Building a Poll App & Advanced SQL/15.3 SQL Commands Reference.html 113B
  396. 2. A Full Python Refresher/8.1 Python Set Operators.html 111B
  397. 6. Building a Poll App & Advanced SQL/15.2 37.1. How Extensibility Works.html 111B
  398. 6. Building a Poll App & Advanced SQL/15.3 37.1. How Extensibility Works.html 111B
  399. 7. Working with dates and times/7.3 How to write decorators in Python.html 111B
  400. 7. Working with dates and times/7.4 How to write decorators in Python.html 111B
  401. 8. Python and Advanced PostgreSQL with psycopg2/6.4 SELECT (PostgreSQL Official Documentation).html 111B
  402. 8. Python and Advanced PostgreSQL with psycopg2/6.7 SELECT (PostgreSQL Official Documentation).html 111B
  403. 8. Python and Advanced PostgreSQL with psycopg2/2.3 Query Language (SQL) Functions (PostgreSQL Official Documentation).html 110B
  404. 8. Python and Advanced PostgreSQL with psycopg2/2.5 Query Language (SQL) Functions (PostgreSQL Official Documentation).html 110B
  405. 8. Python and Advanced PostgreSQL with psycopg2/3.2 Query Language (SQL) Functions (PostgreSQL Official Documentation).html 110B
  406. 8. Python and Advanced PostgreSQL with psycopg2/3.3 Query Language (SQL) Functions (PostgreSQL Official Documentation).html 110B
  407. 3. Build a Programming Journal with Python & SQL/6.2 PostgreSQL Data Types (official documentation).html 109B
  408. 7. Working with dates and times/11.1 What are timezones.html 109B
  409. 7. Working with dates and times/11.2 What are timezones.html 109B
  410. 8. Python and Advanced PostgreSQL with psycopg2/6.1 LOCK (PostgreSQL Official Documentation).html 109B
  411. 8. Python and Advanced PostgreSQL with psycopg2/6.3 LOCK (PostgreSQL Official Documentation).html 109B
  412. 5. Introduction to PostgreSQL Migrating our App/4.1 psycopg2-binary Why.html 107B
  413. 5. Introduction to PostgreSQL Migrating our App/4.6 psycopg2-binary Why.html 107B
  414. 4. A Movie Watchlist App with Python & SQL/13.1 Enabling Foreign Key Support in SQLite (official documentation).html 106B
  415. 4. A Movie Watchlist App with Python & SQL/13.2 Enabling Foreign Key Support in SQLite (official documentation).html 106B
  416. 6. Building a Poll App & Advanced SQL/15.1 33. libpq - C Library.html 106B
  417. 8. Python and Advanced PostgreSQL with psycopg2/2.1 User-Defined Functions (PostgreSQL Official Documentation).html 106B
  418. 8. Python and Advanced PostgreSQL with psycopg2/2.4 User-Defined Functions (PostgreSQL Official Documentation).html 106B
  419. 8. Python and Advanced PostgreSQL with psycopg2/4.3 User-Defined Functions (PostgreSQL Official Documentation).html 106B
  420. 8. Python and Advanced PostgreSQL with psycopg2/4.4 User-Defined Functions (PostgreSQL Official Documentation).html 106B
  421. 3. Build a Programming Journal with Python & SQL/6.3 SQLite Create Table (official documentation).html 105B
  422. 9. Charting data from our tables using matplotlib/2.1 Installation (Official Documentation).html 105B
  423. 6. Building a Poll App & Advanced SQL/1.1 Making an online voting app (part 1).html 104B
  424. 6. Building a Poll App & Advanced SQL/1.1 Online voting app (part 2).html 104B
  425. 6. Building a Poll App & Advanced SQL/1.2 Making an online voting app (part 1).html 104B
  426. 6. Building a Poll App & Advanced SQL/1.2 Online voting app (part 2).html 104B
  427. 3. Build a Programming Journal with Python & SQL/20.1 DROP TABLE in SQLite (Official Documentation).html 103B
  428. 5. Introduction to PostgreSQL Migrating our App/4.2 pipenv cannot install psycopg2-binary, but pip can (py 3.8).html 103B
  429. 5. Introduction to PostgreSQL Migrating our App/4.4 pipenv cannot install psycopg2-binary, but pip can (py 3.8).html 103B
  430. 7. Working with dates and times/7.1 What does the yield keyword do (StackOverflow).html 103B
  431. 7. Working with dates and times/7.3 What does the yield keyword do (StackOverflow).html 103B
  432. 3. Build a Programming Journal with Python & SQL/12.1 SQLite INSERT INTO (official documentation).html 100B
  433. 3. Build a Programming Journal with Python & SQL/12.2 SQLite INSERT INTO (official documentation).html 100B
  434. 3. Build a Programming Journal with Python & SQL/15.1 The SELECT command in SQLite.html 100B
  435. 4. A Movie Watchlist App with Python & SQL/10.1 The SQL DELETE command in SQLite (official documentation).html 100B
  436. 8. Python and Advanced PostgreSQL with psycopg2/7.2 aiopg (Official Documentation).html 100B
  437. 3. Build a Programming Journal with Python & SQL/6.1 SQLite Data Types (official documentation).html 98B
  438. 8. Python and Advanced PostgreSQL with psycopg2/8.1 psycopg2.sql – SQL string composition (psycopg2 Official Documentation).html 98B
  439. 5. Introduction to PostgreSQL Migrating our App/8.2 database.py diff between SQLite and PostgreSQL.html 97B
  440. 7. Working with dates and times/1.2 Diff of app.py changes.html 97B
  441. 7. Working with dates and times/1.3 Diff of app.py changes.html 97B
  442. 4. A Movie Watchlist App with Python & SQL/6.1 The SQL UPDATE command in SQLite (official documentation).html 96B
  443. 4. A Movie Watchlist App with Python & SQL/6.2 The SQL UPDATE command in SQLite (official documentation).html 96B
  444. 4. A Movie Watchlist App with Python & SQL/17.1 SQLite Autoincrement.html 96B
  445. 5. Introduction to PostgreSQL Migrating our App/8.1 Diffchecker - great tool!.html 93B
  446. 7. Working with dates and times/11.3 pytz Official Documentation.html 89B
  447. 7. Working with dates and times/11.1 TimezoneDB free timezone database.html 84B
  448. 7. Working with dates and times/11.2 TimezoneDB free timezone database.html 84B
  449. 7. Working with dates and times/9.2 Python strftime reference.html 82B