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