Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай The Complete Python/PostgreSQL Course 2.0, а также все другие курсы, прямо сейчас!
Премиум
  1. Урок 1. 00:02:32
    Welcome to this course!
  2. Урок 2. 00:01:02
    Introduction to this section
  3. Урок 3. 00:08:27
    Variables in Python
  4. Урок 4. 00:06:27
    String formatting in Python
  5. Урок 5. 00:05:17
    Getting user input
  6. Урок 6. 00:03:20
    Writing our first Python app
  7. Урок 7. 00:06:32
    Lists, tuples and sets
  8. Урок 8. 00:04:40
    Advanced set operations
  9. Урок 9. 00:05:00
    Booleans in Python
  10. Урок 10. 00:08:18
    If statements
  11. Урок 11. 00:02:03
    The "in" keyword in Python
  12. Урок 12. 00:08:19
    If statements with the "in" keyword
  13. Урок 13. 00:11:08
    Loops in Python
  14. Урок 14. 00:07:25
    List comprehensions in Python
  15. Урок 15. 00:08:32
    Dictionaries
  16. Урок 16. 00:08:29
    Destructuring variables
  17. Урок 17. 00:10:42
    Functions in Python
  18. Урок 18. 00:07:41
    Function arguments and parameters
  19. Урок 19. 00:03:55
    Default parameter values
  20. Урок 20. 00:07:20
    Functions returning values
  21. Урок 21. 00:07:53
    Lambda functions in Python
  22. Урок 22. 00:04:02
    Dictionary comprehensions
  23. Урок 23. 00:10:25
    Unpacking arguments
  24. Урок 24. 00:08:45
    Unpacking keyword arguments
  25. Урок 25. 00:15:53
    Object-Oriented Programming in Python
  26. Урок 26. 00:06:26
    Magic methods: _str_ and _repr_
  27. Урок 27. 00:14:04
    @classmethod and @staticmethod
  28. Урок 28. 00:08:33
    Class inheritance
  29. Урок 29. 00:06:09
    Class composition
  30. Урок 30. 00:05:09
    Type hinting in Python 3.5+
  31. Урок 31. 00:09:34
    Imports in Python
  32. Урок 32. 00:08:53
    Relative imports in Python
  33. Урок 33. 00:12:48
    Errors in Python
  34. Урок 34. 00:05:05
    Custom error classes
  35. Урок 35. 00:07:53
    First-class functions
  36. Урок 36. 00:07:13
    Simple decorators in Python
  37. Урок 37. 00:03:34
    The 'at' syntax for decorators
  38. Урок 38. 00:02:25
    Decorating functions with parameters
  39. Урок 39. 00:04:51
    Decorators with parameters
  40. Урок 40. 00:06:04
    Mutability in Python
  41. Урок 41. 00:04:28
    Mutable default parameters (and why they're a bad idea)
  42. Урок 42. 00:02:31
    Overview of the project
  43. Урок 43. 00:06:23
    Creating our user menu
  44. Урок 44. 00:05:43
    What is SQL?
  45. Урок 45. 00:12:29
    Using Python lists as an in-memory database
  46. Урок 46. 00:05:17
    A SQLite data viewer
  47. Урок 47. 00:04:16
    CREATE TABLE: new tables with SQL
  48. Урок 48. 00:07:17
    How to connect to a SQLite database with Python
  49. Урок 49. 00:03:24
    Connecting to SQLite in our app
  50. Урок 50. 00:05:12
    What is a cursor?
  51. Урок 51. 00:04:27
    INSERT INTO: add data to a table
  52. Урок 52. 00:07:16
    How to insert data into SQLite with Python
  53. Урок 53. 00:02:41
    SELECT: retrieve data from a table
  54. Урок 54. 00:07:39
    Retrieving results from a cursor
  55. Урок 55. 00:07:04
    WHERE: search with SQL
  56. Урок 56. 00:01:39
    DROP TABLE: deleting entire tables
  57. Урок 57. 00:03:38
    What is a SQL injection attack?
  58. Урок 58. 00:02:09
    Overview of the project
  59. Урок 59. 00:04:16
    Three development stages of our project
  60. Урок 60. 00:01:26
    Our starting code for this project
  61. Урок 61. 00:05:07
    Queries we'll need for the project to begin with
  62. Урок 62. 00:07:02
    Write the database.py file
  63. Урок 63. 00:03:36
    UPDATE: changing data with SQL
  64. Урок 64. 00:11:46
    Write our user menu and functions
  65. Урок 65. 00:01:02
    Watched movies: second approach
  66. Урок 66. 00:02:16
    DELETE FROM: removing rows with SQL
  67. Урок 67. 00:07:57
    Stage 2: watching movies
  68. Урок 68. 00:04:16
    Relational data: primary and foreign keys
  69. Урок 69. 00:02:53
    Watched movies: final approach
  70. Урок 70. 00:08:50
    Stage 3: adding new watched movies
  71. Урок 71. 00:03:42
    Auto-incrementing row IDs
  72. Урок 72. 00:03:17
    JOIN: access two tables at once with SQL
  73. Урок 73. 00:08:53
    Use JOINs to retrieve the movies a user has watched
  74. Урок 74. 00:01:52
    ORDER BY: sort the returned table
  75. Урок 75. 00:01:06
    LIMIT: getting a certain number of rows
  76. Урок 76. 00:06:51
    LIKE: flexible searching
  77. Урок 77. 00:04:47
    What is an index in SQL?
  78. Урок 78. 00:04:28
    Adding an index to our table for more efficient searching
  79. Урок 79. 00:04:28
    SQLite vs. PostgreSQL
  80. Урок 80. 00:04:48
    How to install PostgreSQL
  81. Урок 81. 00:03:58
    How to run and access PostgreSQL
  82. Урок 82. 00:11:17
    psycopg2 vs psycopg2-binary
  83. Урок 83. 00:08:22
    How to store (and not store!) sensitive information in your code
  84. Урок 84. 00:04:56
    Psycopg2 cursors and query parameters
  85. Урок 85. 00:01:56
    Auto-incrementing columns: SEQUENCE and SERIAL in PostgreSQL
  86. Урок 86. 00:01:31
    Our changed code, and finding differences between files
  87. Урок 87. 00:03:07
    Overview of the project
  88. Урок 88. 00:03:58
    What is ACID?
  89. Урок 89. 00:09:39
    Essential queries we'll need for this project
  90. Урок 90. 00:06:35
    RETURNING data from modified rows
  91. Урок 91. 00:06:17
    Nested queries: getting the latest poll
  92. Урок 92. 00:04:21
    SQL built-in functions
  93. Урок 93. 00:12:14
    GROUP BY and calculating vote percentages
  94. Урок 94. 00:05:46
    PostgreSQL window functions
  95. Урок 95. 00:05:07
    PostgreSQL window functions (part 2)
  96. Урок 96. 00:04:15
    How to use ORDER BY with window functions
  97. Урок 97. 00:04:19
    How to use PARTITION with window functions
  98. Урок 98. 00:06:34
    SQL DISTINCT and DISTINCT ON
  99. Урок 99. 00:01:15
    The SQL HAVING clause
  100. Урок 100. 00:09:53
    SQL VIEW: virtual tables
  101. Урок 101. 00:08:11
    How to read the PostgreSQL documentation
  102. Урок 102. 00:07:16
    Adding type hinting to our application
  103. Урок 103. 00:11:24
    How to separate our database entities into models
  104. Урок 104. 00:04:16
    Creating our Option model class
  105. Урок 105. 00:07:41
    Changes needed in database.py
  106. Урок 106. 00:11:51
    Changes needed in app.py
  107. Урок 107. 00:03:57
    What is connection pooling?
  108. Урок 108. 00:05:52
    How to create a connection pool with psycopg2
  109. Урок 109. 00:05:04
    Reduce pooling duplication with context managers
  110. Урок 110. 00:02:58
    Reduce cursor creation duplication with context managers
  111. Урок 111. 00:04:41
    The Python datetime module
  112. Урок 112. 00:03:05
    How to calculate new dates with timedelta
  113. Урок 113. 00:10:25
    How to handle timezones with pytz
  114. Урок 114. 00:08:26
    How to save dates to PostgreSQL
  115. Урок 115. 00:08:29
    Add the vote date to our polling app
  116. Урок 116. 00:02:59
    Composite primary keys
  117. Урок 117. 00:09:17
    User-defined functions in PostgreSQL
  118. Урок 118. 00:07:47
    Composite types and sets in functions
  119. Урок 119. 00:05:26
    Stored procedures in PostgreSQL
  120. Урок 120. 00:03:29
    Connections vs transactions in psycopg2
  121. Урок 121. 00:08:57
    Locking in PostgreSQL
  122. Урок 122. 00:01:40
    Asynchronous psycopg2
  123. Урок 123. 00:04:41
    SQL string composition with psycopg2
  124. Урок 124. 00:02:29
    Overview: creating graphs from poll data
  125. Урок 125. 00:04:36
    How to draw a line graph with matplotlib
  126. Урок 126. 00:03:56
    Matplotlib figures, axes, and plots
  127. Урок 127. 00:03:26
    The Object-Oriented Approach with matplotlib
  128. Урок 128. 00:04:40
    How to add multiple subplots to a figure
  129. Урок 129. 00:13:28
    How to draw a pie chart with matplotlib
  130. Урок 130. 00:05:26
    How to draw a bar chart with matplotlib
  131. Урок 131. 00:03:26
    How to adjust the size of a matplotlib plot
  132. Урок 132. 00:05:12
    How to adjust the x axis tick labels so they fit in the screen
  133. Урок 133. 00:06:21
    How to draw a stacked bar chart with matplotlib
  134. Урок 134. 00:02:45
    How to create a legend from your graphed data
  135. Урок 135. 00:07:43
    How to export an image with matplotlib
  136. Урок 136. 00:02:46
    How to create one document with multiple matplotlib plots
  137. Урок 137. 00:03:03
    How to create a custom legend with matplotlib