Download SQL and PostgreSQL: The Complete Developer's Guide Torrent

Torrent Contents Size: 7.87 GB

SQL and PostgreSQL: The Complete Developer's Guide

▼ show more 604 files

01 - Simple - But Powerful - SQL Statements

001 Join Our Community!.html	HTML	318 B
002 Course Resources.html	HTML	1.25 KB
002 diagrams.zip	ZIP	7.72 MB
003 What is PostgreSQL All About.mp4	MP4	15.94 MB
003 What is PostgreSQL All About_en.srt	SRT	7.25 KB
004 Database Design.mp4	MP4	49.41 MB
004 Database Design_en.srt	SRT	8.21 KB
005 003-sql.sql	SQL	104 B
005 Creating Tables.mp4	MP4	12.9 MB
005 Creating Tables_en.srt	SRT	7.67 KB
006 Analyzing CREATE TABLE.mp4	MP4	17.67 MB
006 Analyzing CREATE TABLE_en.srt	SRT	5.54 KB
007 005-sql-cumulative.sql	SQL	384 B
007 005-sql.sql	SQL	278 B
007 Inserting Data Into a Table.mp4	MP4	18.07 MB
007 Inserting Data Into a Table_en.srt	SRT	7.59 KB
008 Retrieving Data with Select.mp4	MP4	6.02 MB
008 Retrieving Data with Select_en.srt	SRT	3.45 KB
009 Calculated Columns.mp4	MP4	15.22 MB
009 Calculated Columns_en.srt	SRT	7.23 KB
010 Calculating Phone Revenue.mp4	MP4	3.36 MB
010 Calculating Phone Revenue_en.srt	SRT	1.58 KB
011 Exercise Solution.mp4	MP4	3.15 MB
011 Exercise Solution_en.srt	SRT	1.62 KB
012 012-sql.sql	SQL	404 B
012 String Operators and Functions.mp4	MP4	16.34 MB
012 String Operators and Functions_en.srt	SRT	10.17 KB

02 - Filtering Records

001 013-sql.sql	SQL	48 B
001 Filtering Rows with Where.mp4	MP4	12.26 MB
001 Filtering Rows with Where_en.srt	SRT	6 KB
002 More on the Where Keyword.mp4	MP4	9.45 MB
002 More on the Where Keyword_en.srt	SRT	3.79 KB
003 Compound Where Clauses.mp4	MP4	18.98 MB
003 Compound Where Clauses_en.srt	SRT	7.57 KB
004 A Where Exercise Overview.mp4	MP4	1.72 MB
004 A Where Exercise Overview_en.srt	SRT	946 B
005 A Where Solution.mp4	MP4	2.54 MB
005 A Where Solution_en.srt	SRT	1.52 KB
006 Where With Lists.mp4	MP4	1.59 MB
006 Where With Lists_en.srt	SRT	1.07 KB
007 A Where With Lists Solution.mp4	MP4	4.96 MB
007 A Where With Lists Solution_en.srt	SRT	2.49 KB
008 Calculations in Where Clauses.mp4	MP4	4.68 MB
008 Calculations in Where Clauses_en.srt	SRT	3.02 KB
009 Solving Calculations.mp4	MP4	5.91 MB
009 Solving Calculations_en.srt	SRT	2.95 KB
010 Updating Rows.mp4	MP4	17.3 MB
010 Updating Rows_en.srt	SRT	6.32 KB
011 Deleting Rows.mp4	MP4	11.18 MB
011 Deleting Rows_en.srt	SRT	5.25 KB
012 A Solution for Updating Rows.mp4	MP4	4.94 MB
012 A Solution for Updating Rows_en.srt	SRT	1.98 KB
013 Solution for Deleting Rows.mp4	MP4	4 MB
013 Solution for Deleting Rows_en.srt	SRT	2.27 KB

03 - Working with Tables

001 The Plan Moving Forward.mp4	MP4	10.75 MB
001 The Plan Moving Forward_en.srt	SRT	2.75 KB
002 Approaching Database Design.mp4	MP4	50.16 MB
002 Approaching Database Design_en.srt	SRT	11.79 KB
003 One-to-Many and Many-to-One Relationships.mp4	MP4	41.31 MB
003 One-to-Many and Many-to-One Relationships_en.srt	SRT	10.13 KB
004 One-to-One and Many-to-Many Relationships.mp4	MP4	24.58 MB
004 One-to-One and Many-to-Many Relationships_en.srt	SRT	8.83 KB
005 Primary Keys and Foreign Keys.mp4	MP4	29.57 MB
005 Primary Keys and Foreign Keys_en.srt	SRT	7.95 KB
006 Understanding Foreign Keys.mp4	MP4	63.35 MB
006 Understanding Foreign Keys_en.srt	SRT	12.99 KB
007 007-tables-cumulative.sql	SQL	172 B
007 007-tables.sql	SQL	194 B
007 Auto-Generated ID's.mp4	MP4	22.97 MB
007 Auto-Generated ID's_en.srt	SRT	9.15 KB
008 008-tables-cumulative.sql	SQL	348 B
008 008-tables.sql	SQL	197 B
008 Creating Foreign Key Columns.mp4	MP4	18.32 MB
008 Creating Foreign Key Columns_en.srt	SRT	7.61 KB
009 009-tables-cumulative.sql	SQL	536 B
009 009-tables.sql	SQL	326 B
009 Running Queries on Associated Data.mp4	MP4	38.22 MB
009 Running Queries on Associated Data_en.srt	SRT	10.61 KB
010 Exercise Overview.mp4	MP4	8.25 MB
010 Exercise Overview_en.srt	SRT	3.26 KB
011 Foreign Key Creation Solution.mp4	MP4	8.35 MB
011 Foreign Key Creation Solution_en.srt	SRT	3.14 KB
012 012-tables-cumulative.sql	SQL	600 B
012 012-tables.sql	SQL	199 B
012 Foreign Key Constraints Around Insertion.mp4	MP4	22.15 MB
012 Foreign Key Constraints Around Insertion_en.srt	SRT	8.72 KB
013 Constraints Around Deletion.mp4	MP4	40.54 MB
013 Constraints Around Deletion_en.srt	SRT	7.76 KB
014 Commands You’ll Need for the Next Video.html	HTML	691 B
015 014-tables-cumulative.sql	SQL	994 B
015 014-tables.sql	SQL	469 B
015 Testing Deletion Constraints.mp4	MP4	19.27 MB
015 Testing Deletion Constraints_en.srt	SRT	7.09 KB
016 015-tables-cumulative.sql	SQL	1.28 KB
016 015-tables.sql	SQL	340 B
016 Setting Foreign Keys to Null on Delete.mp4	MP4	12.6 MB
016 Setting Foreign Keys to Null on Delete_en.srt	SRT	4.59 KB
017 Adding Some Complexity.mp4	MP4	9.96 MB
017 Adding Some Complexity_en.srt	SRT	4.75 KB

