SQL and PostgreSQL: The Complete Developer's Guide
- Type:
- Other > Other
- Files:
- 619
- Size:
- 7.87 GiB (8445318092 Bytes)
- Uploaded:
- 2023-09-24 18:18:19 GMT
- By:
-
cybil18
- Seeders:
- 3
- Leechers:
- 20
- Comments
- 0
- Info Hash: 5C6CF90AF75FDFADC3C00A97B5D187332B5B41E0
(Problems with magnets links are fixed by upgrading your torrent client!)
SQL and PostgreSQL: The Complete Developer's Guide Become an expert with SQL and PostgreSQL! Store and fetch data, tune queries, and design efficient database structures! Udemy Link - https://www.udemy.com/course/sql-and-postgresql/ Please seed as much as you can!
| 01 - Simple - But Powerful - SQL Statements/001 Join Our Community!.html | 318 B |
| 01 - Simple - But Powerful - SQL Statements/002 Course Resources.html | 1.25 KiB |
| 01 - Simple - But Powerful - SQL Statements/002 diagrams.zip | 7.72 MiB |
| 01 - Simple - But Powerful - SQL Statements/003 What is PostgreSQL All About.mp4 | 15.94 MiB |
| 01 - Simple - But Powerful - SQL Statements/003 What is PostgreSQL All About_en.srt | 7.25 KiB |
| 01 - Simple - But Powerful - SQL Statements/004 Database Design.mp4 | 49.41 MiB |
| 01 - Simple - But Powerful - SQL Statements/004 Database Design_en.srt | 8.21 KiB |
| 01 - Simple - But Powerful - SQL Statements/005 003-sql.sql | 104 B |
| 01 - Simple - But Powerful - SQL Statements/005 Creating Tables.mp4 | 12.9 MiB |
| 01 - Simple - But Powerful - SQL Statements/005 Creating Tables_en.srt | 7.67 KiB |
| 01 - Simple - But Powerful - SQL Statements/006 Analyzing CREATE TABLE.mp4 | 17.67 MiB |
| 01 - Simple - But Powerful - SQL Statements/006 Analyzing CREATE TABLE_en.srt | 5.54 KiB |
| 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.07 MiB |
| 01 - Simple - But Powerful - SQL Statements/007 Inserting Data Into a Table_en.srt | 7.59 KiB |
| 01 - Simple - But Powerful - SQL Statements/008 Retrieving Data with Select.mp4 | 6.02 MiB |
| 01 - Simple - But Powerful - SQL Statements/008 Retrieving Data with Select_en.srt | 3.45 KiB |
| 01 - Simple - But Powerful - SQL Statements/009 Calculated Columns.mp4 | 15.22 MiB |
| 01 - Simple - But Powerful - SQL Statements/009 Calculated Columns_en.srt | 7.23 KiB |
| 01 - Simple - But Powerful - SQL Statements/010 Calculating Phone Revenue.mp4 | 3.36 MiB |
| 01 - Simple - But Powerful - SQL Statements/010 Calculating Phone Revenue_en.srt | 1.58 KiB |
| 01 - Simple - But Powerful - SQL Statements/011 Exercise Solution.mp4 | 3.15 MiB |
| 01 - Simple - But Powerful - SQL Statements/011 Exercise Solution_en.srt | 1.62 KiB |
| 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.34 MiB |
| 01 - Simple - But Powerful - SQL Statements/012 String Operators and Functions_en.srt | 10.17 KiB |
| 02 - Filtering Records/001 013-sql.sql | 48 B |
| 02 - Filtering Records/001 Filtering Rows with Where.mp4 | 12.26 MiB |
| 02 - Filtering Records/001 Filtering Rows with Where_en.srt | 6 KiB |
| 02 - Filtering Records/002 More on the Where Keyword.mp4 | 9.45 MiB |
| 02 - Filtering Records/002 More on the Where Keyword_en.srt | 3.79 KiB |
| 02 - Filtering Records/003 Compound Where Clauses.mp4 | 18.98 MiB |
| 02 - Filtering Records/003 Compound Where Clauses_en.srt | 7.57 KiB |
| 02 - Filtering Records/004 A Where Exercise Overview.mp4 | 1.72 MiB |
| 02 - Filtering Records/004 A Where Exercise Overview_en.srt | 946 B |
| 02 - Filtering Records/005 A Where Solution.mp4 | 2.54 MiB |
| 02 - Filtering Records/005 A Where Solution_en.srt | 1.52 KiB |
| 02 - Filtering Records/006 Where With Lists.mp4 | 1.59 MiB |
| 02 - Filtering Records/006 Where With Lists_en.srt | 1.07 KiB |
| 02 - Filtering Records/007 A Where With Lists Solution.mp4 | 4.96 MiB |
| 02 - Filtering Records/007 A Where With Lists Solution_en.srt | 2.49 KiB |
| 02 - Filtering Records/008 Calculations in Where Clauses.mp4 | 4.68 MiB |
| 02 - Filtering Records/008 Calculations in Where Clauses_en.srt | 3.02 KiB |
| 02 - Filtering Records/009 Solving Calculations.mp4 | 5.91 MiB |
| 02 - Filtering Records/009 Solving Calculations_en.srt | 2.95 KiB |
| 02 - Filtering Records/010 Updating Rows.mp4 | 17.3 MiB |
| 02 - Filtering Records/010 Updating Rows_en.srt | 6.32 KiB |
| 02 - Filtering Records/011 Deleting Rows.mp4 | 11.18 MiB |
| 02 - Filtering Records/011 Deleting Rows_en.srt | 5.25 KiB |
| 02 - Filtering Records/012 A Solution for Updating Rows.mp4 | 4.94 MiB |
| 02 - Filtering Records/012 A Solution for Updating Rows_en.srt | 1.98 KiB |
| 02 - Filtering Records/013 Solution for Deleting Rows.mp4 | 4 MiB |
| 02 - Filtering Records/013 Solution for Deleting Rows_en.srt | 2.27 KiB |
| 03 - Working with Tables/001 The Plan Moving Forward.mp4 | 10.75 MiB |
| 03 - Working with Tables/001 The Plan Moving Forward_en.srt | 2.75 KiB |
| 03 - Working with Tables/002 Approaching Database Design.mp4 | 50.16 MiB |
| 03 - Working with Tables/002 Approaching Database Design_en.srt | 11.79 KiB |
| 03 - Working with Tables/003 One-to-Many and Many-to-One Relationships.mp4 | 41.31 MiB |
| 03 - Working with Tables/003 One-to-Many and Many-to-One Relationships_en.srt | 10.13 KiB |
| 03 - Working with Tables/004 One-to-One and Many-to-Many Relationships.mp4 | 24.58 MiB |
| 03 - Working with Tables/004 One-to-One and Many-to-Many Relationships_en.srt | 8.83 KiB |
| 03 - Working with Tables/005 Primary Keys and Foreign Keys.mp4 | 29.57 MiB |
| 03 - Working with Tables/005 Primary Keys and Foreign Keys_en.srt | 7.95 KiB |
| 03 - Working with Tables/006 Understanding Foreign Keys.mp4 | 63.35 MiB |
| 03 - Working with Tables/006 Understanding Foreign Keys_en.srt | 12.99 KiB |
| 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 | 22.97 MiB |
| 03 - Working with Tables/007 Auto-Generated ID's_en.srt | 9.15 KiB |
| 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.32 MiB |
| 03 - Working with Tables/008 Creating Foreign Key Columns_en.srt | 7.61 KiB |
| 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.22 MiB |
| 03 - Working with Tables/009 Running Queries on Associated Data_en.srt | 10.61 KiB |
| 03 - Working with Tables/010 Exercise Overview.mp4 | 8.25 MiB |
| 03 - Working with Tables/010 Exercise Overview_en.srt | 3.26 KiB |
| 03 - Working with Tables/011 Foreign Key Creation Solution.mp4 | 8.35 MiB |
| 03 - Working with Tables/011 Foreign Key Creation Solution_en.srt | 3.14 KiB |
| 03 - Working with Tables/012 012-tables-cumulative.sql | 60 B |
| 03 - Working with Tables/012 012-tables.sql | 199 B |
| 03 - Working with Tables/012 Foreign Key Constraints Around Insertion.mp4 | 22.15 MiB |
| 03 - Working with Tables/012 Foreign Key Constraints Around Insertion_en.srt | 8.72 KiB |
| 03 - Working with Tables/013 Constraints Around Deletion.mp4 | 40.54 MiB |
| 03 - Working with Tables/013 Constraints Around Deletion_en.srt | 7.76 KiB |
| 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.27 MiB |
| 03 - Working with Tables/015 Testing Deletion Constraints_en.srt | 7.09 KiB |
| 03 - Working with Tables/016 015-tables-cumulative.sql | 1.28 KiB |
| 03 - Working with Tables/016 015-tables.sql | 34 B |
| 03 - Working with Tables/016 Setting Foreign Keys to Null on Delete.mp4 | 12.6 MiB |
| 03 - Working with Tables/016 Setting Foreign Keys to Null on Delete_en.srt | 4.59 KiB |
| 03 - Working with Tables/017 Adding Some Complexity.mp4 | 9.96 MiB |
| 03 - Working with Tables/017 Adding Some Complexity_en.srt | 4.75 KiB |
| 04 - Relating Records with Joins/001 Adding Some Data.html | 7.66 KiB |
| 04 - Relating Records with Joins/002 Queries with Joins and Aggregations.mp4 | 27.86 MiB |
| 04 - Relating Records with Joins/002 Queries with Joins and Aggregations_en.srt | 5.26 KiB |
| 04 - Relating Records with Joins/003 Joining Data from Different Tables.mp4 | 36.8 MiB |
| 04 - Relating Records with Joins/003 Joining Data from Different Tables_en.srt | 11.65 KiB |
| 04 - Relating Records with Joins/004 Another Quick Join.mp4 | 8.62 MiB |
| 04 - Relating Records with Joins/004 Another Quick Join_en.srt | 3.38 KiB |
| 04 - Relating Records with Joins/005 Exercise Overview.mp4 | 4.85 MiB |
| 04 - Relating Records with Joins/005 Exercise Overview_en.srt | 1.84 KiB |
| 04 - Relating Records with Joins/006 A Joinful Solution.mp4 | 5.27 MiB |
| 04 - Relating Records with Joins/006 A Joinful Solution_en.srt | 2.74 KiB |
| 04 - Relating Records with Joins/007 Alternate Forms of Syntax.mp4 | 24.96 MiB |
| 04 - Relating Records with Joins/007 Alternate Forms of Syntax_en.srt | 9.32 KiB |
| 04 - Relating Records with Joins/008 007-joins-cumulative.sql | 7.54 KiB |
| 04 - Relating Records with Joins/008 Missing Data in Joins.mp4 | 29.27 MiB |
| 04 - Relating Records with Joins/008 Missing Data in Joins_en.srt | 10.03 KiB |
| 04 - Relating Records with Joins/009 Why Wasn't It Included.mp4 | 24.58 MiB |
| 04 - Relating Records with Joins/009 Why Wasn't It Included_en.srt | 3.84 KiB |
| 04 - Relating Records with Joins/010 009-joins-cheatsheet.pdf | 190.52 KiB |
| 04 - Relating Records with Joins/010 Four Kinds of Joins.mp4 | 124.86 MiB |
| 04 - Relating Records with Joins/010 Four Kinds of Joins_en.srt | 15.17 KiB |
| 04 - Relating Records with Joins/011 010-sql-cumulative.sql | 7.59 KiB |
| 04 - Relating Records with Joins/011 Each Join in Practice.mp4 | 40.6 MiB |
| 04 - Relating Records with Joins/011 Each Join in Practice_en.srt | 6.76 KiB |
| 04 - Relating Records with Joins/012 Does Order Matter.mp4 | 61.33 MiB |
| 04 - Relating Records with Joins/012 Does Order Matter_en.srt | 6.38 KiB |
| 04 - Relating Records with Joins/013 Exercise Overview.mp4 | 2.23 MiB |
| 04 - Relating Records with Joins/013 Exercise Overview_en.srt | 1.54 KiB |
| 04 - Relating Records with Joins/014 Two Possible Solutions.mp4 | 16.51 MiB |
| 04 - Relating Records with Joins/015 Where with Join.mp4 | 31.03 MiB |
| 04 - Relating Records with Joins/015 Where with Join_en.srt | 10.6 KiB |
| 04 - Relating Records with Joins/016 Three Way Joins.mp4 | 49.71 MiB |
| 04 - Relating Records with Joins/016 Three Way Joins_en.srt | 12.2 KiB |
| 04 - Relating Records with Joins/017 A Bit of Practice.mp4 | 17.87 MiB |
| 04 - Relating Records with Joins/017 A Bit of Practice_en.srt | 7.81 KiB |
| 04 - Relating Records with Joins/018 Exercise Solution.mp4 | 7.67 MiB |
| 04 - Relating Records with Joins/018 Exercise Solution_en.srt | 4.31 KiB |
| 05 - Aggregation of Records/001 Aggregating and Grouping.mp4 | 7.9 MiB |
| 05 - Aggregation of Records/001 Aggregating and Grouping_en.srt | 3.58 KiB |
| 05 - Aggregation of Records/002 Picturing Group By.mp4 | 29.43 MiB |
| 05 - Aggregation of Records/002 Picturing Group By_en.srt | 8.28 KiB |
| 05 - Aggregation of Records/003 Aggregate Functions.mp4 | 11.58 MiB |
| 05 - Aggregation of Records/003 Aggregate Functions_en.srt | 4.61 KiB |
| 05 - Aggregation of Records/004 Combining Group By and Aggregates.mp4 | 15.13 MiB |
| 05 - Aggregation of Records/004 Combining Group By and Aggregates_en.srt | 7.06 KiB |
| 05 - Aggregation of Records/005 A Gotcha with Count.mp4 | 5.46 MiB |
| 05 - Aggregation of Records/005 A Gotcha with Count_en.srt | 4.21 KiB |
| 05 - Aggregation of Records/006 Visualizing More Grouping.mp4 | 9.72 MiB |
| 05 - Aggregation of Records/006 Visualizing More Grouping_en.srt | 4.67 KiB |
| 05 - Aggregation of Records/007 Exercise Overview.mp4 | 1.66 MiB |
| 05 - Aggregation of Records/007 Exercise Overview_en.srt | 1.2 KiB |
| 05 - Aggregation of Records/008 Grouping Solution.mp4 | 3.15 MiB |
| 05 - Aggregation of Records/008 Grouping Solution_en.srt | 2.21 KiB |
| 05 - Aggregation of Records/009 Adding a Layer of Difficulty.mp4 | 1.79 MiB |
| 05 - Aggregation of Records/009 Adding a Layer of Difficulty_en.srt | 1.12 KiB |
| 05 - Aggregation of Records/010 Solution.mp4 | 3.68 MiB |
| 05 - Aggregation of Records/010 Solution_en.srt | 2.44 KiB |
| 05 - Aggregation of Records/011 Filtering Groups with Having.mp4 | 36.97 MiB |
| 05 - Aggregation of Records/011 Filtering Groups with Having_en.srt | 7.76 KiB |
| 05 - Aggregation of Records/012 Having In Action.mp4 | 6.86 MiB |
| 05 - Aggregation of Records/012 Having In Action_en.srt | 4.11 KiB |
| 05 - Aggregation of Records/013 More on Having!.mp4 | 28.46 MiB |
| 05 - Aggregation of Records/013 More on Having!_en.srt | 11.04 KiB |
| 05 - Aggregation of Records/014 A Having Exercise Overview.mp4 | 12.79 MiB |
| 05 - Aggregation of Records/014 A Having Exercise Overview_en.srt | 5.53 KiB |
| 05 - Aggregation of Records/015 A Quick Solution.mp4 | 7.3 MiB |
| 05 - Aggregation of Records/015 A Quick Solution_en.srt | 3.79 KiB |
| 06 - Working with Large Datasets/001 A New Dataset.html | 17.84 KiB |
| 06 - Working with Large Datasets/002 001-sq-data.sql | 15.82 KiB |
| 06 - Working with Large Datasets/002 Investigating This Dataset.mp4 | 8 MiB |
| 06 - Working with Large Datasets/002 Investigating This Dataset_en.srt | 3.99 KiB |
| 06 - Working with Large Datasets/003 Some Group By Practice.mp4 | 3.1 MiB |
| 06 - Working with Large Datasets/003 Some Group By Practice_en.srt | 2.05 KiB |
| 06 - Working with Large Datasets/004 Group By Review Solution.mp4 | 7.92 MiB |
| 06 - Working with Large Datasets/004 Group By Review Solution_en.srt | 3.71 KiB |
| 06 - Working with Large Datasets/005 Remember Joins.mp4 | 9.3 MiB |
| 06 - Working with Large Datasets/005 Remember Joins_en.srt | 3.66 KiB |
| 06 - Working with Large Datasets/006 Of Course You Remember!.mp4 | 4.42 MiB |
| 06 - Working with Large Datasets/006 Of Course You Remember!_en.srt | 2.21 KiB |
| 06 - Working with Large Datasets/GetFreeCourses.Co.url | 116 B |
| 06 - Working with Large Datasets/How you can help GetFreeCourses.Co.txt | 182 B |
| 07 - Sorting Records/001 The Basics of Sorting.mp4 | 6.73 MiB |
| 07 - Sorting Records/001 The Basics of Sorting_en.srt | 3.69 KiB |
| 07 - Sorting Records/002 Two Variations on Sorting.mp4 | 9.46 MiB |
| 07 - Sorting Records/002 Two Variations on Sorting_en.srt | 4.19 KiB |
| 07 - Sorting Records/003 Offset and Limit.mp4 | 19.43 MiB |
| 07 - Sorting Records/003 Offset and Limit_en.srt | 10.15 KiB |
| 07 - Sorting Records/004 Exercise Overview.mp4 | 1.08 MiB |
| 07 - Sorting Records/004 Exercise Overview_en.srt | 688 B |
| 07 - Sorting Records/005 Exercise Solution.mp4 | 3.33 MiB |
| 07 - Sorting Records/005 Exercise Solution_en.srt | 2.14 KiB |
| 08 - Unions and Intersections with Sets/001 Handling Sets with Union.mp4 | 19.51 MiB |
| 08 - Unions and Intersections with Sets/001 Handling Sets with Union_en.srt | 8.99 KiB |
| 08 - Unions and Intersections with Sets/002 A Few Notes on Union.mp4 | 16.54 MiB |
| 08 - Unions and Intersections with Sets/002 A Few Notes on Union_en.srt | 5.85 KiB |
| 08 - Unions and Intersections with Sets/003 Commonalities with Intersect.mp4 | 15.42 MiB |
| 08 - Unions and Intersections with Sets/003 Commonalities with Intersect_en.srt | 5.05 KiB |
| 08 - Unions and Intersections with Sets/004 Removing Commonalities with Except.mp4 | 20.44 MiB |
| 08 - Unions and Intersections with Sets/004 Removing Commonalities with Except_en.srt | 9.47 KiB |
| 08 - Unions and Intersections with Sets/005 Union Exercise Overview.mp4 | 4.23 MiB |
| 08 - Unions and Intersections with Sets/005 Union Exercise Overview_en.srt | 2.13 KiB |
| 08 - Unions and Intersections with Sets/006 Exercise Solution.mp4 | 4.72 MiB |
| 08 - Unions and Intersections with Sets/006 Exercise Solution_en.srt | 2.15 KiB |
| 09 - Assembling Queries with SubQueries/001 What's a Subquery.mp4 | 30.54 MiB |
| 09 - Assembling Queries with SubQueries/001 What's a Subquery_en.srt | 8.58 KiB |
| 09 - Assembling Queries with SubQueries/002 Thinking About the Structure of Data.mp4 | 23.64 MiB |
| 09 - Assembling Queries with SubQueries/002 Thinking About the Structure of Data_en.srt | 7.54 KiB |
| 09 - Assembling Queries with SubQueries/003 Subqueries in a Select.mp4 | 22.54 MiB |
| 09 - Assembling Queries with SubQueries/003 Subqueries in a Select_en.srt | 8.52 KiB |
| 09 - Assembling Queries with SubQueries/004 Exercise Overview.mp4 | 3.05 MiB |
| 09 - Assembling Queries with SubQueries/004 Exercise Overview_en.srt | 1.74 KiB |
| 09 - Assembling Queries with SubQueries/005 Select Solution.mp4 | 3.8 MiB |
| 09 - Assembling Queries with SubQueries/005 Select Solution_en.srt | 1.94 KiB |
| 09 - Assembling Queries with SubQueries/006 Subqueries in a From.mp4 | 44.45 MiB |
| 09 - Assembling Queries with SubQueries/006 Subqueries in a From_en.srt | 12.26 KiB |
| 09 - Assembling Queries with SubQueries/007 From Subqueries that Return a Value.mp4 | 9.08 MiB |
| 09 - Assembling Queries with SubQueries/007 From Subqueries that Return a Value_en.srt | 4.27 KiB |
| 09 - Assembling Queries with SubQueries/008 Example of a Subquery in a From.mp4 | 53.51 MiB |
| 09 - Assembling Queries with SubQueries/008 Example of a Subquery in a From_en.srt | 13.93 KiB |
| 09 - Assembling Queries with SubQueries/009 Exercise Overview.mp4 | 3.4 MiB |
| 09 - Assembling Queries with SubQueries/009 Exercise Overview_en.srt | 1.78 KiB |
| 09 - Assembling Queries with SubQueries/010 Exercise Solution.mp4 | 10.37 MiB |
| 09 - Assembling Queries with SubQueries/010 Exercise Solution_en.srt | 2.77 KiB |
| 09 - Assembling Queries with SubQueries/011 Subqueries in a Join Clause.mp4 | 16.55 MiB |
| 09 - Assembling Queries with SubQueries/011 Subqueries in a Join Clause_en.srt | 7.03 KiB |
| 09 - Assembling Queries with SubQueries/012 More Useful - Subqueries with Where.mp4 | 36.66 MiB |
| 09 - Assembling Queries with SubQueries/012 More Useful - Subqueries with Where_en.srt | 13.87 KiB |
| 09 - Assembling Queries with SubQueries/013 Data Structure with Where Subqueries.mp4 | 44.04 MiB |
| 09 - Assembling Queries with SubQueries/013 Data Structure with Where Subqueries_en.srt | 9 KiB |
| 09 - Assembling Queries with SubQueries/014 Exercise Overview.mp4 | 2.71 MiB |
| 09 - Assembling Queries with SubQueries/014 Exercise Overview_en.srt | 1.53 KiB |
| 09 - Assembling Queries with SubQueries/015 Exercise Solution.mp4 | 6.25 MiB |
| 09 - Assembling Queries with SubQueries/015 Exercise Solution_en.srt | 3.14 KiB |
| 09 - Assembling Queries with SubQueries/016 The Not In Operator with a List.mp4 | 38.59 MiB |
| 09 - Assembling Queries with SubQueries/016 The Not In Operator with a List_en.srt | 6.35 KiB |
| 09 - Assembling Queries with SubQueries/017 A New Where Operator.mp4 | 38.71 MiB |
| 09 - Assembling Queries with SubQueries/017 A New Where Operator_en.srt | 10.05 KiB |
| 09 - Assembling Queries with SubQueries/018 Finally Some!.mp4 | 31.96 MiB |
| 09 - Assembling Queries with SubQueries/018 Finally Some!_en.srt | 7.93 KiB |
| 09 - Assembling Queries with SubQueries/019 Exercise Overview.mp4 | 1.23 MiB |
| 09 - Assembling Queries with SubQueries/019 Exercise Overview_en.srt | 746 B |
| 09 - Assembling Queries with SubQueries/020 A Quick Solution.mp4 | 4.37 MiB |
| 09 - Assembling Queries with SubQueries/020 A Quick Solution_en.srt | 2.42 KiB |
| 09 - Assembling Queries with SubQueries/021 Probably Too Much About Correlated Subqueries.mp4 | 107 MiB |
| 09 - Assembling Queries with SubQueries/021 Probably Too Much About Correlated Subqueries_en.srt | 26.28 KiB |
| 09 - Assembling Queries with SubQueries/022 More on Correlated Subqueries.mp4 | 44.16 MiB |
| 09 - Assembling Queries with SubQueries/022 More on Correlated Subqueries_en.srt | 13.74 KiB |
| 09 - Assembling Queries with SubQueries/023 A Select Without a From.mp4 | 9.09 MiB |
| 09 - Assembling Queries with SubQueries/023 A Select Without a From_en.srt | 5.2 KiB |
| 09 - Assembling Queries with SubQueries/024 Exercise Overview.mp4 | 1.95 MiB |
| 09 - Assembling Queries with SubQueries/024 Exercise Overview_en.srt | 1.26 KiB |
| 09 - Assembling Queries with SubQueries/025 Exercise Solution.mp4 | 3.57 MiB |
| 09 - Assembling Queries with SubQueries/025 Exercise Solution_en.srt | 1.9 KiB |
| 10 - Selecting Distinct Records/001 Selecting Distinct Values.mp4 | 12.46 MiB |
| 10 - Selecting Distinct Records/001 Selecting Distinct Values_en.srt | 6.58 KiB |
| 10 - Selecting Distinct Records/002 Exercise Overview.mp4 | 1.3 MiB |
| 10 - Selecting Distinct Records/002 Exercise Overview_en.srt | 879 B |
| 10 - Selecting Distinct Records/003 A Distinct Solution.mp4 | 1.9 MiB |
| 10 - Selecting Distinct Records/003 A Distinct Solution_en.srt | 1006 B |
| 11 - Utility Operators, Keywords, and Functions/001 The Greatest Value in a List.mp4 | 11.77 MiB |
| 11 - Utility Operators, Keywords, and Functions/001 The Greatest Value in a List_en.srt | 5.13 KiB |
| 11 - Utility Operators, Keywords, and Functions/002 And the Least Value in a List!.mp4 | 5.55 MiB |
| 11 - Utility Operators, Keywords, and Functions/002 And the Least Value in a List!_en.srt | 3.14 KiB |
| 11 - Utility Operators, Keywords, and Functions/003 The Case Keyword.mp4 | 13.32 MiB |
| 11 - Utility Operators, Keywords, and Functions/003 The Case Keyword_en.srt | 6.91 KiB |
| 12 - Local PostgreSQL Installation/001 PostgreSQL Installation on macOS.mp4 | 21.13 MiB |
| 12 - Local PostgreSQL Installation/001 PostgreSQL Installation on macOS_en.srt | 9.83 KiB |
| 12 - Local PostgreSQL Installation/002 PGAdmin Setup on macOS.mp4 | 36.92 MiB |
| 12 - Local PostgreSQL Installation/002 PGAdmin Setup on macOS_en.srt | 8.04 KiB |
| 12 - Local PostgreSQL Installation/003 Postgres installation on Windows.mp4 | 23.31 MiB |
| 12 - Local PostgreSQL Installation/003 Postgres installation on Windows_en.srt | 6.75 KiB |
| 13 - PostgreSQL Complex Datatypes/001 What'd We Just Do.mp4 | 19.32 MiB |
| 13 - PostgreSQL Complex Datatypes/001 What'd We Just Do_en.srt | 6.45 KiB |
| 13 - PostgreSQL Complex Datatypes/002 Data Types.mp4 | 30.53 MiB |
| 13 - PostgreSQL Complex Datatypes/002 Data Types_en.srt | 7.02 KiB |
| 13 - PostgreSQL Complex Datatypes/003 Fast Rules on Numeric Data Types.mp4 | 18.9 MiB |
| 13 - PostgreSQL Complex Datatypes/003 Fast Rules on Numeric Data Types_en.srt | 3.6 KiB |
| 13 - PostgreSQL Complex Datatypes/004 More on Number Data Types.mp4 | 48.13 MiB |
| 13 - PostgreSQL Complex Datatypes/004 More on Number Data Types_en.srt | 15.2 KiB |
| 13 - PostgreSQL Complex Datatypes/005 Reminder on Character Types.mp4 | 29.9 MiB |
| 13 - PostgreSQL Complex Datatypes/005 Reminder on Character Types_en.srt | 7.83 KiB |
| 13 - PostgreSQL Complex Datatypes/006 Boolean Data Types.mp4 | 8.2 MiB |
| 13 - PostgreSQL Complex Datatypes/006 Boolean Data Types_en.srt | 4.37 KiB |
| 13 - PostgreSQL Complex Datatypes/007 Times, Dates, and Timestamps.mp4 | 21.27 MiB |
| 13 - PostgreSQL Complex Datatypes/007 Times, Dates, and Timestamps_en.srt | 8.48 KiB |
| 13 - PostgreSQL Complex Datatypes/008 Really Awesome Intervals.mp4 | 19.5 MiB |
| 13 - PostgreSQL Complex Datatypes/008 Really Awesome Intervals_en.srt | 9.12 KiB |
| 14 - Database-Side Validation and Constraints/001 Thinking About Validation.mp4 | 34.64 MiB |
| 14 - Database-Side Validation and Constraints/001 Thinking About Validation_en.srt | 6.7 KiB |
| 14 - Database-Side Validation and Constraints/002 Creating and Viewing Tables in PGAdmin.mp4 | 28.09 MiB |
| 14 - Database-Side Validation and Constraints/002 Creating and Viewing Tables in PGAdmin_en.srt | 11.63 KiB |
| 14 - Database-Side Validation and Constraints/003 Applying a Null Constraint.mp4 | 21.08 MiB |
| 14 - Database-Side Validation and Constraints/003 Applying a Null Constraint_en.srt | 10.38 KiB |
| 14 - Database-Side Validation and Constraints/004 Solving a Gotcha with Null Constraints.mp4 | 13.72 MiB |
| 14 - Database-Side Validation and Constraints/004 Solving a Gotcha with Null Constraints_en.srt | 6.69 KiB |
| 14 - Database-Side Validation and Constraints/005 Default Column Values.mp4 | 22.47 MiB |
| 14 - Database-Side Validation and Constraints/005 Default Column Values_en.srt | 5.16 KiB |
| 14 - Database-Side Validation and Constraints/006 Applying a Unique Constraint to One column.mp4 | 43.13 MiB |
| 14 - Database-Side Validation and Constraints/006 Applying a Unique Constraint to One column_en.srt | 9.32 KiB |
| 14 - Database-Side Validation and Constraints/007 Multi-Column Uniqueness.mp4 | 30.06 MiB |
| 14 - Database-Side Validation and Constraints/007 Multi-Column Uniqueness_en.srt | 5.54 KiB |
| 14 - Database-Side Validation and Constraints/008 Adding a Validation Check.mp4 | 18.21 MiB |
| 14 - Database-Side Validation and Constraints/008 Adding a Validation Check_en.srt | 6.35 KiB |
| 14 - Database-Side Validation and Constraints/009 Checks Over Multiple Columns.mp4 | 17.21 MiB |
| 14 - Database-Side Validation and Constraints/009 Checks Over Multiple Columns_en.srt | 8.04 KiB |
| 14 - Database-Side Validation and Constraints/010 So Where Are We Applying Validation.mp4 | 22.04 MiB |
| 14 - Database-Side Validation and Constraints/010 So Where Are We Applying Validation_en.srt | 9.74 KiB |
| 15 - Database Structure Design Patterns/001 Approaching More Complicated Designs.mp4 | 11.21 MiB |
| 15 - Database Structure Design Patterns/001 Approaching More Complicated Designs_en.srt | 5.36 KiB |
| 15 - Database Structure Design Patterns/002 Using a SQL Design Tool.mp4 | 47.29 MiB |
| 15 - Database Structure Design Patterns/002 Using a SQL Design Tool_en.srt | 10.01 KiB |
| 15 - Database Structure Design Patterns/003 A Config-based Schema Designer.mp4 | 28.69 MiB |
| 15 - Database Structure Design Patterns/003 A Config-based Schema Designer_en.srt | 11.68 KiB |
| 15 - Database Structure Design Patterns/004 Here's the Plan.mp4 | 9.63 MiB |
| 15 - Database Structure Design Patterns/004 Here's the Plan_en.srt | 4.2 KiB |
| 15 - Database Structure Design Patterns/005 005-design.dbml | 455 B |
| 15 - Database Structure Design Patterns/005 Rebuilding Some Schema.mp4 | 20.94 MiB |
| 15 - Database Structure Design Patterns/005 Rebuilding Some Schema_en.srt | 10.89 KiB |
| 16 - How to Build a 'Like' System/001 Requirements of a Like System.mp4 | 26.11 MiB |
| 16 - How to Build a 'Like' System/001 Requirements of a Like System_en.srt | 7.62 KiB |
| 16 - How to Build a 'Like' System/002 How Not to Design a Like System.mp4 | 16.22 MiB |
| 16 - How to Build a 'Like' System/002 How Not to Design a Like System_en.srt | 4.9 KiB |
| 16 - How to Build a 'Like' System/003 Designing a Like System.mp4 | 26.14 MiB |
| 16 - How to Build a 'Like' System/003 Designing a Like System_en.srt | 8.38 KiB |
| 16 - How to Build a 'Like' System/004 Making a Reaction System Instead.mp4 | 6.39 MiB |
| 16 - How to Build a 'Like' System/004 Making a Reaction System Instead_en.srt | 2.55 KiB |
| 16 - How to Build a 'Like' System/005 Polymorphic Associations.mp4 | 52.6 MiB |
| 16 - How to Build a 'Like' System/005 Polymorphic Associations_en.srt | 9.42 KiB |
| 16 - How to Build a 'Like' System/006 Polymorphic Association Alternative Implementation.mp4 | 63.84 MiB |
| 16 - How to Build a 'Like' System/006 Polymorphic Association Alternative Implementation_en.srt | 11.14 KiB |
| 16 - How to Build a 'Like' System/007 The Simplest Alternative.mp4 | 26.94 MiB |
| 16 - How to Build a 'Like' System/007 The Simplest Alternative_en.srt | 6.09 KiB |
| 16 - How to Build a 'Like' System/008 So Which Approach.mp4 | 16.02 MiB |
| 16 - How to Build a 'Like' System/008 So Which Approach_en.srt | 7.11 KiB |
| 17 - How to Build a 'Mention' System/001 Additional Features Around Posts.mp4 | 95.79 MiB |
| 17 - How to Build a 'Mention' System/001 Additional Features Around Posts_en.srt | 10.26 KiB |
| 17 - How to Build a 'Mention' System/002 Adding Captions and Locations.mp4 | 8.53 MiB |
| 17 - How to Build a 'Mention' System/002 Adding Captions and Locations_en.srt | 2.64 KiB |
| 17 - How to Build a 'Mention' System/003 Photo Mentions vs Caption Mentions.mp4 | 73.41 MiB |
| 17 - How to Build a 'Mention' System/003 Photo Mentions vs Caption Mentions_en.srt | 12.54 KiB |
| 17 - How to Build a 'Mention' System/004 Considerations on Photo Tags vs Caption Tags.mp4 | 67.08 MiB |
| 17 - How to Build a 'Mention' System/004 Considerations on Photo Tags vs Caption Tags_en.srt | 11.64 KiB |
| 17 - How to Build a 'Mention' System/005 Update For Tags.mp4 | 23.42 MiB |
| 17 - How to Build a 'Mention' System/005 Update For Tags_en.srt | 7.62 KiB |
| 18 - How to Build a 'Hashtag' System/001 Designing a Hashtag System.mp4 | 98.12 MiB |
| 18 - How to Build a 'Hashtag' System/001 Designing a Hashtag System_en.srt | 11.93 KiB |
| 18 - How to Build a 'Hashtag' System/002 Tables for Hashtags.mp4 | 14.45 MiB |
| 18 - How to Build a 'Hashtag' System/002 Tables for Hashtags_en.srt | 5.89 KiB |
| 18 - How to Build a 'Hashtag' System/003 Including the Hashtag Table.mp4 | 18.04 MiB |
| 18 - How to Build a 'Hashtag' System/003 Including the Hashtag Table_en.srt | 5.77 KiB |
| 18 - How to Build a 'Hashtag' System/004 A Few More User Columns.mp4 | 27.66 MiB |
| 18 - How to Build a 'Hashtag' System/004 A Few More User Columns_en.srt | 9.98 KiB |
| 18 - How to Build a 'Hashtag' System/005 Why No Number of Followers or Posts.mp4 | 17.1 MiB |
| 18 - How to Build a 'Hashtag' System/005 Why No Number of Followers or Posts_en.srt | 6.01 KiB |
| 19 - How to Design a 'Follower' System/001 Designing a Follower System.mp4 | 26.49 MiB |
| 19 - How to Design a 'Follower' System/001 Designing a Follower System_en.srt | 9.35 KiB |
| 19 - How to Design a 'Follower' System/GetFreeCourses.Co.url | 116 B |
| 19 - How to Design a 'Follower' System/How you can help GetFreeCourses.Co.txt | 182 B |
| 20 - Implementing Database Design Patterns/001 Back to Postgres.mp4 | 6.84 MiB |
| 20 - Implementing Database Design Patterns/001 Back to Postgres_en.srt | 3.2 KiB |
| 20 - Implementing Database Design Patterns/002 002-db.sql | 375 B |
| 20 - Implementing Database Design Patterns/002 Creating Tables with Checks.mp4 | 60.56 MiB |
| 20 - Implementing Database Design Patterns/002 Creating Tables with Checks_en.srt | 21.37 KiB |
| 20 - Implementing Database Design Patterns/003 003-db.sql | 791 B |
| 20 - Implementing Database Design Patterns/003 Posts Creation.mp4 | 36.16 MiB |
| 20 - Implementing Database Design Patterns/003 Posts Creation_en.srt | 12.82 KiB |
| 20 - Implementing Database Design Patterns/004 004-db.sql | 1.11 KiB |
| 20 - Implementing Database Design Patterns/004 Comments Creation.mp4 | 7.17 MiB |
| 20 - Implementing Database Design Patterns/004 Comments Creation_en.srt | 3.54 KiB |
| 20 - Implementing Database Design Patterns/005 005-db.sql | 1.55 KiB |
| 20 - Implementing Database Design Patterns/005 Likes Creation.mp4 | 23.87 MiB |
| 20 - Implementing Database Design Patterns/005 Likes Creation_en.srt | 10.52 KiB |
| 20 - Implementing Database Design Patterns/006 006-db.sql | 2.19 KiB |
| 20 - Implementing Database Design Patterns/006 Photo Tags and Caption Tags.mp4 | 41.35 MiB |
| 20 - Implementing Database Design Patterns/006 Photo Tags and Caption Tags_en.srt | 8.52 KiB |
| 20 - Implementing Database Design Patterns/007 007-db.sql | 2.84 KiB |
| 20 - Implementing Database Design Patterns/007 Creating Hashtags, Hashtag Posts, and Followers.mp4 | 19.85 MiB |
| 20 - Implementing Database Design Patterns/007 Creating Hashtags, Hashtag Posts, and Followers_en.srt | 9.4 KiB |
| 21 - Approaching and Writing Complex Queries/001 Quick Note About Adding Some Data.html | 251 B |
| 21 - Approaching and Writing Complex Queries/001 ig.sql | 23.51 MiB |
| 21 - Approaching and Writing Complex Queries/002 Adding Some Data.mp4 | 16.95 MiB |
| 21 - Approaching and Writing Complex Queries/002 Adding Some Data_en.srt | 6.8 KiB |
| 21 - Approaching and Writing Complex Queries/003 Restoring from Scratch.mp4 | 21.23 MiB |
| 21 - Approaching and Writing Complex Queries/003 Restoring from Scratch_en.srt | 7.13 KiB |
| 21 - Approaching and Writing Complex Queries/004 Highest User ID's Exercise.mp4 | 7.14 MiB |
| 21 - Approaching and Writing Complex Queries/004 Highest User ID's Exercise_en.srt | 3.16 KiB |
| 21 - Approaching and Writing Complex Queries/005 Solution for User ID's.mp4 | 4.64 MiB |
| 21 - Approaching and Writing Complex Queries/005 Solution for User ID's_en.srt | 1.9 KiB |
| 21 - Approaching and Writing Complex Queries/006 Posts by a Particular User.mp4 | 4.81 MiB |
| 21 - Approaching and Writing Complex Queries/006 Posts by a Particular User_en.srt | 1.76 KiB |
| 21 - Approaching and Writing Complex Queries/007 Solving for Posts by User.mp4 | 9.39 MiB |
| 21 - Approaching and Writing Complex Queries/007 Solving for Posts by User_en.srt | 2.9 KiB |
| 21 - Approaching and Writing Complex Queries/008 Likes Per User.mp4 | 3.59 MiB |
| 21 - Approaching and Writing Complex Queries/008 Likes Per User_en.srt | 1.29 KiB |
| 21 - Approaching and Writing Complex Queries/009 Solution for Likes Per User.mp4 | 6.6 MiB |
| 21 - Approaching and Writing Complex Queries/009 Solution for Likes Per User_en.srt | 2.47 KiB |
| 22 - Understanding the Internals of PostgreSQL/001 Thinking About Performance.mp4 | 9.24 MiB |
| 22 - Understanding the Internals of PostgreSQL/001 Thinking About Performance_en.srt | 3.53 KiB |
| 22 - Understanding the Internals of PostgreSQL/002 Where Does Postgres Store Data.mp4 | 37.02 MiB |
| 22 - Understanding the Internals of PostgreSQL/002 Where Does Postgres Store Data_en.srt | 8.8 KiB |
| 22 - Understanding the Internals of PostgreSQL/003 Heaps, Blocks, and Tuples.mp4 | 22.73 MiB |
| 22 - Understanding the Internals of PostgreSQL/003 Heaps, Blocks, and Tuples_en.srt | 5.9 KiB |
| 22 - Understanding the Internals of PostgreSQL/004 Block Data Layout.mp4 | 17.24 MiB |
| 22 - Understanding the Internals of PostgreSQL/004 Block Data Layout_en.srt | 7.19 KiB |
| 22 - Understanding the Internals of PostgreSQL/005 Heap File Layout.mp4 | 597.17 MiB |
| 22 - Understanding the Internals of PostgreSQL/005 Heap File Layout_en.srt | 50.58 KiB |
| 23 - A Look at Indexes for Performance/001 Full Table Scans.mp4 | 37.18 MiB |
| 23 - A Look at Indexes for Performance/001 Full Table Scans_en.srt | 6.39 KiB |
| 23 - A Look at Indexes for Performance/002 What's an Index.mp4 | 10.1 MiB |
| 23 - A Look at Indexes for Performance/002 What's an Index_en.srt | 3.9 KiB |
| 23 - A Look at Indexes for Performance/003 How an Index Works.mp4 | 69.31 MiB |
| 23 - A Look at Indexes for Performance/003 How an Index Works_en.srt | 12.83 KiB |
| 23 - A Look at Indexes for Performance/004 Creating an Index.mp4 | 13.11 MiB |
| 23 - A Look at Indexes for Performance/004 Creating an Index_en.srt | 6.55 KiB |
| 23 - A Look at Indexes for Performance/005 Benchmarking Queries.mp4 | 22.58 MiB |
| 23 - A Look at Indexes for Performance/005 Benchmarking Queries_en.srt | 8.46 KiB |
| 23 - A Look at Indexes for Performance/006 Downsides of Indexes.mp4 | 31.82 MiB |
| 23 - A Look at Indexes for Performance/006 Downsides of Indexes_en.srt | 7.83 KiB |
| 23 - A Look at Indexes for Performance/007 Index Types.mp4 | 6.46 MiB |
| 23 - A Look at Indexes for Performance/007 Index Types_en.srt | 2.52 KiB |
| 23 - A Look at Indexes for Performance/008 Automatically Generated Indexes.mp4 | 19.74 MiB |
| 23 - A Look at Indexes for Performance/008 Automatically Generated Indexes_en.srt | 5.62 KiB |
| 23 - A Look at Indexes for Performance/009 Behind the Scenes of Indexes.mp4 | 398.75 MiB |
| 24 - Basic Query Tuning/001 The Query Processing Pipeline.mp4 | 25.73 MiB |
| 24 - Basic Query Tuning/001 The Query Processing Pipeline_en.srt | 8.33 KiB |
| 24 - Basic Query Tuning/002 Explain and Explain Analyze.mp4 | 42.83 MiB |
| 24 - Basic Query Tuning/002 Explain and Explain Analyze_en.srt | 8.39 KiB |
| 24 - Basic Query Tuning/003 Solving an Explain Mystery.mp4 | 79.79 MiB |
| 24 - Basic Query Tuning/003 Solving an Explain Mystery_en.srt | 14.13 KiB |
| 25 - Advanced Query Tuning/001 Developing an Intuitive Understanding of Cost.mp4 | 102.89 MiB |
| 25 - Advanced Query Tuning/001 Developing an Intuitive Understanding of Cost_en.srt | 20.13 KiB |
| 25 - Advanced Query Tuning/002 Calculating Cost by Hand.mp4 | 51.25 MiB |
| 25 - Advanced Query Tuning/002 Calculating Cost by Hand_en.srt | 10.01 KiB |
| 25 - Advanced Query Tuning/003 A Touch More on Costs.mp4 | 95.4 MiB |
| 25 - Advanced Query Tuning/003 A Touch More on Costs_en.srt | 11.11 KiB |
| 25 - Advanced Query Tuning/004 Startup vs Total Costs.mp4 | 44.7 MiB |
| 25 - Advanced Query Tuning/004 Startup vs Total Costs_en.srt | 8.98 KiB |
| 25 - Advanced Query Tuning/005 Costs Flow Up.mp4 | 10.1 MiB |
| 25 - Advanced Query Tuning/005 Costs Flow Up_en.srt | 3 KiB |
| 25 - Advanced Query Tuning/006 Use My Index!.mp4 | 39.4 MiB |
| 25 - Advanced Query Tuning/006 Use My Index!_en.srt | 12.52 KiB |
| 26 - Simple Common Table Expressions/001 Common Table Expressions.mp4 | 11.19 MiB |
| 26 - Simple Common Table Expressions/001 Common Table Expressions_en.srt | 2.94 KiB |
| 26 - Simple Common Table Expressions/002 A Quick Solution.mp4 | 13.16 MiB |
| 26 - Simple Common Table Expressions/002 A Quick Solution_en.srt | 5.87 KiB |
| 26 - Simple Common Table Expressions/003 So What's a CTE.mp4 | 33.5 MiB |
| 26 - Simple Common Table Expressions/003 So What's a CTE_en.srt | 6.19 KiB |
| 27 - Recursive Common Table Expressions/001 Recursive CTE's.mp4 | 11.9 MiB |
| 27 - Recursive Common Table Expressions/002 Recursive CTE's Step by Step.mp4 | 62.89 MiB |
| 27 - Recursive Common Table Expressions/002 Recursive CTE's Step by Step_en.srt | 16.13 KiB |
| 27 - Recursive Common Table Expressions/003 Why Use Recursive CTE's.mp4 | 43.14 MiB |
| 27 - Recursive Common Table Expressions/003 Why Use Recursive CTE's_en.srt | 7.59 KiB |
| 27 - Recursive Common Table Expressions/004 Writing the Query.mp4 | 36.56 MiB |
| 27 - Recursive Common Table Expressions/004 Writing the Query_en.srt | 12.49 KiB |
| 27 - Recursive Common Table Expressions/005 Walking Through Recursion.mp4 | 109.41 MiB |
| 27 - Recursive Common Table Expressions/005 Walking Through Recursion_en.srt | 14.96 KiB |
| 28 - Simplifying Queries with Views/001 Most Popular Users.mp4 | 24.81 MiB |
| 28 - Simplifying Queries with Views/001 Most Popular Users_en.srt | 10.22 KiB |
| 28 - Simplifying Queries with Views/002 A Possible Solution for Merging Tables.mp4 | 35.67 MiB |
| 28 - Simplifying Queries with Views/002 A Possible Solution for Merging Tables_en.srt | 6.11 KiB |
| 28 - Simplifying Queries with Views/003 Creating a View.mp4 | 33.33 MiB |
| 28 - Simplifying Queries with Views/003 Creating a View_en.srt | 8.82 KiB |
| 28 - Simplifying Queries with Views/004 When to Use a View.mp4 | 21.21 MiB |
| 28 - Simplifying Queries with Views/004 When to Use a View_en.srt | 5.06 KiB |
| 28 - Simplifying Queries with Views/005 Deleting and Changing Views.mp4 | 12.51 MiB |
| 29 - Optimizing Queries with Materialized Views/001 Materialized Views.mp4 | 8.38 MiB |
| 29 - Optimizing Queries with Materialized Views/001 Materialized Views_en.srt | 3.93 KiB |
| 29 - Optimizing Queries with Materialized Views/002 Grouping by Week.mp4 | 34.4 MiB |
| 29 - Optimizing Queries with Materialized Views/002 Grouping by Week_en.srt | 6.53 KiB |
| 29 - Optimizing Queries with Materialized Views/003 Reminder on Left Joins.mp4 | 15.51 MiB |
| 29 - Optimizing Queries with Materialized Views/003 Reminder on Left Joins_en.srt | 7.11 KiB |
| 29 - Optimizing Queries with Materialized Views/004 Writing a Slow Query.mp4 | 55.08 MiB |
| 29 - Optimizing Queries with Materialized Views/004 Writing a Slow Query_en.srt | 13.96 KiB |
| 29 - Optimizing Queries with Materialized Views/005 Creating and Refreshing Materialized Views.mp4 | 36.1 MiB |
| 29 - Optimizing Queries with Materialized Views/005 Creating and Refreshing Materialized Views_en.srt | 9.74 KiB |
| 29 - Optimizing Queries with Materialized Views/GetFreeCourses.Co.url | 116 B |
| 29 - Optimizing Queries with Materialized Views/How you can help GetFreeCourses.Co.txt | 182 B |
| 30 - Handling Concurrency and Reversibility with Transactions/001 What are Transactions Used For.mp4 | 22.54 MiB |
| 30 - Handling Concurrency and Reversibility with Transactions/001 What are Transactions Used For_en.srt | 6.36 KiB |
| 30 - Handling Concurrency and Reversibility with Transactions/002 Some Sample Data.mp4 | 5.44 MiB |
| 30 - Handling Concurrency and Reversibility with Transactions/002 Some Sample Data_en.srt | 3.28 KiB |
| 30 - Handling Concurrency and Reversibility with Transactions/003 Opening and Closing Transactions.mp4 | 65.33 MiB |
| 30 - Handling Concurrency and Reversibility with Transactions/003 Opening and Closing Transactions_en.srt | 15.13 KiB |
| 30 - Handling Concurrency and Reversibility with Transactions/004 Transaction Cleanup on Crash.mp4 | 32.89 MiB |
| 30 - Handling Concurrency and Reversibility with Transactions/005 Closing Aborted Transactions.mp4 | 7.47 MiB |
| 30 - Handling Concurrency and Reversibility with Transactions/005 Closing Aborted Transactions_en.srt | 2.87 KiB |
| 31 - Managing Database Design with Schema Migrations/001 A Story on Migrations.mp4 | 139.7 MiB |
| 31 - Managing Database Design with Schema Migrations/001 A Story on Migrations_en.srt | 28.04 KiB |
| 31 - Managing Database Design with Schema Migrations/002 Migration Files.mp4 | 44.16 MiB |
| 31 - Managing Database Design with Schema Migrations/002 Migration Files_en.srt | 7.5 KiB |
| 31 - Managing Database Design with Schema Migrations/003 Issues Solved by Migrations.mp4 | 1 MiB |
| 31 - Managing Database Design with Schema Migrations/003 Issues Solved by Migrations_en.srt | 4.52 KiB |
| 31 - Managing Database Design with Schema Migrations/004 A Few Notes on Migrations Libraries.mp4 | 34.19 MiB |
| 31 - Managing Database Design with Schema Migrations/004 A Few Notes on Migrations Libraries_en.srt | 7.56 KiB |
| 31 - Managing Database Design with Schema Migrations/005 A Note About Node Installation.html | 264 B |
| 31 - Managing Database Design with Schema Migrations/006 Project Creation.mp4 | 9.91 MiB |
| 31 - Managing Database Design with Schema Migrations/006 Project Creation_en.srt | 4.51 KiB |
| 31 - Managing Database Design with Schema Migrations/007 Generating and Writing Migrations.mp4 | 45.64 MiB |
| 31 - Managing Database Design with Schema Migrations/007 Generating and Writing Migrations_en.srt | 10.4 KiB |
| 31 - Managing Database Design with Schema Migrations/008 Applying and Reverting Migrations.mp4 | 68.14 MiB |
| 31 - Managing Database Design with Schema Migrations/008 Applying and Reverting Migrations_en.srt | 11.52 KiB |
| 31 - Managing Database Design with Schema Migrations/009 Generating and Applying a Second Migration.mp4 | 16.63 MiB |
| 31 - Managing Database Design with Schema Migrations/009 Generating and Applying a Second Migration_en.srt | 5.43 KiB |
| 32 - Schema vs Data Migrations/001 Schema vs Data Migrations.mp4 | 20.28 MiB |
| 32 - Schema vs Data Migrations/002 Dangers Around Data Migrations.mp4 | 7 MiB |
| 32 - Schema vs Data Migrations/002 Dangers Around Data Migrations_en.srt | 14.78 KiB |
| 32 - Schema vs Data Migrations/003 Properly Running Data and Schema Migrations.mp4 | 19.73 MiB |
| 32 - Schema vs Data Migrations/003 Properly Running Data and Schema Migrations_en.srt | 8.6 KiB |
| 32 - Schema vs Data Migrations/004 Creating a Posts Table.mp4 | 21.59 MiB |
| 32 - Schema vs Data Migrations/004 Creating a Posts Table_en.srt | 7.11 KiB |
| 32 - Schema vs Data Migrations/005 005-index.js | 1.32 KiB |
| 32 - Schema vs Data Migrations/005 A Small Web Server.mp4 | 62.26 MiB |
| 32 - Schema vs Data Migrations/006 Web Server Setup Instructions.html | 1.02 KiB |
| 32 - Schema vs Data Migrations/007 Adding the Loc Column.mp4 | 21.55 MiB |
| 32 - Schema vs Data Migrations/007 Adding the Loc Column_en.srt | 6.29 KiB |
| 32 - Schema vs Data Migrations/008 Writing Values to Both Columns.mp4 | 16.26 MiB |
| 32 - Schema vs Data Migrations/008 Writing Values to Both Columns_en.srt | 6.71 KiB |
| 32 - Schema vs Data Migrations/009 Transaction Locks.mp4 | 96.42 MiB |
| 32 - Schema vs Data Migrations/009 Transaction Locks_en.srt | 22.44 KiB |
| 32 - Schema vs Data Migrations/010 Updating Values.mp4 | 15.27 MiB |
| 32 - Schema vs Data Migrations/010 Updating Values_en.srt | 6.43 KiB |
| 32 - Schema vs Data Migrations/011 01-lng-lat-to-loc.js | 364 B |
| 32 - Schema vs Data Migrations/011 Migrations Setup Instructions.html | 925 B |
| 32 - Schema vs Data Migrations/012 Updating the App Server.mp4 | 13.23 MiB |
| 32 - Schema vs Data Migrations/012 Updating the App Server_en.srt | 6.56 KiB |
| 32 - Schema vs Data Migrations/013 Dropping the Last Columns.mp4 | 11.61 MiB |
| 32 - Schema vs Data Migrations/013 Dropping the Last Columns_en.srt | 4.65 KiB |
| 33 - Accessing PostgreSQL From API's/001 Section Goal.mp4 | 2.62 MiB |
| 33 - Accessing PostgreSQL From API's/001 Section Goal_en.srt | 1.56 KiB |
| 33 - Accessing PostgreSQL From API's/002 Initial Setup.mp4 | 2.23 MiB |
| 33 - Accessing PostgreSQL From API's/002 Initial Setup_en.srt | 2.45 KiB |
| 33 - Accessing PostgreSQL From API's/003 One Fast Migration.mp4 | 24.43 MiB |
| 33 - Accessing PostgreSQL From API's/004 005-access-social-repo.zip | 61.31 KiB |
| 33 - Accessing PostgreSQL From API's/004 Building the Users Router.mp4 | 29.61 MiB |
| 33 - Accessing PostgreSQL From API's/004 Building the Users Router_en.srt | 7.07 KiB |
| 33 - Accessing PostgreSQL From API's/005 Understanding Connection Pools.mp4 | 22.93 MiB |
| 33 - Accessing PostgreSQL From API's/005 Understanding Connection Pools_en.srt | 10.65 KiB |
| 33 - Accessing PostgreSQL From API's/006 Validating Connection Credentials.mp4 | 44.74 MiB |
| 33 - Accessing PostgreSQL From API's/006 Validating Connection Credentials_en.srt | 10.59 KiB |
| 33 - Accessing PostgreSQL From API's/007 008-access.zip | 62 KiB |
| 33 - Accessing PostgreSQL From API's/007 Query and Close.mp4 | 5.9 MiB |
| 33 - Accessing PostgreSQL From API's/007 Query and Close_en.srt | 3.18 KiB |
| 34 - Data Access Pattern - Repositories/001 The Repository Pattern.mp4 | 17.88 MiB |
| 34 - Data Access Pattern - Repositories/001 The Repository Pattern_en.srt | 5.69 KiB |
| 34 - Data Access Pattern - Repositories/002 010-access.zip | 62.58 KiB |
| 34 - Data Access Pattern - Repositories/002 Creating a Repository.mp4 | 24.78 MiB |
| 34 - Data Access Pattern - Repositories/002 Creating a Repository_en.srt | 12.66 KiB |
| 34 - Data Access Pattern - Repositories/003 Accessing the API.mp4 | 23.55 MiB |
| 34 - Data Access Pattern - Repositories/003 Accessing the API_en.srt | 6.25 KiB |
| 34 - Data Access Pattern - Repositories/004 Casing Issues.mp4 | 18.55 MiB |
| 34 - Data Access Pattern - Repositories/004 Casing Issues_en.srt | 6.88 KiB |
| 34 - Data Access Pattern - Repositories/005 Fixing Casing.mp4 | 49.74 MiB |
| 34 - Data Access Pattern - Repositories/005 Fixing Casing_en.srt | 9.99 KiB |
| 34 - Data Access Pattern - Repositories/006 Finding Particular Users.mp4 | 18.16 MiB |
| 34 - Data Access Pattern - Repositories/006 Finding Particular Users_en.srt | 8.38 KiB |
| 35 - Security Around PostgreSQL/001 SQL Injection Exploits.mp4 | 30.46 MiB |
| 35 - Security Around PostgreSQL/001 SQL Injection Exploits_en.srt | 10.71 KiB |
| 35 - Security Around PostgreSQL/002 Handling SQL Injection with Prepared Statements.mp4 | 38.15 MiB |
| 35 - Security Around PostgreSQL/002 Handling SQL Injection with Prepared Statements_en.srt | 12.78 KiB |
| 35 - Security Around PostgreSQL/003 Preventing SQL Injection.mp4 | 34.29 MiB |
| 35 - Security Around PostgreSQL/003 Preventing SQL Injection_en.srt | 11.96 KiB |
| 35 - Security Around PostgreSQL/004 Reminder on Post Requests.mp4 | 14.4 MiB |
| 35 - Security Around PostgreSQL/004 Reminder on Post Requests_en.srt | 4.28 KiB |
| 35 - Security Around PostgreSQL/005 019-access.zip | 63.56 KiB |
| 35 - Security Around PostgreSQL/005 Inserting Users.mp4 | 15.25 MiB |
| 35 - Security Around PostgreSQL/005 Inserting Users_en.srt | 6.53 KiB |
| 35 - Security Around PostgreSQL/006 Handling Updates.mp4 | 16.66 MiB |
| 35 - Security Around PostgreSQL/006 Handling Updates_en.srt | 7 KiB |
| 35 - Security Around PostgreSQL/007 021-access.zip | 63.66 KiB |
| 35 - Security Around PostgreSQL/007 And, Finally, Delete.mp4 | 18.24 MiB |
| 35 - Security Around PostgreSQL/007 And, Finally, Delete_en.srt | 6.7 KiB |
| 36 - Fast Parallel Testing/001 A Note on Testing.mp4 | 7.64 MiB |
| 36 - Fast Parallel Testing/001 A Note on Testing_en.srt | 5.07 KiB |
| 36 - Fast Parallel Testing/002 Assertions Around User Count.mp4 | 42.34 MiB |
| 36 - Fast Parallel Testing/002 Assertions Around User Count_en.srt | 11.15 KiB |
| 36 - Fast Parallel Testing/003 024-access.zip | 64.5 KiB |
| 36 - Fast Parallel Testing/003 Connecting to a DB For Tests.mp4 | 54.23 MiB |
| 36 - Fast Parallel Testing/003 Connecting to a DB For Tests_en.srt | 8.19 KiB |
| 36 - Fast Parallel Testing/004 025-access.zip | 64.51 KiB |
| 36 - Fast Parallel Testing/004 Disconnecting After Tests.mp4 | 12.86 MiB |
| 36 - Fast Parallel Testing/004 Disconnecting After Tests_en.srt | 4.86 KiB |
| 36 - Fast Parallel Testing/005 026-access.zip | 64.52 KiB |
| 36 - Fast Parallel Testing/005 Multi-DB Setup.mp4 | 21.85 MiB |
| 36 - Fast Parallel Testing/005 Multi-DB Setup_en.srt | 7.31 KiB |
| 36 - Fast Parallel Testing/006 027-access.zip | 64.52 KiB |
| 36 - Fast Parallel Testing/006 Assumptions Around Content.mp4 | 33.12 MiB |
| 36 - Fast Parallel Testing/006 Assumptions Around Content_en.srt | 8.08 KiB |
| 36 - Fast Parallel Testing/007 028-access.zip | 65.77 KiB |
| 36 - Fast Parallel Testing/007 Issues with Parallel Tests.mp4 | 35.76 MiB |
| 36 - Fast Parallel Testing/007 Issues with Parallel Tests_en.srt | 8.34 KiB |
| 36 - Fast Parallel Testing/008 Isolation with Schemas.mp4 | 27.4 MiB |
| 36 - Fast Parallel Testing/008 Isolation with Schemas_en.srt | 6.59 KiB |
| 36 - Fast Parallel Testing/009 Creating and Accessing Schemas.mp4 | 19.38 MiB |
| 36 - Fast Parallel Testing/009 Creating and Accessing Schemas_en.srt | 8.21 KiB |
| 36 - Fast Parallel Testing/010 Controlling Schema Access with Search Paths.mp4 | 30.95 MiB |
| 36 - Fast Parallel Testing/010 Controlling Schema Access with Search Paths_en.srt | 8.82 KiB |
| 36 - Fast Parallel Testing/011 Routing Schema Access.mp4 | 41.12 MiB |
| 36 - Fast Parallel Testing/011 Routing Schema Access_en.srt | 6.47 KiB |
| 36 - Fast Parallel Testing/012 Strategy for Isolation.mp4 | 17.57 MiB |
| 36 - Fast Parallel Testing/012 Strategy for Isolation_en.srt | 7.17 KiB |
| 36 - Fast Parallel Testing/013 034-access.zip | 66.14 KiB |
| 36 - Fast Parallel Testing/013 Programmatic Schema Creation.mp4 | 65.75 MiB |
| 36 - Fast Parallel Testing/013 Programmatic Schema Creation_en.srt | 18.58 KiB |
| 36 - Fast Parallel Testing/014 035-access.zip | 66.14 KiB |
| 36 - Fast Parallel Testing/014 Escaping Identifiers.mp4 | 25.53 MiB |
| 36 - Fast Parallel Testing/014 Escaping Identifiers_en.srt | 6.73 KiB |
| 36 - Fast Parallel Testing/015 036-access.zip | 66.48 KiB |
| 36 - Fast Parallel Testing/015 Test Helpers.mp4 | 43.34 MiB |
| 36 - Fast Parallel Testing/015 Test Helpers_en.srt | 8.1 KiB |
| 36 - Fast Parallel Testing/016 037-access.zip | 66.59 KiB |
| 36 - Fast Parallel Testing/016 Cleaning up Schemas and Roles.mp4 | 31.28 MiB |
| 36 - Fast Parallel Testing/016 Cleaning up Schemas and Roles_en.srt | 8.5 KiB |
| 36 - Fast Parallel Testing/017 Finally... Parallel Tests! (Final Lecture).mp4 | 18.57 MiB |
| 36 - Fast Parallel Testing/017 Finally... Parallel Tests! (Final Lecture)_en.srt | 5.14 KiB |
| 36 - Fast Parallel Testing/GetFreeCourses.Co.url | 116 B |
| 36 - Fast Parallel Testing/How you can help GetFreeCourses.Co.txt | 182 B |
| 37 - Bonus!/001 Bonus!.html | 3.37 KiB |
| Download Paid Udemy Courses For Free.url | 116 B |
| GetFreeCourses.Co.url | 116 B |
| How you can help GetFreeCourses.Co.txt | 182 B |
