Guest
\ 0:00 Welcome to this course! 2.A Full Python Refresher\ 2:31 Introduction to this section 3:33 Variables in Python 11:59 String formatting in Python 18:25 Getting user input 23:42 Writing our first Python app 27:01 Lists, tuples and sets 33:33 Advanced set operations 38:13 Booleans in Python 43:13 If statements 51:30 The in keyword in Python 53:32 If statements with the in keyword 1:01:50 Loops in Python 1:12:58 List comprehensions in Python 1:20:22 Dictionaries 1:28:54 Destructuring variables 1:37:22 Functions in Python 1:48:04 Function arguments and parameters 1:55:45 Default parameter values 1:59:40 Functions returning values 2:07:00 Lambda functions in Python 2:14:53 Dictionary comprehensions 2:18:54 Unpacking arguments 2:29:18 Unpacking keyword arguments 2:38:03 Object-Oriented Programming in Python 2:53:55 Magic methods _str_ and _repr_ 3:00:21 [id29436710|@classmethod] and @staticmethod 3:14:25 Class inheritance 3:22:57 Class composition 3:29:05 Type hinting in Python 3.5 3:34:14 Imports in Python 3:43:48 Relative imports in Python 3:52:41 Errors in Python 4:05:29 Custom error classes 4:10:34 First-class functions 4:18:26 Simple decorators in Python 4:25:39 The ’at’ syntax for decorators 4:29:12 Decorating functions with parameters 4:31:37 Decorators with parameters 4:36:27 Mutability in Python 4:42:31 Mutable default parameters (and why they’re a bad idea) a Programming Journal with Python & SQL\ 4:46:59 Overview of the project 4:49:30 Creating our user menu 4:55:52 What is SQL 5:01:34 Using Python lists as an in-memory database 5:14:02 A SQLite data viewer 5:19:19 CREATE TABLE new tables with SQL 5:23:35 How to connect to a SQLite database with Python 5:30:52 Connecting to SQLite in our app 5:34:15 What is a cursor 5:39:27 INSERT INTO add data to a table 5:43:54 How to insert data into SQLite with Python 5:51:09 SELECT retrieve data from a table 5:53:50 Retrieving results from a cursor 6:01:28 WHERE search with SQL 6:08:31 DROP TABLE deleting entire tables 6:10:10 What is a SQL injection attack 4.A Movie Watchlist App with Python & SQL\ 6:13:48 Overview of the project 6:15:57 Three development stages of our project 6:20:12 Our starting code for this project 6:21:38 Queries we’ll need for the project to begin with 6:26:45 Write the file 6:33:46 UPDATE changing data with SQL 6:37:22 Write our user menu and functions 6:49:08 Watched movies second approach 6:50:09 DELETE FROM removing rows with SQL 6:52:25 Stage 2 watching movies 7:00:22 Relational data primary and foreign keys 7:04:37 Watched movies final approach 7:07:30 Stage 3 adding new watched movies 7:16:20 Auto-incrementing row IDs 7:20:01 JOIN access two tables at once with SQL 7:23:17 Use JOINs to retrieve the movies a user has watched 7:32:09 ORDER BY sort the returned table 7:34:01 LIMIT getting a certain number of rows 7:35:07 LIKE flexible searching 7:41:57 What is an index in SQL 7:46:44 Adding an index to our table for more efficient searching to PostgreSQL Migrating our App\ 7:51:12 SQLite vs. PostgreSQL 7:55:39 How to install PostgreSQL 8:00:26 How to run and access PostgreSQL 8:04:24 psycopg2 vs psycopg2-binary 8:15:40 How to store (and not store!) sensitive information in your code 8:24:02 Psycopg2 cursors and query parameters 8:28:58 Auto-incrementing columns SEQUENCE and SERIAL in PostgreSQL 8:30:53 Our changed code, and finding differences between files a Poll App & Advanced SQL\ 8:32:24 Overview of the project 8:35:30 What is ACID 8:39:28 Essential queries we’ll need for this project 8:49:07 RETURNING data from modified rows 8:55:42 Nested queries getting the latest poll 9:01:58 SQL built-in functions 9:06:19 GROUP BY and calculating vote percentages 9:18:32 PostgreSQL window functions 1-2 9:29:24 How to use ORDER BY with window functions 9:33:39 How to use PARTITION with window functions 9:37:58 SQL DISTINCT and DISTINCT ON 9:44:32 The SQL HAVING clause 9:45:46 SQL VIEW virtual tables 9:55:39 How to read the PostgreSQL documentation 10:03:49 Adding type hinting to our application with dates and times\ 10:11:05 How to separate our database entities into models 10:22:29 Creating our Option model class 10:26:44 Changes needed in 10:34:25 Changes needed in 10:46:15 What is connection pooling 10:50:12 How to create a connection pool with psycopg2 10:56:03 Reduce pooling duplication with context managers 11:01:07 Reduce cursor creation duplication with context managers 11:04:05 The Python datetime 11:08:46 How to calculate new dates with timedelta 11:11:50 How to handle timezones with pytz 11:22:15 How to save dates to PostgreSQL 11:30:40 Add the vote date to our polling app and Advanced PostgreSQL with psycopg2\ 11:39:09 Composite primary keys 11:42:08 User-defined functions in PostgreSQL 11:51:24 Composite types and sets in functions 11:59:11 Stored procedures in