04 - Relating Records with Joins

001 Adding Some Data.html	HTML	7.66 KB
002 Queries with Joins and Aggregations.mp4	MP4	27.86 MB
002 Queries with Joins and Aggregations_en.srt	SRT	5.26 KB
003 Joining Data from Different Tables.mp4	MP4	36.8 MB
003 Joining Data from Different Tables_en.srt	SRT	11.65 KB
004 Another Quick Join.mp4	MP4	8.62 MB
004 Another Quick Join_en.srt	SRT	3.38 KB
005 Exercise Overview.mp4	MP4	4.85 MB
005 Exercise Overview_en.srt	SRT	1.84 KB
006 A Joinful Solution.mp4	MP4	5.27 MB
006 A Joinful Solution_en.srt	SRT	2.74 KB
007 Alternate Forms of Syntax.mp4	MP4	24.96 MB
007 Alternate Forms of Syntax_en.srt	SRT	9.32 KB
008 007-joins-cumulative.sql	SQL	7.54 KB
008 Missing Data in Joins.mp4	MP4	29.27 MB
008 Missing Data in Joins_en.srt	SRT	10.03 KB
009 Why Wasn't It Included.mp4	MP4	24.58 MB
009 Why Wasn't It Included_en.srt	SRT	3.84 KB
010 009-joins-cheatsheet.pdf	PDF	190.52 KB
010 Four Kinds of Joins.mp4	MP4	124.86 MB
010 Four Kinds of Joins_en.srt	SRT	15.17 KB
011 010-sql-cumulative.sql	SQL	7.59 KB
011 Each Join in Practice.mp4	MP4	40.6 MB
011 Each Join in Practice_en.srt	SRT	6.76 KB
012 Does Order Matter.mp4	MP4	61.33 MB
012 Does Order Matter_en.srt	SRT	6.38 KB
013 Exercise Overview.mp4	MP4	2.23 MB
013 Exercise Overview_en.srt	SRT	1.54 KB
014 Two Possible Solutions.mp4	MP4	16.51 MB
015 Where with Join.mp4	MP4	31.03 MB
015 Where with Join_en.srt	SRT	10.6 KB
016 Three Way Joins.mp4	MP4	49.71 MB
016 Three Way Joins_en.srt	SRT	12.2 KB
017 A Bit of Practice.mp4	MP4	17.87 MB
017 A Bit of Practice_en.srt	SRT	7.81 KB
018 Exercise Solution.mp4	MP4	7.67 MB
018 Exercise Solution_en.srt	SRT	4.31 KB

05 - Aggregation of Records

001 Aggregating and Grouping.mp4	MP4	7.9 MB
001 Aggregating and Grouping_en.srt	SRT	3.58 KB
002 Picturing Group By.mp4	MP4	29.43 MB
002 Picturing Group By_en.srt	SRT	8.28 KB
003 Aggregate Functions.mp4	MP4	11.58 MB
003 Aggregate Functions_en.srt	SRT	4.61 KB
004 Combining Group By and Aggregates.mp4	MP4	15.13 MB
004 Combining Group By and Aggregates_en.srt	SRT	7.06 KB
005 A Gotcha with Count.mp4	MP4	5.46 MB
005 A Gotcha with Count_en.srt	SRT	4.21 KB
006 Visualizing More Grouping.mp4	MP4	9.72 MB
006 Visualizing More Grouping_en.srt	SRT	4.67 KB
007 Exercise Overview.mp4	MP4	1.66 MB
007 Exercise Overview_en.srt	SRT	1.2 KB
008 Grouping Solution.mp4	MP4	3.15 MB
008 Grouping Solution_en.srt	SRT	2.21 KB
009 Adding a Layer of Difficulty.mp4	MP4	1.79 MB
009 Adding a Layer of Difficulty_en.srt	SRT	1.12 KB
010 Solution.mp4	MP4	3.68 MB
010 Solution_en.srt	SRT	2.44 KB
011 Filtering Groups with Having.mp4	MP4	36.97 MB
011 Filtering Groups with Having_en.srt	SRT	7.76 KB
012 Having In Action.mp4	MP4	6.86 MB
012 Having In Action_en.srt	SRT	4.11 KB
013 More on Having!.mp4	MP4	28.46 MB
013 More on Having!_en.srt	SRT	11.04 KB
014 A Having Exercise Overview.mp4	MP4	12.79 MB
014 A Having Exercise Overview_en.srt	SRT	5.53 KB
015 A Quick Solution.mp4	MP4	7.3 MB
015 A Quick Solution_en.srt	SRT	3.79 KB

