Udemy SQL and PostgreSQL The Complete Developer Guide 2024 | 73797D8952AE59CADE265E637102DC7EA45AEA94

Udemy SQL and PostgreSQL The Complete Developer Guide 2024

Name	Udemy - SQL and PostgreSQL The Complete Developer's Guide (7.2024)	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	5.4 GB
Total Files	653
Last Seen
Hash	73797D8952AE59CADE265E637102DC7EA45AEA94

/01 - Simple - But Powerful - SQL Statements/
001 Join Our Community!.html	0.3 KB
01 - Simple - But Powerful - SQL Statements/
002 Course Resources.html	1.3 KB
002 diagrams.zip	8.1 MB
003 What is PostgreSQL All About.mp4	22.8 MB
003 What is PostgreSQL All About.srt	7.4 KB
004 Database Design.mp4	37.1 MB
004 Database Design.srt	8.4 KB
005 Database Terminology.html	10.3 KB
006 003-sql.sql	0.1 KB
006 Creating Tables.mp4	19.5 MB
006 Creating Tables.srt	7.9 KB
007 Analyzing CREATE TABLE.mp4	11.9 MB
007 Analyzing CREATE TABLE.srt	5.7 KB
008 005-sql-cumulative.sql	0.4 KB
008 005-sql.sql	0.3 KB
008 Inserting Data Into a Table.mp4	12.7 MB
008 Inserting Data Into a Table.srt	7.8 KB
009 Retrieving Data with Select.mp4	4.2 MB
009 Retrieving Data with Select.srt	3.5 KB
010 Create, Insert, and Select!.html	4.6 KB
011 Calculated Columns.mp4	10.9 MB
011 Calculated Columns.srt	7.4 KB
012 Calculating Phone Revenue.mp4	2.3 MB
012 Calculating Phone Revenue.srt	1.6 KB
013 Using Calculated Columns.html	5.5 KB
014 Exercise Solution.mp4	2.3 MB
014 Exercise Solution.srt	1.7 KB
015 012-sql.sql	0.4 KB
015 String Operators and Functions.mp4	11.9 MB
015 String Operators and Functions.srt	10.4 KB
02 - Filtering Records/
001 013-sql.sql	0.0 KB
001 Filtering Rows with Where.mp4	8.8 MB
001 Filtering Rows with Where.srt	6.1 KB
002 More on the Where Keyword.mp4	6.3 MB
002 More on the Where Keyword.srt	3.9 KB
003 Compound Where Clauses.mp4	13.4 MB
003 Compound Where Clauses.srt	7.7 KB
004 A Where Exercise Overview.mp4	1.3 MB
004 A Where Exercise Overview.srt	0.9 KB
005 Practicing Where Statements.html	5.2 KB
006 A Where Solution.mp4	2.0 MB
006 A Where Solution.srt	1.6 KB
007 Where With Lists.mp4	1.2 MB
007 Where With Lists.srt	1.1 KB
008 A More Challenging 'Where'.html	5.2 KB
009 A Where With Lists Solution.mp4	3.7 MB
009 A Where With Lists Solution.srt	2.6 KB
010 Calculations in Where Clauses.mp4	3.6 MB
010 Calculations in Where Clauses.srt	3.1 KB
011 Trying Calculations in Where Clauses.html	5.8 KB
012 Solving Calculations.mp4	4.4 MB
012 Solving Calculations.srt	3.0 KB
013 Updating Rows.mp4	12.3 MB
013 Updating Rows.srt	6.5 KB
014 Deleting Rows.mp4	7.9 MB
014 Deleting Rows.srt	5.4 KB
015 Try Updating Records In a Table!.html	5.4 KB
016 A Solution for Updating Rows.mp4	3.6 MB
016 A Solution for Updating Rows.srt	2.0 KB
017 Practice Deleting Records.html	5.3 KB
018 Solution for Deleting Rows.mp4	2.9 MB
018 Solution for Deleting Rows.srt	2.3 KB
03 - Working with Tables/
001 The Plan Moving Forward.mp4	7.4 MB
001 The Plan Moving Forward.srt	2.8 KB
002 Approaching Database Design.mp4	32.0 MB
002 Approaching Database Design.srt	12.1 KB
003 Let's Design Some Schema.html	10.8 KB
004 One-to-Many and Many-to-One Relationships.mp4	27.5 MB
004 One-to-Many and Many-to-One Relationships.srt	10.4 KB
005 A 'Has One' or 'Has Many'.html	13.4 KB
006 One-to-One and Many-to-Many Relationships.mp4	16.0 MB
006 One-to-One and Many-to-Many Relationships.srt	9.0 KB
007 Identifying One-to-One and Many-to-Many Relationships.html	11.8 KB
008 Primary Keys and Foreign Keys.mp4	19.7 MB
008 Primary Keys and Foreign Keys.srt	8.1 KB
009 Understanding Foreign Keys.mp4	43.6 MB
009 Understanding Foreign Keys.srt	13.3 KB
010 Foreign Keys; How Do They Work.html	13.9 KB
011 007-tables-cumulative.sql	0.2 KB
011 007-tables.sql	0.2 KB
011 Auto-Generated ID's.mp4	15.3 MB
011 Auto-Generated ID's.srt	9.4 KB
012 008-tables-cumulative.sql	0.3 KB
012 008-tables.sql	0.2 KB
012 Creating Foreign Key Columns.mp4	12.6 MB
012 Creating Foreign Key Columns.srt	7.8 KB
013 009-tables-cumulative.sql	0.5 KB
013 009-tables.sql	0.3 KB
013 Running Queries on Associated Data.mp4	25.7 MB
013 Running Queries on Associated Data.srt	10.9 KB
014 Exercise Overview.mp4	5.6 MB
014 Exercise Overview.srt	3.3 KB
015 Creating and Using Foreign Keys.html	5.1 KB
016 Foreign Key Creation Solution.mp4	5.7 MB
016 Foreign Key Creation Solution.srt	3.2 KB
017 012-tables-cumulative.sql	0.6 KB
017 012-tables.sql	0.2 KB
017 Foreign Key Constraints Around Insertion.mp4	15.7 MB
017 Foreign Key Constraints Around Insertion.srt	8.9 KB
018 Constraints Around Deletion.mp4	27.2 MB
018 Constraints Around Deletion.srt	8.0 KB
019 Commands You’ll Need for the Next Video.html	0.7 KB
020 014-tables-cumulative.sql	1.0 KB
020 014-tables.sql	0.5 KB
020 Testing Deletion Constraints.mp4	13.1 MB
020 Testing Deletion Constraints.srt	7.3 KB
021 015-tables-cumulative.sql	1.3 KB
021 015-tables.sql	0.3 KB
021 Setting Foreign Keys to Null on Delete.mp4	8.7 MB
021 Setting Foreign Keys to Null on Delete.srt	4.7 KB
022 What Happens On Delete.html	11.3 KB
023 Adding Some Complexity.mp4	7.1 MB
023 Adding Some Complexity.srt	4.9 KB
04 - Relating Records with Joins/
001 Adding Some Data.html	7.8 KB
002 Queries with Joins and Aggregations.mp4	18.6 MB
002 Queries with Joins and Aggregations.srt	5.4 KB
003 Joining Data from Different Tables.mp4	24.9 MB
003 Joining Data from Different Tables.srt	11.9 KB
004 Another Quick Join.mp4	5.9 MB
004 Another Quick Join.srt	3.5 KB
005 Exercise Overview.mp4	3.2 MB
005 Exercise Overview.srt	1.9 KB
006 Practice Joining Data.html	5.4 KB
007 A Joinful Solution.mp4	3.6 MB
007 A Joinful Solution.srt	2.8 KB
008 Alternate Forms of Syntax.mp4	17.1 MB
008 Alternate Forms of Syntax.srt	9.5 KB
009 007-joins-cumulative.sql	7.7 KB
009 Missing Data in Joins.mp4	20.0 MB
009 Missing Data in Joins.srt	10.3 KB
010 Why Wasn't It Included.mp4	15.7 MB
010 Why Wasn't It Included.srt	3.9 KB
011 009-joins-cheatsheet.pdf	195.1 KB
011 Four Kinds of Joins.mp4	78.8 MB
011 Four Kinds of Joins.srt	15.5 KB
012 010-sql-cumulative.sql	7.8 KB
012 Each Join in Practice.mp4	24.6 MB
012 Each Join in Practice.srt	6.9 KB
013 Does Order Matter.mp4	37.7 MB
013 Does Order Matter.srt	6.5 KB
014 Test Your Joining Knowledge.html	21.7 KB
015 Exercise Overview.mp4	1.6 MB
015 Exercise Overview.srt	1.6 KB
016 Joins, Joins, Join!.html	5.2 KB
017 Two Possible Solutions.mp4	10.7 MB
017 Two Possible Solutions.srt	4.9 KB
018 Where with Join.mp4	21.2 MB
018 Where with Join.srt	10.9 KB
019 Three Way Joins.mp4	33.6 MB
019 Three Way Joins.srt	12.5 KB
020 A Bit of Practice.mp4	12.1 MB
020 A Bit of Practice.srt	8.0 KB
021 Three Way Exercise.html	5.9 KB
022 Exercise Solution.mp4	5.7 MB
022 Exercise Solution.srt	4.4 KB
05 - Aggregation of Records/
001 Aggregating and Grouping.mp4	5.6 MB
001 Aggregating and Grouping.srt	3.7 KB
002 Picturing Group By.mp4	20.1 MB
002 Picturing Group By.srt	8.5 KB
003 Selecting Columns After Grouping.html	12.1 KB
004 Aggregate Functions.mp4	8.0 MB
004 Aggregate Functions.srt	4.7 KB
005 Combining Group By and Aggregates.mp4	10.7 MB
005 Combining Group By and Aggregates.srt	7.2 KB
006 A Gotcha with Count.mp4	4.2 MB
006 A Gotcha with Count.srt	4.3 KB
007 Visualizing More Grouping.mp4	7.0 MB
007 Visualizing More Grouping.srt	4.8 KB
008 Exercise Overview.mp4	1.2 MB
008 Exercise Overview.srt	1.2 KB
009 Practice For Grouping and Aggregating.html	5.4 KB
010 Grouping Solution.mp4	2.3 MB
010 Grouping Solution.srt	2.3 KB
011 Adding a Layer of Difficulty.mp4	1.2 MB
011 Adding a Layer of Difficulty.srt	1.1 KB
012 Grouping With a Join!.html	5.6 KB
013 Solution.mp4	2.7 MB
013 Solution.srt	2.5 KB
014 Filtering Groups with Having.mp4	25.1 MB
014 Filtering Groups with Having.srt	7.9 KB
015 Having In Action.mp4	4.9 MB
015 Having In Action.srt	4.2 KB
016 More on Having!.mp4	19.5 MB
016 More on Having!.srt	11.3 KB
017 A Having Exercise Overview.mp4	8.8 MB
017 A Having Exercise Overview.srt	5.7 KB
018 Practice Yourself Some Having.html	5.7 KB
019 A Quick Solution.mp4	5.4 MB
019 A Quick Solution.srt	3.9 KB
06 - Working with Large Datasets/
001 A New Dataset.html	18.3 KB
002 001-sq-data.sql	16.2 KB
002 Investigating This Dataset.mp4	5.7 MB
002 Investigating This Dataset.srt	4.1 KB
003 Some Group By Practice.mp4	2.2 MB
003 Some Group By Practice.srt	2.1 KB
004 Group By Review.html	5.2 KB
005 Group By Review Solution.mp4	5.6 MB
005 Group By Review Solution.srt	3.8 KB
006 Remember Joins.mp4	6.3 MB
006 Remember Joins.srt	3.7 KB
007 Inner Join Review.html	6.0 KB
008 Of Course You Remember!.mp4	3.2 MB
008 Of Course You Remember!.srt	2.3 KB
07 - Sorting Records/
001 The Basics of Sorting.mp4	4.9 MB
001 The Basics of Sorting.srt	3.8 KB
002 Two Variations on Sorting.mp4	6.6 MB
002 Two Variations on Sorting.srt	4.3 KB
003 Offset and Limit.mp4	13.8 MB
003 Offset and Limit.srt	10.4 KB
004 Exercise Overview.mp4	830.6 KB
004 Exercise Overview.srt	0.7 KB
005 Sorting, Offsetting, and Limiting.html	5.1 KB
006 Exercise Solution.mp4	2.5 MB
006 Exercise Solution.srt	2.2 KB
08 - Unions and Intersections with Sets/
001 Handling Sets with Union.mp4	13.6 MB
001 Handling Sets with Union.srt	9.2 KB
002 A Few Notes on Union.mp4	11.3 MB
002 A Few Notes on Union.srt	6.0 KB
003 Commonalities with Intersect.mp4	10.6 MB
003 Commonalities with Intersect.srt	5.2 KB
004 Removing Commonalities with Except.mp4	14.3 MB
004 Removing Commonalities with Except.srt	9.7 KB
005 Union Exercise Overview.mp4	3.1 MB
005 Union Exercise Overview.srt	2.2 KB
006 Merging Results with Union.html	5.7 KB
007 Exercise Solution.mp4	3.4 MB
007 Exercise Solution.srt	2.2 KB
09 - Assembling Queries with SubQueries/
001 What's a Subquery.mp4	20.4 MB
001 What's a Subquery.srt	8.8 KB
002 Thinking About the Structure of Data.mp4	15.9 MB
002 Thinking About the Structure of Data.srt	7.7 KB
003 What's the Data Look Like.html	12.2 KB
004 Subqueries in a Select.mp4	15.9 MB
004 Subqueries in a Select.srt	8.7 KB
005 Exercise Overview.mp4	2.2 MB
005 Exercise Overview.srt	1.8 KB
006 Embedding in Select.html	5.7 KB
007 Select Solution.mp4	2.8 MB
007 Select Solution.srt	2.0 KB
008 Subqueries in a From.mp4	29.7 MB
008 Subqueries in a From.srt	12.6 KB
009 From Subqueries that Return a Value.mp4	6.4 MB
009 From Subqueries that Return a Value.srt	4.4 KB
010 Example of a Subquery in a From.mp4	36.0 MB
010 Example of a Subquery in a From.srt	14.3 KB
011 Exercise Overview.mp4	2.5 MB
011 Exercise Overview.srt	1.8 KB
012 Subquery From's.html	5.2 KB
013 Exercise Solution.mp4	6.9 MB
013 Exercise Solution.srt	2.8 KB
014 Subqueries in a Join Clause.mp4	11.4 MB
014 Subqueries in a Join Clause.srt	7.2 KB
015 More Useful - Subqueries with Where.mp4	25.0 MB
015 More Useful - Subqueries with Where.srt	14.2 KB
016 Data Structure with Where Subqueries.mp4	29.0 MB
016 Data Structure with Where Subqueries.srt	9.2 KB
017 Exercise Overview.mp4	2.0 MB
017 Exercise Overview.srt	1.6 KB
018 Subquery Where's.html	5.2 KB
019 Exercise Solution.mp4	4.7 MB
019 Exercise Solution.srt	3.2 KB
020 The Not In Operator with a List.mp4	24.6 MB
020 The Not In Operator with a List.srt	6.5 KB
021 A New Where Operator.mp4	25.4 MB
021 A New Where Operator.srt	10.3 KB
022 Finally Some!.mp4	21.5 MB
022 Finally Some!.srt	8.1 KB
023 Is It A Valid Subquery.html	16.6 KB
024 Exercise Overview.mp4	874.2 KB
024 Exercise Overview.srt	0.7 KB
025 Practice Your Subqueries!.html	5.2 KB
026 A Quick Solution.mp4	3.2 MB
026 A Quick Solution.srt	2.5 KB
027 Probably Too Much About Correlated Subqueries.mp4	70.1 MB
027 Probably Too Much About Correlated Subqueries.srt	26.9 KB
028 More on Correlated Subqueries.mp4	29.2 MB
028 More on Correlated Subqueries.srt	14.1 KB
029 A Select Without a From.mp4	6.8 MB
029 A Select Without a From.srt	5.3 KB
030 Exercise Overview.mp4	1.4 MB
030 Exercise Overview.srt	1.3 KB
031 From-less Selects.html	5.6 KB
032 Exercise Solution.mp4	2.6 MB
032 Exercise Solution.srt	1.9 KB
10 - Selecting Distinct Records/
001 Selecting Distinct Values.mp4	8.8 MB
001 Selecting Distinct Values.srt	6.7 KB
002 Exercise Overview.mp4	984.2 KB
002 Exercise Overview.srt	0.9 KB
003 Some Practice with Distinct.html	5.1 KB
004 A Distinct Solution.mp4	1.4 MB
004 A Distinct Solution.srt	1.0 KB
11 - Utility Operators, Keywords, and Functions/
001 The Greatest Value in a List.mp4	8.2 MB
001 The Greatest Value in a List.srt	5.3 KB
002 And the Least Value in a List!.mp4	3.9 MB
002 And the Least Value in a List!.srt	3.2 KB
003 The Case Keyword.mp4	20.0 MB
003 The Case Keyword.srt	7.1 KB
12 - Local PostgreSQL Installation/
001 PostgreSQL Installation on macOS.mp4	14.8 MB
001 PostgreSQL Installation on macOS.srt	10.1 KB
002 pgAdmin Setup on macOS.mp4	11.7 MB
002 pgAdmin Setup on macOS.srt	8.2 KB
003 Postgres installation on Windows.mp4	14.4 MB
003 Postgres installation on Windows.srt	6.9 KB
13 - PostgreSQL Complex Datatypes/
001 What'd We Just Do.mp4	13.0 MB
001 What'd We Just Do.srt	6.6 KB
002 Data Types.mp4	20.7 MB
002 Data Types.srt	7.2 KB
003 Fast Rules on Numeric Data Types.mp4	12.5 MB
003 Fast Rules on Numeric Data Types.srt	3.7 KB
004 More on Number Data Types.mp4	32.0 MB
004 More on Number Data Types.srt	15.6 KB
005 Reminder on Character Types.mp4	20.1 MB
005 Reminder on Character Types.srt	8.0 KB
006 Boolean Data Types.mp4	5.7 MB
006 Boolean Data Types.srt	4.5 KB
007 Times, Dates, and Timestamps.mp4	15.0 MB
007 Times, Dates, and Timestamps.srt	8.7 KB
008 Really Awesome Intervals.mp4	14.1 MB
008 Really Awesome Intervals.srt	9.3 KB
14 - Database-Side Validation and Constraints/
001 Thinking About Validation.mp4	23.3 MB
001 Thinking About Validation.srt	6.9 KB
002 Creating and Viewing Tables in PGAdmin.mp4	19.5 MB
002 Creating and Viewing Tables in PGAdmin.srt	11.9 KB
003 Applying a Null Constraint.mp4	14.8 MB
003 Applying a Null Constraint.srt	10.6 KB
004 Solving a Gotcha with Null Constraints.mp4	9.5 MB
004 Solving a Gotcha with Null Constraints.srt	6.9 KB
005 Creating NULL Constraints.html	10.4 KB
006 Default Column Values.mp4	15.0 MB
006 Default Column Values.srt	5.3 KB
007 Applying a Unique Constraint to One column.mp4	28.1 MB
007 Applying a Unique Constraint to One column.srt	9.5 KB
008 Multi-Column Uniqueness.mp4	19.3 MB
008 Multi-Column Uniqueness.srt	5.7 KB
009 Is It Unique.html	10.5 KB
010 Adding a Validation Check.mp4	12.3 MB
010 Adding a Validation Check.srt	6.5 KB
011 Checks Over Multiple Columns.mp4	12.1 MB
011 Checks Over Multiple Columns.srt	8.2 KB
012 Does It Pass a Check.html	9.5 KB
013 So Where Are We Applying Validation.mp4	15.2 MB
013 So Where Are We Applying Validation.srt	10.0 KB
15 - Database Structure Design Patterns/
001 Approaching More Complicated Designs.mp4	8.0 MB
001 Approaching More Complicated Designs.srt	5.5 KB
002 Using a SQL Design Tool.mp4	34.0 MB
002 Using a SQL Design Tool.srt	10.2 KB
003 A Config-based Schema Designer.mp4	20.2 MB
003 A Config-based Schema Designer.srt	12.0 KB
004 Here's the Plan.mp4	6.2 MB
004 Here's the Plan.srt	4.3 KB
005 005-design.dbml	0.5 KB
005 Rebuilding Some Schema.mp4	14.8 MB
005 Rebuilding Some Schema.srt	11.2 KB
16 - How to Build a 'Like' System/
001 Requirements of a Like System.mp4	17.0 MB
001 Requirements of a Like System.srt	7.8 KB
002 How Not to Design a Like System.mp4	10.8 MB
002 How Not to Design a Like System.srt	5.0 KB
003 Designing a Like System.mp4	17.6 MB
003 Designing a Like System.srt	8.6 KB
004 Building a Similar System.html	10.3 KB
005 Making a Reaction System Instead.mp4	4.3 MB
005 Making a Reaction System Instead.srt	2.6 KB
006 Polymorphic Associations.mp4	35.0 MB
006 Polymorphic Associations.srt	9.6 KB
007 Polymorphic Association Alternative Implementation.mp4	41.4 MB
007 Polymorphic Association Alternative Implementation.srt	11.4 KB
008 The Simplest Alternative.mp4	18.2 MB
008 The Simplest Alternative.srt	6.2 KB
009 Polymorphic Associations.html	12.9 KB
010 So Which Approach.mp4	11.0 MB
010 So Which Approach.srt	7.3 KB
17 - How to Build a 'Mention' System/
001 Additional Features Around Posts.mp4	56.7 MB
001 Additional Features Around Posts.srt	10.5 KB
002 Adding Captions and Locations.mp4	5.6 MB
002 Adding Captions and Locations.srt	2.7 KB
003 Photo Mentions vs Caption Mentions.mp4	46.4 MB
003 Photo Mentions vs Caption Mentions.srt	12.8 KB
004 Considerations on Photo Tags vs Caption Tags.mp4	45.0 MB
004 Considerations on Photo Tags vs Caption Tags.srt	11.9 KB
005 Update For Tags.mp4	15.7 MB
005 Update For Tags.srt	7.8 KB
18 - How to Build a 'Hashtag' System/
001 Designing a Hashtag System.mp4	63.5 MB
001 Designing a Hashtag System.srt	12.2 KB
002 Tables for Hashtags.mp4	10.5 MB
002 Tables for Hashtags.srt	6.0 KB
003 Including the Hashtag Table.mp4	12.1 MB
003 Including the Hashtag Table.srt	5.9 KB
004 A Few More User Columns.mp4	17.7 MB
004 A Few More User Columns.srt	10.2 KB
005 Why No Number of Followers or Posts.mp4	10.9 MB
005 Why No Number of Followers or Posts.srt	6.2 KB
19 - How to Design a 'Follower' System/
001 Designing a Follower System.mp4	18.0 MB
001 Designing a Follower System.srt	9.6 KB
20 - Implementing Database Design Patterns/
001 Back to Postgres.mp4	4.6 MB
001 Back to Postgres.srt	3.3 KB
002 002-db.sql	0.4 KB
002 Creating Tables with Checks.mp4	42.0 MB
002 Creating Tables with Checks.srt	21.9 KB
003 003-db.sql	0.8 KB
003 Posts Creation.mp4	25.5 MB
003 Posts Creation.srt	13.1 KB
004 004-db.sql	1.1 KB
004 Comments Creation.mp4	5.2 MB
004 Comments Creation.srt	3.6 KB
005 005-db.sql	1.6 KB
005 Likes Creation.mp4	16.6 MB
005 Likes Creation.srt	10.8 KB
006 006-db.sql	2.2 KB
006 Photo Tags and Caption Tags.mp4	27.0 MB
006 Photo Tags and Caption Tags.srt	8.7 KB
007 007-db.sql	2.9 KB
007 Creating Hashtags, Hashtag Posts, and Followers.mp4	14.3 MB
007 Creating Hashtags, Hashtag Posts, and Followers.srt	9.6 KB
21 - Approaching and Writing Complex Queries/
001 ig.sql	24.7 MB
001 Quick Note About Adding Some Data.html	1.3 KB
002 Adding Some Data.mp4	11.4 MB
002 Adding Some Data.srt	7.0 KB
003 Restoring from Scratch.mp4	14.5 MB
003 Restoring from Scratch.srt	7.3 KB
004 Highest User ID's Exercise.mp4	5.0 MB
004 Highest User ID's Exercise.srt	3.2 KB
005 Solution for User ID's.mp4	3.1 MB
005 Solution for User ID's.srt	1.9 KB
006 Posts by a Particular User.mp4	3.1 MB
006 Posts by a Particular User.srt	1.8 KB
007 Solving for Posts by User.mp4	6.1 MB
007 Solving for Posts by User.srt	3.0 KB
008 Likes Per User.mp4	2.4 MB
008 Likes Per User.srt	1.3 KB
009 Solution for Likes Per User.mp4	4.6 MB
009 Solution for Likes Per User.srt	2.5 KB
22 - Understanding the Internals of PostgreSQL/
001 Thinking About Performance.mp4	6.8 MB
001 Thinking About Performance.srt	3.6 KB
002 Where Does Postgres Store Data.mp4	23.7 MB
002 Where Does Postgres Store Data.srt	9.0 KB
003 Heaps, Blocks, and Tuples.mp4	15.9 MB
003 Heaps, Blocks, and Tuples.srt	6.0 KB
004 Terminology Check.html	10.2 KB
005 Block Data Layout.mp4	12.3 MB
005 Block Data Layout.srt	7.4 KB
006 Heap File Layout.mp4	354.8 MB
006 Heap File Layout.srt	51.8 KB
23 - A Look at Indexes for Performance/
001 Full Table Scans.mp4	25.0 MB
001 Full Table Scans.srt	6.5 KB
002 What's an Index.mp4	6.7 MB
002 What's an Index.srt	4.0 KB
003 How an Index Works.mp4	45.3 MB
003 How an Index Works.srt	13.1 KB
004 Creating an Index.mp4	9.3 MB
004 Creating an Index.srt	6.7 KB
005 Benchmarking Queries.mp4	15.7 MB
005 Benchmarking Queries.srt	8.7 KB
006 Downsides of Indexes.mp4	20.8 MB
006 Downsides of Indexes.srt	8.0 KB
007 Index Types.mp4	4.3 MB
007 Index Types.srt	2.6 KB
008 Automatically Generated Indexes.mp4	13.4 MB
008 Automatically Generated Indexes.srt	5.8 KB
009 Using Automatically Created Indexes.html	9.7 KB
010 Behind the Scenes of Indexes.mp4	249.9 MB
24 - Basic Query Tuning/
001 The Query Processing Pipeline.mp4	16.9 MB
001 The Query Processing Pipeline.srt	8.5 KB
002 Explain and Explain Analyze.mp4	28.5 MB
002 Explain and Explain Analyze.srt	8.6 KB
003 Explain Vs Explain Analyze.html	9.1 KB
004 Solving an Explain Mystery.mp4	51.4 MB
004 Solving an Explain Mystery.srt	14.5 KB
25 - Advanced Query Tuning/
001 Developing an Intuitive Understanding of Cost.mp4	67.7 MB
001 Developing an Intuitive Understanding of Cost.srt	20.6 KB
002 Calculating Cost by Hand.mp4	33.7 MB
002 Calculating Cost by Hand.srt	10.2 KB
003 A Touch More on Costs.mp4	58.0 MB
003 A Touch More on Costs.srt	11.4 KB
004 Calculating Costs.html	11.9 KB
005 Startup vs Total Costs.mp4	30.1 MB
005 Startup vs Total Costs.srt	9.2 KB
006 Costs Flow Up.mp4	6.7 MB
006 Costs Flow Up.srt	3.1 KB
007 Use My Index!.mp4	27.2 MB
007 Use My Index!.srt	12.8 KB
26 - Simple Common Table Expressions/
001 Common Table Expressions.mp4	7.3 MB
001 Common Table Expressions.srt	3.0 KB
002 A Quick Solution.mp4	9.1 MB
002 A Quick Solution.srt	6.0 KB
003 So What's a CTE.mp4	21.5 MB
003 So What's a CTE.srt	6.3 KB
27 - Recursive Common Table Expressions/
001 Recursive CTE's.mp4	8.2 MB
002 Recursive CTE's Step by Step.mp4	42.0 MB
002 Recursive CTE's Step by Step.srt	16.5 KB
003 Why Use Recursive CTE's.mp4	28.6 MB
003 Why Use Recursive CTE's.srt	7.8 KB
004 Writing the Query.mp4	24.7 MB
004 Writing the Query.srt	12.8 KB
005 Walking Through Recursion.mp4	69.2 MB
005 Walking Through Recursion.srt	15.3 KB
28 - Simplifying Queries with Views/
001 Most Popular Users.mp4	17.4 MB
001 Most Popular Users.srt	10.5 KB
002 A Possible Solution for Merging Tables.mp4	23.4 MB
002 A Possible Solution for Merging Tables.srt	6.3 KB
003 Creating a View.mp4	22.3 MB
003 Creating a View.srt	9.0 KB
004 When to Use a View.mp4	13.7 MB
004 When to Use a View.srt	5.2 KB
005 Deleting and Changing Views.mp4	8.3 MB
29 - Optimizing Queries with Materialized Views/
001 Materialized Views.mp4	5.9 MB
001 Materialized Views.srt	4.0 KB
002 Grouping by Week.mp4	23.2 MB
002 Grouping by Week.srt	6.7 KB
003 Reminder on Left Joins.mp4	11.0 MB
003 Reminder on Left Joins.srt	7.3 KB
004 Writing a Slow Query.mp4	36.8 MB
004 Writing a Slow Query.srt	14.3 KB
005 Creating and Refreshing Materialized Views.mp4	23.6 MB
005 Creating and Refreshing Materialized Views.srt	10.0 KB
006 Views vs Materialized Views.html	9.9 KB
30 - Handling Concurrency and Reversibility with Transactions/
001 What are Transactions Used For.mp4	16.2 MB
001 What are Transactions Used For.srt	6.5 KB
002 Some Sample Data.mp4	4.0 MB
002 Some Sample Data.srt	3.4 KB
003 Opening and Closing Transactions.mp4	44.2 MB
003 Opening and Closing Transactions.srt	15.5 KB
004 Transaction Cleanup on Crash.mp4	21.2 MB
005 Closing Aborted Transactions.mp4	5.1 MB
005 Closing Aborted Transactions.srt	2.9 KB
31 - Managing Database Design with Schema Migrations/
001 A Story on Migrations.mp4	92.9 MB
001 A Story on Migrations.srt	28.7 KB
002 Migration Files.mp4	30.2 MB
002 Migration Files.srt	7.7 KB
003 Issues Solved by Migrations.mp4	7.0 MB
003 Issues Solved by Migrations.srt	4.6 KB
004 A Few Notes on Migrations Libraries.mp4	22.7 MB
004 A Few Notes on Migrations Libraries.srt	7.7 KB
005 A Note About Node Installation.html	0.3 KB
006 Project Creation.mp4	6.5 MB
006 Project Creation.srt	4.6 KB
007 Generating and Writing Migrations.mp4	29.9 MB
007 Generating and Writing Migrations.srt	10.6 KB
008 Applying and Reverting Migrations.mp4	42.1 MB
008 Applying and Reverting Migrations.srt	11.8 KB
009 Generating and Applying a Second Migration.mp4	11.3 MB
009 Generating and Applying a Second Migration.srt	5.6 KB
32 - Schema vs Data Migrations/
001 Schema vs Data Migrations.mp4	14.1 MB
002 Dangers Around Data Migrations.mp4	46.5 MB
002 Dangers Around Data Migrations.srt	15.1 KB
003 Properly Running Data and Schema Migrations.mp4	14.3 MB
003 Properly Running Data and Schema Migrations.srt	8.8 KB
004 Creating a Posts Table.mp4	15.1 MB
004 Creating a Posts Table.srt	7.3 KB
005 005-index.js	1.3 KB
005 A Small Web Server.mp4	42.6 MB
006 Web Server Setup Instructions.html	1.0 KB
007 Adding the Loc Column.mp4	14.9 MB
007 Adding the Loc Column.srt	6.4 KB
008 Writing Values to Both Columns.mp4	11.2 MB
008 Writing Values to Both Columns.srt	6.9 KB
009 Transaction Locks.mp4	65.7 MB
009 Transaction Locks.srt	23.0 KB
010 Updating Values.mp4	10.6 MB
010 Updating Values.srt	6.6 KB
011 01-lng-lat-to-loc.js	0.4 KB
011 Migrations Setup Instructions.html	0.9 KB
012 Updating the App Server.mp4	9.2 MB
012 Updating the App Server.srt	6.7 KB
013 Dropping the Last Columns.mp4	7.9 MB
013 Dropping the Last Columns.srt	4.8 KB
33 - Accessing PostgreSQL From API's/
001 Section Goal.mp4	2.1 MB
001 Section Goal.srt	1.6 KB
002 Initial Setup.mp4	1.8 MB
002 Initial Setup.srt	2.5 KB
003 One Fast Migration.mp4	16.4 MB
004 005-access-social-repo.zip	62.8 KB
004 Building the Users Router.mp4	19.5 MB
004 Building the Users Router.srt	7.2 KB
005 Understanding Connection Pools.mp4	16.8 MB
005 Understanding Connection Pools.srt	10.9 KB
006 Validating Connection Credentials.mp4	29.3 MB
006 Validating Connection Credentials.srt	10.8 KB
007 008-access.zip	63.5 KB
007 Query and Close.mp4	4.2 MB
007 Query and Close.srt	3.3 KB
34 - Data Access Pattern - Repositories/
001 The Repository Pattern.mp4	12.3 MB
001 The Repository Pattern.srt	5.8 KB
002 010-access.zip	64.1 KB
002 Creating a Repository.mp4	17.5 MB
002 Creating a Repository.srt	13.0 KB
003 Accessing the API.mp4	15.4 MB
003 Accessing the API.srt	6.4 KB
004 Casing Issues.mp4	12.6 MB
004 Casing Issues.srt	7.0 KB
005 Fixing Casing.mp4	31.8 MB
005 Fixing Casing.srt	10.2 KB
006 Finding Particular Users.mp4	12.6 MB
006 Finding Particular Users.srt	8.6 KB
35 - Security Around PostgreSQL/
001 SQL Injection Exploits.mp4	21.4 MB
001 SQL Injection Exploits.srt	11.0 KB
002 Handling SQL Injection with Prepared Statements.mp4	26.7 MB
002 Handling SQL Injection with Prepared Statements.srt	13.1 KB
003 Preventing SQL Injection.mp4	23.6 MB
003 Preventing SQL Injection.srt	12.2 KB
004 Reminder on Post Requests.mp4	9.7 MB
004 Reminder on Post Requests.srt	4.4 KB
005 019-access.zip	65.1 KB
005 Inserting Users.mp4	10.5 MB
005 Inserting Users.srt	6.7 KB
006 Handling Updates.mp4	11.3 MB
006 Handling Updates.srt	7.2 KB
007 021-access.zip	65.2 KB
007 And, Finally, Delete.mp4	12.1 MB
007 And, Finally, Delete.srt	6.9 KB
36 - Fast Parallel Testing/
001 A Note on Testing.mp4	5.6 MB
001 A Note on Testing.srt	5.2 KB
002 Assertions Around User Count.mp4	28.2 MB
002 Assertions Around User Count.srt	11.4 KB
003 024-access.zip	66.0 KB
003 Connecting to a DB For Tests.mp4	33.6 MB
003 Connecting to a DB For Tests.srt	8.4 KB
004 025-access.zip	66.1 KB
004 Disconnecting After Tests.mp4	8.6 MB
004 Disconnecting After Tests.srt	5.0 KB
005 026-access.zip	66.1 KB
005 Multi-DB Setup.mp4	14.8 MB
005 Multi-DB Setup.srt	7.5 KB
006 027-access.zip	66.1 KB
006 Assumptions Around Content.mp4	21.6 MB
006 Assumptions Around Content.srt	8.3 KB
007 028-access.zip	67.4 KB
007 Issues with Parallel Tests.mp4	23.9 MB
007 Issues with Parallel Tests.srt	8.5 KB
008 Isolation with Schemas.mp4	18.9 MB
008 Isolation with Schemas.srt	6.7 KB
009 Creating and Accessing Schemas.mp4	13.4 MB
009 Creating and Accessing Schemas.srt	8.4 KB
010 Controlling Schema Access with Search Paths.mp4	21.1 MB
010 Controlling Schema Access with Search Paths.srt	9.0 KB
011 Routing Schema Access.mp4	25.9 MB
011 Routing Schema Access.srt	6.6 KB
012 Strategy for Isolation.mp4	12.2 MB
012 Strategy for Isolation.srt	7.3 KB
013 034-access.zip	67.7 KB
013 Programmatic Schema Creation.mp4	43.2 MB
013 Programmatic Schema Creation.srt	19.0 KB
014 035-access.zip	67.7 KB
014 Escaping Identifiers.mp4	16.7 MB
014 Escaping Identifiers.srt	6.9 KB
015 036-access.zip	68.1 KB
015 Test Helpers.mp4	27.7 MB
015 Test Helpers.srt	8.3 KB
016 037-access.zip	68.2 KB
016 Cleaning up Schemas and Roles.mp4	20.4 MB
016 Cleaning up Schemas and Roles.srt	8.7 KB
017 Finally... Parallel Tests! (Final Lecture).mp4	12.0 MB
017 Finally... Parallel Tests! (Final Lecture).srt	5.3 KB
37 - Bonus!/
001 Bonus!.html	3.8 KB
Total files 653