GigaCourse Com Udemy SQL and PostgreSQL The Complete Developer Guide

GigaCourse Com Udemy SQL and PostgreSQL The Complete Developer Guide

Name	[GigaCourse.Com] Udemy - SQL and PostgreSQL The Complete Developer's Guide	DOWNLOAD Copy Link
Total Size	5.4 GB
Total Files	615
Last Seen	2024-07-08 23:46
Hash	4D46C87CF3A71FA68B051D97072B597C955C7AF2

/0. Websites you may like/
[CourseClub.ME].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/01 - Simple - But Powerful - SQL Statements/
001 Join Our Community_.html	0.3 KB
002 Course Resources.html	1.3 KB
003 What is PostgreSQL All About_.mp4	22.8 MB
003 What is PostgreSQL All About___en.srt	7.4 KB
004 Database Design.mp4	37.1 MB
004 Database Design__en.srt	8.2 KB
005 Creating Tables.mp4	19.5 MB
005 Creating Tables__en.srt	7.7 KB
006 Analyzing CREATE TABLE.mp4	11.9 MB
006 Analyzing CREATE TABLE__en.srt	5.5 KB
007 Inserting Data Into a Table.mp4	12.7 MB
007 Inserting Data Into a Table__en.srt	7.6 KB
008 Retrieving Data with Select.mp4	4.2 MB
008 Retrieving Data with Select__en.srt	3.3 KB
009 Calculated Columns.mp4	10.9 MB
009 Calculated Columns__en.srt	7.3 KB
010 Calculating Phone Revenue.mp4	2.3 MB
010 Calculating Phone Revenue__en.srt	1.6 KB
011 Exercise Solution.mp4	2.3 MB
011 Exercise Solution__en.srt	1.6 KB
012 String Operators and Functions.mp4	11.9 MB
012 String Operators and Functions__en.srt	9.9 KB
28579121-003-sql.sql	0.1 KB
28579125-005-sql-cumulative.sql	0.4 KB
28579127-005-sql.sql	0.3 KB
28579131-012-sql.sql	0.4 KB
37099256-diagrams.zip	8.1 MB
/02 - Filtering Records/
001 Filtering Rows with _Where_.mp4	8.8 MB
001 Filtering Rows with _Where___en.srt	5.8 KB
002 More on the _Where_ Keyword.mp4	6.3 MB
002 More on the _Where_ Keyword__en.srt	3.8 KB
003 Compound _Where_ Clauses.mp4	13.4 MB
003 Compound _Where_ Clauses__en.srt	7.6 KB
004 A _Where_ Exercise Overview.mp4	1.3 MB
004 A _Where_ Exercise Overview__en.srt	1.0 KB
005 A _Where_ Solution.mp4	2.0 MB
005 A _Where_ Solution__en.srt	1.3 KB
006 _Where_ With Lists.mp4	1.2 MB
006 _Where_ With Lists__en.srt	1.0 KB
007 A _Where_ With Lists Solution.mp4	3.7 MB
007 A _Where_ With Lists Solution__en.srt	2.3 KB
008 Calculations in _Where_ Clauses.mp4	3.6 MB
008 Calculations in _Where_ Clauses__en.srt	3.1 KB
009 Solving Calculations.mp4	4.4 MB
010 Updating Rows.mp4	12.3 MB
010 Updating Rows__en.srt	6.4 KB
011 Deleting Rows.mp4	9.6 MB
011 Deleting Rows__en.srt	5.0 KB
012 A Solution for Updating Rows.mp4	3.6 MB
012 A Solution for Updating Rows__en.srt	2.2 KB
013 Solution for Deleting Rows.mp4	2.9 MB
013 Solution for Deleting Rows__en.srt	2.0 KB
28579133-013-sql.sql	0.0 KB
/03 - Working with Tables/
001 The Plan Moving Forward.mp4	7.4 MB
001 The Plan Moving Forward__en.srt	2.8 KB
002 Approaching Database Design.mp4	32.0 MB
002 Approaching Database Design__en.srt	12.0 KB
003 One-to-Many and Many-to-One Relationships.mp4	27.5 MB
003 One-to-Many and Many-to-One Relationships__en.srt	10.1 KB
004 One-to-One and Many-to-Many Relationships.mp4	16.0 MB
004 One-to-One and Many-to-Many Relationships__en.srt	8.7 KB
005 Primary Keys and Foreign Keys.mp4	19.7 MB
005 Primary Keys and Foreign Keys__en.srt	7.9 KB
006 Understanding Foreign Keys.mp4	43.6 MB
006 Understanding Foreign Keys__en.srt	12.9 KB
007 Auto-Generated ID's.mp4	15.3 MB
007 Auto-Generated ID's__en.srt	8.9 KB
008 Creating Foreign Key Columns.mp4	12.6 MB
008 Creating Foreign Key Columns__en.srt	7.4 KB
009 Running Queries on Associated Data.mp4	25.7 MB
009 Running Queries on Associated Data__en.srt	10.3 KB
010 Exercise Overview.mp4	5.6 MB
010 Exercise Overview__en.srt	3.4 KB
011 Foreign Key Creation Solution.mp4	5.7 MB
011 Foreign Key Creation Solution__en.srt	3.0 KB
012 Foreign Key Constraints Around Insertion.mp4	17.7 MB
012 Foreign Key Constraints Around Insertion__en.srt	8.7 KB
013 Constraints Around Deletion.mp4	27.2 MB
013 Constraints Around Deletion__en.srt	7.6 KB
014 Commands You8217ll Need for the Next Video.html	0.7 KB
015 Testing Deletion Constraints.mp4	14.9 MB
015 Testing Deletion Constraints__en.srt	6.7 KB
016 Setting Foreign Keys to Null on Delete.mp4	8.7 MB
016 Setting Foreign Keys to Null on Delete__en.srt	4.4 KB
017 Adding Some Complexity.mp4	7.1 MB
017 Adding Some Complexity__en.srt	4.8 KB
28579153-007-tables-cumulative.sql	0.2 KB
28579155-007-tables.sql	0.2 KB
28579157-008-tables-cumulative.sql	0.3 KB
28579159-008-tables.sql	0.2 KB
28579161-009-tables-cumulative.sql	0.5 KB
28579163-009-tables.sql	0.3 KB
28579179-012-tables-cumulative.sql	0.6 KB
28579183-012-tables.sql	0.2 KB
28579187-014-tables-cumulative.sql	1.0 KB
28579189-014-tables.sql	0.5 KB
28579191-015-tables-cumulative.sql	1.3 KB
28579193-015-tables.sql	0.3 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__en.srt	5.2 KB
003 Joining Data from Different Tables.mp4	28.7 MB
003 Joining Data from Different Tables__en.srt	11.8 KB
004 Another Quick Join.mp4	5.9 MB
004 Another Quick Join__en.srt	3.2 KB
005 Exercise Overview.mp4	3.2 MB
005 Exercise Overview__en.srt	1.8 KB
006 A Joinful Solution.mp4	3.6 MB
006 A Joinful Solution__en.srt	2.6 KB
007 Alternate Forms of Syntax.mp4	15.1 MB
007 Alternate Forms of Syntax__en.srt	9.3 KB
008 Missing Data in Joins.mp4	20.0 MB
008 Missing Data in Joins__en.srt	9.8 KB
009 Why Wasn't It Included.mp4	15.7 MB
009 Why Wasn't It Included__en.srt	3.8 KB
010 Four Kinds of Joins.mp4	78.9 MB
010 Four Kinds of Joins__en.srt	14.7 KB
011 Each Join in Practice.mp4	24.6 MB
011 Each Join in Practice__en.srt	6.3 KB
012 Does Order Matter_.mp4	37.7 MB
012 Does Order Matter___en.srt	6.4 KB
013 Exercise Overview.mp4	1.6 MB
013 Exercise Overview__en.srt	1.5 KB
014 Two Possible Solutions.mp4	10.7 MB
014 Two Possible Solutions__en.srt	4.7 KB
015 Where with Join.mp4	21.2 MB
015 Where with Join__en.srt	10.3 KB
016 Three Way Joins.mp4	33.6 MB
016 Three Way Joins__en.srt	12.2 KB
017 A Bit of Practice.mp4	12.1 MB
017 A Bit of Practice__en.srt	7.6 KB
018 Exercise Solution.mp4	5.7 MB
018 Exercise Solution__en.srt	4.0 KB
28571441-009-joins-cheatsheet.pdf	195.1 KB
28595533-007-joins-cumulative.sql	7.7 KB
28595535-010-sql-cumulative.sql	7.8 KB
/05 - Aggregation of Records/
001 Aggregating and Grouping.mp4	5.6 MB
001 Aggregating and Grouping__en.srt	3.5 KB
002 Picturing Group By.mp4	32.4 MB
002 Picturing Group By__en.srt	8.2 KB
003 Aggregate Functions.mp4	8.0 MB
003 Aggregate Functions__en.srt	4.5 KB
004 Combining Group By and Aggregates.mp4	10.7 MB
004 Combining Group By and Aggregates__en.srt	7.2 KB
005 A Gotcha with Count.mp4	4.2 MB
005 A Gotcha with Count__en.srt	4.1 KB
006 Visualizing More Grouping.mp4	7.0 MB
006 Visualizing More Grouping__en.srt	4.6 KB
007 Exercise Overview.mp4	1.2 MB
007 Exercise Overview__en.srt	1.1 KB
008 Grouping Solution.mp4	2.3 MB
008 Grouping Solution__en.srt	2.2 KB
009 Adding a Layer of Difficulty.mp4	1.2 MB
009 Adding a Layer of Difficulty__en.srt	1.1 KB
010 Solution.mp4	2.7 MB
010 Solution__en.srt	2.2 KB
011 Filtering Groups with Having.mp4	25.1 MB
011 Filtering Groups with Having__en.srt	7.7 KB
012 Having In Action.mp4	4.9 MB
012 Having In Action__en.srt	4.0 KB
013 More on Having_.mp4	19.5 MB
013 More on Having___en.srt	10.4 KB
014 A Having Exercise Overview.mp4	8.8 MB
014 A Having Exercise Overview__en.srt	5.5 KB
015 A Quick Solution.mp4	5.4 MB
015 A Quick Solution__en.srt	3.8 KB
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/06 - Working with Large Datasets/
001 A New Dataset.html	18.3 KB
002 Investigating This Dataset.mp4	5.7 MB
003 Some Group By Practice.mp4	2.2 MB
003 Some Group By Practice__en.srt	2.0 KB
004 Group By Review Solution.mp4	5.6 MB
004 Group By Review Solution__en.srt	3.5 KB
005 Remember Joins_.mp4	6.3 MB
005 Remember Joins___en.srt	3.5 KB
006 Of Course You Remember_.mp4	3.2 MB
006 Of Course You Remember___en.srt	2.1 KB
28595541-001-sq-data.sql	16.2 KB
/07 - Sorting Records/
001 The Basics of Sorting.mp4	4.9 MB
001 The Basics of Sorting__en.srt	3.6 KB
002 Two Variations on Sorting.mp4	6.6 MB
002 Two Variations on Sorting__en.srt	4.1 KB
003 Offset and Limit.mp4	13.8 MB
004 Exercise Overview.mp4	830.6 KB
004 Exercise Overview__en.srt	0.7 KB
005 Exercise Solution.mp4	2.5 MB
005 Exercise Solution__en.srt	2.0 KB
/08 - Unions and Intersections with Sets/
001 Handling Sets with Union.mp4	13.6 MB
001 Handling Sets with Union__en.srt	8.7 KB
002 A Few Notes on Union.mp4	11.3 MB
002 A Few Notes on Union__en.srt	5.7 KB
003 Commonalities with Intersect.mp4	10.6 MB
003 Commonalities with Intersect__en.srt	5.0 KB
004 Removing Commonalities with Except.mp4	14.3 MB
004 Removing Commonalities with Except__en.srt	9.4 KB
005 Union Exercise Overview.mp4	3.1 MB
005 Union Exercise Overview__en.srt	2.2 KB
006 Exercise Solution.mp4	3.4 MB
006 Exercise Solution__en.srt	2.1 KB
/09 - Assembling Queries with SubQueries/
001 What's a Subquery_.mp4	20.4 MB
001 What's a Subquery___en.srt	8.9 KB
002 Thinking About the Structure of Data.mp4	15.9 MB
002 Thinking About the Structure of Data__en.srt	7.5 KB
003 Subqueries in a Select.mp4	15.9 MB
003 Subqueries in a Select__en.srt	8.5 KB
004 Exercise Overview.mp4	2.2 MB
004 Exercise Overview__en.srt	1.7 KB
005 Select Solution.mp4	2.8 MB
005 Select Solution__en.srt	1.8 KB
006 Subqueries in a From.mp4	29.7 MB
006 Subqueries in a From__en.srt	12.0 KB
007 From Subqueries that Return a Value.mp4	6.4 MB
007 From Subqueries that Return a Value__en.srt	4.3 KB
008 Example of a Subquery in a From.mp4	36.0 MB
008 Example of a Subquery in a From__en.srt	13.7 KB
009 Exercise Overview.mp4	2.5 MB
009 Exercise Overview__en.srt	1.9 KB
010 Exercise Solution.mp4	6.9 MB
011 Subqueries in a Join Clause.mp4	11.4 MB
011 Subqueries in a Join Clause__en.srt	6.8 KB
012 More Useful - Subqueries with Where.mp4	25.0 MB
012 More Useful - Subqueries with Where__en.srt	13.6 KB
013 Data Structure with Where Subqueries.mp4	29.0 MB
013 Data Structure with Where Subqueries__en.srt	8.9 KB
014 Exercise Overview.mp4	2.0 MB
015 Exercise Solution.mp4	4.7 MB
015 Exercise Solution__en.srt	3.1 KB
016 The Not In Operator with a List.mp4	24.6 MB
016 The Not In Operator with a List__en.srt	6.4 KB
017 A New Where Operator.mp4	25.4 MB
017 A New Where Operator__en.srt	9.6 KB
018 Finally Some_.mp4	21.5 MB
018 Finally Some___en.srt	8.2 KB
019 Exercise Overview.mp4	874.2 KB
019 Exercise Overview__en.srt	0.7 KB
020 A Quick Solution.mp4	3.2 MB
020 A Quick Solution__en.srt	2.4 KB
021 Probably Too Much About Correlated Subqueries.mp4	70.1 MB
021 Probably Too Much About Correlated Subqueries__en.srt	25.2 KB
022 More on Correlated Subqueries.mp4	29.2 MB
022 More on Correlated Subqueries__en.srt	13.1 KB
023 A Select Without a From_.mp4	6.8 MB
023 A Select Without a From___en.srt	5.3 KB
024 Exercise Overview.mp4	1.4 MB
024 Exercise Overview__en.srt	1.2 KB
025 Exercise Solution.mp4	2.6 MB
025 Exercise Solution__en.srt	1.7 KB
/10 - Selecting Distinct Records/
001 Selecting Distinct Values.mp4	8.8 MB
001 Selecting Distinct Values__en.srt	6.5 KB
002 Exercise Overview.mp4	984.2 KB
002 Exercise Overview__en.srt	0.9 KB
003 A Distinct Solution.mp4	1.4 MB
003 A Distinct Solution__en.srt	0.9 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__en.srt	5.0 KB
002 And the Least Value in a List_.mp4	3.9 MB
002 And the Least Value in a List___en.srt	3.0 KB
003 The Case Keyword.mp4	20.0 MB
003 The Case Keyword__en.srt	6.7 KB
/12 - Local PostgreSQL Installation/
001 PostgreSQL Installation on macOS.mp4	14.8 MB
001 PostgreSQL Installation on macOS__en.srt	9.9 KB
002 PGAdmin Setup on macOS.mp4	23.1 MB
002 PGAdmin Setup on macOS__en.srt	7.7 KB
003 Postgres installation on Windows.mp4	14.4 MB
003 Postgres installation on Windows__en.srt	6.6 KB
/13 - PostgreSQL Complex Datatypes/
001 What'd We Just Do_.mp4	13.0 MB
001 What'd We Just Do___en.srt	6.5 KB
002 Data Types.mp4	20.7 MB
002 Data Types__en.srt	7.1 KB
003 Fast Rules on Numeric Data Types.mp4	12.5 MB
003 Fast Rules on Numeric Data Types__en.srt	3.6 KB
004 More on Number Data Types.mp4	32.0 MB
004 More on Number Data Types__en.srt	14.7 KB
005 Reminder on Character Types.mp4	20.1 MB
005 Reminder on Character Types__en.srt	7.5 KB
006 Boolean Data Types.mp4	5.7 MB
006 Boolean Data Types__en.srt	3.9 KB
007 Times, Dates, and Timestamps.mp4	15.0 MB
007 Times, Dates, and Timestamps__en.srt	8.3 KB
008 Really Awesome Intervals.mp4	14.1 MB
008 Really Awesome Intervals__en.srt	9.0 KB
/14 - Database-Side Validation and Constraints/
001 Thinking About Validation.mp4	17.3 MB
001 Thinking About Validation__en.srt	6.8 KB
002 Creating and Viewing Tables in PGAdmin.mp4	19.5 MB
002 Creating and Viewing Tables in PGAdmin__en.srt	11.5 KB
003 Applying a Null Constraint.mp4	14.8 MB
003 Applying a Null Constraint__en.srt	10.2 KB
004 Solving a Gotcha with Null Constraints.mp4	9.5 MB
004 Solving a Gotcha with Null Constraints__en.srt	6.5 KB
005 Default Column Values.mp4	15.0 MB
006 Applying a Unique Constraint to One column.mp4	28.1 MB
006 Applying a Unique Constraint to One column__en.srt	8.8 KB
007 Multi-Column Uniqueness.mp4	19.3 MB
007 Multi-Column Uniqueness__en.srt	5.2 KB
008 Adding a Validation Check.mp4	12.3 MB
008 Adding a Validation Check__en.srt	6.1 KB
009 Checks Over Multiple Columns.mp4	12.1 MB
009 Checks Over Multiple Columns__en.srt	7.6 KB
010 So Where Are We Applying Validation_.mp4	15.2 MB
010 So Where Are We Applying Validation___en.srt	9.9 KB
/15 - Database Structure Design Patterns/
001 Approaching More Complicated Designs.mp4	8.0 MB
002 Using a SQL Design Tool.mp4	34.0 MB
002 Using a SQL Design Tool__en.srt	9.9 KB
003 A Config-based Schema Designer.mp4	20.2 MB
003 A Config-based Schema Designer__en.srt	11.8 KB
004 Here's the Plan.mp4	6.2 MB
004 Here's the Plan__en.srt	4.2 KB
005 Rebuilding Some Schema.mp4	14.8 MB
005 Rebuilding Some Schema__en.srt	10.6 KB
28595545-005-design.dbml	0.5 KB
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/16 - How to Build a 'Like' System/
001 Requirements of a Like System.mp4	17.0 MB
001 Requirements of a Like System__en.srt	7.7 KB
002 How Not to Design a Like System.mp4	10.8 MB
002 How Not to Design a Like System__en.srt	4.8 KB
003 Designing a Like System.mp4	17.6 MB
003 Designing a Like System__en.srt	8.3 KB
004 Making a Reaction System Instead.mp4	4.3 MB
004 Making a Reaction System Instead__en.srt	2.5 KB
005 Polymorphic Associations.mp4	35.0 MB
005 Polymorphic Associations__en.srt	9.6 KB
006 Polymorphic Association Alternative Implementation.mp4	41.4 MB
006 Polymorphic Association Alternative Implementation__en.srt	10.9 KB
007 The Simplest Alternative.mp4	18.2 MB
007 The Simplest Alternative__en.srt	6.1 KB
008 So Which Approach_.mp4	11.0 MB
008 So Which Approach___en.srt	7.0 KB
/17 - How to Build a 'Mention' System/
001 Additional Features Around Posts.mp4	56.7 MB
001 Additional Features Around Posts__en.srt	10.0 KB
002 Adding Captions and Locations.mp4	5.6 MB
002 Adding Captions and Locations__en.srt	2.6 KB
003 Photo Mentions vs Caption Mentions.mp4	46.4 MB
003 Photo Mentions vs Caption Mentions__en.srt	12.6 KB
004 Considerations on Photo Tags vs Caption Tags.mp4	45.0 MB
004 Considerations on Photo Tags vs Caption Tags__en.srt	11.6 KB
005 Update For Tags.mp4	15.7 MB
005 Update For Tags__en.srt	7.4 KB
/18 - How to Build a 'Hashtag' System/
001 Designing a Hashtag System.mp4	63.5 MB
001 Designing a Hashtag System__en.srt	11.9 KB
002 Tables for Hashtags.mp4	10.5 MB
002 Tables for Hashtags__en.srt	5.8 KB
003 Including the Hashtag Table.mp4	12.1 MB
003 Including the Hashtag Table__en.srt	5.9 KB
004 A Few More User Columns.mp4	17.7 MB
004 A Few More User Columns__en.srt	9.8 KB
005 Why No Number of Followers or Posts_.mp4	10.9 MB
005 Why No Number of Followers or Posts___en.srt	6.0 KB
/19 - How to Design a 'Follower' System/
001 Designing a Follower System.mp4	18.0 MB
001 Designing a Follower System__en.srt	9.2 KB
/20 - Implementing Database Design Patterns/
001 Back to Postgres.mp4	4.6 MB
001 Back to Postgres__en.srt	3.3 KB
002 Creating Tables with Checks.mp4	42.0 MB
002 Creating Tables with Checks__en.srt	20.9 KB
003 Posts Creation.mp4	25.5 MB
003 Posts Creation__en.srt	12.7 KB
004 Comments Creation.mp4	5.2 MB
004 Comments Creation__en.srt	3.4 KB
005 Likes Creation.mp4	16.6 MB
005 Likes Creation__en.srt	10.0 KB
006 Photo Tags and Caption Tags.mp4	27.0 MB
006 Photo Tags and Caption Tags__en.srt	8.2 KB
007 Creating Hashtags, Hashtag Posts, and Followers.mp4	14.3 MB
007 Creating Hashtags, Hashtag Posts, and Followers__en.srt	9.0 KB
28595559-002-db.sql	0.4 KB
28595561-003-db.sql	0.8 KB
28595563-004-db.sql	1.1 KB
28595565-005-db.sql	1.6 KB
28595567-006-db.sql	2.2 KB
28595569-007-db.sql	2.9 KB
/21 - Approaching and Writing Complex Queries/
001 Quick Note About Adding Some Data.html	0.3 KB
002 Adding Some Data.mp4	11.4 MB
002 Adding Some Data__en.srt	6.6 KB
003 Restoring from Scratch.mp4	14.5 MB
003 Restoring from Scratch__en.srt	7.0 KB
004 Highest User ID's Exercise.mp4	5.0 MB
004 Highest User ID's Exercise__en.srt	3.1 KB
005 Solution for User ID's.mp4	3.1 MB
005 Solution for User ID's__en.srt	1.8 KB
006 Posts by a Particular User.mp4	3.1 MB
006 Posts by a Particular User__en.srt	1.8 KB
007 Solving for Posts by User.mp4	6.1 MB
007 Solving for Posts by User__en.srt	2.8 KB
008 Likes Per User.mp4	2.4 MB
009 Solution for Likes Per User.mp4	4.6 MB
009 Solution for Likes Per User__en.srt	2.5 KB
28595573-ig.sql	24.7 MB
/22 - Understanding the Internals of PostgreSQL/
001 Thinking About Performance.mp4	6.8 MB
001 Thinking About Performance__en.srt	3.7 KB
002 Where Does Postgres Store Data_.mp4	23.7 MB
002 Where Does Postgres Store Data___en.srt	8.8 KB
003 Heaps, Blocks, and Tuples.mp4	15.9 MB
003 Heaps, Blocks, and Tuples__en.srt	5.8 KB
004 Block Data Layout.mp4	12.3 MB
004 Block Data Layout__en.srt	6.9 KB
005 Heap File Layout.mp4	355.1 MB
005 Heap File Layout__en.srt	49.5 KB
/23 - A Look at Indexes for Performance/
001 Full Table Scans.mp4	25.0 MB
001 Full Table Scans__en.srt	6.5 KB
002 What's an Index.mp4	6.7 MB
002 What's an Index__en.srt	4.0 KB
003 How an Index Works.mp4	45.3 MB
003 How an Index Works__en.srt	12.3 KB
004 Creating an Index.mp4	9.3 MB
004 Creating an Index__en.srt	6.2 KB
005 Benchmarking Queries.mp4	15.7 MB
005 Benchmarking Queries__en.srt	8.5 KB
006 Downsides of Indexes.mp4	20.8 MB
006 Downsides of Indexes__en.srt	8.2 KB
007 Index Types.mp4	4.3 MB
007 Index Types__en.srt	2.6 KB
008 Automatically Generated Indexes.mp4	13.4 MB
008 Automatically Generated Indexes__en.srt	5.7 KB
009 Behind the Scenes of Indexes.mp4	249.9 MB
009 Behind the Scenes of Indexes__en.srt	48.7 KB
/24 - Basic Query Tuning/
001 The Query Processing Pipeline.mp4	16.9 MB
001 The Query Processing Pipeline__en.srt	8.1 KB
002 Explain and Explain Analyze.mp4	28.5 MB
002 Explain and Explain Analyze__en.srt	8.3 KB
003 Solving an Explain Mystery.mp4	51.4 MB
003 Solving an Explain Mystery__en.srt	14.0 KB
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/25 - Advanced Query Tuning/
001 Developing an Intuitive Understanding of Cost.mp4	67.7 MB
001 Developing an Intuitive Understanding of Cost__en.srt	20.4 KB
002 Calculating Cost by Hand.mp4	33.7 MB
002 Calculating Cost by Hand__en.srt	10.1 KB
003 A Touch More on Costs.mp4	58.0 MB
003 A Touch More on Costs__en.srt	11.4 KB
004 Startup vs Total Costs.mp4	30.1 MB
004 Startup vs Total Costs__en.srt	9.1 KB
005 Costs Flow Up.mp4	6.7 MB
005 Costs Flow Up__en.srt	3.1 KB
006 Use My Index_.mp4	27.2 MB
006 Use My Index___en.srt	12.7 KB
/26 - Simple Common Table Expressions/
001 Common Table Expressions.mp4	7.3 MB
001 Common Table Expressions__en.srt	3.0 KB
002 A Quick Solution.mp4	9.1 MB
002 A Quick Solution__en.srt	5.6 KB
003 So What's a CTE_.mp4	21.5 MB
003 So What's a CTE___en.srt	5.8 KB
/27 - Recursive Common Table Expressions/
001 Recursive CTE's.mp4	8.2 MB
001 Recursive CTE's__en.srt	5.0 KB
002 Recursive CTE's Step by Step.mp4	42.0 MB
002 Recursive CTE's Step by Step__en.srt	15.5 KB
003 Why Use Recursive CTE's_.mp4	28.6 MB
004 Writing the Query.mp4	24.7 MB
004 Writing the Query__en.srt	11.9 KB
005 Walking Through Recursion.mp4	69.2 MB
005 Walking Through Recursion__en.srt	14.9 KB
/28 - Simplifying Queries with Views/
001 Most Popular Users.mp4	17.4 MB
001 Most Popular Users__en.srt	9.8 KB
002 A Possible Solution for Merging Tables.mp4	23.4 MB
002 A Possible Solution for Merging Tables__en.srt	6.2 KB
003 Creating a View.mp4	22.3 MB
003 Creating a View__en.srt	8.5 KB
004 When to Use a View_.mp4	13.7 MB
004 When to Use a View___en.srt	5.0 KB
005 Deleting and Changing Views.mp4	8.3 MB
005 Deleting and Changing Views__en.srt	3.7 KB
/29 - Optimizing Queries with Materialized Views/
001 Materialized Views.mp4	5.9 MB
001 Materialized Views__en.srt	3.9 KB
002 Grouping by Week.mp4	23.2 MB
002 Grouping by Week__en.srt	6.4 KB
003 Reminder on Left Joins.mp4	11.0 MB
003 Reminder on Left Joins__en.srt	6.9 KB
004 Writing a Slow Query.mp4	36.8 MB
004 Writing a Slow Query__en.srt	13.9 KB
005 Creating and Refreshing Materialized Views.mp4	23.6 MB
/30 - Handling Concurrency and Reversibility with Transactions/
001 What are Transactions Used For_.mp4	16.2 MB
001 What are Transactions Used For___en.srt	6.4 KB
002 Some Sample Data.mp4	4.0 MB
002 Some Sample Data__en.srt	3.1 KB
003 Opening and Closing Transactions.mp4	44.2 MB
003 Opening and Closing Transactions__en.srt	15.1 KB
004 Transaction Cleanup on Crash.mp4	21.2 MB
004 Transaction Cleanup on Crash__en.srt	6.1 KB
005 Closing Aborted Transactions.mp4	5.1 MB
005 Closing Aborted Transactions__en.srt	2.7 KB
/31 - Managing Database Design with Schema Migrations/
001 A Story on Migrations.mp4	92.9 MB
001 A Story on Migrations__en.srt	27.8 KB
002 Migration Files.mp4	30.2 MB
002 Migration Files__en.srt	7.5 KB
003 Issues Solved by Migrations.mp4	7.0 MB
003 Issues Solved by Migrations__en.srt	4.5 KB
004 A Few Notes on Migrations Libraries.mp4	22.7 MB
004 A Few Notes on Migrations Libraries__en.srt	7.8 KB
005 A Note About Node Installation.html	0.3 KB
006 Project Creation.mp4	6.5 MB
006 Project Creation__en.srt	4.5 KB
007 Generating and Writing Migrations.mp4	29.9 MB
007 Generating and Writing Migrations__en.srt	10.4 KB
008 Applying and Reverting Migrations.mp4	42.1 MB
008 Applying and Reverting Migrations__en.srt	11.2 KB
009 Generating and Applying a Second Migration.mp4	11.3 MB
009 Generating and Applying a Second Migration__en.srt	5.2 KB
/32 - Schema vs Data Migrations/
001 Schema vs Data Migrations.mp4	14.1 MB
001 Schema vs Data Migrations__en.srt	6.4 KB
002 Dangers Around Data Migrations.mp4	46.5 MB
002 Dangers Around Data Migrations__en.srt	14.5 KB
003 Properly Running Data and Schema Migrations.mp4	14.3 MB
003 Properly Running Data and Schema Migrations__en.srt	8.8 KB
004 Creating a Posts Table.mp4	15.1 MB
004 Creating a Posts Table__en.srt	6.8 KB
005 A Small Web Server.mp4	42.6 MB
005 A Small Web Server__en.srt	20.9 KB
006 Web Server Setup Instructions.html	1.0 KB
007 Adding the Loc Column.mp4	14.9 MB
007 Adding the Loc Column__en.srt	6.0 KB
008 Writing Values to Both Columns.mp4	11.2 MB
008 Writing Values to Both Columns__en.srt	6.5 KB
009 Transaction Locks.mp4	65.7 MB
009 Transaction Locks__en.srt	22.2 KB
010 Updating Values.mp4	10.6 MB
010 Updating Values__en.srt	6.4 KB
011 Migrations Setup Instructions.html	0.9 KB
012 Updating the App Server.mp4	9.2 MB
012 Updating the App Server__en.srt	6.6 KB
013 Dropping the Last Columns.mp4	7.9 MB
28595583-005-index.js	1.3 KB
28595585-01-lng-lat-to-loc.js	0.4 KB
/33 - Accessing PostgreSQL From API's/
001 Section Goal.mp4	2.1 MB
001 Section Goal__en.srt	1.5 KB
002 Initial Setup.mp4	1.8 MB
003 One Fast Migration.mp4	16.4 MB
003 One Fast Migration__en.srt	7.3 KB
004 Building the Users Router.mp4	19.5 MB
004 Building the Users Router__en.srt	6.7 KB
005 Understanding Connection Pools.mp4	16.8 MB
005 Understanding Connection Pools__en.srt	10.6 KB
006 Validating Connection Credentials.mp4	29.3 MB
006 Validating Connection Credentials__en.srt	10.6 KB
007 Query and Close__en.srt	3.1 KB
28571947-008-access.zip	63.5 KB
28571973-005-access-social-repo.zip	62.8 KB
/34 - Data Access Pattern - Repositories/
001 The Repository Pattern.mp4	12.3 MB
001 The Repository Pattern__en.srt	5.7 KB
002 Creating a Repository.mp4	17.5 MB
002 Creating a Repository__en.srt	12.6 KB
003 Accessing the API.mp4	15.4 MB
004 Casing Issues.mp4	12.6 MB
004 Casing Issues__en.srt	7.0 KB
005 Fixing Casing.mp4	31.8 MB
005 Fixing Casing__en.srt	9.5 KB
006 Finding Particular Users.mp4	12.6 MB
006 Finding Particular Users__en.srt	8.2 KB
28571891-010-access.zip	64.1 KB
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/35 - Security Around PostgreSQL/
001 SQL Injection Exploits.mp4	21.4 MB
001 SQL Injection Exploits__en.srt	10.8 KB
002 Handling SQL Injection with Prepared Statements.mp4	26.7 MB
002 Handling SQL Injection with Prepared Statements__en.srt	12.8 KB
003 Preventing SQL Injection.mp4	23.6 MB
003 Preventing SQL Injection__en.srt	11.5 KB
004 Reminder on Post Requests.mp4	9.7 MB
004 Reminder on Post Requests__en.srt	4.2 KB
005 Inserting Users.mp4	10.5 MB
005 Inserting Users__en.srt	6.3 KB
006 Handling Updates.mp4	11.3 MB
006 Handling Updates__en.srt	6.8 KB
007 And, Finally, Delete.mp4	12.1 MB
007 And, Finally, Delete__en.srt	6.3 KB
28571907-021-access.zip	65.2 KB
28571915-019-access.zip	65.1 KB
/36 - Fast Parallel Testing/
001 A Note on Testing.mp4	5.6 MB
001 A Note on Testing__en.srt	5.0 KB
002 Assertions Around User Count.mp4	28.2 MB
002 Assertions Around User Count__en.srt	10.6 KB
003 Connecting to a DB For Tests.mp4	33.6 MB
003 Connecting to a DB For Tests__en.srt	8.2 KB
004 Disconnecting After Tests.mp4	8.6 MB
004 Disconnecting After Tests__en.srt	4.6 KB
005 Multi-DB Setup.mp4	14.8 MB
005 Multi-DB Setup__en.srt	7.5 KB
006 Assumptions Around Content.mp4	21.6 MB
006 Assumptions Around Content__en.srt	8.2 KB
007 Issues with Parallel Tests.mp4	23.9 MB
007 Issues with Parallel Tests__en.srt	7.9 KB
008 Isolation with Schemas.mp4	18.9 MB
008 Isolation with Schemas__en.srt	6.5 KB
009 Creating and Accessing Schemas.mp4	13.4 MB
009 Creating and Accessing Schemas__en.srt	8.0 KB
010 Controlling Schema Access with Search Paths.mp4	21.1 MB
010 Controlling Schema Access with Search Paths__en.srt	8.8 KB
011 Routing Schema Access.mp4	25.9 MB
011 Routing Schema Access__en.srt	6.6 KB
012 Strategy for Isolation.mp4	12.2 MB
012 Strategy for Isolation__en.srt	7.2 KB
013 Programmatic Schema Creation.mp4	43.2 MB
013 Programmatic Schema Creation__en.srt	18.1 KB
014 Escaping Identifiers.mp4	16.7 MB
014 Escaping Identifiers__en.srt	6.4 KB
015 Test Helpers.mp4	27.7 MB
015 Test Helpers__en.srt	7.9 KB
016 Cleaning up Schemas and Roles.mp4	20.4 MB
016 Cleaning up Schemas and Roles__en.srt	8.2 KB
017 Finally... Parallel Tests_.mp4	12.2 MB
017 Finally... Parallel Tests___en.srt	5.3 KB
28571893-037-access.zip	68.2 KB
28571899-034-access.zip	67.7 KB
28571901-038-access.zip	68.2 KB
28571903-027-access.zip	66.1 KB
28571917-024-access.zip	66.0 KB
28571925-025-access.zip	66.1 KB
28571937-028-access.zip	67.4 KB
28571943-036-access.zip	68.1 KB
28571955-035-access.zip	67.7 KB
28572037-026-access.zip	66.1 KB
/37 - Bonus_/
001 Bonus_.html	4.2 KB
/
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
Total files 615