06 - Working with Large Datasets

001 A New Dataset.html	HTML	17.84 KB
002 001-sq-data.sql	SQL	15.82 KB
002 Investigating This Dataset.mp4	MP4	8 MB
002 Investigating This Dataset_en.srt	SRT	3.99 KB
003 Some Group By Practice.mp4	MP4	3.1 MB
003 Some Group By Practice_en.srt	SRT	2.05 KB
004 Group By Review Solution.mp4	MP4	7.92 MB
004 Group By Review Solution_en.srt	SRT	3.71 KB
005 Remember Joins.mp4	MP4	9.3 MB
005 Remember Joins_en.srt	SRT	3.66 KB
006 Of Course You Remember!.mp4	MP4	4.42 MB
006 Of Course You Remember!_en.srt	SRT	2.21 KB
GetFreeCourses.Co.url	URL	116 B
How you can help GetFreeCourses.Co.txt	TXT	182 B

07 - Sorting Records

001 The Basics of Sorting.mp4	MP4	6.73 MB
001 The Basics of Sorting_en.srt	SRT	3.69 KB
002 Two Variations on Sorting.mp4	MP4	9.46 MB
002 Two Variations on Sorting_en.srt	SRT	4.19 KB
003 Offset and Limit.mp4	MP4	19.43 MB
003 Offset and Limit_en.srt	SRT	10.15 KB
004 Exercise Overview.mp4	MP4	1.08 MB
004 Exercise Overview_en.srt	SRT	688 B
005 Exercise Solution.mp4	MP4	3.33 MB
005 Exercise Solution_en.srt	SRT	2.14 KB

08 - Unions and Intersections with Sets

001 Handling Sets with Union.mp4	MP4	19.51 MB
001 Handling Sets with Union_en.srt	SRT	8.99 KB
002 A Few Notes on Union.mp4	MP4	16.54 MB
002 A Few Notes on Union_en.srt	SRT	5.85 KB
003 Commonalities with Intersect.mp4	MP4	15.42 MB
003 Commonalities with Intersect_en.srt	SRT	5.05 KB
004 Removing Commonalities with Except.mp4	MP4	20.44 MB
004 Removing Commonalities with Except_en.srt	SRT	9.47 KB
005 Union Exercise Overview.mp4	MP4	4.23 MB
005 Union Exercise Overview_en.srt	SRT	2.13 KB
006 Exercise Solution.mp4	MP4	4.72 MB
006 Exercise Solution_en.srt	SRT	2.15 KB

09 - Assembling Queries with SubQueries

001 What's a Subquery.mp4	MP4	30.54 MB
001 What's a Subquery_en.srt	SRT	8.58 KB
002 Thinking About the Structure of Data.mp4	MP4	23.64 MB
002 Thinking About the Structure of Data_en.srt	SRT	7.54 KB
003 Subqueries in a Select.mp4	MP4	22.54 MB
003 Subqueries in a Select_en.srt	SRT	8.52 KB
004 Exercise Overview.mp4	MP4	3.05 MB
004 Exercise Overview_en.srt	SRT	1.74 KB
005 Select Solution.mp4	MP4	3.8 MB
005 Select Solution_en.srt	SRT	1.94 KB
006 Subqueries in a From.mp4	MP4	44.45 MB
006 Subqueries in a From_en.srt	SRT	12.26 KB
007 From Subqueries that Return a Value.mp4	MP4	9.08 MB
007 From Subqueries that Return a Value_en.srt	SRT	4.27 KB
008 Example of a Subquery in a From.mp4	MP4	53.51 MB
008 Example of a Subquery in a From_en.srt	SRT	13.93 KB
009 Exercise Overview.mp4	MP4	3.4 MB
009 Exercise Overview_en.srt	SRT	1.78 KB
010 Exercise Solution.mp4	MP4	10.37 MB
010 Exercise Solution_en.srt	SRT	2.77 KB
011 Subqueries in a Join Clause.mp4	MP4	16.55 MB
011 Subqueries in a Join Clause_en.srt	SRT	7.03 KB
012 More Useful - Subqueries with Where.mp4	MP4	36.66 MB
012 More Useful - Subqueries with Where_en.srt	SRT	13.87 KB
013 Data Structure with Where Subqueries.mp4	MP4	44.04 MB
013 Data Structure with Where Subqueries_en.srt	SRT	9 KB
014 Exercise Overview.mp4	MP4	2.71 MB
014 Exercise Overview_en.srt	SRT	1.53 KB
015 Exercise Solution.mp4	MP4	6.25 MB
015 Exercise Solution_en.srt	SRT	3.14 KB
016 The Not In Operator with a List.mp4	MP4	38.59 MB
016 The Not In Operator with a List_en.srt	SRT	6.35 KB
017 A New Where Operator.mp4	MP4	38.71 MB
017 A New Where Operator_en.srt	SRT	10.05 KB
018 Finally Some!.mp4	MP4	31.96 MB
018 Finally Some!_en.srt	SRT	7.93 KB
019 Exercise Overview.mp4	MP4	1.23 MB
019 Exercise Overview_en.srt	SRT	746 B
020 A Quick Solution.mp4	MP4	4.37 MB
020 A Quick Solution_en.srt	SRT	2.42 KB
021 Probably Too Much About Correlated Subqueries.mp4	MP4	107 MB
021 Probably Too Much About Correlated Subqueries_en.srt	SRT	26.28 KB
022 More on Correlated Subqueries.mp4	MP4	44.16 MB
022 More on Correlated Subqueries_en.srt	SRT	13.74 KB
023 A Select Without a From.mp4	MP4	9.09 MB
023 A Select Without a From_en.srt	SRT	5.2 KB
024 Exercise Overview.mp4	MP4	1.95 MB
024 Exercise Overview_en.srt	SRT	1.26 KB
025 Exercise Solution.mp4	MP4	3.57 MB
025 Exercise Solution_en.srt	SRT	1.9 KB

