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