- 
                                        
                                            Урок 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