10 - Selecting Distinct Records

001 Selecting Distinct Values.mp4	MP4	12.46 MB
001 Selecting Distinct Values_en.srt	SRT	6.58 KB
002 Exercise Overview.mp4	MP4	1.3 MB
002 Exercise Overview_en.srt	SRT	879 B
003 A Distinct Solution.mp4	MP4	1.9 MB
003 A Distinct Solution_en.srt	SRT	1006 B

11 - Utility Operators, Keywords, and Functions

001 The Greatest Value in a List.mp4	MP4	11.77 MB
001 The Greatest Value in a List_en.srt	SRT	5.13 KB
002 And the Least Value in a List!.mp4	MP4	5.55 MB
002 And the Least Value in a List!_en.srt	SRT	3.14 KB
003 The Case Keyword.mp4	MP4	13.32 MB
003 The Case Keyword_en.srt	SRT	6.91 KB

12 - Local PostgreSQL Installation

001 PostgreSQL Installation on macOS.mp4	MP4	21.13 MB
001 PostgreSQL Installation on macOS_en.srt	SRT	9.83 KB
002 PGAdmin Setup on macOS.mp4	MP4	36.92 MB
002 PGAdmin Setup on macOS_en.srt	SRT	8.04 KB
003 Postgres installation on Windows.mp4	MP4	23.31 MB
003 Postgres installation on Windows_en.srt	SRT	6.75 KB

13 - PostgreSQL Complex Datatypes

001 What'd We Just Do.mp4	MP4	19.32 MB
001 What'd We Just Do_en.srt	SRT	6.45 KB
002 Data Types.mp4	MP4	30.53 MB
002 Data Types_en.srt	SRT	7.02 KB
003 Fast Rules on Numeric Data Types.mp4	MP4	18.9 MB
003 Fast Rules on Numeric Data Types_en.srt	SRT	3.6 KB
004 More on Number Data Types.mp4	MP4	48.13 MB
004 More on Number Data Types_en.srt	SRT	15.2 KB
005 Reminder on Character Types.mp4	MP4	29.9 MB
005 Reminder on Character Types_en.srt	SRT	7.83 KB
006 Boolean Data Types.mp4	MP4	8.2 MB
006 Boolean Data Types_en.srt	SRT	4.37 KB
007 Times, Dates, and Timestamps.mp4	MP4	21.27 MB
007 Times, Dates, and Timestamps_en.srt	SRT	8.48 KB
008 Really Awesome Intervals.mp4	MP4	19.5 MB
008 Really Awesome Intervals_en.srt	SRT	9.12 KB

14 - Database-Side Validation and Constraints

001 Thinking About Validation.mp4	MP4	34.64 MB
001 Thinking About Validation_en.srt	SRT	6.7 KB
002 Creating and Viewing Tables in PGAdmin.mp4	MP4	28.09 MB
002 Creating and Viewing Tables in PGAdmin_en.srt	SRT	11.63 KB
003 Applying a Null Constraint.mp4	MP4	21.08 MB
003 Applying a Null Constraint_en.srt	SRT	10.38 KB
004 Solving a Gotcha with Null Constraints.mp4	MP4	13.72 MB
004 Solving a Gotcha with Null Constraints_en.srt	SRT	6.69 KB
005 Default Column Values.mp4	MP4	22.47 MB
005 Default Column Values_en.srt	SRT	5.16 KB
006 Applying a Unique Constraint to One column.mp4	MP4	43.13 MB
006 Applying a Unique Constraint to One column_en.srt	SRT	9.32 KB
007 Multi-Column Uniqueness.mp4	MP4	30.06 MB
007 Multi-Column Uniqueness_en.srt	SRT	5.54 KB
008 Adding a Validation Check.mp4	MP4	18.21 MB
008 Adding a Validation Check_en.srt	SRT	6.35 KB
009 Checks Over Multiple Columns.mp4	MP4	17.21 MB
009 Checks Over Multiple Columns_en.srt	SRT	8.04 KB
010 So Where Are We Applying Validation.mp4	MP4	22.04 MB
010 So Where Are We Applying Validation_en.srt	SRT	9.74 KB

15 - Database Structure Design Patterns

001 Approaching More Complicated Designs.mp4	MP4	11.21 MB
001 Approaching More Complicated Designs_en.srt	SRT	5.36 KB
002 Using a SQL Design Tool.mp4	MP4	47.29 MB
002 Using a SQL Design Tool_en.srt	SRT	10.01 KB
003 A Config-based Schema Designer.mp4	MP4	28.69 MB
003 A Config-based Schema Designer_en.srt	SRT	11.68 KB
004 Here's the Plan.mp4	MP4	9.63 MB
004 Here's the Plan_en.srt	SRT	4.2 KB
005 005-design.dbml	DBML	455 B
005 Rebuilding Some Schema.mp4	MP4	20.94 MB
005 Rebuilding Some Schema_en.srt	SRT	10.89 KB

16 - How to Build a 'Like' System

