Filename Size 01 - Simple - But Powerful - SQL Statements/001 Join Our Community!.html 318 B 01 - Simple - But Powerful - SQL Statements/002 Course Resources.html 1.3 KB 01 - Simple - But Powerful - SQL Statements/002 diagrams.zip 7.7 MB 01 - Simple - But Powerful - SQL Statements/003 What is PostgreSQL All About.mp4 15.9 MB 01 - Simple - But Powerful - SQL Statements/003 What is PostgreSQL All About_en.srt 7.3 KB 01 - Simple - But Powerful - SQL Statements/004 Database Design.mp4 49.4 MB 01 - Simple - But Powerful - SQL Statements/004 Database Design_en.srt 8.2 KB 01 - Simple - But Powerful - SQL Statements/005 003-sql.sql 104 B 01 - Simple - But Powerful - SQL Statements/005 Creating Tables.mp4 12.9 MB 01 - Simple - But Powerful - SQL Statements/005 Creating Tables_en.srt 7.7 KB 01 - Simple - But Powerful - SQL Statements/006 Analyzing CREATE TABLE.mp4 17.7 MB 01 - Simple - But Powerful - SQL Statements/006 Analyzing CREATE TABLE_en.srt 5.5 KB 01 - Simple - But Powerful - SQL Statements/007 005-sql-cumulative.sql 384 B 01 - Simple - But Powerful - SQL Statements/007 005-sql.sql 278 B 01 - Simple - But Powerful - SQL Statements/007 Inserting Data Into a Table.mp4 18.1 MB 01 - Simple - But Powerful - SQL Statements/007 Inserting Data Into a Table_en.srt 7.6 KB 01 - Simple - But Powerful - SQL Statements/008 Retrieving Data with Select.mp4 6 MB 01 - Simple - But Powerful - SQL Statements/008 Retrieving Data with Select_en.srt 3.4 KB 01 - Simple - But Powerful - SQL Statements/009 Calculated Columns.mp4 15.2 MB 01 - Simple - But Powerful - SQL Statements/009 Calculated Columns_en.srt 7.2 KB 01 - Simple - But Powerful - SQL Statements/010 Calculating Phone Revenue.mp4 3.4 MB 01 - Simple - But Powerful - SQL Statements/010 Calculating Phone Revenue_en.srt 1.6 KB 01 - Simple - But Powerful - SQL Statements/011 Exercise Solution.mp4 3.1 MB 01 - Simple - But Powerful - SQL Statements/011 Exercise Solution_en.srt 1.6 KB 01 - Simple - But Powerful - SQL Statements/012 012-sql.sql 404 B 01 - Simple - But Powerful - SQL Statements/012 String Operators and Functions.mp4 16.3 MB 01 - Simple - But Powerful - SQL Statements/012 String Operators and Functions_en.srt 10.2 KB 02 - Filtering Records/001 013-sql.sql 48 B 02 - Filtering Records/001 Filtering Rows with Where.mp4 12.3 MB 02 - Filtering Records/001 Filtering Rows with Where_en.srt 6 KB 02 - Filtering Records/002 More on the Where Keyword.mp4 9.4 MB 02 - Filtering Records/002 More on the Where Keyword_en.srt 3.8 KB 02 - Filtering Records/003 Compound Where Clauses.mp4 19 MB 02 - Filtering Records/003 Compound Where Clauses_en.srt 7.6 KB 02 - Filtering Records/004 A Where Exercise Overview.mp4 1.7 MB 02 - Filtering Records/004 A Where Exercise Overview_en.srt 946 B 02 - Filtering Records/005 A Where Solution.mp4 2.5 MB 02 - Filtering Records/005 A Where Solution_en.srt 1.5 KB 02 - Filtering Records/006 Where With Lists.mp4 1.6 MB 02 - Filtering Records/006 Where With Lists_en.srt 1.1 KB 02 - Filtering Records/007 A Where With Lists Solution.mp4 5 MB 02 - Filtering Records/007 A Where With Lists Solution_en.srt 2.5 KB 02 - Filtering Records/008 Calculations in Where Clauses.mp4 4.7 MB 02 - Filtering Records/008 Calculations in Where Clauses_en.srt 3 KB 02 - Filtering Records/009 Solving Calculations.mp4 5.9 MB 02 - Filtering Records/009 Solving Calculations_en.srt 2.9 KB 02 - Filtering Records/010 Updating Rows.mp4 17.3 MB 02 - Filtering Records/010 Updating Rows_en.srt 6.3 KB 02 - Filtering Records/011 Deleting Rows.mp4 11.2 MB 02 - Filtering Records/011 Deleting Rows_en.srt 5.3 KB 02 - Filtering Records/012 A Solution for Updating Rows.mp4 4.9 MB 02 - Filtering Records/012 A Solution for Updating Rows_en.srt 2 KB 02 - Filtering Records/013 Solution for Deleting Rows.mp4 4 MB 02 - Filtering Records/013 Solution for Deleting Rows_en.srt 2.3 KB 03 - Working with Tables/001 The Plan Moving Forward.mp4 10.7 MB 03 - Working with Tables/001 The Plan Moving Forward_en.srt 2.8 KB 03 - Working with Tables/002 Approaching Database Design.mp4 50.2 MB 03 - Working with Tables/002 Approaching Database Design_en.srt 11.8 KB 03 - Working with Tables/003 One-to-Many and Many-to-One Relationships.mp4 41.3 MB 03 - Working with Tables/003 One-to-Many and Many-to-One Relationships_en.srt 10.1 KB 03 - Working with Tables/004 One-to-One and Many-to-Many Relationships.mp4 24.6 MB 03 - Working with Tables/004 One-to-One and Many-to-Many Relationships_en.srt 8.8 KB 03 - Working with Tables/005 Primary Keys and Foreign Keys.mp4 29.6 MB 03 - Working with Tables/005 Primary Keys and Foreign Keys_en.srt 8 KB 03 - Working with Tables/006 Understanding Foreign Keys.mp4 63.3 MB 03 - Working with Tables/006 Understanding Foreign Keys_en.srt 13 KB 03 - Working with Tables/007 007-tables-cumulative.sql 172 B 03 - Working with Tables/007 007-tables.sql 194 B 03 - Working with Tables/007 Auto-Generated ID's.mp4 23 MB 03 - Working with Tables/007 Auto-Generated ID's_en.srt 9.2 KB 03 - Working with Tables/008 008-tables-cumulative.sql 348 B 03 - Working with Tables/008 008-tables.sql 197 B 03 - Working with Tables/008 Creating Foreign Key Columns.mp4 18.3 MB 03 - Working with Tables/008 Creating Foreign Key Columns_en.srt 7.6 KB 03 - Working with Tables/009 009-tables-cumulative.sql 536 B 03 - Working with Tables/009 009-tables.sql 326 B 03 - Working with Tables/009 Running Queries on Associated Data.mp4 38.2 MB 03 - Working with Tables/009 Running Queries on Associated Data_en.srt 10.6 KB 03 - Working with Tables/010 Exercise Overview.mp4 8.3 MB 03 - Working with Tables/010 Exercise Overview_en.srt 3.3 KB 03 - Working with Tables/011 Foreign Key Creation Solution.mp4 8.4 MB 03 - Working with Tables/011 Foreign Key Creation Solution_en.srt 3.1 KB 03 - Working with Tables/012 012-tables-cumulative.sql 600 B 03 - Working with Tables/012 012-tables.sql 199 B 03 - Working with Tables/012 Foreign Key Constraints Around Insertion.mp4 22.2 MB 03 - Working with Tables/012 Foreign Key Constraints Around Insertion_en.srt 8.7 KB 03 - Working with Tables/013 Constraints Around Deletion.mp4 40.5 MB 03 - Working with Tables/013 Constraints Around Deletion_en.srt 7.8 KB 03 - Working with Tables/014 Commands You’ll Need for the Next Video.html 691 B 03 - Working with Tables/015 014-tables-cumulative.sql 994 B 03 - Working with Tables/015 014-tables.sql 469 B 03 - Working with Tables/015 Testing Deletion Constraints.mp4 19.3 MB 03 - Working with Tables/015 Testing Deletion Constraints_en.srt 7.1 KB 03 - Working with Tables/016 015-tables-cumulative.sql 1.3 KB 03 - Working with Tables/016 015-tables.sql 340 B 03 - Working with Tables/016 Setting Foreign Keys to Null on Delete.mp4 12.6 MB 03 - Working with Tables/016 Setting Foreign Keys to Null on Delete_en.srt 4.6 KB 03 - Working with Tables/017 Adding Some Complexity.mp4 10 MB 03 - Working with Tables/017 Adding Some Complexity_en.srt 4.8 KB