1. Урок 1.00:03:31
    Introduction
  2. Урок 2.00:02:20
    Installing Python on Windows
  3. Урок 3.00:01:25
    Installing Python on Mac
  4. Урок 4.00:03:37
    The Python interactive shell (IDLE)
  5. Урок 5.00:05:22
    Numbers and Strings in Python
  6. Урок 6.00:06:15
    Variables in Python
  7. Урок 7.00:03:34
    The str() method to convert to Strings
  8. Урок 8.00:06:33
    Running a Python file from the IDLE
  9. Урок 9.00:05:40
    Getting user input in Python
  10. Урок 10.00:02:27
    The int() method to convert to Integers
  11. Урок 11.00:06:51
    The format() method to simplify String formatting
  12. Урок 12.00:05:20
    Lists in Python
  13. Урок 13.00:03:08
    The for loop in Python
  14. Урок 14.00:05:23
    Boolean expressions, True and False
  15. Урок 15.00:04:58
    If statements in Python
  16. Урок 16.00:04:44
    The 'in' keyword to check whether a list contains an element
  17. Урок 17.00:09:28
    Giving the user multiple chances in our program
  18. Урок 18.00:08:21
    Generating random integers in Python
  19. Урок 19.00:07:11
    Defining our own methods in Python
  20. Урок 20.00:04:55
    Returning values from our methods in Python
  21. Урок 21.00:03:48
    The String split() method
  22. Урок 22.00:06:44
    List comprehension in Python
  23. Урок 23.00:07:26
    Python Sets — what is a Set?
  24. Урок 24.00:06:06
    Set comprehension in Python
  25. Урок 25.00:07:38
    Creating our lottery numbers
  26. Урок 26.00:06:21
    Calculating the lottery winnings
  27. Урок 27.00:02:32
    Installing PyCharm, a professional Python tool
  28. Урок 28.00:01:59
    Setting up PyCharm on Mac
  29. Урок 29.00:03:49
    Setting up PyCharm on Windows
  30. Урок 30.00:09:21
    Dictionaries in Python
  31. Урок 31.00:07:54
    Advanced Dictionary usage in Python
  32. Урок 32.00:07:20
    Methods returning dictionaries
  33. Урок 33.00:05:12
    Appending to a list in Python
  34. Урок 34.00:08:34
    Adding marks to our student data structure
  35. Урок 35.00:08:18
    The sum() method in Python
  36. Урок 36.00:06:08
    Iterating over a list and using the dictionaries inside it
  37. Урок 37.00:14:45
    Creating the application menu
  38. Урок 38.00:12:06
    What are classes? Classes in Python
  39. Урок 39.00:08:04
    The Movie Class
  40. Урок 40.00:06:18
    The User Class (and the __repr__ method)
  41. Урок 41.00:09:34
    The filter() method in Python
  42. Урок 42.00:06:24
    More Movie operations and methods
  43. Урок 43.00:04:28
    Writing to a file in Python
  44. Урок 44.00:09:55
    Saving CSV files with our data
  45. Урок 45.00:12:13
    Loading our data from CSV files
  46. Урок 46.00:06:27
    Saving JSON files with our data
  47. Урок 47.00:08:10
    Loading our data from JSON files
  48. Урок 48.00:05:32
    Argument unpacking in Python (the two asterisks)
  49. Урок 49.00:15:26
    Creating the menu for our application
  50. Урок 50.00:12:53
    Introduction to databases
  51. Урок 51.00:04:01
    Installing PostgreSQL on Windows
  52. Урок 52.00:06:42
    Using PostgreSQL on Windows
  53. Урок 53.00:02:09
    Executing SQL queries on Windows
  54. Урок 54.00:05:02
    Installing PostgreSQL on Mac
  55. Урок 55.00:09:04
    Using PostgreSQL on Mac
  56. Урок 56.00:01:31
    Executing SQL commands on Mac
  57. Урок 57.00:03:16
    Using the sample data provided
  58. Урок 58.00:07:32
    SQL: The SELECT command
  59. Урок 59.00:04:17
    SQL: filtering with WHERE
  60. Урок 60.00:01:44
    SQL: LIMIT for limiting the number of results
  61. Урок 61.00:05:35
    SQL: UPDATE data in a table
  62. Урок 62.00:04:33
    SQL: DELETE data from a table
  63. Урок 63.00:05:01
    SQL Wildcards for filtering unknowns
  64. Урок 64.00:14:22
    What is a JOIN?
  65. Урок 65.00:09:56
    SQL: JOINs and JOIN examples
  66. Урок 66.00:09:09
    SQL: GROUP BY for aggregation of data
  67. Урок 67.00:04:43
    SQL: ORDER BY for sorting data
  68. Урок 68.00:11:39
    SQL: CREATE TABLE
  69. Урок 69.00:09:49
    SQL: INSERT INTO for adding data to a table
  70. Урок 70.00:06:46
    SQL: SEQUENCE for auto-incrementing fields
  71. Урок 71.00:11:55
    SQL: CREATE INDEX and advanced information about indexes
  72. Урок 72.00:05:33
    SQL: DROP TABLE for deleting tables and data
  73. Урок 73.00:19:03
    SQL: VIEWs and what they are used for
  74. Урок 74.00:11:37
    SQL: built-in functions and the HAVING construct
  75. Урок 75.00:14:24
    Dates in SQL: an old problem
  76. Урок 76.00:10:58
    Other data types in SQL (including JSON in PostgreSQL)
  77. Урок 77.00:09:31
    Nested SELECT statements for complex queries
  78. Урок 78.00:03:14
    The PostgreSQL SERIAL type
  79. Урок 79.00:05:32
    Installing psycopg2 on Windows (2018 update)
  80. Урок 80.00:10:30
    Installing psycopg2 on Windows (older versions)
  81. Урок 81.00:03:58
    Installing psycopg2 on Mac
  82. Урок 82.00:03:30
    Verifying everything works—don't proceed if it doesn't!
  83. Урок 83.00:05:45
    Mac OS X: Fixing psycopg2 'library not loaded' error
  84. Урок 84.00:08:23
    What is a virtual environment?
  85. Урок 85.00:03:58
    psycopg2 on a virtualenv on Windows (2018 update)
  86. Урок 86.00:05:12
    Psycopg2 on a virtualenv on Windows (older versions)
  87. Урок 87.00:04:15
    Setting up the app structure, pip, and requirements.txt
  88. Урок 88.00:09:54
    Recap on classes and object-oriented programming
  89. Урок 89.00:17:28
    Saving to database from Python
  90. Урок 90.00:15:40
    Loading from the database from Python
  91. Урок 91.00:04:20
    Removing some duplicate code from our app
  92. Урок 92.00:13:23
    Connection pooling and why it is important
  93. Урок 93.00:09:04
    Creating the ConnectionPool class
  94. Урок 94.00:09:23
    Creating the ConnectionFromPool class
  95. Урок 95.00:08:06
    Obtaining a cursor from the ConnectionFromPool class
  96. Урок 96.00:18:52
    The Database class and selective initialisation
  97. Урок 97.00:06:11
    Cleaning up the Database class
  98. Урок 98.00:03:44
    End of section review
  99. Урок 99.00:25:39
    What is an API?
  100. Урок 100.00:11:46
    Making requests in Python
  101. Урок 101.00:07:27
    What is OAuth?
  102. Урок 102.00:04:15
    Creating a Twitter app
  103. Урок 103.00:04:51
    Setting up Twitter login
  104. Урок 104.00:15:13
    Getting the OAuth request token
  105. Урок 105.00:04:52
    More on the Python debugger—an essential tool
  106. Урок 106.00:09:39
    Getting authorization by the user
  107. Урок 107.00:06:26
    Getting the OAuth access token
  108. Урок 108.00:16:45
    Performing Twitter requests: getting images
  109. Урок 109.00:11:01
    Reusing code from the last section to save users
  110. Урок 110.00:07:48
    Creating users in our app
  111. Урок 111.00:13:40
    Retrieving users in our app
  112. Урок 112.00:19:29
    Cleaning up the code—extremely important!
  113. Урок 113.00:15:53
    Introduction to Flask and Python Web Development
  114. Урок 114.00:11:26
    Adding a Twitter login endpoint
  115. Урок 115.00:23:17
    Adding Twitter authorization
  116. Урок 116.00:08:46
    Creating the user profile
  117. Урок 117.00:08:48
    The Flask before_request decorator
  118. Урок 118.00:02:42
    Checking if a user is already logged in
  119. Урок 119.00:07:55
    Searching tweets and displaying them
  120. Урок 120.00:03:20
    Searching for different things
  121. Урок 121.00:08:37
    What is Bootstrap?
  122. Урок 122.00:06:11
    Writing our own CSS
  123. Урок 123.00:06:46
    Allowing users to perform custom searches
  124. Урок 124.00:15:56
    Adding sentiment analysis with another API
  125. Урок 125.00:05:01
    What is Git?
  126. Урок 126.00:07:16
    Installing Git on Mac and Windows
  127. Урок 127.00:07:43
    Introduction to the UNIX terminal
  128. Урок 128.00:05:31
    The VIM text editor, a powerful terminal editor
  129. Урок 129.00:03:32
    Dealing with files in the UNIX terminal
  130. Урок 130.00:06:16
    What is a Git repository?
  131. Урок 131.00:03:52
    git init — create a Git repository
  132. Урок 132.00:08:27
    git add and git commit — staging and committing
  133. Урок 133.00:01:56
    git log — viewing past commits
  134. Урок 134.00:02:33
    Creating a repository on GitHub
  135. Урок 135.00:02:36
    git remote — managing remote repositories
  136. Урок 136.00:05:32
    Adding your SSH key to GitHub
  137. Урок 137.00:07:10
    What is a README file? Introduction to Markdown
  138. Урок 138.00:02:48
    git pull — pulling other's changes
  139. Урок 139.00:14:31
    OOP: Inheritance
  140. Урок 140.00:05:11
    OOP: Multiple Inheritance in Python
  141. Урок 141.00:03:55
    OOP: What is composition?
  142. Урок 142.00:11:46
    OOP: What is encapsulation?
  143. Урок 143.00:11:21
    Introduction to Exceptions in Python
  144. Урок 144.00:06:52
    Creating our own Exceptions
  145. Урок 145.00:06:00
    Some of the available built-in Exceptions
  146. Урок 146.00:20:45
    Python built-in methods
  147. Урок 147.00:07:46
    Assertions in Python
  148. Урок 148.00:08:04
    Lambda expressions in Python
  149. Урок 149.00:10:15
    More uses of lambda expressions
  150. Урок 150.00:17:22
    Lambda expressions in the wild
  151. Урок 151.00:19:42
    Introduction to unit testing with unittest
  152. Урок 152.00:06:08
    What are data structures?
  153. Урок 153.00:09:17
    What is a Linked List?
  154. Урок 154.00:10:24
    Introduction to Linked List Assignment
  155. Урок 155.00:08:50
    Programming our own Linked List in Python
  156. Урок 156.00:06:24
    Creating a Queue
  157. Урок 157.00:11:08
    Introduction to Queue Assignment
  158. Урок 158.00:15:03
    Programming our own Queue in Python
  159. Урок 159.00:03:37
    Creating a Stack
  160. Урок 160.00:05:24
    Introduction to Stack Assignment
  161. Урок 161.00:06:58
    Programming our own Stack in Python
  162. Урок 162.00:08:11
    Creating a Binary Tree
  163. Урок 163.00:07:37
    Introduction to Binary Tree Assignment
  164. Урок 164.00:09:14
    Programming our own Binary Tree in Python