001 Requirements of a Like System.mp4	MP4	26.11 MB
001 Requirements of a Like System_en.srt	SRT	7.62 KB
002 How Not to Design a Like System.mp4	MP4	16.22 MB
002 How Not to Design a Like System_en.srt	SRT	4.9 KB
003 Designing a Like System.mp4	MP4	26.14 MB
003 Designing a Like System_en.srt	SRT	8.38 KB
004 Making a Reaction System Instead.mp4	MP4	6.39 MB
004 Making a Reaction System Instead_en.srt	SRT	2.55 KB
005 Polymorphic Associations.mp4	MP4	52.6 MB
005 Polymorphic Associations_en.srt	SRT	9.42 KB
006 Polymorphic Association Alternative Implementation.mp4	MP4	63.84 MB
006 Polymorphic Association Alternative Implementation_en.srt	SRT	11.14 KB
007 The Simplest Alternative.mp4	MP4	26.94 MB
007 The Simplest Alternative_en.srt	SRT	6.09 KB
008 So Which Approach.mp4	MP4	16.02 MB
008 So Which Approach_en.srt	SRT	7.11 KB

17 - How to Build a 'Mention' System

001 Additional Features Around Posts.mp4	MP4	95.79 MB
001 Additional Features Around Posts_en.srt	SRT	10.26 KB
002 Adding Captions and Locations.mp4	MP4	8.53 MB
002 Adding Captions and Locations_en.srt	SRT	2.64 KB
003 Photo Mentions vs Caption Mentions.mp4	MP4	73.41 MB
003 Photo Mentions vs Caption Mentions_en.srt	SRT	12.54 KB
004 Considerations on Photo Tags vs Caption Tags.mp4	MP4	67.08 MB
004 Considerations on Photo Tags vs Caption Tags_en.srt	SRT	11.64 KB
005 Update For Tags.mp4	MP4	23.42 MB
005 Update For Tags_en.srt	SRT	7.62 KB

18 - How to Build a 'Hashtag' System

001 Designing a Hashtag System.mp4	MP4	98.12 MB
001 Designing a Hashtag System_en.srt	SRT	11.93 KB
002 Tables for Hashtags.mp4	MP4	14.45 MB
002 Tables for Hashtags_en.srt	SRT	5.89 KB
003 Including the Hashtag Table.mp4	MP4	18.04 MB
003 Including the Hashtag Table_en.srt	SRT	5.77 KB
004 A Few More User Columns.mp4	MP4	27.66 MB
004 A Few More User Columns_en.srt	SRT	9.98 KB
005 Why No Number of Followers or Posts.mp4	MP4	17.1 MB
005 Why No Number of Followers or Posts_en.srt	SRT	6.01 KB

19 - How to Design a 'Follower' System

001 Designing a Follower System.mp4	MP4	26.49 MB
001 Designing a Follower System_en.srt	SRT	9.35 KB
GetFreeCourses.Co.url	URL	116 B
How you can help GetFreeCourses.Co.txt	TXT	182 B

20 - Implementing Database Design Patterns

001 Back to Postgres.mp4	MP4	6.84 MB
001 Back to Postgres_en.srt	SRT	3.2 KB
002 002-db.sql	SQL	375 B
002 Creating Tables with Checks.mp4	MP4	60.56 MB
002 Creating Tables with Checks_en.srt	SRT	21.37 KB
003 003-db.sql	SQL	791 B
003 Posts Creation.mp4	MP4	36.16 MB
003 Posts Creation_en.srt	SRT	12.82 KB
004 004-db.sql	SQL	1.11 KB
004 Comments Creation.mp4	MP4	7.17 MB
004 Comments Creation_en.srt	SRT	3.54 KB
005 005-db.sql	SQL	1.55 KB
005 Likes Creation.mp4	MP4	23.87 MB
005 Likes Creation_en.srt	SRT	10.52 KB
006 006-db.sql	SQL	2.19 KB
006 Photo Tags and Caption Tags.mp4	MP4	41.35 MB
006 Photo Tags and Caption Tags_en.srt	SRT	8.52 KB
007 007-db.sql	SQL	2.84 KB
007 Creating Hashtags, Hashtag Posts, and Followers.mp4	MP4	19.85 MB
007 Creating Hashtags, Hashtag Posts, and Followers_en.srt	SRT	9.4 KB

21 - Approaching and Writing Complex Queries

001 Quick Note About Adding Some Data.html	HTML	251 B
001 ig.sql	SQL	23.51 MB
002 Adding Some Data.mp4	MP4	16.95 MB
002 Adding Some Data_en.srt	SRT	6.8 KB
003 Restoring from Scratch.mp4	MP4	21.23 MB
003 Restoring from Scratch_en.srt	SRT	7.13 KB
004 Highest User ID's Exercise.mp4	MP4	7.14 MB
004 Highest User ID's Exercise_en.srt	SRT	3.16 KB
005 Solution for User ID's.mp4	MP4	4.64 MB
005 Solution for User ID's_en.srt	SRT	1.9 KB
006 Posts by a Particular User.mp4	MP4	4.81 MB
006 Posts by a Particular User_en.srt	SRT	1.76 KB
007 Solving for Posts by User.mp4	MP4	9.39 MB
007 Solving for Posts by User_en.srt	SRT	2.9 KB
008 Likes Per User.mp4	MP4	3.59 MB
008 Likes Per User_en.srt	SRT	1.29 KB
009 Solution for Likes Per User.mp4	MP4	6.6 MB
009 Solution for Likes Per User_en.srt	SRT	2.47 KB

22 - Understanding the Internals of PostgreSQL

001 Thinking About Performance.mp4	MP4	9.24 MB
001 Thinking About Performance_en.srt	SRT	3.53 KB
002 Where Does Postgres Store Data.mp4	MP4	37.02 MB
002 Where Does Postgres Store Data_en.srt	SRT	8.8 KB
003 Heaps, Blocks, and Tuples.mp4	MP4	22.73 MB
003 Heaps, Blocks, and Tuples_en.srt	SRT	5.9 KB
004 Block Data Layout.mp4	MP4	17.24 MB
004 Block Data Layout_en.srt	SRT	7.19 KB
005 Heap File Layout.mp4	MP4	597.17 MB
005 Heap File Layout_en.srt	SRT	50.58 KB

