GetFreeCourses Co Udemy SQL and PostgreSQL The Complete Developer Guide

GetFreeCourses Co Udemy SQL and PostgreSQL The Complete Developer Guide

Name	GetFreeCourses.Co-Udemy-SQL and PostgreSQL The Complete Developer's Guide	DOWNLOAD Copy Link
Total Size	8.4 GB
Total Files	619
Last Seen	2024-10-05 23:51
Hash	5C6CF90AF75FDFADC3C00A97B5D187332B5B41E0

/01 - Simple - But Powerful - SQL Statements/
001 Join Our Community!.html	0.3 KB
002 Course Resources.html	1.3 KB
002 diagrams.zip	8.1 MB
003 What is PostgreSQL All About.mp4	16.7 MB
003 What is PostgreSQL All About_en.srt	7.4 KB
004 Database Design.mp4	51.8 MB
004 Database Design_en.srt	8.4 KB
005 003-sql.sql	0.1 KB
005 Creating Tables.mp4	13.5 MB
005 Creating Tables_en.srt	7.9 KB
006 Analyzing CREATE TABLE.mp4	18.5 MB
006 Analyzing CREATE TABLE_en.srt	5.7 KB
007 005-sql-cumulative.sql	0.4 KB
007 005-sql.sql	0.3 KB
007 Inserting Data Into a Table.mp4	18.9 MB
007 Inserting Data Into a Table_en.srt	7.8 KB
008 Retrieving Data with Select.mp4	6.3 MB
008 Retrieving Data with Select_en.srt	3.5 KB
009 Calculated Columns.mp4	16.0 MB
009 Calculated Columns_en.srt	7.4 KB
010 Calculating Phone Revenue.mp4	3.5 MB
010 Calculating Phone Revenue_en.srt	1.6 KB
011 Exercise Solution.mp4	3.3 MB
011 Exercise Solution_en.srt	1.7 KB
012 012-sql.sql	0.4 KB
012 String Operators and Functions.mp4	17.1 MB
012 String Operators and Functions_en.srt	10.4 KB
/02 - Filtering Records/
001 013-sql.sql	0.0 KB
001 Filtering Rows with Where.mp4	12.9 MB
001 Filtering Rows with Where_en.srt	6.1 KB
002 More on the Where Keyword.mp4	9.9 MB
002 More on the Where Keyword_en.srt	3.9 KB
003 Compound Where Clauses.mp4	19.9 MB
003 Compound Where Clauses_en.srt	7.7 KB
004 A Where Exercise Overview.mp4	1.8 MB
004 A Where Exercise Overview_en.srt	0.9 KB
005 A Where Solution.mp4	2.7 MB
005 A Where Solution_en.srt	1.6 KB
006 Where With Lists.mp4	1.7 MB
006 Where With Lists_en.srt	1.1 KB
007 A Where With Lists Solution.mp4	5.2 MB
007 A Where With Lists Solution_en.srt	2.6 KB
008 Calculations in Where Clauses.mp4	4.9 MB
008 Calculations in Where Clauses_en.srt	3.1 KB
009 Solving Calculations.mp4	6.2 MB
009 Solving Calculations_en.srt	3.0 KB
010 Updating Rows.mp4	18.1 MB
010 Updating Rows_en.srt	6.5 KB
011 Deleting Rows.mp4	11.7 MB
011 Deleting Rows_en.srt	5.4 KB
012 A Solution for Updating Rows.mp4	5.2 MB
012 A Solution for Updating Rows_en.srt	2.0 KB
013 Solution for Deleting Rows.mp4	4.2 MB
013 Solution for Deleting Rows_en.srt	2.3 KB
/03 - Working with Tables/
001 The Plan Moving Forward.mp4	11.3 MB
001 The Plan Moving Forward_en.srt	2.8 KB
002 Approaching Database Design.mp4	52.6 MB
002 Approaching Database Design_en.srt	12.1 KB
003 One-to-Many and Many-to-One Relationships.mp4	43.3 MB
003 One-to-Many and Many-to-One Relationships_en.srt	10.4 KB
004 One-to-One and Many-to-Many Relationships.mp4	25.8 MB
004 One-to-One and Many-to-Many Relationships_en.srt	9.0 KB
005 Primary Keys and Foreign Keys.mp4	31.0 MB
005 Primary Keys and Foreign Keys_en.srt	8.1 KB
006 Understanding Foreign Keys.mp4	66.4 MB
006 Understanding Foreign Keys_en.srt	13.3 KB
007 007-tables-cumulative.sql	0.2 KB
007 007-tables.sql	0.2 KB
007 Auto-Generated ID's.mp4	24.1 MB
007 Auto-Generated ID's_en.srt	9.4 KB
008 008-tables-cumulative.sql	0.3 KB
008 008-tables.sql	0.2 KB
008 Creating Foreign Key Columns.mp4	19.2 MB
008 Creating Foreign Key Columns_en.srt	7.8 KB
009 009-tables-cumulative.sql	0.5 KB
009 009-tables.sql	0.3 KB
009 Running Queries on Associated Data.mp4	40.1 MB
009 Running Queries on Associated Data_en.srt	10.9 KB
010 Exercise Overview.mp4	8.7 MB
010 Exercise Overview_en.srt	3.3 KB
011 Foreign Key Creation Solution.mp4	8.8 MB
011 Foreign Key Creation Solution_en.srt	3.2 KB
012 012-tables-cumulative.sql	0.6 KB
012 012-tables.sql	0.2 KB
012 Foreign Key Constraints Around Insertion.mp4	23.2 MB
012 Foreign Key Constraints Around Insertion_en.srt	8.9 KB
013 Constraints Around Deletion.mp4	42.5 MB
013 Constraints Around Deletion_en.srt	8.0 KB
014 Commands You’ll Need for the Next Video.html	0.7 KB
015 014-tables-cumulative.sql	1.0 KB
015 014-tables.sql	0.5 KB
015 Testing Deletion Constraints.mp4	20.2 MB
015 Testing Deletion Constraints_en.srt	7.3 KB
016 015-tables-cumulative.sql	1.3 KB
016 015-tables.sql	0.3 KB
016 Setting Foreign Keys to Null on Delete.mp4	13.2 MB
016 Setting Foreign Keys to Null on Delete_en.srt	4.7 KB
017 Adding Some Complexity.mp4	10.4 MB
017 Adding Some Complexity_en.srt	4.9 KB
/04 - Relating Records with Joins/
001 Adding Some Data.html	7.8 KB
002 Queries with Joins and Aggregations.mp4	29.2 MB
002 Queries with Joins and Aggregations_en.srt	5.4 KB
003 Joining Data from Different Tables.mp4	38.6 MB
003 Joining Data from Different Tables_en.srt	11.9 KB
004 Another Quick Join.mp4	9.0 MB
004 Another Quick Join_en.srt	3.5 KB
005 Exercise Overview.mp4	5.1 MB
005 Exercise Overview_en.srt	1.9 KB
006 A Joinful Solution.mp4	5.5 MB
006 A Joinful Solution_en.srt	2.8 KB
007 Alternate Forms of Syntax.mp4	26.2 MB
007 Alternate Forms of Syntax_en.srt	9.5 KB
008 007-joins-cumulative.sql	7.7 KB
008 Missing Data in Joins.mp4	30.7 MB
008 Missing Data in Joins_en.srt	10.3 KB
009 Why Wasn't It Included.mp4	25.8 MB
009 Why Wasn't It Included_en.srt	3.9 KB
010 009-joins-cheatsheet.pdf	195.1 KB
010 Four Kinds of Joins.mp4	130.9 MB
010 Four Kinds of Joins_en.srt	15.5 KB
011 010-sql-cumulative.sql	7.8 KB
011 Each Join in Practice.mp4	42.6 MB
011 Each Join in Practice_en.srt	6.9 KB
012 Does Order Matter.mp4	64.3 MB
012 Does Order Matter_en.srt	6.5 KB
013 Exercise Overview.mp4	2.3 MB
013 Exercise Overview_en.srt	1.6 KB
014 Two Possible Solutions.mp4	17.3 MB
015 Where with Join.mp4	32.5 MB
015 Where with Join_en.srt	10.9 KB
016 Three Way Joins.mp4	52.1 MB
016 Three Way Joins_en.srt	12.5 KB
017 A Bit of Practice.mp4	18.7 MB
017 A Bit of Practice_en.srt	8.0 KB
018 Exercise Solution.mp4	8.0 MB
018 Exercise Solution_en.srt	4.4 KB
/05 - Aggregation of Records/
001 Aggregating and Grouping.mp4	8.3 MB
001 Aggregating and Grouping_en.srt	3.7 KB
002 Picturing Group By.mp4	30.9 MB
002 Picturing Group By_en.srt	8.5 KB
003 Aggregate Functions.mp4	12.1 MB
003 Aggregate Functions_en.srt	4.7 KB
004 Combining Group By and Aggregates.mp4	15.9 MB
004 Combining Group By and Aggregates_en.srt	7.2 KB
005 A Gotcha with Count.mp4	5.7 MB
005 A Gotcha with Count_en.srt	4.3 KB
006 Visualizing More Grouping.mp4	10.2 MB
006 Visualizing More Grouping_en.srt	4.8 KB
007 Exercise Overview.mp4	1.7 MB
007 Exercise Overview_en.srt	1.2 KB
008 Grouping Solution.mp4	3.3 MB
008 Grouping Solution_en.srt	2.3 KB
009 Adding a Layer of Difficulty.mp4	1.9 MB
009 Adding a Layer of Difficulty_en.srt	1.1 KB
010 Solution.mp4	3.9 MB
010 Solution_en.srt	2.5 KB
011 Filtering Groups with Having.mp4	38.8 MB
011 Filtering Groups with Having_en.srt	7.9 KB
012 Having In Action.mp4	7.2 MB
012 Having In Action_en.srt	4.2 KB
013 More on Having!.mp4	29.8 MB
013 More on Having!_en.srt	11.3 KB
014 A Having Exercise Overview.mp4	13.4 MB
014 A Having Exercise Overview_en.srt	5.7 KB
015 A Quick Solution.mp4	7.7 MB
015 A Quick Solution_en.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	8.4 MB
002 Investigating This Dataset_en.srt	4.1 KB
003 Some Group By Practice.mp4	3.3 MB
003 Some Group By Practice_en.srt	2.1 KB
004 Group By Review Solution.mp4	8.3 MB
004 Group By Review Solution_en.srt	3.8 KB
005 Remember Joins.mp4	9.8 MB
005 Remember Joins_en.srt	3.7 KB
006 Of Course You Remember!.mp4	4.6 MB
006 Of Course You Remember!_en.srt	2.3 KB
GetFreeCourses.Co.url	0.1 KB
How you can help GetFreeCourses.Co.txt	0.2 KB
/07 - Sorting Records/
001 The Basics of Sorting.mp4	7.1 MB
001 The Basics of Sorting_en.srt	3.8 KB
002 Two Variations on Sorting.mp4	9.9 MB
002 Two Variations on Sorting_en.srt	4.3 KB
003 Offset and Limit.mp4	20.4 MB
003 Offset and Limit_en.srt	10.4 KB
004 Exercise Overview.mp4	1.1 MB
004 Exercise Overview_en.srt	0.7 KB
005 Exercise Solution.mp4	3.5 MB
005 Exercise Solution_en.srt	2.2 KB
/08 - Unions and Intersections with Sets/
001 Handling Sets with Union.mp4	20.5 MB
001 Handling Sets with Union_en.srt	9.2 KB
002 A Few Notes on Union.mp4	17.3 MB
002 A Few Notes on Union_en.srt	6.0 KB
003 Commonalities with Intersect.mp4	16.2 MB
003 Commonalities with Intersect_en.srt	5.2 KB
004 Removing Commonalities with Except.mp4	21.4 MB
004 Removing Commonalities with Except_en.srt	9.7 KB
005 Union Exercise Overview.mp4	4.4 MB
005 Union Exercise Overview_en.srt	2.2 KB
006 Exercise Solution.mp4	4.9 MB
006 Exercise Solution_en.srt	2.2 KB
/09 - Assembling Queries with SubQueries/
001 What's a Subquery.mp4	32.0 MB
001 What's a Subquery_en.srt	8.8 KB
002 Thinking About the Structure of Data.mp4	24.8 MB
002 Thinking About the Structure of Data_en.srt	7.7 KB
003 Subqueries in a Select.mp4	23.6 MB
003 Subqueries in a Select_en.srt	8.7 KB
004 Exercise Overview.mp4	3.2 MB
004 Exercise Overview_en.srt	1.8 KB
005 Select Solution.mp4	4.0 MB
005 Select Solution_en.srt	2.0 KB
006 Subqueries in a From.mp4	46.6 MB
006 Subqueries in a From_en.srt	12.6 KB
007 From Subqueries that Return a Value.mp4	9.5 MB
007 From Subqueries that Return a Value_en.srt	4.4 KB
008 Example of a Subquery in a From.mp4	56.1 MB
008 Example of a Subquery in a From_en.srt	14.3 KB
009 Exercise Overview.mp4	3.6 MB
009 Exercise Overview_en.srt	1.8 KB
010 Exercise Solution.mp4	10.9 MB
010 Exercise Solution_en.srt	2.8 KB
011 Subqueries in a Join Clause.mp4	17.4 MB
011 Subqueries in a Join Clause_en.srt	7.2 KB
012 More Useful - Subqueries with Where.mp4	38.4 MB
012 More Useful - Subqueries with Where_en.srt	14.2 KB
013 Data Structure with Where Subqueries.mp4	46.2 MB
013 Data Structure with Where Subqueries_en.srt	9.2 KB
014 Exercise Overview.mp4	2.8 MB
014 Exercise Overview_en.srt	1.6 KB
015 Exercise Solution.mp4	6.5 MB
015 Exercise Solution_en.srt	3.2 KB
016 The Not In Operator with a List.mp4	40.5 MB
016 The Not In Operator with a List_en.srt	6.5 KB
017 A New Where Operator.mp4	40.6 MB
017 A New Where Operator_en.srt	10.3 KB
018 Finally Some!.mp4	33.5 MB
018 Finally Some!_en.srt	8.1 KB
019 Exercise Overview.mp4	1.3 MB
019 Exercise Overview_en.srt	0.7 KB
020 A Quick Solution.mp4	4.6 MB
020 A Quick Solution_en.srt	2.5 KB
021 Probably Too Much About Correlated Subqueries.mp4	112.2 MB
021 Probably Too Much About Correlated Subqueries_en.srt	26.9 KB
022 More on Correlated Subqueries.mp4	46.3 MB
022 More on Correlated Subqueries_en.srt	14.1 KB
023 A Select Without a From.mp4	9.5 MB
023 A Select Without a From_en.srt	5.3 KB
024 Exercise Overview.mp4	2.0 MB
024 Exercise Overview_en.srt	1.3 KB
025 Exercise Solution.mp4	3.7 MB
025 Exercise Solution_en.srt	1.9 KB
/10 - Selecting Distinct Records/
001 Selecting Distinct Values.mp4	13.1 MB
001 Selecting Distinct Values_en.srt	6.7 KB
002 Exercise Overview.mp4	1.4 MB
002 Exercise Overview_en.srt	0.9 KB
003 A Distinct Solution.mp4	2.0 MB
003 A Distinct Solution_en.srt	1.0 KB
/11 - Utility Operators, Keywords, and Functions/
001 The Greatest Value in a List.mp4	12.3 MB
001 The Greatest Value in a List_en.srt	5.3 KB
002 And the Least Value in a List!.mp4	5.8 MB
002 And the Least Value in a List!_en.srt	3.2 KB
003 The Case Keyword.mp4	14.0 MB
003 The Case Keyword_en.srt	7.1 KB
/12 - Local PostgreSQL Installation/
001 PostgreSQL Installation on macOS.mp4	22.2 MB
001 PostgreSQL Installation on macOS_en.srt	10.1 KB
002 PGAdmin Setup on macOS.mp4	38.7 MB
002 PGAdmin Setup on macOS_en.srt	8.2 KB
003 Postgres installation on Windows.mp4	24.4 MB
003 Postgres installation on Windows_en.srt	6.9 KB
/13 - PostgreSQL Complex Datatypes/
001 What'd We Just Do.mp4	20.3 MB
001 What'd We Just Do_en.srt	6.6 KB
002 Data Types.mp4	32.0 MB
002 Data Types_en.srt	7.2 KB
003 Fast Rules on Numeric Data Types.mp4	19.8 MB
003 Fast Rules on Numeric Data Types_en.srt	3.7 KB
004 More on Number Data Types.mp4	50.5 MB
004 More on Number Data Types_en.srt	15.6 KB
005 Reminder on Character Types.mp4	31.4 MB
005 Reminder on Character Types_en.srt	8.0 KB
006 Boolean Data Types.mp4	8.6 MB
006 Boolean Data Types_en.srt	4.5 KB
007 Times, Dates, and Timestamps.mp4	22.3 MB
007 Times, Dates, and Timestamps_en.srt	8.7 KB
008 Really Awesome Intervals.mp4	20.4 MB
008 Really Awesome Intervals_en.srt	9.3 KB
/14 - Database-Side Validation and Constraints/
001 Thinking About Validation.mp4	36.3 MB
001 Thinking About Validation_en.srt	6.9 KB
002 Creating and Viewing Tables in PGAdmin.mp4	29.5 MB
002 Creating and Viewing Tables in PGAdmin_en.srt	11.9 KB
003 Applying a Null Constraint.mp4	22.1 MB
003 Applying a Null Constraint_en.srt	10.6 KB
004 Solving a Gotcha with Null Constraints.mp4	14.4 MB
004 Solving a Gotcha with Null Constraints_en.srt	6.9 KB
005 Default Column Values.mp4	23.6 MB
005 Default Column Values_en.srt	5.3 KB
006 Applying a Unique Constraint to One column.mp4	45.2 MB
006 Applying a Unique Constraint to One column_en.srt	9.5 KB
007 Multi-Column Uniqueness.mp4	31.5 MB
007 Multi-Column Uniqueness_en.srt	5.7 KB
008 Adding a Validation Check.mp4	19.1 MB
008 Adding a Validation Check_en.srt	6.5 KB
009 Checks Over Multiple Columns.mp4	18.0 MB
009 Checks Over Multiple Columns_en.srt	8.2 KB
010 So Where Are We Applying Validation.mp4	23.1 MB
010 So Where Are We Applying Validation_en.srt	10.0 KB
/15 - Database Structure Design Patterns/
001 Approaching More Complicated Designs.mp4	11.8 MB
001 Approaching More Complicated Designs_en.srt	5.5 KB
002 Using a SQL Design Tool.mp4	49.6 MB
002 Using a SQL Design Tool_en.srt	10.2 KB
003 A Config-based Schema Designer.mp4	30.1 MB
003 A Config-based Schema Designer_en.srt	12.0 KB
004 Here's the Plan.mp4	10.1 MB
004 Here's the Plan_en.srt	4.3 KB
005 005-design.dbml	0.5 KB
005 Rebuilding Some Schema.mp4	22.0 MB
005 Rebuilding Some Schema_en.srt	11.2 KB
/16 - How to Build a 'Like' System/
001 Requirements of a Like System.mp4	27.4 MB
001 Requirements of a Like System_en.srt	7.8 KB
002 How Not to Design a Like System.mp4	17.0 MB
002 How Not to Design a Like System_en.srt	5.0 KB
003 Designing a Like System.mp4	27.4 MB
003 Designing a Like System_en.srt	8.6 KB
004 Making a Reaction System Instead.mp4	6.7 MB
004 Making a Reaction System Instead_en.srt	2.6 KB
005 Polymorphic Associations.mp4	55.2 MB
005 Polymorphic Associations_en.srt	9.6 KB
006 Polymorphic Association Alternative Implementation.mp4	66.9 MB
006 Polymorphic Association Alternative Implementation_en.srt	11.4 KB
007 The Simplest Alternative.mp4	28.2 MB
007 The Simplest Alternative_en.srt	6.2 KB
008 So Which Approach.mp4	16.8 MB
008 So Which Approach_en.srt	7.3 KB
/17 - How to Build a 'Mention' System/
001 Additional Features Around Posts.mp4	100.4 MB
001 Additional Features Around Posts_en.srt	10.5 KB
002 Adding Captions and Locations.mp4	8.9 MB
002 Adding Captions and Locations_en.srt	2.7 KB
003 Photo Mentions vs Caption Mentions.mp4	77.0 MB
003 Photo Mentions vs Caption Mentions_en.srt	12.8 KB
004 Considerations on Photo Tags vs Caption Tags.mp4	70.3 MB
004 Considerations on Photo Tags vs Caption Tags_en.srt	11.9 KB
005 Update For Tags.mp4	24.6 MB
005 Update For Tags_en.srt	7.8 KB
/18 - How to Build a 'Hashtag' System/
001 Designing a Hashtag System.mp4	102.9 MB
001 Designing a Hashtag System_en.srt	12.2 KB
002 Tables for Hashtags.mp4	15.2 MB
002 Tables for Hashtags_en.srt	6.0 KB
003 Including the Hashtag Table.mp4	18.9 MB
003 Including the Hashtag Table_en.srt	5.9 KB
004 A Few More User Columns.mp4	29.0 MB
004 A Few More User Columns_en.srt	10.2 KB
005 Why No Number of Followers or Posts.mp4	17.9 MB
005 Why No Number of Followers or Posts_en.srt	6.2 KB
/19 - How to Design a 'Follower' System/
001 Designing a Follower System.mp4	27.8 MB
001 Designing a Follower System_en.srt	9.6 KB
GetFreeCourses.Co.url	0.1 KB
How you can help GetFreeCourses.Co.txt	0.2 KB
/20 - Implementing Database Design Patterns/
001 Back to Postgres.mp4	7.2 MB
001 Back to Postgres_en.srt	3.3 KB
002 002-db.sql	0.4 KB
002 Creating Tables with Checks.mp4	63.5 MB
002 Creating Tables with Checks_en.srt	21.9 KB
003 003-db.sql	0.8 KB
003 Posts Creation.mp4	37.9 MB
003 Posts Creation_en.srt	13.1 KB
004 004-db.sql	1.1 KB
004 Comments Creation.mp4	7.5 MB
004 Comments Creation_en.srt	3.6 KB
005 005-db.sql	1.6 KB
005 Likes Creation.mp4	25.0 MB
005 Likes Creation_en.srt	10.8 KB
006 006-db.sql	2.2 KB
006 Photo Tags and Caption Tags.mp4	43.4 MB
006 Photo Tags and Caption Tags_en.srt	8.7 KB
007 007-db.sql	2.9 KB
007 Creating Hashtags, Hashtag Posts, and Followers.mp4	20.8 MB
007 Creating Hashtags, Hashtag Posts, and Followers_en.srt	9.6 KB
/21 - Approaching and Writing Complex Queries/
001 Quick Note About Adding Some Data.html	0.3 KB
001 ig.sql	24.7 MB
002 Adding Some Data.mp4	17.8 MB
002 Adding Some Data_en.srt	7.0 KB
003 Restoring from Scratch.mp4	22.3 MB
003 Restoring from Scratch_en.srt	7.3 KB
004 Highest User ID's Exercise.mp4	7.5 MB
004 Highest User ID's Exercise_en.srt	3.2 KB
005 Solution for User ID's.mp4	4.9 MB
005 Solution for User ID's_en.srt	1.9 KB
006 Posts by a Particular User.mp4	5.0 MB
006 Posts by a Particular User_en.srt	1.8 KB
007 Solving for Posts by User.mp4	9.8 MB
007 Solving for Posts by User_en.srt	3.0 KB
008 Likes Per User.mp4	3.8 MB
008 Likes Per User_en.srt	1.3 KB
009 Solution for Likes Per User.mp4	6.9 MB
009 Solution for Likes Per User_en.srt	2.5 KB
/22 - Understanding the Internals of PostgreSQL/
001 Thinking About Performance.mp4	9.7 MB
001 Thinking About Performance_en.srt	3.6 KB
002 Where Does Postgres Store Data.mp4	38.8 MB
002 Where Does Postgres Store Data_en.srt	9.0 KB
003 Heaps, Blocks, and Tuples.mp4	23.8 MB
003 Heaps, Blocks, and Tuples_en.srt	6.0 KB
004 Block Data Layout.mp4	18.1 MB
004 Block Data Layout_en.srt	7.4 KB
005 Heap File Layout.mp4	626.2 MB
005 Heap File Layout_en.srt	51.8 KB
/23 - A Look at Indexes for Performance/
001 Full Table Scans.mp4	39.0 MB
001 Full Table Scans_en.srt	6.5 KB
002 What's an Index.mp4	10.6 MB
002 What's an Index_en.srt	4.0 KB
003 How an Index Works.mp4	72.7 MB
003 How an Index Works_en.srt	13.1 KB
004 Creating an Index.mp4	13.8 MB
004 Creating an Index_en.srt	6.7 KB
005 Benchmarking Queries.mp4	23.7 MB
005 Benchmarking Queries_en.srt	8.7 KB
006 Downsides of Indexes.mp4	33.4 MB
006 Downsides of Indexes_en.srt	8.0 KB
007 Index Types.mp4	6.8 MB
007 Index Types_en.srt	2.6 KB
008 Automatically Generated Indexes.mp4	20.7 MB
008 Automatically Generated Indexes_en.srt	5.8 KB
009 Behind the Scenes of Indexes.mp4	418.1 MB
/24 - Basic Query Tuning/
001 The Query Processing Pipeline.mp4	27.0 MB
001 The Query Processing Pipeline_en.srt	8.5 KB
002 Explain and Explain Analyze.mp4	44.9 MB
002 Explain and Explain Analyze_en.srt	8.6 KB
003 Solving an Explain Mystery.mp4	83.7 MB
003 Solving an Explain Mystery_en.srt	14.5 KB
/25 - Advanced Query Tuning/
001 Developing an Intuitive Understanding of Cost.mp4	107.9 MB
001 Developing an Intuitive Understanding of Cost_en.srt	20.6 KB
002 Calculating Cost by Hand.mp4	53.7 MB
002 Calculating Cost by Hand_en.srt	10.2 KB
003 A Touch More on Costs.mp4	100.0 MB
003 A Touch More on Costs_en.srt	11.4 KB
004 Startup vs Total Costs.mp4	46.9 MB
004 Startup vs Total Costs_en.srt	9.2 KB
005 Costs Flow Up.mp4	10.6 MB
005 Costs Flow Up_en.srt	3.1 KB
006 Use My Index!.mp4	41.3 MB
006 Use My Index!_en.srt	12.8 KB
/26 - Simple Common Table Expressions/
001 Common Table Expressions.mp4	11.7 MB
001 Common Table Expressions_en.srt	3.0 KB
002 A Quick Solution.mp4	13.8 MB
002 A Quick Solution_en.srt	6.0 KB
003 So What's a CTE.mp4	35.1 MB
003 So What's a CTE_en.srt	6.3 KB
/27 - Recursive Common Table Expressions/
001 Recursive CTE's.mp4	12.5 MB
002 Recursive CTE's Step by Step.mp4	65.9 MB
002 Recursive CTE's Step by Step_en.srt	16.5 KB
003 Why Use Recursive CTE's.mp4	45.2 MB
003 Why Use Recursive CTE's_en.srt	7.8 KB
004 Writing the Query.mp4	38.3 MB
004 Writing the Query_en.srt	12.8 KB
005 Walking Through Recursion.mp4	114.7 MB
005 Walking Through Recursion_en.srt	15.3 KB
/28 - Simplifying Queries with Views/
001 Most Popular Users.mp4	26.0 MB
001 Most Popular Users_en.srt	10.5 KB
002 A Possible Solution for Merging Tables.mp4	37.4 MB
002 A Possible Solution for Merging Tables_en.srt	6.3 KB
003 Creating a View.mp4	35.0 MB
003 Creating a View_en.srt	9.0 KB
004 When to Use a View.mp4	22.2 MB
004 When to Use a View_en.srt	5.2 KB
005 Deleting and Changing Views.mp4	13.1 MB
/29 - Optimizing Queries with Materialized Views/
001 Materialized Views.mp4	8.8 MB
001 Materialized Views_en.srt	4.0 KB
002 Grouping by Week.mp4	36.1 MB
002 Grouping by Week_en.srt	6.7 KB
003 Reminder on Left Joins.mp4	16.3 MB
003 Reminder on Left Joins_en.srt	7.3 KB
004 Writing a Slow Query.mp4	57.8 MB
004 Writing a Slow Query_en.srt	14.3 KB
005 Creating and Refreshing Materialized Views.mp4	37.9 MB
005 Creating and Refreshing Materialized Views_en.srt	10.0 KB
GetFreeCourses.Co.url	0.1 KB
How you can help GetFreeCourses.Co.txt	0.2 KB
/30 - Handling Concurrency and Reversibility with Transactions/
001 What are Transactions Used For.mp4	23.6 MB
001 What are Transactions Used For_en.srt	6.5 KB
002 Some Sample Data.mp4	5.7 MB
002 Some Sample Data_en.srt	3.4 KB
003 Opening and Closing Transactions.mp4	68.5 MB
003 Opening and Closing Transactions_en.srt	15.5 KB
004 Transaction Cleanup on Crash.mp4	34.5 MB
005 Closing Aborted Transactions.mp4	7.8 MB
005 Closing Aborted Transactions_en.srt	2.9 KB
/31 - Managing Database Design with Schema Migrations/
001 A Story on Migrations.mp4	146.5 MB
001 A Story on Migrations_en.srt	28.7 KB
002 Migration Files.mp4	46.3 MB
002 Migration Files_en.srt	7.7 KB
003 Issues Solved by Migrations.mp4	10.5 MB
003 Issues Solved by Migrations_en.srt	4.6 KB
004 A Few Notes on Migrations Libraries.mp4	35.8 MB
004 A Few Notes on Migrations Libraries_en.srt	7.7 KB
005 A Note About Node Installation.html	0.3 KB
006 Project Creation.mp4	10.4 MB
006 Project Creation_en.srt	4.6 KB
007 Generating and Writing Migrations.mp4	47.9 MB
007 Generating and Writing Migrations_en.srt	10.6 KB
008 Applying and Reverting Migrations.mp4	71.4 MB
008 Applying and Reverting Migrations_en.srt	11.8 KB
009 Generating and Applying a Second Migration.mp4	17.4 MB
009 Generating and Applying a Second Migration_en.srt	5.6 KB
/32 - Schema vs Data Migrations/
001 Schema vs Data Migrations.mp4	21.3 MB
002 Dangers Around Data Migrations.mp4	73.4 MB
002 Dangers Around Data Migrations_en.srt	15.1 KB
003 Properly Running Data and Schema Migrations.mp4	20.7 MB
003 Properly Running Data and Schema Migrations_en.srt	8.8 KB
004 Creating a Posts Table.mp4	22.6 MB
004 Creating a Posts Table_en.srt	7.3 KB
005 005-index.js	1.3 KB
005 A Small Web Server.mp4	65.3 MB
006 Web Server Setup Instructions.html	1.0 KB
007 Adding the Loc Column.mp4	22.6 MB
007 Adding the Loc Column_en.srt	6.4 KB
008 Writing Values to Both Columns.mp4	17.1 MB
008 Writing Values to Both Columns_en.srt	6.9 KB
009 Transaction Locks.mp4	101.1 MB
009 Transaction Locks_en.srt	23.0 KB
010 Updating Values.mp4	16.0 MB
010 Updating Values_en.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	13.9 MB
012 Updating the App Server_en.srt	6.7 KB
013 Dropping the Last Columns.mp4	12.2 MB
013 Dropping the Last Columns_en.srt	4.8 KB
/33 - Accessing PostgreSQL From API's/
001 Section Goal.mp4	2.7 MB
001 Section Goal_en.srt	1.6 KB
002 Initial Setup.mp4	2.3 MB
002 Initial Setup_en.srt	2.5 KB
003 One Fast Migration.mp4	25.6 MB
004 005-access-social-repo.zip	62.8 KB
004 Building the Users Router.mp4	31.0 MB
004 Building the Users Router_en.srt	7.2 KB
005 Understanding Connection Pools.mp4	24.0 MB
005 Understanding Connection Pools_en.srt	10.9 KB
006 Validating Connection Credentials.mp4	46.9 MB
006 Validating Connection Credentials_en.srt	10.8 KB
007 008-access.zip	63.5 KB
007 Query and Close.mp4	6.2 MB
007 Query and Close_en.srt	3.3 KB
/34 - Data Access Pattern - Repositories/
001 The Repository Pattern.mp4	18.7 MB
001 The Repository Pattern_en.srt	5.8 KB
002 010-access.zip	64.1 KB
002 Creating a Repository.mp4	26.0 MB
002 Creating a Repository_en.srt	13.0 KB
003 Accessing the API.mp4	24.7 MB
003 Accessing the API_en.srt	6.4 KB
004 Casing Issues.mp4	19.5 MB
004 Casing Issues_en.srt	7.0 KB
005 Fixing Casing.mp4	52.2 MB
005 Fixing Casing_en.srt	10.2 KB
006 Finding Particular Users.mp4	19.0 MB
006 Finding Particular Users_en.srt	8.6 KB
/35 - Security Around PostgreSQL/
001 SQL Injection Exploits.mp4	31.9 MB
001 SQL Injection Exploits_en.srt	11.0 KB
002 Handling SQL Injection with Prepared Statements.mp4	40.0 MB
002 Handling SQL Injection with Prepared Statements_en.srt	13.1 KB
003 Preventing SQL Injection.mp4	36.0 MB
003 Preventing SQL Injection_en.srt	12.2 KB
004 Reminder on Post Requests.mp4	15.1 MB
004 Reminder on Post Requests_en.srt	4.4 KB
005 019-access.zip	65.1 KB
005 Inserting Users.mp4	16.0 MB
005 Inserting Users_en.srt	6.7 KB
006 Handling Updates.mp4	17.5 MB
006 Handling Updates_en.srt	7.2 KB
007 021-access.zip	65.2 KB
007 And, Finally, Delete.mp4	19.1 MB
007 And, Finally, Delete_en.srt	6.9 KB
/36 - Fast Parallel Testing/
001 A Note on Testing.mp4	8.0 MB
001 A Note on Testing_en.srt	5.2 KB
002 Assertions Around User Count.mp4	44.4 MB
002 Assertions Around User Count_en.srt	11.4 KB
003 024-access.zip	66.0 KB
003 Connecting to a DB For Tests.mp4	56.9 MB
003 Connecting to a DB For Tests_en.srt	8.4 KB
004 025-access.zip	66.1 KB
004 Disconnecting After Tests.mp4	13.5 MB
004 Disconnecting After Tests_en.srt	5.0 KB
005 026-access.zip	66.1 KB
005 Multi-DB Setup.mp4	22.9 MB
005 Multi-DB Setup_en.srt	7.5 KB
006 027-access.zip	66.1 KB
006 Assumptions Around Content.mp4	34.7 MB
006 Assumptions Around Content_en.srt	8.3 KB
007 028-access.zip	67.4 KB
007 Issues with Parallel Tests.mp4	37.5 MB
007 Issues with Parallel Tests_en.srt	8.5 KB
008 Isolation with Schemas.mp4	28.7 MB
008 Isolation with Schemas_en.srt	6.7 KB
009 Creating and Accessing Schemas.mp4	20.3 MB
009 Creating and Accessing Schemas_en.srt	8.4 KB
010 Controlling Schema Access with Search Paths.mp4	32.4 MB
010 Controlling Schema Access with Search Paths_en.srt	9.0 KB
011 Routing Schema Access.mp4	43.1 MB
011 Routing Schema Access_en.srt	6.6 KB
012 Strategy for Isolation.mp4	18.4 MB
012 Strategy for Isolation_en.srt	7.3 KB
013 034-access.zip	67.7 KB
013 Programmatic Schema Creation.mp4	68.9 MB
013 Programmatic Schema Creation_en.srt	19.0 KB
014 035-access.zip	67.7 KB
014 Escaping Identifiers.mp4	26.8 MB
014 Escaping Identifiers_en.srt	6.9 KB
015 036-access.zip	68.1 KB
015 Test Helpers.mp4	45.5 MB
015 Test Helpers_en.srt	8.3 KB
016 037-access.zip	68.2 KB
016 Cleaning up Schemas and Roles.mp4	32.8 MB
016 Cleaning up Schemas and Roles_en.srt	8.7 KB
017 Finally... Parallel Tests! (Final Lecture).mp4	19.5 MB
017 Finally... Parallel Tests! (Final Lecture)_en.srt	5.3 KB
GetFreeCourses.Co.url	0.1 KB
How you can help GetFreeCourses.Co.txt	0.2 KB
/37 - Bonus!/
001 Bonus!.html	3.4 KB
/
Download Paid Udemy Courses For Free.url	0.1 KB
GetFreeCourses.Co.url	0.1 KB
How you can help GetFreeCourses.Co.txt	0.2 KB
Total files 619