|
Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
| [CourseClub.Me].url |
122B |
| [CourseClub.Me].url |
122B |
| [CourseClub.Me].url |
122B |
| [CourseClub.Me].url |
122B |
| [CourseClub.Me].url |
122B |
| [CourseClub.ME].url |
122B |
| [GigaCourse.Com].url |
49B |
| [GigaCourse.Com].url |
49B |
| [GigaCourse.Com].url |
49B |
| [GigaCourse.Com].url |
49B |
| [GigaCourse.Com].url |
49B |
| [GigaCourse.Com].url |
49B |
| 001 Adding Some Data.html |
7.66KB |
| 001 Additional Features Around Posts__en.srt |
9.78KB |
| 001 Additional Features Around Posts.mp4 |
54.04MB |
| 001 Aggregating and Grouping__en.srt |
3.46KB |
| 001 Aggregating and Grouping.mp4 |
5.34MB |
| 001 A New Dataset.html |
17.84KB |
| 001 A Note on Testing__en.srt |
4.84KB |
| 001 A Note on Testing.mp4 |
5.36MB |
| 001 Approaching More Complicated Designs.mp4 |
7.66MB |
| 001 A Story on Migrations__en.srt |
27.19KB |
| 001 A Story on Migrations.mp4 |
88.61MB |
| 001 Back to Postgres__en.srt |
3.19KB |
| 001 Back to Postgres.mp4 |
4.42MB |
| 001 Bonus_.html |
4.11KB |
| 001 Common Table Expressions__en.srt |
2.89KB |
| 001 Common Table Expressions.mp4 |
7.00MB |
| 001 Designing a Follower System__en.srt |
8.96KB |
| 001 Designing a Follower System.mp4 |
17.21MB |
| 001 Designing a Hashtag System__en.srt |
11.64KB |
| 001 Designing a Hashtag System.mp4 |
60.55MB |
| 001 Developing an Intuitive Understanding of Cost__en.srt |
19.88KB |
| 001 Developing an Intuitive Understanding of Cost.mp4 |
64.58MB |
| 001 Filtering Rows with _Where___en.srt |
5.63KB |
| 001 Filtering Rows with _Where_.mp4 |
8.43MB |
| 001 Full Table Scans__en.srt |
6.35KB |
| 001 Full Table Scans.mp4 |
23.88MB |
| 001 Handling Sets with Union__en.srt |
8.54KB |
| 001 Handling Sets with Union.mp4 |
13.00MB |
| 001 Join Our Community_.html |
318B |
| 001 Materialized Views__en.srt |
3.77KB |
| 001 Materialized Views.mp4 |
5.60MB |
| 001 Most Popular Users__en.srt |
9.59KB |
| 001 Most Popular Users.mp4 |
16.57MB |
| 001 PostgreSQL Installation on macOS__en.srt |
9.69KB |
| 001 PostgreSQL Installation on macOS.mp4 |
14.14MB |
| 001 Quick Note About Adding Some Data.html |
251B |
| 001 Recursive CTE's__en.srt |
4.91KB |
| 001 Recursive CTE's.mp4 |
7.78MB |
| 001 Requirements of a Like System__en.srt |
7.53KB |
| 001 Requirements of a Like System.mp4 |
16.24MB |
| 001 Schema vs Data Migrations__en.srt |
6.25KB |
| 001 Schema vs Data Migrations.mp4 |
13.43MB |
| 001 Section Goal__en.srt |
1.48KB |
| 001 Section Goal.mp4 |
1.96MB |
| 001 Selecting Distinct Values__en.srt |
6.33KB |
| 001 Selecting Distinct Values.mp4 |
8.43MB |
| 001 SQL Injection Exploits__en.srt |
10.52KB |
| 001 SQL Injection Exploits.mp4 |
20.45MB |
| 001 The Basics of Sorting__en.srt |
3.51KB |
| 001 The Basics of Sorting.mp4 |
4.64MB |
| 001 The Greatest Value in a List__en.srt |
4.92KB |
| 001 The Greatest Value in a List.mp4 |
7.87MB |
| 001 The Plan Moving Forward__en.srt |
2.72KB |
| 001 The Plan Moving Forward.mp4 |
7.08MB |
| 001 The Query Processing Pipeline__en.srt |
7.95KB |
| 001 The Query Processing Pipeline.mp4 |
16.08MB |
| 001 The Repository Pattern__en.srt |
5.54KB |
| 001 The Repository Pattern.mp4 |
11.69MB |
| 001 Thinking About Performance__en.srt |
3.58KB |
| 001 Thinking About Performance.mp4 |
6.48MB |
| 001 Thinking About Validation__en.srt |
6.67KB |
| 001 Thinking About Validation.mp4 |
16.52MB |
| 001 What'd We Just Do___en.srt |
6.37KB |
| 001 What'd We Just Do_.mp4 |
12.38MB |
| 001 What's a Subquery___en.srt |
8.67KB |
| 001 What's a Subquery_.mp4 |
19.43MB |
| 001 What are Transactions Used For___en.srt |
6.25KB |
| 001 What are Transactions Used For_.mp4 |
15.45MB |
| 002 Adding Captions and Locations__en.srt |
2.56KB |
| 002 Adding Captions and Locations.mp4 |
5.36MB |
| 002 Adding Some Data__en.srt |
6.45KB |
| 002 Adding Some Data.mp4 |
10.84MB |
| 002 A Few Notes on Union__en.srt |
5.53KB |
| 002 A Few Notes on Union.mp4 |
10.82MB |
| 002 And the Least Value in a List___en.srt |
2.95KB |
| 002 And the Least Value in a List_.mp4 |
3.76MB |
| 002 A Possible Solution for Merging Tables__en.srt |
6.07KB |
| 002 A Possible Solution for Merging Tables.mp4 |
22.31MB |
| 002 Approaching Database Design__en.srt |
11.75KB |
| 002 Approaching Database Design.mp4 |
30.49MB |
| 002 A Quick Solution__en.srt |
5.49KB |
| 002 A Quick Solution.mp4 |
8.70MB |
| 002 Assertions Around User Count__en.srt |
10.32KB |
| 002 Assertions Around User Count.mp4 |
26.88MB |
| 002 Calculating Cost by Hand__en.srt |
9.82KB |
| 002 Calculating Cost by Hand.mp4 |
32.19MB |
| 002 Course Resources.html |
1.25KB |
| 002 Creating and Viewing Tables in PGAdmin__en.srt |
11.23KB |
| 002 Creating and Viewing Tables in PGAdmin.mp4 |
18.55MB |
| 002 Creating a Repository__en.srt |
12.30KB |
| 002 Creating a Repository.mp4 |
16.66MB |
| 002 Creating Tables with Checks__en.srt |
20.44KB |
| 002 Creating Tables with Checks.mp4 |
40.10MB |
| 002 Dangers Around Data Migrations__en.srt |
14.15KB |
| 002 Dangers Around Data Migrations.mp4 |
44.32MB |
| 002 Data Types__en.srt |
6.98KB |
| 002 Data Types.mp4 |
19.72MB |
| 002 Exercise Overview__en.srt |
876B |
| 002 Exercise Overview.mp4 |
961.13KB |
| 002 Explain and Explain Analyze__en.srt |
8.13KB |
| 002 Explain and Explain Analyze.mp4 |
27.15MB |
| 002 Grouping by Week__en.srt |
6.21KB |
| 002 Grouping by Week.mp4 |
22.12MB |
| 002 Handling SQL Injection with Prepared Statements__en.srt |
12.46KB |
| 002 Handling SQL Injection with Prepared Statements.mp4 |
25.48MB |
| 002 How Not to Design a Like System__en.srt |
4.72KB |
| 002 How Not to Design a Like System.mp4 |
10.26MB |
| 002 Initial Setup.mp4 |
1.71MB |
| 002 Investigating This Dataset.mp4 |
5.42MB |
| 002 Migration Files__en.srt |
7.33KB |
| 002 Migration Files.mp4 |
28.84MB |
| 002 More on the _Where_ Keyword__en.srt |
3.75KB |
| 002 More on the _Where_ Keyword.mp4 |
6.00MB |
| 002 PGAdmin Setup on macOS__en.srt |
7.53KB |
| 002 PGAdmin Setup on macOS.mp4 |
22.05MB |
| 002 Picturing Group By__en.srt |
8.06KB |
| 002 Picturing Group By.mp4 |
30.92MB |
| 002 Queries with Joins and Aggregations__en.srt |
5.06KB |
| 002 Queries with Joins and Aggregations.mp4 |
17.77MB |
| 002 Recursive CTE's Step by Step__en.srt |
15.15KB |
| 002 Recursive CTE's Step by Step.mp4 |
40.08MB |
| 002 Some Sample Data__en.srt |
3.06KB |
| 002 Some Sample Data.mp4 |
3.78MB |
| 002 Tables for Hashtags__en.srt |
5.65KB |
| 002 Tables for Hashtags.mp4 |
10.02MB |
| 002 Thinking About the Structure of Data__en.srt |
7.37KB |
| 002 Thinking About the Structure of Data.mp4 |
15.19MB |
| 002 Two Variations on Sorting__en.srt |
4.02KB |
| 002 Two Variations on Sorting.mp4 |
6.28MB |
| 002 Using a SQL Design Tool__en.srt |
9.66KB |
| 002 Using a SQL Design Tool.mp4 |
32.43MB |
| 002 What's an Index__en.srt |
3.89KB |
| 002 What's an Index.mp4 |
6.34MB |
| 002 Where Does Postgres Store Data___en.srt |
8.63KB |
| 002 Where Does Postgres Store Data_.mp4 |
22.62MB |
| 003 Accessing the API.mp4 |
14.68MB |
| 003 A Config-based Schema Designer__en.srt |
11.51KB |
| 003 A Config-based Schema Designer.mp4 |
19.25MB |
| 003 A Distinct Solution__en.srt |
931B |
| 003 A Distinct Solution.mp4 |
1.36MB |
| 003 Aggregate Functions__en.srt |
4.42KB |
| 003 Aggregate Functions.mp4 |
7.62MB |
| 003 Applying a Null Constraint__en.srt |
9.98KB |
| 003 Applying a Null Constraint.mp4 |
14.08MB |
| 003 A Touch More on Costs__en.srt |
11.17KB |
| 003 A Touch More on Costs.mp4 |
55.34MB |
| 003 Commonalities with Intersect__en.srt |
4.91KB |
| 003 Commonalities with Intersect.mp4 |
10.13MB |
| 003 Compound _Where_ Clauses__en.srt |
7.41KB |
| 003 Compound _Where_ Clauses.mp4 |
12.76MB |
| 003 Connecting to a DB For Tests__en.srt |
7.98KB |
| 003 Connecting to a DB For Tests.mp4 |
32.00MB |
| 003 Creating a View__en.srt |
8.29KB |
| 003 Creating a View.mp4 |
21.25MB |
| 003 Designing a Like System__en.srt |
8.07KB |
| 003 Designing a Like System.mp4 |
16.81MB |
| 003 Fast Rules on Numeric Data Types__en.srt |
3.50KB |
| 003 Fast Rules on Numeric Data Types.mp4 |
11.96MB |
| 003 Heaps, Blocks, and Tuples__en.srt |
5.62KB |
| 003 Heaps, Blocks, and Tuples.mp4 |
15.16MB |
| 003 How an Index Works__en.srt |
11.99KB |
| 003 How an Index Works.mp4 |
43.22MB |
| 003 Including the Hashtag Table__en.srt |
5.77KB |
| 003 Including the Hashtag Table.mp4 |
11.58MB |
| 003 Issues Solved by Migrations__en.srt |
4.40KB |
| 003 Issues Solved by Migrations.mp4 |
6.69MB |
| 003 Joining Data from Different Tables__en.srt |
11.51KB |
| 003 Joining Data from Different Tables.mp4 |
27.41MB |
| 003 Offset and Limit.mp4 |
13.21MB |
| 003 One Fast Migration__en.srt |
7.09KB |
| 003 One Fast Migration.mp4 |
15.66MB |
| 003 One-to-Many and Many-to-One Relationships__en.srt |
9.85KB |
| 003 One-to-Many and Many-to-One Relationships.mp4 |
26.25MB |
| 003 Opening and Closing Transactions__en.srt |
14.76KB |
| 003 Opening and Closing Transactions.mp4 |
42.15MB |
| 003 Photo Mentions vs Caption Mentions__en.srt |
12.33KB |
| 003 Photo Mentions vs Caption Mentions.mp4 |
44.21MB |
| 003 Postgres installation on Windows__en.srt |
6.41KB |
| 003 Postgres installation on Windows.mp4 |
13.77MB |
| 003 Posts Creation__en.srt |
12.42KB |
| 003 Posts Creation.mp4 |
24.30MB |
| 003 Preventing SQL Injection__en.srt |
11.26KB |
| 003 Preventing SQL Injection.mp4 |
22.48MB |
| 003 Properly Running Data and Schema Migrations__en.srt |
8.64KB |
| 003 Properly Running Data and Schema Migrations.mp4 |
13.60MB |
| 003 Reminder on Left Joins__en.srt |
6.71KB |
| 003 Reminder on Left Joins.mp4 |
10.50MB |
| 003 Restoring from Scratch__en.srt |
6.81KB |
| 003 Restoring from Scratch.mp4 |
13.85MB |
| 003 Solving an Explain Mystery__en.srt |
13.66KB |
| 003 Solving an Explain Mystery.mp4 |
49.05MB |
| 003 Some Group By Practice__en.srt |
1.97KB |
| 003 Some Group By Practice.mp4 |
2.09MB |
| 003 So What's a CTE___en.srt |
5.62KB |
| 003 So What's a CTE_.mp4 |
20.53MB |
| 003 Subqueries in a Select__en.srt |
8.29KB |
| 003 Subqueries in a Select.mp4 |
15.15MB |
| 003 The Case Keyword__en.srt |
6.53KB |
| 003 The Case Keyword.mp4 |
19.04MB |
| 003 What is PostgreSQL All About___en.srt |
7.24KB |
| 003 What is PostgreSQL All About_.mp4 |
21.75MB |
| 003 Why Use Recursive CTE's_.mp4 |
27.27MB |
| 004 A _Where_ Exercise Overview__en.srt |
962B |
| 004 A _Where_ Exercise Overview.mp4 |
1.22MB |
| 004 A Few More User Columns__en.srt |
9.57KB |
| 004 A Few More User Columns.mp4 |
16.86MB |
| 004 A Few Notes on Migrations Libraries__en.srt |
7.60KB |
| 004 A Few Notes on Migrations Libraries.mp4 |
21.69MB |
| 004 Another Quick Join__en.srt |
3.15KB |
| 004 Another Quick Join.mp4 |
5.62MB |
| 004 Block Data Layout__en.srt |
6.75KB |
| 004 Block Data Layout.mp4 |
11.75MB |
| 004 Building the Users Router__en.srt |
6.59KB |
| 004 Building the Users Router.mp4 |
18.61MB |
| 004 Casing Issues__en.srt |
6.85KB |
| 004 Casing Issues.mp4 |
11.97MB |
| 004 Combining Group By and Aggregates__en.srt |
7.03KB |
| 004 Combining Group By and Aggregates.mp4 |
10.24MB |
| 004 Comments Creation__en.srt |
3.37KB |
| 004 Comments Creation.mp4 |
4.93MB |
| 004 Considerations on Photo Tags vs Caption Tags__en.srt |
11.33KB |
| 004 Considerations on Photo Tags vs Caption Tags.mp4 |
42.88MB |
| 004 Creating an Index__en.srt |
6.09KB |
| 004 Creating an Index.mp4 |
8.89MB |
| 004 Creating a Posts Table__en.srt |
6.67KB |
| 004 Creating a Posts Table.mp4 |
14.37MB |
| 004 Database Design__en.srt |
7.97KB |
| 004 Database Design.mp4 |
35.37MB |
| 004 Disconnecting After Tests__en.srt |
4.48KB |
| 004 Disconnecting After Tests.mp4 |
8.24MB |
| 004 Exercise Overview__en.srt |
692B |
| 004 Exercise Overview__en.srt |
1.69KB |
| 004 Exercise Overview.mp4 |
811.13KB |
| 004 Exercise Overview.mp4 |
2.10MB |
| 004 Group By Review Solution__en.srt |
3.43KB |
| 004 Group By Review Solution.mp4 |
5.32MB |
| 004 Here's the Plan__en.srt |
4.15KB |
| 004 Here's the Plan.mp4 |
5.90MB |
| 004 Highest User ID's Exercise__en.srt |
3.02KB |
| 004 Highest User ID's Exercise.mp4 |
4.74MB |
| 004 Making a Reaction System Instead__en.srt |
2.47KB |
| 004 Making a Reaction System Instead.mp4 |
4.12MB |
| 004 More on Number Data Types__en.srt |
14.38KB |
| 004 More on Number Data Types.mp4 |
30.51MB |
| 004 One-to-One and Many-to-Many Relationships__en.srt |
8.51KB |
| 004 One-to-One and Many-to-Many Relationships.mp4 |
15.27MB |
| 004 Reminder on Post Requests__en.srt |
4.06KB |
| 004 Reminder on Post Requests.mp4 |
9.24MB |
| 004 Removing Commonalities with Except__en.srt |
9.22KB |
| 004 Removing Commonalities with Except.mp4 |
13.67MB |
| 004 Solving a Gotcha with Null Constraints__en.srt |
6.30KB |
| 004 Solving a Gotcha with Null Constraints.mp4 |
9.10MB |
| 004 Startup vs Total Costs__en.srt |
8.87KB |
| 004 Startup vs Total Costs.mp4 |
28.66MB |
| 004 Transaction Cleanup on Crash__en.srt |
5.97KB |
| 004 Transaction Cleanup on Crash.mp4 |
20.21MB |
| 004 When to Use a View___en.srt |
4.85KB |
| 004 When to Use a View_.mp4 |
13.04MB |
| 004 Writing a Slow Query__en.srt |
13.61KB |
| 004 Writing a Slow Query.mp4 |
35.07MB |
| 004 Writing the Query__en.srt |
11.58KB |
| 004 Writing the Query.mp4 |
23.59MB |
| 005 A _Where_ Solution__en.srt |
1.32KB |
| 005 A _Where_ Solution.mp4 |
1.89MB |
| 005 A Gotcha with Count__en.srt |
4.05KB |
| 005 A Gotcha with Count.mp4 |
3.99MB |
| 005 A Note About Node Installation.html |
264B |
| 005 A Small Web Server__en.srt |
20.38KB |
| 005 A Small Web Server.mp4 |
40.67MB |
| 005 Benchmarking Queries__en.srt |
8.29KB |
| 005 Benchmarking Queries.mp4 |
14.93MB |
| 005 Closing Aborted Transactions__en.srt |
2.68KB |
| 005 Closing Aborted Transactions.mp4 |
4.83MB |
| 005 Costs Flow Up__en.srt |
3.03KB |
| 005 Costs Flow Up.mp4 |
6.35MB |
| 005 Creating and Refreshing Materialized Views.mp4 |
22.49MB |
| 005 Creating Tables__en.srt |
7.50KB |
| 005 Creating Tables.mp4 |
18.61MB |
| 005 Default Column Values.mp4 |
14.32MB |
| 005 Deleting and Changing Views__en.srt |
3.60KB |
| 005 Deleting and Changing Views.mp4 |
7.92MB |
| 005 Exercise Overview__en.srt |
1.73KB |
| 005 Exercise Overview.mp4 |
3.09MB |
| 005 Exercise Solution__en.srt |
1.99KB |
| 005 Exercise Solution.mp4 |
2.41MB |
| 005 Fixing Casing__en.srt |
9.31KB |
| 005 Fixing Casing.mp4 |
30.31MB |
| 005 Heap File Layout__en.srt |
48.34KB |
| 005 Heap File Layout.mp4 |
338.62MB |
| 005 Inserting Users__en.srt |
6.11KB |
| 005 Inserting Users.mp4 |
9.98MB |
| 005 Likes Creation__en.srt |
9.73KB |
| 005 Likes Creation.mp4 |
15.83MB |
| 005 Multi-DB Setup__en.srt |
7.31KB |
| 005 Multi-DB Setup.mp4 |
14.14MB |
| 005 Polymorphic Associations__en.srt |
9.40KB |
| 005 Polymorphic Associations.mp4 |
33.43MB |
| 005 Primary Keys and Foreign Keys__en.srt |
7.68KB |
| 005 Primary Keys and Foreign Keys.mp4 |
18.82MB |
| 005 Rebuilding Some Schema__en.srt |
10.33KB |
| 005 Rebuilding Some Schema.mp4 |
14.12MB |
| 005 Remember Joins___en.srt |
3.45KB |
| 005 Remember Joins_.mp4 |
5.97MB |
| 005 Reminder on Character Types__en.srt |
7.33KB |
| 005 Reminder on Character Types.mp4 |
19.13MB |
| 005 Select Solution__en.srt |
1.77KB |
| 005 Select Solution.mp4 |
2.62MB |
| 005 Solution for User ID's__en.srt |
1.78KB |
| 005 Solution for User ID's.mp4 |
2.99MB |
| 005 Understanding Connection Pools__en.srt |
10.34KB |
| 005 Understanding Connection Pools.mp4 |
16.03MB |
| 005 Union Exercise Overview__en.srt |
2.19KB |
| 005 Union Exercise Overview.mp4 |
2.97MB |
| 005 Update For Tags__en.srt |
7.20KB |
| 005 Update For Tags.mp4 |
14.97MB |
| 005 Walking Through Recursion__en.srt |
14.59KB |
| 005 Walking Through Recursion.mp4 |
65.98MB |
| 005 Why No Number of Followers or Posts___en.srt |
5.90KB |
| 005 Why No Number of Followers or Posts_.mp4 |
10.44MB |
| 006 _Where_ With Lists__en.srt |
1.02KB |
| 006 _Where_ With Lists.mp4 |
1.12MB |
| 006 A Joinful Solution__en.srt |
2.50KB |
| 006 A Joinful Solution.mp4 |
3.47MB |
| 006 Analyzing CREATE TABLE__en.srt |
5.36KB |
| 006 Analyzing CREATE TABLE.mp4 |
11.38MB |
| 006 Applying a Unique Constraint to One column__en.srt |
8.63KB |
| 006 Applying a Unique Constraint to One column.mp4 |
26.77MB |
| 006 Assumptions Around Content__en.srt |
8.00KB |
| 006 Assumptions Around Content.mp4 |
20.64MB |
| 006 Boolean Data Types__en.srt |
3.77KB |
| 006 Boolean Data Types.mp4 |
5.43MB |
| 006 Downsides of Indexes__en.srt |
8.03KB |
| 006 Downsides of Indexes.mp4 |
19.87MB |
| 006 Exercise Solution__en.srt |
2.02KB |
| 006 Exercise Solution.mp4 |
3.25MB |
| 006 Finding Particular Users__en.srt |
7.97KB |
| 006 Finding Particular Users.mp4 |
12.00MB |
| 006 Handling Updates__en.srt |
6.62KB |
| 006 Handling Updates.mp4 |
10.78MB |
| 006 Of Course You Remember___en.srt |
2.06KB |
| 006 Of Course You Remember_.mp4 |
3.02MB |
| 006 Photo Tags and Caption Tags__en.srt |
8.05KB |
| 006 Photo Tags and Caption Tags.mp4 |
25.74MB |
| 006 Polymorphic Association Alternative Implementation__en.srt |
10.62KB |
| 006 Polymorphic Association Alternative Implementation.mp4 |
39.49MB |
| 006 Posts by a Particular User__en.srt |
1.72KB |
| 006 Posts by a Particular User.mp4 |
2.97MB |
| 006 Project Creation__en.srt |
4.40KB |
| 006 Project Creation.mp4 |
6.23MB |
| 006 Subqueries in a From__en.srt |
11.68KB |
| 006 Subqueries in a From.mp4 |
28.32MB |
| 006 Understanding Foreign Keys__en.srt |
12.60KB |
| 006 Understanding Foreign Keys.mp4 |
41.56MB |
| 006 Use My Index___en.srt |
12.43KB |
| 006 Use My Index_.mp4 |
25.95MB |
| 006 Validating Connection Credentials__en.srt |
10.34KB |
| 006 Validating Connection Credentials.mp4 |
27.90MB |
| 006 Visualizing More Grouping__en.srt |
4.45KB |
| 006 Visualizing More Grouping.mp4 |
6.72MB |
| 006 Web Server Setup Instructions.html |
1.02KB |
| 007 A _Where_ With Lists Solution__en.srt |
2.29KB |
| 007 A _Where_ With Lists Solution.mp4 |
3.56MB |
| 007 Adding the Loc Column__en.srt |
5.90KB |
| 007 Adding the Loc Column.mp4 |
14.20MB |
| 007 Alternate Forms of Syntax__en.srt |
9.11KB |
| 007 Alternate Forms of Syntax.mp4 |
14.42MB |
| 007 And, Finally, Delete__en.srt |
6.13KB |
| 007 And, Finally, Delete.mp4 |
11.52MB |
| 007 Auto-Generated ID's__en.srt |
8.69KB |
| 007 Auto-Generated ID's.mp4 |
14.63MB |
| 007 Creating Hashtags, Hashtag Posts, and Followers__en.srt |
8.81KB |
| 007 Creating Hashtags, Hashtag Posts, and Followers.mp4 |
13.66MB |
| 007 Exercise Overview__en.srt |
1.12KB |
| 007 Exercise Overview.mp4 |
1.14MB |
| 007 From Subqueries that Return a Value__en.srt |
4.21KB |
| 007 From Subqueries that Return a Value.mp4 |
6.11MB |
| 007 Generating and Writing Migrations__en.srt |
10.20KB |
| 007 Generating and Writing Migrations.mp4 |
28.53MB |
| 007 Index Types__en.srt |
2.51KB |
| 007 Index Types.mp4 |
4.08MB |
| 007 Inserting Data Into a Table__en.srt |
7.38KB |
| 007 Inserting Data Into a Table.mp4 |
12.12MB |
| 007 Issues with Parallel Tests__en.srt |
7.72KB |
| 007 Issues with Parallel Tests.mp4 |
22.82MB |
| 007 Multi-Column Uniqueness__en.srt |
5.08KB |
| 007 Multi-Column Uniqueness.mp4 |
18.37MB |
| 007 Query and Close__en.srt |
3.03KB |
| 007 Solving for Posts by User__en.srt |
2.75KB |
| 007 Solving for Posts by User.mp4 |
5.85MB |
| 007 The Simplest Alternative__en.srt |
5.96KB |
| 007 The Simplest Alternative.mp4 |
17.40MB |
| 007 Times, Dates, and Timestamps__en.srt |
8.15KB |
| 007 Times, Dates, and Timestamps.mp4 |
14.29MB |
| 008 Adding a Validation Check__en.srt |
5.96KB |
| 008 Adding a Validation Check.mp4 |
11.70MB |
| 008 Applying and Reverting Migrations__en.srt |
10.91KB |
| 008 Applying and Reverting Migrations.mp4 |
40.15MB |
| 008 Automatically Generated Indexes__en.srt |
5.59KB |
| 008 Automatically Generated Indexes.mp4 |
12.81MB |
| 008 Calculations in _Where_ Clauses__en.srt |
3.00KB |
| 008 Calculations in _Where_ Clauses.mp4 |
3.41MB |
| 008 Creating Foreign Key Columns__en.srt |
7.25KB |
| 008 Creating Foreign Key Columns.mp4 |
12.01MB |
| 008 Example of a Subquery in a From__en.srt |
13.34KB |
| 008 Example of a Subquery in a From.mp4 |
34.35MB |
| 008 Grouping Solution__en.srt |
2.10KB |
| 008 Grouping Solution.mp4 |
2.23MB |
| 008 Isolation with Schemas__en.srt |
6.39KB |
| 008 Isolation with Schemas.mp4 |
18.07MB |
| 008 Likes Per User.mp4 |
2.25MB |
| 008 Missing Data in Joins__en.srt |
9.53KB |
| 008 Missing Data in Joins.mp4 |
19.08MB |
| 008 Really Awesome Intervals__en.srt |
8.81KB |
| 008 Really Awesome Intervals.mp4 |
13.48MB |
| 008 Retrieving Data with Select__en.srt |
3.21KB |
| 008 Retrieving Data with Select.mp4 |
4.05MB |
| 008 So Which Approach___en.srt |
6.83KB |
| 008 So Which Approach_.mp4 |
10.46MB |
| 008 Writing Values to Both Columns__en.srt |
6.30KB |
| 008 Writing Values to Both Columns.mp4 |
10.66MB |
| 009 Adding a Layer of Difficulty__en.srt |
1.08KB |
| 009 Adding a Layer of Difficulty.mp4 |
1.19MB |
| 009 Behind the Scenes of Indexes__en.srt |
47.52KB |
| 009 Behind the Scenes of Indexes.mp4 |
238.29MB |
| 009 Calculated Columns__en.srt |
7.14KB |
| 009 Calculated Columns.mp4 |
10.37MB |
| 009 Checks Over Multiple Columns__en.srt |
7.43KB |
| 009 Checks Over Multiple Columns.mp4 |
11.57MB |
| 009 Creating and Accessing Schemas__en.srt |
7.81KB |
| 009 Creating and Accessing Schemas.mp4 |
12.81MB |
| 009 Exercise Overview__en.srt |
1.82KB |
| 009 Exercise Overview.mp4 |
2.40MB |
| 009 Generating and Applying a Second Migration__en.srt |
5.04KB |
| 009 Generating and Applying a Second Migration.mp4 |
10.78MB |
| 009 Running Queries on Associated Data__en.srt |
10.06KB |
| 009 Running Queries on Associated Data.mp4 |
24.52MB |
| 009 Solution for Likes Per User__en.srt |
2.42KB |
| 009 Solution for Likes Per User.mp4 |
4.37MB |
| 009 Solving Calculations.mp4 |
4.15MB |
| 009 Transaction Locks__en.srt |
21.70KB |
| 009 Transaction Locks.mp4 |
62.64MB |
| 009 Why Wasn't It Included__en.srt |
3.68KB |
| 009 Why Wasn't It Included.mp4 |
14.99MB |
| 010 Calculating Phone Revenue__en.srt |
1.52KB |
| 010 Calculating Phone Revenue.mp4 |
2.19MB |
| 010 Controlling Schema Access with Search Paths__en.srt |
8.55KB |
| 010 Controlling Schema Access with Search Paths.mp4 |
20.15MB |
| 010 Exercise Overview__en.srt |
3.31KB |
| 010 Exercise Overview.mp4 |
5.34MB |
| 010 Exercise Solution.mp4 |
6.56MB |
| 010 Four Kinds of Joins__en.srt |
14.40KB |
| 010 Four Kinds of Joins.mp4 |
75.29MB |
| 010 Solution__en.srt |
2.13KB |
| 010 Solution.mp4 |
2.59MB |
| 010 So Where Are We Applying Validation___en.srt |
9.63KB |
| 010 So Where Are We Applying Validation_.mp4 |
14.54MB |
| 010 Updating Rows__en.srt |
6.30KB |
| 010 Updating Rows.mp4 |
11.69MB |
| 010 Updating Values__en.srt |
6.27KB |
| 010 Updating Values.mp4 |
10.13MB |
| 011 Deleting Rows__en.srt |
4.88KB |
| 011 Deleting Rows.mp4 |
9.13MB |
| 011 Each Join in Practice__en.srt |
6.12KB |
| 011 Each Join in Practice.mp4 |
23.44MB |
| 011 Exercise Solution__en.srt |
1.57KB |
| 011 Exercise Solution.mp4 |
2.17MB |
| 011 Filtering Groups with Having__en.srt |
7.54KB |
| 011 Filtering Groups with Having.mp4 |
23.90MB |
| 011 Foreign Key Creation Solution__en.srt |
2.95KB |
| 011 Foreign Key Creation Solution.mp4 |
5.39MB |
| 011 Migrations Setup Instructions.html |
925B |
| 011 Routing Schema Access__en.srt |
6.43KB |
| 011 Routing Schema Access.mp4 |
24.75MB |
| 011 Subqueries in a Join Clause__en.srt |
6.66KB |
| 011 Subqueries in a Join Clause.mp4 |
10.84MB |
| 012 A Solution for Updating Rows__en.srt |
2.13KB |
| 012 A Solution for Updating Rows.mp4 |
3.42MB |
| 012 Does Order Matter___en.srt |
6.26KB |
| 012 Does Order Matter_.mp4 |
35.92MB |
| 012 Foreign Key Constraints Around Insertion__en.srt |
8.51KB |
| 012 Foreign Key Constraints Around Insertion.mp4 |
16.89MB |
| 012 Having In Action__en.srt |
3.87KB |
| 012 Having In Action.mp4 |
4.69MB |
| 012 More Useful - Subqueries with Where__en.srt |
13.32KB |
| 012 More Useful - Subqueries with Where.mp4 |
23.88MB |
| 012 Strategy for Isolation__en.srt |
7.01KB |
| 012 Strategy for Isolation.mp4 |
11.66MB |
| 012 String Operators and Functions__en.srt |
9.62KB |
| 012 String Operators and Functions.mp4 |
11.34MB |
| 012 Updating the App Server__en.srt |
6.43KB |
| 012 Updating the App Server.mp4 |
8.80MB |
| 013 Constraints Around Deletion__en.srt |
7.47KB |
| 013 Constraints Around Deletion.mp4 |
25.98MB |
| 013 Data Structure with Where Subqueries__en.srt |
8.72KB |
| 013 Data Structure with Where Subqueries.mp4 |
27.68MB |
| 013 Dropping the Last Columns.mp4 |
7.58MB |
| 013 Exercise Overview__en.srt |
1.43KB |
| 013 Exercise Overview.mp4 |
1.53MB |
| 013 More on Having___en.srt |
10.20KB |
| 013 More on Having_.mp4 |
18.57MB |
| 013 Programmatic Schema Creation__en.srt |
17.71KB |
| 013 Programmatic Schema Creation.mp4 |
41.17MB |
| 013 Solution for Deleting Rows__en.srt |
1.96KB |
| 013 Solution for Deleting Rows.mp4 |
2.76MB |
| 014 A Having Exercise Overview__en.srt |
5.36KB |
| 014 A Having Exercise Overview.mp4 |
8.40MB |
| 014 Commands You8217ll Need for the Next Video.html |
691B |
| 014 Escaping Identifiers__en.srt |
6.23KB |
| 014 Escaping Identifiers.mp4 |
15.94MB |
| 014 Exercise Overview.mp4 |
1.90MB |
| 014 Two Possible Solutions__en.srt |
4.60KB |
| 014 Two Possible Solutions.mp4 |
10.19MB |
| 015 A Quick Solution__en.srt |
3.69KB |
| 015 A Quick Solution.mp4 |
5.19MB |
| 015 Exercise Solution__en.srt |
3.02KB |
| 015 Exercise Solution.mp4 |
4.45MB |
| 015 Test Helpers__en.srt |
7.74KB |
| 015 Test Helpers.mp4 |
26.41MB |
| 015 Testing Deletion Constraints__en.srt |
6.58KB |
| 015 Testing Deletion Constraints.mp4 |
14.19MB |
| 015 Where with Join__en.srt |
10.03KB |
| 015 Where with Join.mp4 |
20.21MB |
| 016 Cleaning up Schemas and Roles__en.srt |
7.96KB |
| 016 Cleaning up Schemas and Roles.mp4 |
19.43MB |
| 016 Setting Foreign Keys to Null on Delete__en.srt |
4.29KB |
| 016 Setting Foreign Keys to Null on Delete.mp4 |
8.26MB |
| 016 The Not In Operator with a List__en.srt |
6.28KB |
| 016 The Not In Operator with a List.mp4 |
23.45MB |
| 016 Three Way Joins__en.srt |
11.90KB |
| 016 Three Way Joins.mp4 |
32.08MB |
| 017 A Bit of Practice__en.srt |
7.47KB |
| 017 A Bit of Practice.mp4 |
11.53MB |
| 017 Adding Some Complexity__en.srt |
4.66KB |
| 017 Adding Some Complexity.mp4 |
6.78MB |
| 017 A New Where Operator__en.srt |
9.42KB |
| 017 A New Where Operator.mp4 |
24.20MB |
| 017 Finally... Parallel Tests___en.srt |
5.15KB |
| 017 Finally... Parallel Tests_.mp4 |
11.63MB |
| 018 Exercise Solution__en.srt |
3.88KB |
| 018 Exercise Solution.mp4 |
5.44MB |
| 018 Finally Some___en.srt |
8.03KB |
| 018 Finally Some_.mp4 |
20.48MB |
| 019 Exercise Overview__en.srt |
743B |
| 019 Exercise Overview.mp4 |
853.67KB |
| 020 A Quick Solution__en.srt |
2.38KB |
| 020 A Quick Solution.mp4 |
3.06MB |
| 021 Probably Too Much About Correlated Subqueries__en.srt |
24.57KB |
| 021 Probably Too Much About Correlated Subqueries.mp4 |
66.89MB |
| 022 More on Correlated Subqueries__en.srt |
12.76KB |
| 022 More on Correlated Subqueries.mp4 |
27.85MB |
| 023 A Select Without a From___en.srt |
5.18KB |
| 023 A Select Without a From_.mp4 |
6.44MB |
| 024 Exercise Overview__en.srt |
1.19KB |
| 024 Exercise Overview.mp4 |
1.37MB |
| 025 Exercise Solution__en.srt |
1.70KB |
| 025 Exercise Solution.mp4 |
2.53MB |
| 28571441-009-joins-cheatsheet.pdf |
190.52KB |
| 28571891-010-access.zip |
62.58KB |
| 28571893-037-access.zip |
66.59KB |
| 28571899-034-access.zip |
66.14KB |
| 28571901-038-access.zip |
66.57KB |
| 28571903-027-access.zip |
64.52KB |
| 28571907-021-access.zip |
63.66KB |
| 28571915-019-access.zip |
63.56KB |
| 28571917-024-access.zip |
64.50KB |
| 28571925-025-access.zip |
64.51KB |
| 28571937-028-access.zip |
65.77KB |
| 28571943-036-access.zip |
66.48KB |
| 28571947-008-access.zip |
62.00KB |
| 28571955-035-access.zip |
66.14KB |
| 28571973-005-access-social-repo.zip |
61.31KB |
| 28572037-026-access.zip |
64.52KB |
| 28579121-003-sql.sql |
104B |
| 28579125-005-sql-cumulative.sql |
384B |
| 28579127-005-sql.sql |
278B |
| 28579131-012-sql.sql |
404B |
| 28579133-013-sql.sql |
48B |
| 28579153-007-tables-cumulative.sql |
172B |
| 28579155-007-tables.sql |
194B |
| 28579157-008-tables-cumulative.sql |
348B |
| 28579159-008-tables.sql |
197B |
| 28579161-009-tables-cumulative.sql |
536B |
| 28579163-009-tables.sql |
326B |
| 28579179-012-tables-cumulative.sql |
600B |
| 28579183-012-tables.sql |
199B |
| 28579187-014-tables-cumulative.sql |
994B |
| 28579189-014-tables.sql |
469B |
| 28579191-015-tables-cumulative.sql |
1.28KB |
| 28579193-015-tables.sql |
340B |
| 28595533-007-joins-cumulative.sql |
7.54KB |
| 28595535-010-sql-cumulative.sql |
7.59KB |
| 28595541-001-sq-data.sql |
15.82KB |
| 28595545-005-design.dbml |
455B |
| 28595559-002-db.sql |
375B |
| 28595561-003-db.sql |
791B |
| 28595563-004-db.sql |
1.11KB |
| 28595565-005-db.sql |
1.55KB |
| 28595567-006-db.sql |
2.19KB |
| 28595569-007-db.sql |
2.84KB |
| 28595573-ig.sql |
23.51MB |
| 28595583-005-index.js |
1.32KB |
| 28595585-01-lng-lat-to-loc.js |
364B |
| 37099256-diagrams.zip |
7.72MB |