23 - A Look at Indexes for Performance

001 Full Table Scans.mp4	MP4	37.18 MB
001 Full Table Scans_en.srt	SRT	6.39 KB
002 What's an Index.mp4	MP4	10.1 MB
002 What's an Index_en.srt	SRT	3.9 KB
003 How an Index Works.mp4	MP4	69.31 MB
003 How an Index Works_en.srt	SRT	12.83 KB
004 Creating an Index.mp4	MP4	13.11 MB
004 Creating an Index_en.srt	SRT	6.55 KB
005 Benchmarking Queries.mp4	MP4	22.58 MB
005 Benchmarking Queries_en.srt	SRT	8.46 KB
006 Downsides of Indexes.mp4	MP4	31.82 MB
006 Downsides of Indexes_en.srt	SRT	7.83 KB
007 Index Types.mp4	MP4	6.46 MB
007 Index Types_en.srt	SRT	2.52 KB
008 Automatically Generated Indexes.mp4	MP4	19.74 MB
008 Automatically Generated Indexes_en.srt	SRT	5.62 KB
009 Behind the Scenes of Indexes.mp4	MP4	398.75 MB

24 - Basic Query Tuning

001 The Query Processing Pipeline.mp4	MP4	25.73 MB
001 The Query Processing Pipeline_en.srt	SRT	8.33 KB
002 Explain and Explain Analyze.mp4	MP4	42.83 MB
002 Explain and Explain Analyze_en.srt	SRT	8.39 KB
003 Solving an Explain Mystery.mp4	MP4	79.79 MB
003 Solving an Explain Mystery_en.srt	SRT	14.13 KB

25 - Advanced Query Tuning

001 Developing an Intuitive Understanding of Cost.mp4	MP4	102.89 MB
001 Developing an Intuitive Understanding of Cost_en.srt	SRT	20.13 KB
002 Calculating Cost by Hand.mp4	MP4	51.25 MB
002 Calculating Cost by Hand_en.srt	SRT	10.01 KB
003 A Touch More on Costs.mp4	MP4	95.4 MB
003 A Touch More on Costs_en.srt	SRT	11.11 KB
004 Startup vs Total Costs.mp4	MP4	44.7 MB
004 Startup vs Total Costs_en.srt	SRT	8.98 KB
005 Costs Flow Up.mp4	MP4	10.1 MB
005 Costs Flow Up_en.srt	SRT	3 KB
006 Use My Index!.mp4	MP4	39.4 MB
006 Use My Index!_en.srt	SRT	12.52 KB

26 - Simple Common Table Expressions

001 Common Table Expressions.mp4	MP4	11.19 MB
001 Common Table Expressions_en.srt	SRT	2.94 KB
002 A Quick Solution.mp4	MP4	13.16 MB
002 A Quick Solution_en.srt	SRT	5.87 KB
003 So What's a CTE.mp4	MP4	33.5 MB
003 So What's a CTE_en.srt	SRT	6.19 KB

27 - Recursive Common Table Expressions

001 Recursive CTE's.mp4	MP4	11.9 MB
002 Recursive CTE's Step by Step.mp4	MP4	62.89 MB
002 Recursive CTE's Step by Step_en.srt	SRT	16.13 KB
003 Why Use Recursive CTE's.mp4	MP4	43.14 MB
003 Why Use Recursive CTE's_en.srt	SRT	7.59 KB
004 Writing the Query.mp4	MP4	36.56 MB
004 Writing the Query_en.srt	SRT	12.49 KB
005 Walking Through Recursion.mp4	MP4	109.41 MB
005 Walking Through Recursion_en.srt	SRT	14.96 KB

28 - Simplifying Queries with Views

001 Most Popular Users.mp4	MP4	24.81 MB
001 Most Popular Users_en.srt	SRT	10.22 KB
002 A Possible Solution for Merging Tables.mp4	MP4	35.67 MB
002 A Possible Solution for Merging Tables_en.srt	SRT	6.11 KB
003 Creating a View.mp4	MP4	33.33 MB
003 Creating a View_en.srt	SRT	8.82 KB
004 When to Use a View.mp4	MP4	21.21 MB
004 When to Use a View_en.srt	SRT	5.06 KB
005 Deleting and Changing Views.mp4	MP4	12.51 MB

29 - Optimizing Queries with Materialized Views

001 Materialized Views.mp4	MP4	8.38 MB
001 Materialized Views_en.srt	SRT	3.93 KB
002 Grouping by Week.mp4	MP4	34.4 MB
002 Grouping by Week_en.srt	SRT	6.53 KB
003 Reminder on Left Joins.mp4	MP4	15.51 MB
003 Reminder on Left Joins_en.srt	SRT	7.11 KB
004 Writing a Slow Query.mp4	MP4	55.08 MB
004 Writing a Slow Query_en.srt	SRT	13.96 KB
005 Creating and Refreshing Materialized Views.mp4	MP4	36.1 MB
005 Creating and Refreshing Materialized Views_en.srt	SRT	9.74 KB
GetFreeCourses.Co.url	URL	116 B
How you can help GetFreeCourses.Co.txt	TXT	182 B

30 - Handling Concurrency and Reversibility with Transactions

