资源详情

返回首页 | 相关搜索
Udemy - SQL and PostgreSQL The Complete Developer's Guide (7.2024)
大小 5 GB
文件数 653
Info Hash: 73797D8952AE59CADE265E637102DC7EA45AEA94
收录时间 2025-12-16 11:11:22
更新时间 2025-12-19 00:48:15
文件列表 (653)
01 - Simple - But Powerful - SQL Statements/001 Join Our Community!.html
318 B
01 - Simple - But Powerful - SQL Statements/002 Course Resources.html
1.25 KB
01 - Simple - But Powerful - SQL Statements/002 diagrams.zip
7.72 MB
01 - Simple - But Powerful - SQL Statements/003 What is PostgreSQL All About.mp4
21.75 MB
01 - Simple - But Powerful - SQL Statements/003 What is PostgreSQL All About.srt
7.25 KB
01 - Simple - But Powerful - SQL Statements/004 Database Design.mp4
35.37 MB
01 - Simple - But Powerful - SQL Statements/004 Database Design.srt
8.21 KB
01 - Simple - But Powerful - SQL Statements/005 Database Terminology.html
10.1 KB
01 - Simple - But Powerful - SQL Statements/006 003-sql.sql
104 B
01 - Simple - But Powerful - SQL Statements/006 Creating Tables.mp4
18.61 MB
01 - Simple - But Powerful - SQL Statements/006 Creating Tables.srt
7.67 KB
01 - Simple - But Powerful - SQL Statements/007 Analyzing CREATE TABLE.mp4
11.38 MB
01 - Simple - But Powerful - SQL Statements/007 Analyzing CREATE TABLE.srt
5.54 KB
01 - Simple - But Powerful - SQL Statements/008 005-sql-cumulative.sql
384 B
01 - Simple - But Powerful - SQL Statements/008 005-sql.sql
278 B
01 - Simple - But Powerful - SQL Statements/008 Inserting Data Into a Table.mp4
12.12 MB
01 - Simple - But Powerful - SQL Statements/008 Inserting Data Into a Table.srt
7.59 KB
01 - Simple - But Powerful - SQL Statements/009 Retrieving Data with Select.mp4
4.05 MB
01 - Simple - But Powerful - SQL Statements/009 Retrieving Data with Select.srt
3.45 KB
01 - Simple - But Powerful - SQL Statements/010 Create, Insert, and Select!.html
4.45 KB
01 - Simple - But Powerful - SQL Statements/011 Calculated Columns.mp4
10.37 MB
01 - Simple - But Powerful - SQL Statements/011 Calculated Columns.srt
7.23 KB
01 - Simple - But Powerful - SQL Statements/012 Calculating Phone Revenue.mp4
2.19 MB
01 - Simple - But Powerful - SQL Statements/012 Calculating Phone Revenue.srt
1.58 KB
01 - Simple - But Powerful - SQL Statements/013 Using Calculated Columns.html
5.35 KB
01 - Simple - But Powerful - SQL Statements/014 Exercise Solution.mp4
2.17 MB
01 - Simple - But Powerful - SQL Statements/014 Exercise Solution.srt
1.62 KB
01 - Simple - But Powerful - SQL Statements/015 012-sql.sql
404 B
01 - Simple - But Powerful - SQL Statements/015 String Operators and Functions.mp4
11.34 MB
01 - Simple - But Powerful - SQL Statements/015 String Operators and Functions.srt
10.17 KB
02 - Filtering Records/001 013-sql.sql
48 B
02 - Filtering Records/001 Filtering Rows with Where.mp4
8.42 MB
02 - Filtering Records/001 Filtering Rows with Where.srt
6 KB
02 - Filtering Records/002 More on the Where Keyword.mp4
6 MB
02 - Filtering Records/002 More on the Where Keyword.srt
3.79 KB
02 - Filtering Records/003 Compound Where Clauses.mp4
12.76 MB
02 - Filtering Records/003 Compound Where Clauses.srt
7.57 KB
02 - Filtering Records/004 A Where Exercise Overview.mp4
1.22 MB
02 - Filtering Records/004 A Where Exercise Overview.srt
946 B
02 - Filtering Records/005 Practicing Where Statements.html
5.07 KB
02 - Filtering Records/006 A Where Solution.mp4
1.89 MB
02 - Filtering Records/006 A Where Solution.srt
1.52 KB
02 - Filtering Records/007 Where With Lists.mp4
1.12 MB
02 - Filtering Records/007 Where With Lists.srt
1.07 KB
02 - Filtering Records/008 A More Challenging 'Where'.html
5.12 KB
02 - Filtering Records/009 A Where With Lists Solution.mp4
3.56 MB
02 - Filtering Records/009 A Where With Lists Solution.srt
2.49 KB
02 - Filtering Records/010 Calculations in Where Clauses.mp4
3.41 MB
02 - Filtering Records/010 Calculations in Where Clauses.srt
3.02 KB
02 - Filtering Records/011 Trying Calculations in Where Clauses.html
5.66 KB
02 - Filtering Records/012 Solving Calculations.mp4
4.15 MB
02 - Filtering Records/012 Solving Calculations.srt
2.95 KB
02 - Filtering Records/013 Updating Rows.mp4
11.71 MB
02 - Filtering Records/013 Updating Rows.srt
6.32 KB
02 - Filtering Records/014 Deleting Rows.mp4
7.51 MB
02 - Filtering Records/014 Deleting Rows.srt
5.25 KB
02 - Filtering Records/015 Try Updating Records In a Table!.html
5.25 KB
02 - Filtering Records/016 A Solution for Updating Rows.mp4
3.42 MB
02 - Filtering Records/016 A Solution for Updating Rows.srt
1.98 KB
02 - Filtering Records/017 Practice Deleting Records.html
5.22 KB
02 - Filtering Records/018 Solution for Deleting Rows.mp4
2.76 MB
02 - Filtering Records/018 Solution for Deleting Rows.srt
2.27 KB
03 - Working with Tables/001 The Plan Moving Forward.mp4
7.09 MB
03 - Working with Tables/001 The Plan Moving Forward.srt
2.75 KB
03 - Working with Tables/002 Approaching Database Design.mp4
30.48 MB
03 - Working with Tables/002 Approaching Database Design.srt
11.79 KB
03 - Working with Tables/003 Let's Design Some Schema.html
10.53 KB
03 - Working with Tables/004 One-to-Many and Many-to-One Relationships.mp4
26.25 MB
03 - Working with Tables/004 One-to-Many and Many-to-One Relationships.srt
10.13 KB
03 - Working with Tables/005 A 'Has One' or 'Has Many'.html
13.12 KB
03 - Working with Tables/006 One-to-One and Many-to-Many Relationships.mp4
15.28 MB
03 - Working with Tables/006 One-to-One and Many-to-Many Relationships.srt
8.83 KB
03 - Working with Tables/007 Identifying One-to-One and Many-to-Many Relationships.html
11.52 KB
03 - Working with Tables/008 Primary Keys and Foreign Keys.mp4
18.82 MB
03 - Working with Tables/008 Primary Keys and Foreign Keys.srt
7.95 KB
03 - Working with Tables/009 Understanding Foreign Keys.mp4
41.56 MB
03 - Working with Tables/009 Understanding Foreign Keys.srt
12.99 KB
03 - Working with Tables/010 Foreign Keys; How Do They Work.html
13.55 KB
03 - Working with Tables/011 007-tables-cumulative.sql
172 B
03 - Working with Tables/011 007-tables.sql
194 B
03 - Working with Tables/011 Auto-Generated ID's.mp4
14.64 MB
03 - Working with Tables/011 Auto-Generated ID's.srt
9.15 KB
03 - Working with Tables/012 008-tables-cumulative.sql
348 B
03 - Working with Tables/012 008-tables.sql
197 B
03 - Working with Tables/012 Creating Foreign Key Columns.mp4
11.99 MB
03 - Working with Tables/012 Creating Foreign Key Columns.srt
7.61 KB
03 - Working with Tables/013 009-tables-cumulative.sql
536 B
03 - Working with Tables/013 009-tables.sql
326 B
03 - Working with Tables/013 Running Queries on Associated Data.mp4
24.51 MB
03 - Working with Tables/013 Running Queries on Associated Data.srt
10.61 KB
03 - Working with Tables/014 Exercise Overview.mp4
5.34 MB
03 - Working with Tables/014 Exercise Overview.srt
3.26 KB
03 - Working with Tables/015 Creating and Using Foreign Keys.html
4.97 KB
03 - Working with Tables/016 Foreign Key Creation Solution.mp4
5.39 MB
03 - Working with Tables/016 Foreign Key Creation Solution.srt
3.14 KB
03 - Working with Tables/017 012-tables-cumulative.sql
600 B
03 - Working with Tables/017 012-tables.sql
199 B
03 - Working with Tables/017 Foreign Key Constraints Around Insertion.mp4
14.99 MB
03 - Working with Tables/017 Foreign Key Constraints Around Insertion.srt
8.72 KB
03 - Working with Tables/018 Constraints Around Deletion.mp4
25.98 MB
03 - Working with Tables/018 Constraints Around Deletion.srt
7.76 KB
03 - Working with Tables/019 Commands You’ll Need for the Next Video.html
691 B
03 - Working with Tables/020 014-tables-cumulative.sql
994 B
03 - Working with Tables/020 014-tables.sql
469 B
03 - Working with Tables/020 Testing Deletion Constraints.mp4
12.46 MB
03 - Working with Tables/020 Testing Deletion Constraints.srt
7.09 KB
03 - Working with Tables/021 015-tables-cumulative.sql
1.28 KB
03 - Working with Tables/021 015-tables.sql
340 B
03 - Working with Tables/021 Setting Foreign Keys to Null on Delete.mp4
8.26 MB
03 - Working with Tables/021 Setting Foreign Keys to Null on Delete.srt
4.59 KB
03 - Working with Tables/022 What Happens On Delete.html
11.04 KB
03 - Working with Tables/023 Adding Some Complexity.mp4
6.78 MB
03 - Working with Tables/023 Adding Some Complexity.srt
4.75 KB
04 - Relating Records with Joins/001 Adding Some Data.html
7.66 KB
04 - Relating Records with Joins/002 Queries with Joins and Aggregations.mp4
17.78 MB
04 - Relating Records with Joins/002 Queries with Joins and Aggregations.srt
5.26 KB
04 - Relating Records with Joins/003 Joining Data from Different Tables.mp4
23.74 MB
04 - Relating Records with Joins/003 Joining Data from Different Tables.srt
11.65 KB
04 - Relating Records with Joins/004 Another Quick Join.mp4
5.62 MB
04 - Relating Records with Joins/004 Another Quick Join.srt
3.38 KB
04 - Relating Records with Joins/005 Exercise Overview.mp4
3.09 MB
04 - Relating Records with Joins/005 Exercise Overview.srt
1.84 KB
04 - Relating Records with Joins/006 Practice Joining Data.html
5.29 KB
04 - Relating Records with Joins/007 A Joinful Solution.mp4
3.47 MB
04 - Relating Records with Joins/007 A Joinful Solution.srt
2.74 KB
04 - Relating Records with Joins/008 Alternate Forms of Syntax.mp4
16.28 MB
04 - Relating Records with Joins/008 Alternate Forms of Syntax.srt
9.32 KB
04 - Relating Records with Joins/009 007-joins-cumulative.sql
7.54 KB
04 - Relating Records with Joins/009 Missing Data in Joins.mp4
19.08 MB
04 - Relating Records with Joins/009 Missing Data in Joins.srt
10.03 KB
04 - Relating Records with Joins/010 Why Wasn't It Included.mp4
14.99 MB
04 - Relating Records with Joins/010 Why Wasn't It Included.srt
3.84 KB
04 - Relating Records with Joins/011 009-joins-cheatsheet.pdf
190.52 KB
04 - Relating Records with Joins/011 Four Kinds of Joins.mp4
75.16 MB
04 - Relating Records with Joins/011 Four Kinds of Joins.srt
15.17 KB
04 - Relating Records with Joins/012 010-sql-cumulative.sql
7.59 KB
04 - Relating Records with Joins/012 Each Join in Practice.mp4
23.44 MB
04 - Relating Records with Joins/012 Each Join in Practice.srt
6.76 KB
04 - Relating Records with Joins/013 Does Order Matter.mp4
35.92 MB
04 - Relating Records with Joins/013 Does Order Matter.srt
6.38 KB
04 - Relating Records with Joins/014 Test Your Joining Knowledge.html
21.15 KB
04 - Relating Records with Joins/015 Exercise Overview.mp4
1.53 MB
04 - Relating Records with Joins/015 Exercise Overview.srt
1.54 KB
04 - Relating Records with Joins/016 Joins, Joins, Join!.html
5.11 KB
04 - Relating Records with Joins/017 Two Possible Solutions.mp4
10.19 MB
04 - Relating Records with Joins/017 Two Possible Solutions.srt
4.82 KB
04 - Relating Records with Joins/018 Where with Join.mp4
20.21 MB
04 - Relating Records with Joins/018 Where with Join.srt
10.6 KB
04 - Relating Records with Joins/019 Three Way Joins.mp4
32.08 MB
04 - Relating Records with Joins/019 Three Way Joins.srt
12.2 KB
04 - Relating Records with Joins/020 A Bit of Practice.mp4
11.53 MB
04 - Relating Records with Joins/020 A Bit of Practice.srt
7.81 KB
04 - Relating Records with Joins/021 Three Way Exercise.html
5.73 KB
04 - Relating Records with Joins/022 Exercise Solution.mp4
5.44 MB
04 - Relating Records with Joins/022 Exercise Solution.srt
4.31 KB
05 - Aggregation of Records/001 Aggregating and Grouping.mp4
5.34 MB
05 - Aggregation of Records/001 Aggregating and Grouping.srt
3.58 KB
05 - Aggregation of Records/002 Picturing Group By.mp4
19.13 MB
05 - Aggregation of Records/002 Picturing Group By.srt
8.28 KB
05 - Aggregation of Records/003 Selecting Columns After Grouping.html
11.77 KB
05 - Aggregation of Records/004 Aggregate Functions.mp4
7.62 MB
05 - Aggregation of Records/004 Aggregate Functions.srt
4.61 KB
05 - Aggregation of Records/005 Combining Group By and Aggregates.mp4
10.24 MB
05 - Aggregation of Records/005 Combining Group By and Aggregates.srt
7.06 KB
05 - Aggregation of Records/006 A Gotcha with Count.mp4
3.99 MB
05 - Aggregation of Records/006 A Gotcha with Count.srt
4.21 KB
05 - Aggregation of Records/007 Visualizing More Grouping.mp4
6.72 MB
05 - Aggregation of Records/007 Visualizing More Grouping.srt
4.67 KB
05 - Aggregation of Records/008 Exercise Overview.mp4
1.14 MB
05 - Aggregation of Records/008 Exercise Overview.srt
1.2 KB
05 - Aggregation of Records/009 Practice For Grouping and Aggregating.html
5.31 KB
05 - Aggregation of Records/010 Grouping Solution.mp4
2.23 MB
05 - Aggregation of Records/010 Grouping Solution.srt
2.21 KB
05 - Aggregation of Records/011 Adding a Layer of Difficulty.mp4
1.19 MB
05 - Aggregation of Records/011 Adding a Layer of Difficulty.srt
1.12 KB
05 - Aggregation of Records/012 Grouping With a Join!.html
5.42 KB
05 - Aggregation of Records/013 Solution.mp4
2.59 MB
05 - Aggregation of Records/013 Solution.srt
2.44 KB
05 - Aggregation of Records/014 Filtering Groups with Having.mp4
23.9 MB
05 - Aggregation of Records/014 Filtering Groups with Having.srt
7.76 KB
05 - Aggregation of Records/015 Having In Action.mp4
4.69 MB
05 - Aggregation of Records/015 Having In Action.srt
4.11 KB
05 - Aggregation of Records/016 More on Having!.mp4
18.57 MB
05 - Aggregation of Records/016 More on Having!.srt
11.04 KB
05 - Aggregation of Records/017 A Having Exercise Overview.mp4
8.4 MB
05 - Aggregation of Records/017 A Having Exercise Overview.srt
5.53 KB
05 - Aggregation of Records/018 Practice Yourself Some Having.html
5.54 KB
05 - Aggregation of Records/019 A Quick Solution.mp4
5.19 MB
05 - Aggregation of Records/019 A Quick Solution.srt
3.79 KB
06 - Working with Large Datasets/001 A New Dataset.html
17.84 KB
06 - Working with Large Datasets/002 001-sq-data.sql
15.82 KB
06 - Working with Large Datasets/002 Investigating This Dataset.mp4
5.42 MB
06 - Working with Large Datasets/002 Investigating This Dataset.srt
3.99 KB
06 - Working with Large Datasets/003 Some Group By Practice.mp4
2.09 MB
06 - Working with Large Datasets/003 Some Group By Practice.srt
2.05 KB
06 - Working with Large Datasets/004 Group By Review.html
5.1 KB
06 - Working with Large Datasets/005 Group By Review Solution.mp4
5.32 MB
06 - Working with Large Datasets/005 Group By Review Solution.srt
3.71 KB
06 - Working with Large Datasets/006 Remember Joins.mp4
5.97 MB
06 - Working with Large Datasets/006 Remember Joins.srt
3.66 KB
06 - Working with Large Datasets/007 Inner Join Review.html
5.85 KB
06 - Working with Large Datasets/008 Of Course You Remember!.mp4
3.02 MB
06 - Working with Large Datasets/008 Of Course You Remember!.srt
2.21 KB
07 - Sorting Records/001 The Basics of Sorting.mp4
4.64 MB
07 - Sorting Records/001 The Basics of Sorting.srt
3.69 KB
07 - Sorting Records/002 Two Variations on Sorting.mp4
6.28 MB
07 - Sorting Records/002 Two Variations on Sorting.srt
4.19 KB
07 - Sorting Records/003 Offset and Limit.mp4
13.21 MB
07 - Sorting Records/003 Offset and Limit.srt
10.15 KB
07 - Sorting Records/004 Exercise Overview.mp4
811.13 KB
07 - Sorting Records/004 Exercise Overview.srt
688 B
07 - Sorting Records/005 Sorting, Offsetting, and Limiting.html
4.98 KB
07 - Sorting Records/006 Exercise Solution.mp4
2.41 MB
07 - Sorting Records/006 Exercise Solution.srt
2.14 KB
08 - Unions and Intersections with Sets/001 Handling Sets with Union.mp4
13 MB
08 - Unions and Intersections with Sets/001 Handling Sets with Union.srt
8.99 KB
08 - Unions and Intersections with Sets/002 A Few Notes on Union.mp4
10.82 MB
08 - Unions and Intersections with Sets/002 A Few Notes on Union.srt
5.85 KB
08 - Unions and Intersections with Sets/003 Commonalities with Intersect.mp4
10.13 MB
08 - Unions and Intersections with Sets/003 Commonalities with Intersect.srt
5.05 KB
08 - Unions and Intersections with Sets/004 Removing Commonalities with Except.mp4
13.67 MB
08 - Unions and Intersections with Sets/004 Removing Commonalities with Except.srt
9.47 KB
08 - Unions and Intersections with Sets/005 Union Exercise Overview.mp4
2.97 MB
08 - Unions and Intersections with Sets/005 Union Exercise Overview.srt
2.13 KB
08 - Unions and Intersections with Sets/006 Merging Results with Union.html
5.56 KB
08 - Unions and Intersections with Sets/007 Exercise Solution.mp4
3.25 MB
08 - Unions and Intersections with Sets/007 Exercise Solution.srt
2.15 KB
09 - Assembling Queries with SubQueries/001 What's a Subquery.mp4
19.42 MB
09 - Assembling Queries with SubQueries/001 What's a Subquery.srt
8.58 KB
09 - Assembling Queries with SubQueries/002 Thinking About the Structure of Data.mp4
15.19 MB
09 - Assembling Queries with SubQueries/002 Thinking About the Structure of Data.srt
7.54 KB
09 - Assembling Queries with SubQueries/003 What's the Data Look Like.html
11.89 KB
09 - Assembling Queries with SubQueries/004 Subqueries in a Select.mp4
15.15 MB
09 - Assembling Queries with SubQueries/004 Subqueries in a Select.srt
8.52 KB
09 - Assembling Queries with SubQueries/005 Exercise Overview.mp4
2.1 MB
09 - Assembling Queries with SubQueries/005 Exercise Overview.srt
1.74 KB
09 - Assembling Queries with SubQueries/006 Embedding in Select.html
5.6 KB
09 - Assembling Queries with SubQueries/007 Select Solution.mp4
2.62 MB
09 - Assembling Queries with SubQueries/007 Select Solution.srt
1.94 KB
09 - Assembling Queries with SubQueries/008 Subqueries in a From.mp4
28.32 MB
09 - Assembling Queries with SubQueries/008 Subqueries in a From.srt
12.26 KB
09 - Assembling Queries with SubQueries/009 From Subqueries that Return a Value.mp4
6.11 MB
09 - Assembling Queries with SubQueries/009 From Subqueries that Return a Value.srt
4.27 KB
09 - Assembling Queries with SubQueries/010 Example of a Subquery in a From.mp4
34.37 MB
09 - Assembling Queries with SubQueries/010 Example of a Subquery in a From.srt
13.93 KB
09 - Assembling Queries with SubQueries/011 Exercise Overview.mp4
2.4 MB
09 - Assembling Queries with SubQueries/011 Exercise Overview.srt
1.78 KB
09 - Assembling Queries with SubQueries/012 Subquery From's.html
5.1 KB
09 - Assembling Queries with SubQueries/013 Exercise Solution.mp4
6.56 MB
09 - Assembling Queries with SubQueries/013 Exercise Solution.srt
2.77 KB
09 - Assembling Queries with SubQueries/014 Subqueries in a Join Clause.mp4
10.84 MB
09 - Assembling Queries with SubQueries/014 Subqueries in a Join Clause.srt
7.03 KB
09 - Assembling Queries with SubQueries/015 More Useful - Subqueries with Where.mp4
23.88 MB
09 - Assembling Queries with SubQueries/015 More Useful - Subqueries with Where.srt
13.87 KB
09 - Assembling Queries with SubQueries/016 Data Structure with Where Subqueries.mp4
27.68 MB
09 - Assembling Queries with SubQueries/016 Data Structure with Where Subqueries.srt
9 KB
09 - Assembling Queries with SubQueries/017 Exercise Overview.mp4
1.9 MB
09 - Assembling Queries with SubQueries/017 Exercise Overview.srt
1.53 KB
09 - Assembling Queries with SubQueries/018 Subquery Where's.html
5.11 KB
09 - Assembling Queries with SubQueries/019 Exercise Solution.mp4
4.45 MB
09 - Assembling Queries with SubQueries/019 Exercise Solution.srt
3.14 KB
09 - Assembling Queries with SubQueries/020 The Not In Operator with a List.mp4
23.45 MB
09 - Assembling Queries with SubQueries/020 The Not In Operator with a List.srt
6.35 KB
09 - Assembling Queries with SubQueries/021 A New Where Operator.mp4
24.2 MB
09 - Assembling Queries with SubQueries/021 A New Where Operator.srt
10.05 KB
09 - Assembling Queries with SubQueries/022 Finally Some!.mp4
20.48 MB
09 - Assembling Queries with SubQueries/022 Finally Some!.srt
7.93 KB
09 - Assembling Queries with SubQueries/023 Is It A Valid Subquery.html
16.23 KB
09 - Assembling Queries with SubQueries/024 Exercise Overview.mp4
853.67 KB
09 - Assembling Queries with SubQueries/024 Exercise Overview.srt
746 B
09 - Assembling Queries with SubQueries/025 Practice Your Subqueries!.html
5.09 KB
09 - Assembling Queries with SubQueries/026 A Quick Solution.mp4
3.06 MB
09 - Assembling Queries with SubQueries/026 A Quick Solution.srt
2.42 KB
09 - Assembling Queries with SubQueries/027 Probably Too Much About Correlated Subqueries.mp4
66.89 MB
09 - Assembling Queries with SubQueries/027 Probably Too Much About Correlated Subqueries.srt
26.28 KB
09 - Assembling Queries with SubQueries/028 More on Correlated Subqueries.mp4
27.85 MB
09 - Assembling Queries with SubQueries/028 More on Correlated Subqueries.srt
13.74 KB
09 - Assembling Queries with SubQueries/029 A Select Without a From.mp4
6.44 MB
09 - Assembling Queries with SubQueries/029 A Select Without a From.srt
5.2 KB
09 - Assembling Queries with SubQueries/030 Exercise Overview.mp4
1.37 MB
09 - Assembling Queries with SubQueries/030 Exercise Overview.srt
1.26 KB
09 - Assembling Queries with SubQueries/031 From-less Selects.html
5.5 KB
09 - Assembling Queries with SubQueries/032 Exercise Solution.mp4
2.53 MB
09 - Assembling Queries with SubQueries/032 Exercise Solution.srt
1.9 KB
10 - Selecting Distinct Records/001 Selecting Distinct Values.mp4
8.43 MB
10 - Selecting Distinct Records/001 Selecting Distinct Values.srt
6.58 KB
10 - Selecting Distinct Records/002 Exercise Overview.mp4
961.13 KB
10 - Selecting Distinct Records/002 Exercise Overview.srt
879 B
10 - Selecting Distinct Records/003 Some Practice with Distinct.html
4.94 KB
10 - Selecting Distinct Records/004 A Distinct Solution.mp4
1.36 MB
10 - Selecting Distinct Records/004 A Distinct Solution.srt
1006 B
11 - Utility Operators, Keywords, and Functions/001 The Greatest Value in a List.mp4
7.87 MB
11 - Utility Operators, Keywords, and Functions/001 The Greatest Value in a List.srt
5.13 KB
11 - Utility Operators, Keywords, and Functions/002 And the Least Value in a List!.mp4
3.76 MB
11 - Utility Operators, Keywords, and Functions/002 And the Least Value in a List!.srt
3.14 KB
11 - Utility Operators, Keywords, and Functions/003 The Case Keyword.mp4
19.04 MB
11 - Utility Operators, Keywords, and Functions/003 The Case Keyword.srt
6.91 KB
12 - Local PostgreSQL Installation/001 PostgreSQL Installation on macOS.mp4
14.14 MB
12 - Local PostgreSQL Installation/001 PostgreSQL Installation on macOS.srt
9.83 KB
12 - Local PostgreSQL Installation/002 pgAdmin Setup on macOS.mp4
11.19 MB
12 - Local PostgreSQL Installation/002 pgAdmin Setup on macOS.srt
8.01 KB
12 - Local PostgreSQL Installation/003 Postgres installation on Windows.mp4
13.77 MB
12 - Local PostgreSQL Installation/003 Postgres installation on Windows.srt
6.75 KB
13 - PostgreSQL Complex Datatypes/001 What'd We Just Do.mp4
12.38 MB
13 - PostgreSQL Complex Datatypes/001 What'd We Just Do.srt
6.45 KB
13 - PostgreSQL Complex Datatypes/002 Data Types.mp4
19.71 MB
13 - PostgreSQL Complex Datatypes/002 Data Types.srt
7.02 KB
13 - PostgreSQL Complex Datatypes/003 Fast Rules on Numeric Data Types.mp4
11.96 MB
13 - PostgreSQL Complex Datatypes/003 Fast Rules on Numeric Data Types.srt
3.6 KB
13 - PostgreSQL Complex Datatypes/004 More on Number Data Types.mp4
30.51 MB
13 - PostgreSQL Complex Datatypes/004 More on Number Data Types.srt
15.2 KB
13 - PostgreSQL Complex Datatypes/005 Reminder on Character Types.mp4
19.13 MB
13 - PostgreSQL Complex Datatypes/005 Reminder on Character Types.srt
7.83 KB
13 - PostgreSQL Complex Datatypes/006 Boolean Data Types.mp4
5.43 MB
13 - PostgreSQL Complex Datatypes/006 Boolean Data Types.srt
4.37 KB
13 - PostgreSQL Complex Datatypes/007 Times, Dates, and Timestamps.mp4
14.29 MB
13 - PostgreSQL Complex Datatypes/007 Times, Dates, and Timestamps.srt
8.48 KB
13 - PostgreSQL Complex Datatypes/008 Really Awesome Intervals.mp4
13.48 MB
13 - PostgreSQL Complex Datatypes/008 Really Awesome Intervals.srt
9.12 KB
14 - Database-Side Validation and Constraints/001 Thinking About Validation.mp4
22.22 MB
14 - Database-Side Validation and Constraints/001 Thinking About Validation.srt
6.7 KB
14 - Database-Side Validation and Constraints/002 Creating and Viewing Tables in PGAdmin.mp4
18.55 MB
14 - Database-Side Validation and Constraints/002 Creating and Viewing Tables in PGAdmin.srt
11.63 KB
14 - Database-Side Validation and Constraints/003 Applying a Null Constraint.mp4
14.08 MB
14 - Database-Side Validation and Constraints/003 Applying a Null Constraint.srt
10.38 KB
14 - Database-Side Validation and Constraints/004 Solving a Gotcha with Null Constraints.mp4
9.1 MB
14 - Database-Side Validation and Constraints/004 Solving a Gotcha with Null Constraints.srt
6.69 KB
14 - Database-Side Validation and Constraints/005 Creating NULL Constraints.html
10.2 KB
14 - Database-Side Validation and Constraints/006 Default Column Values.mp4
14.32 MB
14 - Database-Side Validation and Constraints/006 Default Column Values.srt
5.16 KB
14 - Database-Side Validation and Constraints/007 Applying a Unique Constraint to One column.mp4
26.77 MB
14 - Database-Side Validation and Constraints/007 Applying a Unique Constraint to One column.srt
9.32 KB
14 - Database-Side Validation and Constraints/008 Multi-Column Uniqueness.mp4
18.37 MB
14 - Database-Side Validation and Constraints/008 Multi-Column Uniqueness.srt
5.54 KB
14 - Database-Side Validation and Constraints/009 Is It Unique.html
10.26 KB
14 - Database-Side Validation and Constraints/010 Adding a Validation Check.mp4
11.7 MB
14 - Database-Side Validation and Constraints/010 Adding a Validation Check.srt
6.35 KB
14 - Database-Side Validation and Constraints/011 Checks Over Multiple Columns.mp4
11.57 MB
14 - Database-Side Validation and Constraints/011 Checks Over Multiple Columns.srt
8.04 KB
14 - Database-Side Validation and Constraints/012 Does It Pass a Check.html
9.23 KB
14 - Database-Side Validation and Constraints/013 So Where Are We Applying Validation.mp4
14.54 MB
14 - Database-Side Validation and Constraints/013 So Where Are We Applying Validation.srt
9.74 KB
15 - Database Structure Design Patterns/001 Approaching More Complicated Designs.mp4
7.66 MB
15 - Database Structure Design Patterns/001 Approaching More Complicated Designs.srt
5.36 KB
15 - Database Structure Design Patterns/002 Using a SQL Design Tool.mp4
32.43 MB
15 - Database Structure Design Patterns/002 Using a SQL Design Tool.srt
10.01 KB
15 - Database Structure Design Patterns/003 A Config-based Schema Designer.mp4
19.25 MB
15 - Database Structure Design Patterns/003 A Config-based Schema Designer.srt
11.68 KB
15 - Database Structure Design Patterns/004 Here's the Plan.mp4
5.9 MB
15 - Database Structure Design Patterns/004 Here's the Plan.srt
4.2 KB
15 - Database Structure Design Patterns/005 005-design.dbml
455 B
15 - Database Structure Design Patterns/005 Rebuilding Some Schema.mp4
14.12 MB
15 - Database Structure Design Patterns/005 Rebuilding Some Schema.srt
10.89 KB
16 - How to Build a 'Like' System/001 Requirements of a Like System.mp4
16.24 MB
16 - How to Build a 'Like' System/001 Requirements of a Like System.srt
7.62 KB
16 - How to Build a 'Like' System/002 How Not to Design a Like System.mp4
10.26 MB
16 - How to Build a 'Like' System/002 How Not to Design a Like System.srt
4.9 KB
16 - How to Build a 'Like' System/003 Designing a Like System.mp4
16.81 MB
16 - How to Build a 'Like' System/003 Designing a Like System.srt
8.38 KB
16 - How to Build a 'Like' System/004 Building a Similar System.html
10.02 KB
16 - How to Build a 'Like' System/005 Making a Reaction System Instead.mp4
4.12 MB
16 - How to Build a 'Like' System/005 Making a Reaction System Instead.srt
2.55 KB
16 - How to Build a 'Like' System/006 Polymorphic Associations.mp4
33.43 MB
16 - How to Build a 'Like' System/006 Polymorphic Associations.srt
9.42 KB
16 - How to Build a 'Like' System/007 Polymorphic Association Alternative Implementation.mp4
39.49 MB
16 - How to Build a 'Like' System/007 Polymorphic Association Alternative Implementation.srt
11.14 KB
16 - How to Build a 'Like' System/008 The Simplest Alternative.mp4
17.4 MB
16 - How to Build a 'Like' System/008 The Simplest Alternative.srt
6.09 KB
16 - How to Build a 'Like' System/009 Polymorphic Associations.html
12.64 KB
16 - How to Build a 'Like' System/010 So Which Approach.mp4
10.46 MB
16 - How to Build a 'Like' System/010 So Which Approach.srt
7.11 KB
17 - How to Build a 'Mention' System/001 Additional Features Around Posts.mp4
54.04 MB
17 - How to Build a 'Mention' System/001 Additional Features Around Posts.srt
10.26 KB
17 - How to Build a 'Mention' System/002 Adding Captions and Locations.mp4
5.36 MB
17 - How to Build a 'Mention' System/002 Adding Captions and Locations.srt
2.64 KB
17 - How to Build a 'Mention' System/003 Photo Mentions vs Caption Mentions.mp4
44.21 MB
17 - How to Build a 'Mention' System/003 Photo Mentions vs Caption Mentions.srt
12.54 KB
17 - How to Build a 'Mention' System/004 Considerations on Photo Tags vs Caption Tags.mp4
42.88 MB
17 - How to Build a 'Mention' System/004 Considerations on Photo Tags vs Caption Tags.srt
11.64 KB
17 - How to Build a 'Mention' System/005 Update For Tags.mp4
14.97 MB
17 - How to Build a 'Mention' System/005 Update For Tags.srt
7.62 KB
18 - How to Build a 'Hashtag' System/001 Designing a Hashtag System.mp4
60.55 MB
18 - How to Build a 'Hashtag' System/001 Designing a Hashtag System.srt
11.93 KB
18 - How to Build a 'Hashtag' System/002 Tables for Hashtags.mp4
10.02 MB
18 - How to Build a 'Hashtag' System/002 Tables for Hashtags.srt
5.89 KB
18 - How to Build a 'Hashtag' System/003 Including the Hashtag Table.mp4
11.58 MB
18 - How to Build a 'Hashtag' System/003 Including the Hashtag Table.srt
5.77 KB
18 - How to Build a 'Hashtag' System/004 A Few More User Columns.mp4
16.86 MB
18 - How to Build a 'Hashtag' System/004 A Few More User Columns.srt
9.98 KB
18 - How to Build a 'Hashtag' System/005 Why No Number of Followers or Posts.mp4
10.44 MB
18 - How to Build a 'Hashtag' System/005 Why No Number of Followers or Posts.srt
6.01 KB
19 - How to Design a 'Follower' System/001 Designing a Follower System.mp4
17.21 MB
19 - How to Design a 'Follower' System/001 Designing a Follower System.srt
9.35 KB
20 - Implementing Database Design Patterns/001 Back to Postgres.mp4
4.42 MB
20 - Implementing Database Design Patterns/001 Back to Postgres.srt
3.2 KB
20 - Implementing Database Design Patterns/002 002-db.sql
375 B
20 - Implementing Database Design Patterns/002 Creating Tables with Checks.mp4
40.1 MB
20 - Implementing Database Design Patterns/002 Creating Tables with Checks.srt
21.37 KB
20 - Implementing Database Design Patterns/003 003-db.sql
791 B
20 - Implementing Database Design Patterns/003 Posts Creation.mp4
24.3 MB
20 - Implementing Database Design Patterns/003 Posts Creation.srt
12.82 KB
20 - Implementing Database Design Patterns/004 004-db.sql
1.11 KB
20 - Implementing Database Design Patterns/004 Comments Creation.mp4
4.93 MB
20 - Implementing Database Design Patterns/004 Comments Creation.srt
3.54 KB
20 - Implementing Database Design Patterns/005 005-db.sql
1.55 KB
20 - Implementing Database Design Patterns/005 Likes Creation.mp4
15.83 MB
20 - Implementing Database Design Patterns/005 Likes Creation.srt
10.52 KB
20 - Implementing Database Design Patterns/006 006-db.sql
2.19 KB
20 - Implementing Database Design Patterns/006 Photo Tags and Caption Tags.mp4
25.74 MB
20 - Implementing Database Design Patterns/006 Photo Tags and Caption Tags.srt
8.52 KB
20 - Implementing Database Design Patterns/007 007-db.sql
2.84 KB
20 - Implementing Database Design Patterns/007 Creating Hashtags, Hashtag Posts, and Followers.mp4
13.66 MB
20 - Implementing Database Design Patterns/007 Creating Hashtags, Hashtag Posts, and Followers.srt
9.4 KB
21 - Approaching and Writing Complex Queries/001 ig.sql
23.51 MB
21 - Approaching and Writing Complex Queries/001 Quick Note About Adding Some Data.html
1.29 KB
21 - Approaching and Writing Complex Queries/002 Adding Some Data.mp4
10.84 MB
21 - Approaching and Writing Complex Queries/002 Adding Some Data.srt
6.8 KB
21 - Approaching and Writing Complex Queries/003 Restoring from Scratch.mp4
13.85 MB
21 - Approaching and Writing Complex Queries/003 Restoring from Scratch.srt
7.13 KB
21 - Approaching and Writing Complex Queries/004 Highest User ID's Exercise.mp4
4.74 MB
21 - Approaching and Writing Complex Queries/004 Highest User ID's Exercise.srt
3.16 KB
21 - Approaching and Writing Complex Queries/005 Solution for User ID's.mp4
2.99 MB
21 - Approaching and Writing Complex Queries/005 Solution for User ID's.srt
1.9 KB
21 - Approaching and Writing Complex Queries/006 Posts by a Particular User.mp4
2.97 MB
21 - Approaching and Writing Complex Queries/006 Posts by a Particular User.srt
1.76 KB
21 - Approaching and Writing Complex Queries/007 Solving for Posts by User.mp4
5.85 MB
21 - Approaching and Writing Complex Queries/007 Solving for Posts by User.srt
2.9 KB
21 - Approaching and Writing Complex Queries/008 Likes Per User.mp4
2.25 MB
21 - Approaching and Writing Complex Queries/008 Likes Per User.srt
1.29 KB
21 - Approaching and Writing Complex Queries/009 Solution for Likes Per User.mp4
4.37 MB
21 - Approaching and Writing Complex Queries/009 Solution for Likes Per User.srt
2.47 KB
22 - Understanding the Internals of PostgreSQL/001 Thinking About Performance.mp4
6.48 MB
22 - Understanding the Internals of PostgreSQL/001 Thinking About Performance.srt
3.53 KB
22 - Understanding the Internals of PostgreSQL/002 Where Does Postgres Store Data.mp4
22.61 MB
22 - Understanding the Internals of PostgreSQL/002 Where Does Postgres Store Data.srt
8.8 KB
22 - Understanding the Internals of PostgreSQL/003 Heaps, Blocks, and Tuples.mp4
15.16 MB
22 - Understanding the Internals of PostgreSQL/003 Heaps, Blocks, and Tuples.srt
5.9 KB
22 - Understanding the Internals of PostgreSQL/004 Terminology Check.html
10 KB
22 - Understanding the Internals of PostgreSQL/005 Block Data Layout.mp4
11.75 MB
22 - Understanding the Internals of PostgreSQL/005 Block Data Layout.srt
7.19 KB
22 - Understanding the Internals of PostgreSQL/006 Heap File Layout.mp4
338.39 MB
22 - Understanding the Internals of PostgreSQL/006 Heap File Layout.srt
50.58 KB
23 - A Look at Indexes for Performance/001 Full Table Scans.mp4
23.88 MB
23 - A Look at Indexes for Performance/001 Full Table Scans.srt
6.39 KB
23 - A Look at Indexes for Performance/002 What's an Index.mp4
6.34 MB
23 - A Look at Indexes for Performance/002 What's an Index.srt
3.9 KB
23 - A Look at Indexes for Performance/003 How an Index Works.mp4
43.22 MB
23 - A Look at Indexes for Performance/003 How an Index Works.srt
12.83 KB
23 - A Look at Indexes for Performance/004 Creating an Index.mp4
8.89 MB
23 - A Look at Indexes for Performance/004 Creating an Index.srt
6.55 KB
23 - A Look at Indexes for Performance/005 Benchmarking Queries.mp4
14.93 MB
23 - A Look at Indexes for Performance/005 Benchmarking Queries.srt
8.46 KB
23 - A Look at Indexes for Performance/006 Downsides of Indexes.mp4
19.87 MB
23 - A Look at Indexes for Performance/006 Downsides of Indexes.srt
7.83 KB
23 - A Look at Indexes for Performance/007 Index Types.mp4
4.08 MB
23 - A Look at Indexes for Performance/007 Index Types.srt
2.52 KB
23 - A Look at Indexes for Performance/008 Automatically Generated Indexes.mp4
12.81 MB
23 - A Look at Indexes for Performance/008 Automatically Generated Indexes.srt
5.62 KB
23 - A Look at Indexes for Performance/009 Using Automatically Created Indexes.html
9.46 KB
23 - A Look at Indexes for Performance/010 Behind the Scenes of Indexes.mp4
238.29 MB
24 - Basic Query Tuning/001 The Query Processing Pipeline.mp4
16.08 MB
24 - Basic Query Tuning/001 The Query Processing Pipeline.srt
8.33 KB
24 - Basic Query Tuning/002 Explain and Explain Analyze.mp4
27.15 MB
24 - Basic Query Tuning/002 Explain and Explain Analyze.srt
8.39 KB
24 - Basic Query Tuning/003 Explain Vs Explain Analyze.html
8.93 KB
24 - Basic Query Tuning/004 Solving an Explain Mystery.mp4
49.05 MB
24 - Basic Query Tuning/004 Solving an Explain Mystery.srt
14.13 KB
25 - Advanced Query Tuning/001 Developing an Intuitive Understanding of Cost.mp4
64.58 MB
25 - Advanced Query Tuning/001 Developing an Intuitive Understanding of Cost.srt
20.13 KB
25 - Advanced Query Tuning/002 Calculating Cost by Hand.mp4
32.19 MB
25 - Advanced Query Tuning/002 Calculating Cost by Hand.srt
10.01 KB
25 - Advanced Query Tuning/003 A Touch More on Costs.mp4
55.34 MB
25 - Advanced Query Tuning/003 A Touch More on Costs.srt
11.11 KB
25 - Advanced Query Tuning/004 Calculating Costs.html
11.63 KB
25 - Advanced Query Tuning/005 Startup vs Total Costs.mp4
28.66 MB
25 - Advanced Query Tuning/005 Startup vs Total Costs.srt
8.98 KB
25 - Advanced Query Tuning/006 Costs Flow Up.mp4
6.35 MB
25 - Advanced Query Tuning/006 Costs Flow Up.srt
3 KB
25 - Advanced Query Tuning/007 Use My Index!.mp4
25.95 MB
25 - Advanced Query Tuning/007 Use My Index!.srt
12.52 KB
26 - Simple Common Table Expressions/001 Common Table Expressions.mp4
7 MB
26 - Simple Common Table Expressions/001 Common Table Expressions.srt
2.94 KB
26 - Simple Common Table Expressions/002 A Quick Solution.mp4
8.7 MB
26 - Simple Common Table Expressions/002 A Quick Solution.srt
5.87 KB
26 - Simple Common Table Expressions/003 So What's a CTE.mp4
20.53 MB
26 - Simple Common Table Expressions/003 So What's a CTE.srt
6.19 KB
27 - Recursive Common Table Expressions/001 Recursive CTE's.mp4
7.78 MB
27 - Recursive Common Table Expressions/002 Recursive CTE's Step by Step.mp4
40.08 MB
27 - Recursive Common Table Expressions/002 Recursive CTE's Step by Step.srt
16.13 KB
27 - Recursive Common Table Expressions/003 Why Use Recursive CTE's.mp4
27.27 MB
27 - Recursive Common Table Expressions/003 Why Use Recursive CTE's.srt
7.59 KB
27 - Recursive Common Table Expressions/004 Writing the Query.mp4
23.59 MB
27 - Recursive Common Table Expressions/004 Writing the Query.srt
12.49 KB
27 - Recursive Common Table Expressions/005 Walking Through Recursion.mp4
65.98 MB
27 - Recursive Common Table Expressions/005 Walking Through Recursion.srt
14.96 KB
28 - Simplifying Queries with Views/001 Most Popular Users.mp4
16.57 MB
28 - Simplifying Queries with Views/001 Most Popular Users.srt
10.22 KB
28 - Simplifying Queries with Views/002 A Possible Solution for Merging Tables.mp4
22.31 MB
28 - Simplifying Queries with Views/002 A Possible Solution for Merging Tables.srt
6.11 KB
28 - Simplifying Queries with Views/003 Creating a View.mp4
21.25 MB
28 - Simplifying Queries with Views/003 Creating a View.srt
8.82 KB
28 - Simplifying Queries with Views/004 When to Use a View.mp4
13.04 MB
28 - Simplifying Queries with Views/004 When to Use a View.srt
5.06 KB
28 - Simplifying Queries with Views/005 Deleting and Changing Views.mp4
7.92 MB
29 - Optimizing Queries with Materialized Views/001 Materialized Views.mp4
5.6 MB
29 - Optimizing Queries with Materialized Views/001 Materialized Views.srt
3.93 KB
29 - Optimizing Queries with Materialized Views/002 Grouping by Week.mp4
22.12 MB
29 - Optimizing Queries with Materialized Views/002 Grouping by Week.srt
6.53 KB
29 - Optimizing Queries with Materialized Views/003 Reminder on Left Joins.mp4
10.5 MB
29 - Optimizing Queries with Materialized Views/003 Reminder on Left Joins.srt
7.11 KB
29 - Optimizing Queries with Materialized Views/004 Writing a Slow Query.mp4
35.07 MB
29 - Optimizing Queries with Materialized Views/004 Writing a Slow Query.srt
13.96 KB
29 - Optimizing Queries with Materialized Views/005 Creating and Refreshing Materialized Views.mp4
22.49 MB
29 - Optimizing Queries with Materialized Views/005 Creating and Refreshing Materialized Views.srt
9.74 KB
29 - Optimizing Queries with Materialized Views/006 Views vs Materialized Views.html
9.7 KB
30 - Handling Concurrency and Reversibility with Transactions/001 What are Transactions Used For.mp4
15.45 MB
30 - Handling Concurrency and Reversibility with Transactions/001 What are Transactions Used For.srt
6.36 KB
30 - Handling Concurrency and Reversibility with Transactions/002 Some Sample Data.mp4
3.78 MB
30 - Handling Concurrency and Reversibility with Transactions/002 Some Sample Data.srt
3.28 KB
30 - Handling Concurrency and Reversibility with Transactions/003 Opening and Closing Transactions.mp4
42.15 MB
30 - Handling Concurrency and Reversibility with Transactions/003 Opening and Closing Transactions.srt
15.13 KB
30 - Handling Concurrency and Reversibility with Transactions/004 Transaction Cleanup on Crash.mp4
20.21 MB
30 - Handling Concurrency and Reversibility with Transactions/005 Closing Aborted Transactions.mp4
4.83 MB
30 - Handling Concurrency and Reversibility with Transactions/005 Closing Aborted Transactions.srt
2.87 KB
31 - Managing Database Design with Schema Migrations/001 A Story on Migrations.mp4
88.61 MB
31 - Managing Database Design with Schema Migrations/001 A Story on Migrations.srt
28.04 KB
31 - Managing Database Design with Schema Migrations/002 Migration Files.mp4
28.84 MB
31 - Managing Database Design with Schema Migrations/002 Migration Files.srt
7.5 KB
31 - Managing Database Design with Schema Migrations/003 Issues Solved by Migrations.mp4
6.69 MB
31 - Managing Database Design with Schema Migrations/003 Issues Solved by Migrations.srt
4.52 KB
31 - Managing Database Design with Schema Migrations/004 A Few Notes on Migrations Libraries.mp4
21.69 MB
31 - Managing Database Design with Schema Migrations/004 A Few Notes on Migrations Libraries.srt
7.56 KB
31 - Managing Database Design with Schema Migrations/005 A Note About Node Installation.html
264 B
31 - Managing Database Design with Schema Migrations/006 Project Creation.mp4
6.23 MB
31 - Managing Database Design with Schema Migrations/006 Project Creation.srt
4.51 KB
31 - Managing Database Design with Schema Migrations/007 Generating and Writing Migrations.mp4
28.53 MB
31 - Managing Database Design with Schema Migrations/007 Generating and Writing Migrations.srt
10.4 KB
31 - Managing Database Design with Schema Migrations/008 Applying and Reverting Migrations.mp4
40.15 MB
31 - Managing Database Design with Schema Migrations/008 Applying and Reverting Migrations.srt
11.52 KB
31 - Managing Database Design with Schema Migrations/009 Generating and Applying a Second Migration.mp4
10.78 MB
31 - Managing Database Design with Schema Migrations/009 Generating and Applying a Second Migration.srt
5.43 KB
32 - Schema vs Data Migrations/001 Schema vs Data Migrations.mp4
13.43 MB
32 - Schema vs Data Migrations/002 Dangers Around Data Migrations.mp4
44.32 MB
32 - Schema vs Data Migrations/002 Dangers Around Data Migrations.srt
14.78 KB
32 - Schema vs Data Migrations/003 Properly Running Data and Schema Migrations.mp4
13.6 MB
32 - Schema vs Data Migrations/003 Properly Running Data and Schema Migrations.srt
8.6 KB
32 - Schema vs Data Migrations/004 Creating a Posts Table.mp4
14.37 MB
32 - Schema vs Data Migrations/004 Creating a Posts Table.srt
7.11 KB
32 - Schema vs Data Migrations/005 005-index.js
1.32 KB
32 - Schema vs Data Migrations/005 A Small Web Server.mp4
40.67 MB
32 - Schema vs Data Migrations/006 Web Server Setup Instructions.html
1.02 KB
32 - Schema vs Data Migrations/007 Adding the Loc Column.mp4
14.2 MB
32 - Schema vs Data Migrations/007 Adding the Loc Column.srt
6.29 KB
32 - Schema vs Data Migrations/008 Writing Values to Both Columns.mp4
10.66 MB
32 - Schema vs Data Migrations/008 Writing Values to Both Columns.srt
6.71 KB
32 - Schema vs Data Migrations/009 Transaction Locks.mp4
62.64 MB
32 - Schema vs Data Migrations/009 Transaction Locks.srt
22.44 KB
32 - Schema vs Data Migrations/010 Updating Values.mp4
10.13 MB
32 - Schema vs Data Migrations/010 Updating Values.srt
6.43 KB
32 - Schema vs Data Migrations/011 01-lng-lat-to-loc.js
364 B
32 - Schema vs Data Migrations/011 Migrations Setup Instructions.html
925 B
32 - Schema vs Data Migrations/012 Updating the App Server.mp4
8.8 MB
32 - Schema vs Data Migrations/012 Updating the App Server.srt
6.56 KB
32 - Schema vs Data Migrations/013 Dropping the Last Columns.mp4
7.58 MB
32 - Schema vs Data Migrations/013 Dropping the Last Columns.srt
4.65 KB
33 - Accessing PostgreSQL From API's/001 Section Goal.mp4
1.96 MB
33 - Accessing PostgreSQL From API's/001 Section Goal.srt
1.56 KB
33 - Accessing PostgreSQL From API's/002 Initial Setup.mp4
1.71 MB
33 - Accessing PostgreSQL From API's/002 Initial Setup.srt
2.45 KB
33 - Accessing PostgreSQL From API's/003 One Fast Migration.mp4
15.66 MB
33 - Accessing PostgreSQL From API's/004 005-access-social-repo.zip
61.31 KB
33 - Accessing PostgreSQL From API's/004 Building the Users Router.mp4
18.61 MB
33 - Accessing PostgreSQL From API's/004 Building the Users Router.srt
7.07 KB
33 - Accessing PostgreSQL From API's/005 Understanding Connection Pools.mp4
16.03 MB
33 - Accessing PostgreSQL From API's/005 Understanding Connection Pools.srt
10.65 KB
33 - Accessing PostgreSQL From API's/006 Validating Connection Credentials.mp4
27.9 MB
33 - Accessing PostgreSQL From API's/006 Validating Connection Credentials.srt
10.59 KB
33 - Accessing PostgreSQL From API's/007 008-access.zip
62 KB
33 - Accessing PostgreSQL From API's/007 Query and Close.mp4
4.04 MB
33 - Accessing PostgreSQL From API's/007 Query and Close.srt
3.18 KB
34 - Data Access Pattern - Repositories/001 The Repository Pattern.mp4
11.69 MB
34 - Data Access Pattern - Repositories/001 The Repository Pattern.srt
5.69 KB
34 - Data Access Pattern - Repositories/002 010-access.zip
62.58 KB
34 - Data Access Pattern - Repositories/002 Creating a Repository.mp4
16.66 MB
34 - Data Access Pattern - Repositories/002 Creating a Repository.srt
12.66 KB
34 - Data Access Pattern - Repositories/003 Accessing the API.mp4
14.68 MB
34 - Data Access Pattern - Repositories/003 Accessing the API.srt
6.25 KB
34 - Data Access Pattern - Repositories/004 Casing Issues.mp4
11.97 MB
34 - Data Access Pattern - Repositories/004 Casing Issues.srt
6.88 KB
34 - Data Access Pattern - Repositories/005 Fixing Casing.mp4
30.31 MB
34 - Data Access Pattern - Repositories/005 Fixing Casing.srt
9.99 KB
34 - Data Access Pattern - Repositories/006 Finding Particular Users.mp4
12 MB
34 - Data Access Pattern - Repositories/006 Finding Particular Users.srt
8.38 KB
35 - Security Around PostgreSQL/001 SQL Injection Exploits.mp4
20.45 MB
35 - Security Around PostgreSQL/001 SQL Injection Exploits.srt
10.71 KB
35 - Security Around PostgreSQL/002 Handling SQL Injection with Prepared Statements.mp4
25.48 MB
35 - Security Around PostgreSQL/002 Handling SQL Injection with Prepared Statements.srt
12.78 KB
35 - Security Around PostgreSQL/003 Preventing SQL Injection.mp4
22.48 MB
35 - Security Around PostgreSQL/003 Preventing SQL Injection.srt
11.96 KB
35 - Security Around PostgreSQL/004 Reminder on Post Requests.mp4
9.24 MB
35 - Security Around PostgreSQL/004 Reminder on Post Requests.srt
4.28 KB
35 - Security Around PostgreSQL/005 019-access.zip
63.56 KB
35 - Security Around PostgreSQL/005 Inserting Users.mp4
9.98 MB
35 - Security Around PostgreSQL/005 Inserting Users.srt
6.53 KB
35 - Security Around PostgreSQL/006 Handling Updates.mp4
10.78 MB
35 - Security Around PostgreSQL/006 Handling Updates.srt
7 KB
35 - Security Around PostgreSQL/007 021-access.zip
63.66 KB
35 - Security Around PostgreSQL/007 And, Finally, Delete.mp4
11.52 MB
35 - Security Around PostgreSQL/007 And, Finally, Delete.srt
6.7 KB
36 - Fast Parallel Testing/001 A Note on Testing.mp4
5.36 MB
36 - Fast Parallel Testing/001 A Note on Testing.srt
5.07 KB
36 - Fast Parallel Testing/002 Assertions Around User Count.mp4
26.88 MB
36 - Fast Parallel Testing/002 Assertions Around User Count.srt
11.15 KB
36 - Fast Parallel Testing/003 024-access.zip
64.5 KB
36 - Fast Parallel Testing/003 Connecting to a DB For Tests.mp4
32 MB
36 - Fast Parallel Testing/003 Connecting to a DB For Tests.srt
8.19 KB
36 - Fast Parallel Testing/004 025-access.zip
64.51 KB
36 - Fast Parallel Testing/004 Disconnecting After Tests.mp4
8.24 MB
36 - Fast Parallel Testing/004 Disconnecting After Tests.srt
4.86 KB
36 - Fast Parallel Testing/005 026-access.zip
64.52 KB
36 - Fast Parallel Testing/005 Multi-DB Setup.mp4
14.14 MB
36 - Fast Parallel Testing/005 Multi-DB Setup.srt
7.31 KB
36 - Fast Parallel Testing/006 027-access.zip
64.52 KB
36 - Fast Parallel Testing/006 Assumptions Around Content.mp4
20.64 MB
36 - Fast Parallel Testing/006 Assumptions Around Content.srt
8.08 KB
36 - Fast Parallel Testing/007 028-access.zip
65.77 KB
36 - Fast Parallel Testing/007 Issues with Parallel Tests.mp4
22.82 MB
36 - Fast Parallel Testing/007 Issues with Parallel Tests.srt
8.34 KB
36 - Fast Parallel Testing/008 Isolation with Schemas.mp4
18.07 MB
36 - Fast Parallel Testing/008 Isolation with Schemas.srt
6.59 KB
36 - Fast Parallel Testing/009 Creating and Accessing Schemas.mp4
12.81 MB
36 - Fast Parallel Testing/009 Creating and Accessing Schemas.srt
8.21 KB
36 - Fast Parallel Testing/010 Controlling Schema Access with Search Paths.mp4
20.15 MB
36 - Fast Parallel Testing/010 Controlling Schema Access with Search Paths.srt
8.82 KB
36 - Fast Parallel Testing/011 Routing Schema Access.mp4
24.75 MB
36 - Fast Parallel Testing/011 Routing Schema Access.srt
6.47 KB
36 - Fast Parallel Testing/012 Strategy for Isolation.mp4
11.66 MB
36 - Fast Parallel Testing/012 Strategy for Isolation.srt
7.17 KB
36 - Fast Parallel Testing/013 034-access.zip
66.14 KB
36 - Fast Parallel Testing/013 Programmatic Schema Creation.mp4
41.17 MB
36 - Fast Parallel Testing/013 Programmatic Schema Creation.srt
18.58 KB
36 - Fast Parallel Testing/014 035-access.zip
66.14 KB
36 - Fast Parallel Testing/014 Escaping Identifiers.mp4
15.94 MB
36 - Fast Parallel Testing/014 Escaping Identifiers.srt
6.73 KB
36 - Fast Parallel Testing/015 036-access.zip
66.48 KB
36 - Fast Parallel Testing/015 Test Helpers.mp4
26.41 MB
36 - Fast Parallel Testing/015 Test Helpers.srt
8.1 KB
36 - Fast Parallel Testing/016 037-access.zip
66.59 KB
36 - Fast Parallel Testing/016 Cleaning up Schemas and Roles.mp4
19.43 MB
36 - Fast Parallel Testing/016 Cleaning up Schemas and Roles.srt
8.5 KB
36 - Fast Parallel Testing/017 Finally... Parallel Tests! (Final Lecture).mp4
11.45 MB
36 - Fast Parallel Testing/017 Finally... Parallel Tests! (Final Lecture).srt
5.14 KB
37 - Bonus!/001 Bonus!.html
3.69 KB
相关资源

免责声明

本网站仅提供DHT网络资源索引服务，不存储任何资源文件。所有资源均来自DHT网络，本站无法控制其内容。请遵守当地法律法规，合理使用网络资源。如涉及版权问题，请联系 fuckatgfw@protonmail.com。

© 2025 鹿鹿堂