001 What are Transactions Used For.mp4	MP4	22.54 MB
001 What are Transactions Used For_en.srt	SRT	6.36 KB
002 Some Sample Data.mp4	MP4	5.44 MB
002 Some Sample Data_en.srt	SRT	3.28 KB
003 Opening and Closing Transactions.mp4	MP4	65.33 MB
003 Opening and Closing Transactions_en.srt	SRT	15.13 KB
004 Transaction Cleanup on Crash.mp4	MP4	32.89 MB
005 Closing Aborted Transactions.mp4	MP4	7.47 MB
005 Closing Aborted Transactions_en.srt	SRT	2.87 KB

31 - Managing Database Design with Schema Migrations

001 A Story on Migrations.mp4	MP4	139.7 MB
001 A Story on Migrations_en.srt	SRT	28.04 KB
002 Migration Files.mp4	MP4	44.16 MB
002 Migration Files_en.srt	SRT	7.5 KB
003 Issues Solved by Migrations.mp4	MP4	10 MB
003 Issues Solved by Migrations_en.srt	SRT	4.52 KB
004 A Few Notes on Migrations Libraries.mp4	MP4	34.19 MB
004 A Few Notes on Migrations Libraries_en.srt	SRT	7.56 KB
005 A Note About Node Installation.html	HTML	264 B
006 Project Creation.mp4	MP4	9.91 MB
006 Project Creation_en.srt	SRT	4.51 KB
007 Generating and Writing Migrations.mp4	MP4	45.64 MB
007 Generating and Writing Migrations_en.srt	SRT	10.4 KB
008 Applying and Reverting Migrations.mp4	MP4	68.14 MB
008 Applying and Reverting Migrations_en.srt	SRT	11.52 KB
009 Generating and Applying a Second Migration.mp4	MP4	16.63 MB
009 Generating and Applying a Second Migration_en.srt	SRT	5.43 KB

32 - Schema vs Data Migrations

001 Schema vs Data Migrations.mp4	MP4	20.28 MB
002 Dangers Around Data Migrations.mp4	MP4	70 MB
002 Dangers Around Data Migrations_en.srt	SRT	14.78 KB
003 Properly Running Data and Schema Migrations.mp4	MP4	19.73 MB
003 Properly Running Data and Schema Migrations_en.srt	SRT	8.6 KB
004 Creating a Posts Table.mp4	MP4	21.59 MB
004 Creating a Posts Table_en.srt	SRT	7.11 KB
005 005-index.js	JS	1.32 KB
005 A Small Web Server.mp4	MP4	62.26 MB
006 Web Server Setup Instructions.html	HTML	1.02 KB
007 Adding the Loc Column.mp4	MP4	21.55 MB
007 Adding the Loc Column_en.srt	SRT	6.29 KB
008 Writing Values to Both Columns.mp4	MP4	16.26 MB
008 Writing Values to Both Columns_en.srt	SRT	6.71 KB
009 Transaction Locks.mp4	MP4	96.42 MB
009 Transaction Locks_en.srt	SRT	22.44 KB
010 Updating Values.mp4	MP4	15.27 MB
010 Updating Values_en.srt	SRT	6.43 KB
011 01-lng-lat-to-loc.js	JS	364 B
011 Migrations Setup Instructions.html	HTML	925 B
012 Updating the App Server.mp4	MP4	13.23 MB
012 Updating the App Server_en.srt	SRT	6.56 KB
013 Dropping the Last Columns.mp4	MP4	11.61 MB
013 Dropping the Last Columns_en.srt	SRT	4.65 KB

33 - Accessing PostgreSQL From API's

001 Section Goal.mp4	MP4	2.62 MB
001 Section Goal_en.srt	SRT	1.56 KB
002 Initial Setup.mp4	MP4	2.23 MB
002 Initial Setup_en.srt	SRT	2.45 KB
003 One Fast Migration.mp4	MP4	24.43 MB
004 005-access-social-repo.zip	ZIP	61.31 KB
004 Building the Users Router.mp4	MP4	29.61 MB
004 Building the Users Router_en.srt	SRT	7.07 KB
005 Understanding Connection Pools.mp4	MP4	22.93 MB
005 Understanding Connection Pools_en.srt	SRT	10.65 KB
006 Validating Connection Credentials.mp4	MP4	44.74 MB
006 Validating Connection Credentials_en.srt	SRT	10.59 KB
007 008-access.zip	ZIP	62 KB
007 Query and Close.mp4	MP4	5.9 MB
007 Query and Close_en.srt	SRT	3.18 KB

34 - Data Access Pattern - Repositories

001 The Repository Pattern.mp4	MP4	17.88 MB
001 The Repository Pattern_en.srt	SRT	5.69 KB
002 010-access.zip	ZIP	62.58 KB
002 Creating a Repository.mp4	MP4	24.78 MB
002 Creating a Repository_en.srt	SRT	12.66 KB
003 Accessing the API.mp4	MP4	23.55 MB
003 Accessing the API_en.srt	SRT	6.25 KB
004 Casing Issues.mp4	MP4	18.55 MB
004 Casing Issues_en.srt	SRT	6.88 KB
005 Fixing Casing.mp4	MP4	49.74 MB
005 Fixing Casing_en.srt	SRT	9.99 KB
006 Finding Particular Users.mp4	MP4	18.16 MB
006 Finding Particular Users_en.srt	SRT	8.38 KB

35 - Security Around PostgreSQL

001 SQL Injection Exploits.mp4	MP4	30.46 MB
001 SQL Injection Exploits_en.srt	SRT	10.71 KB
002 Handling SQL Injection with Prepared Statements.mp4	MP4	38.15 MB
002 Handling SQL Injection with Prepared Statements_en.srt	SRT	12.78 KB
003 Preventing SQL Injection.mp4	MP4	34.29 MB
003 Preventing SQL Injection_en.srt	SRT	11.96 KB
004 Reminder on Post Requests.mp4	MP4	14.4 MB
004 Reminder on Post Requests_en.srt	SRT	4.28 KB
005 019-access.zip	ZIP	63.56 KB
005 Inserting Users.mp4	MP4	15.25 MB
005 Inserting Users_en.srt	SRT	6.53 KB
006 Handling Updates.mp4	MP4	16.66 MB
006 Handling Updates_en.srt	SRT	7 KB
007 021-access.zip	ZIP	63.66 KB
007 And, Finally, Delete.mp4	MP4	18.24 MB
007 And, Finally, Delete_en.srt	SRT	6.7 KB

36 - Fast Parallel Testing

001 A Note on Testing.mp4	MP4	7.64 MB
001 A Note on Testing_en.srt	SRT	5.07 KB
002 Assertions Around User Count.mp4	MP4	42.34 MB
002 Assertions Around User Count_en.srt	SRT	11.15 KB
003 024-access.zip	ZIP	64.5 KB
003 Connecting to a DB For Tests.mp4	MP4	54.23 MB
003 Connecting to a DB For Tests_en.srt	SRT	8.19 KB
004 025-access.zip	ZIP	64.51 KB
004 Disconnecting After Tests.mp4	MP4	12.86 MB
004 Disconnecting After Tests_en.srt	SRT	4.86 KB
005 026-access.zip	ZIP	64.52 KB
005 Multi-DB Setup.mp4	MP4	21.85 MB
005 Multi-DB Setup_en.srt	SRT	7.31 KB
006 027-access.zip	ZIP	64.52 KB
006 Assumptions Around Content.mp4	MP4	33.12 MB
006 Assumptions Around Content_en.srt	SRT	8.08 KB
007 028-access.zip	ZIP	65.77 KB
007 Issues with Parallel Tests.mp4	MP4	35.76 MB
007 Issues with Parallel Tests_en.srt	SRT	8.34 KB
008 Isolation with Schemas.mp4	MP4	27.4 MB
008 Isolation with Schemas_en.srt	SRT	6.59 KB
009 Creating and Accessing Schemas.mp4	MP4	19.38 MB
009 Creating and Accessing Schemas_en.srt	SRT	8.21 KB
010 Controlling Schema Access with Search Paths.mp4	MP4	30.95 MB
010 Controlling Schema Access with Search Paths_en.srt	SRT	8.82 KB
011 Routing Schema Access.mp4	MP4	41.12 MB
011 Routing Schema Access_en.srt	SRT	6.47 KB
012 Strategy for Isolation.mp4	MP4	17.57 MB
012 Strategy for Isolation_en.srt	SRT	7.17 KB
013 034-access.zip	ZIP	66.14 KB
013 Programmatic Schema Creation.mp4	MP4	65.75 MB
013 Programmatic Schema Creation_en.srt	SRT	18.58 KB
014 035-access.zip	ZIP	66.14 KB
014 Escaping Identifiers.mp4	MP4	25.53 MB
014 Escaping Identifiers_en.srt	SRT	6.73 KB
015 036-access.zip	ZIP	66.48 KB
015 Test Helpers.mp4	MP4	43.34 MB
015 Test Helpers_en.srt	SRT	8.1 KB
016 037-access.zip	ZIP	66.59 KB
016 Cleaning up Schemas and Roles.mp4	MP4	31.28 MB
016 Cleaning up Schemas and Roles_en.srt	SRT	8.5 KB
017 Finally... Parallel Tests! (Final Lecture).mp4	MP4	18.57 MB
017 Finally... Parallel Tests! (Final Lecture)_en.srt	SRT	5.14 KB
GetFreeCourses.Co.url	URL	116 B
How you can help GetFreeCourses.Co.txt	TXT	182 B

37 - Bonus!

001 Bonus!.html

HTML

3.37 KB

Download Paid Udemy Courses For Free.url

URL

116 B

GetFreeCourses.Co.url

URL

116 B

How you can help GetFreeCourses.Co.txt

TXT

182 B

Description

									Show full description
								

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Udemy - Master Modern SQL and PostgreSQL with Vibe Coding and AI Posted by freecoursewb in Other Posted in Other 8 1.4 GB 5 months ago freecoursewb	Size 1.4 GB	Files 40	Age 5 months ago	Seeds 8	Leechs 3	Source
Introduction to Spark SQL and DataFrames Posted by freecoursewb in Other Posted in Other 0 330.4 MB 8 months ago freecoursewb	Size 330.4 MB	Files 96	Age 8 months ago	Seeds 0	Leechs 0	Source
Udemy - SQL Interview Kit (2025) - 100 + Challenges and Solutions Posted by freecoursewb in Other Posted in Other 8 2.4 GB 8 months ago freecoursewb	Size 2.4 GB	Files 0	Age 8 months ago	Seeds 8	Leechs 1	Source
Learn Modern Backend Development with Python and SQL Posted by freecoursewb in Other Posted in Other 3 1.7 GB 11 months ago freecoursewb	Size 1.7 GB	Files 52	Age 11 months ago	Seeds 3	Leechs 0	Source
Udemy - SQL and PostgreSQL - A Practical Course Posted by freecoursewb in Other Posted in Other 11 1 GB 1 year ago freecoursewb	Size 1 GB	Files 157	Age 1 year ago	Seeds 11	Leechs 2	Source

SQL and PostgreSQL: The Complete Developer's Guide

Torrent Contents Size: 7.87 GB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags

Tracker name
udp://tracker.coppersurfer.tk:6969/announce
udp://9.rarbg.me:2850/announce
udp://9.rarbg.to:2920/announce
udp://tracker.opentrackr.org:1337
udp://tracker.leechers-paradise.org:6969/announce