|
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 |
| [FCS Forum].url |
133B |
| [FreeCourseSite.com].url |
127B |
| 1.1 013 - sql.sql |
48B |
| 1.1 ig.sql |
23.52MB |
| 1. Adding Some Data.html |
7.51KB |
| 1. Additional Features Around Posts.mp4 |
56.37MB |
| 1. Additional Features Around Posts.srt |
9.77KB |
| 1. Aggregating and Grouping.mp4 |
9.89MB |
| 1. Aggregating and Grouping.srt |
3.46KB |
| 1. A New Dataset.html |
17.13KB |
| 1. A Note on Testing.mp4 |
10.52MB |
| 1. A Note on Testing.srt |
4.84KB |
| 1. Approaching More Complicated Designs.mp4 |
15.68MB |
| 1. A Story on Migrations.mp4 |
112.29MB |
| 1. A Story on Migrations.srt |
27.19KB |
| 1. Back to Postgres.mp4 |
10.08MB |
| 1. Back to Postgres.srt |
3.19KB |
| 1. Bonus!.html |
2.96KB |
| 1. Common Table Expressions.mp4 |
11.93MB |
| 1. Common Table Expressions.srt |
2.89KB |
| 1. Designing a Follower System.mp4 |
33.56MB |
| 1. Designing a Follower System.srt |
8.96KB |
| 1. Designing a Hashtag System.mp4 |
67.51MB |
| 1. Designing a Hashtag System.srt |
11.64KB |
| 1. Developing an Intuitive Understanding of Cost.mp4 |
84.44MB |
| 1. Developing an Intuitive Understanding of Cost.srt |
19.87KB |
| 1. Filtering Rows with Where.mp4 |
16.88MB |
| 1. Filtering Rows with Where.srt |
5.63KB |
| 1. Full Table Scans.mp4 |
26.78MB |
| 1. Full Table Scans.srt |
6.34KB |
| 1. Handling Sets with Union.mp4 |
26.97MB |
| 1. Handling Sets with Union.srt |
8.53KB |
| 1. Join Our Community!.html |
271B |
| 1. Materialized Views.mp4 |
11.04MB |
| 1. Materialized Views.srt |
3.77KB |
| 1. Most Popular Users.mp4 |
30.02MB |
| 1. Most Popular Users.srt |
9.58KB |
| 1. PostgreSQL Installation on macOS.mp4 |
26.89MB |
| 1. PostgreSQL Installation on macOS.srt |
9.68KB |
| 1. Quick Note About Adding Some Data.html |
251B |
| 1. Recursive CTE's.mp4 |
16.97MB |
| 1. Recursive CTE's.srt |
4.91KB |
| 1. Requirements of a Like System.mp4 |
30.06MB |
| 1. Requirements of a Like System.srt |
7.53KB |
| 1. Schema vs Data Migrations.mp4 |
21.38MB |
| 1. Schema vs Data Migrations.srt |
6.25KB |
| 1. Section Goal.mp4 |
3.31MB |
| 1. Section Goal.srt |
1.47KB |
| 1. Selecting Distinct Values.mp4 |
17.97MB |
| 1. Selecting Distinct Values.srt |
6.32KB |
| 1. SQL Injection Exploits.mp4 |
33.19MB |
| 1. SQL Injection Exploits.srt |
10.51KB |
| 1. The Basics of Sorting.mp4 |
10.62MB |
| 1. The Basics of Sorting.srt |
3.50KB |
| 1. The Greatest Value in a List.mp4 |
14.57MB |
| 1. The Greatest Value in a List.srt |
4.92KB |
| 1. The Plan Moving Forward.mp4 |
8.81MB |
| 1. The Plan Moving Forward.srt |
2.72KB |
| 1. The Query Processing Pipeline.mp4 |
33.28MB |
| 1. The Query Processing Pipeline.srt |
7.95KB |
| 1. The Repository Pattern.mp4 |
21.00MB |
| 1. The Repository Pattern.srt |
5.54KB |
| 1. Thinking About Performance.mp4 |
9.48MB |
| 1. Thinking About Performance.srt |
3.57KB |
| 1. Thinking About Validation.mp4 |
28.67MB |
| 1. Thinking About Validation.srt |
6.67KB |
| 1. What'd We Just Do.mp4 |
22.86MB |
| 1. What'd We Just Do.srt |
6.37KB |
| 1. What's a Subquery.mp4 |
35.43MB |
| 1. What's a Subquery.srt |
8.67KB |
| 1. What are Transactions Used For.mp4 |
18.78MB |
| 1. What are Transactions Used For.srt |
6.25KB |
| 10. Adding a Validation Check.mp4 |
23.60MB |
| 10. Adding a Validation Check.srt |
5.96KB |
| 10. Behind the Scenes of Indexes.mp4 |
249.21MB |
| 10. Behind the Scenes of Indexes.srt |
47.52KB |
| 10. Calculated Columns.mp4 |
18.69MB |
| 10. Calculated Columns.srt |
7.14KB |
| 10. Calculations in Where Clauses.mp4 |
6.42MB |
| 10. Calculations in Where Clauses.srt |
3.00KB |
| 10. Controlling Schema Access with Search Paths.mp4 |
34.01MB |
| 10. Controlling Schema Access with Search Paths.srt |
8.54KB |
| 10. Example of a Subquery in a From.mp4 |
44.56MB |
| 10. Example of a Subquery in a From.srt |
13.34KB |
| 10. Foreign Keys; How Do They Work.html |
129B |
| 10. Grouping Solution.mp4 |
4.38MB |
| 10. Grouping Solution.srt |
2.10KB |
| 10. So Which Approach.mp4 |
24.82MB |
| 10. So Which Approach.srt |
6.83KB |
| 10. Updating Values.mp4 |
19.54MB |
| 10. Updating Values.srt |
6.27KB |
| 10. Why Wasn't It Included.mp4 |
20.81MB |
| 10. Why Wasn't It Included.srt |
3.68KB |
| 11.1 007 - tables - cumulative.sql |
172B |
| 11.1 009_-_joins_-_cheatsheet.pdf |
190.52KB |
| 11.1 01-lng-lat-to-loc.js |
364B |
| 11.2 007 - tables.sql |
194B |
| 11. Adding a Layer of Difficulty.mp4 |
2.70MB |
| 11. Adding a Layer of Difficulty.srt |
1.08KB |
| 11. Auto-Generated ID's.mp4 |
31.58MB |
| 11. Auto-Generated ID's.srt |
8.69KB |
| 11. Calculating Phone Revenue.mp4 |
5.50MB |
| 11. Calculating Phone Revenue.srt |
1.52KB |
| 11. Checks Over Multiple Columns.mp4 |
23.63MB |
| 11. Checks Over Multiple Columns.srt |
7.42KB |
| 11. Exercise Overview.mp4 |
5.03MB |
| 11. Exercise Overview.srt |
1.81KB |
| 11. Four Kinds of Joins.mp4 |
86.43MB |
| 11. Four Kinds of Joins.srt |
14.40KB |
| 11. Migrations Setup Instructions.html |
925B |
| 11. Routing Schema Access.mp4 |
26.30MB |
| 11. Routing Schema Access.srt |
6.43KB |
| 11. Trying Calculations in Where Clauses.html |
129B |
| 12.1 008 - tables.sql |
197B |
| 12.1 010 - sql - cumulative.sql |
7.59KB |
| 12.2 008 - tables - cumulative.sql |
348B |
| 12. Creating Foreign Key Columns.mp4 |
23.25MB |
| 12. Creating Foreign Key Columns.srt |
7.25KB |
| 12. Does It Pass a Check.html |
129B |
| 12. Each Join in Practice.mp4 |
34.27MB |
| 12. Each Join in Practice.srt |
6.11KB |
| 12. Grouping With a Join!.html |
129B |
| 12. Solving Calculations.mp4 |
8.28MB |
| 12. Strategy for Isolation.mp4 |
25.18MB |
| 12. Strategy for Isolation.srt |
7.01KB |
| 12. Subquery From's.html |
129B |
| 12. Updating the App Server.mp4 |
22.55MB |
| 12. Updating the App Server.srt |
6.42KB |
| 12. Using Calculated Columns.html |
129B |
| 13.1 009 - tables.sql |
326B |
| 13.1 034_-_access.zip |
66.14KB |
| 13.2 009 - tables - cumulative.sql |
536B |
| 13. Does Order Matter.mp4 |
37.26MB |
| 13. Does Order Matter.srt |
6.26KB |
| 13. Dropping the Last Columns.mp4 |
14.48MB |
| 13. Exercise Solution.mp4 |
4.22MB |
| 13. Exercise Solution.mp4 |
7.50MB |
| 13. Exercise Solution.srt |
1.57KB |
| 13. Programmatic Schema Creation.mp4 |
76.23MB |
| 13. Programmatic Schema Creation.srt |
17.71KB |
| 13. Running Queries on Associated Data.mp4 |
31.66MB |
| 13. Running Queries on Associated Data.srt |
10.06KB |
| 13. Solution.mp4 |
5.01MB |
| 13. Solution.srt |
2.13KB |
| 13. So Where Are We Applying Validation.mp4 |
31.00MB |
| 13. So Where Are We Applying Validation.srt |
9.63KB |
| 13. Updating Rows.mp4 |
20.87MB |
| 13. Updating Rows.srt |
6.29KB |
| 14.1 012 - sql.sql |
404B |
| 14.1 035_-_access.zip |
66.14KB |
| 14. Deleting Rows.mp4 |
18.06MB |
| 14. Deleting Rows.srt |
4.87KB |
| 14. Escaping Identifiers.mp4 |
29.82MB |
| 14. Escaping Identifiers.srt |
6.23KB |
| 14. Exercise Overview.mp4 |
11.60MB |
| 14. Exercise Overview.srt |
3.31KB |
| 14. Filtering Groups with Having.mp4 |
26.01MB |
| 14. Filtering Groups with Having.srt |
7.54KB |
| 14. String Operators and Functions.mp4 |
24.40MB |
| 14. String Operators and Functions.srt |
9.62KB |
| 14. Subqueries in a Join Clause.mp4 |
24.44MB |
| 14. Subqueries in a Join Clause.srt |
6.65KB |
| 14. Test Your Joining Knowledge.html |
129B |
| 15.1 036_-_access.zip |
66.48KB |
| 15. Creating and Using Foreign Keys.html |
129B |
| 15. Exercise Overview.mp4 |
3.44MB |
| 15. Exercise Overview.srt |
1.43KB |
| 15. Having In Action.mp4 |
11.76MB |
| 15. Having In Action.srt |
3.87KB |
| 15. More Useful - Subqueries with Where.mp4 |
42.98MB |
| 15. More Useful - Subqueries with Where.srt |
13.31KB |
| 15. Test Helpers.mp4 |
35.54MB |
| 15. Test Helpers.srt |
7.74KB |
| 15. Try Updating Records In a Table!.html |
129B |
| 16.1 037_-_access.zip |
66.59KB |
| 16. A Solution for Updating Rows.mp4 |
7.28MB |
| 16. A Solution for Updating Rows.srt |
2.13KB |
| 16. Cleaning up Schemas and Roles.mp4 |
45.03MB |
| 16. Cleaning up Schemas and Roles.srt |
7.96KB |
| 16. Data Structure with Where Subqueries.mp4 |
35.39MB |
| 16. Data Structure with Where Subqueries.srt |
8.72KB |
| 16. Foreign Key Creation Solution.mp4 |
11.57MB |
| 16. Foreign Key Creation Solution.srt |
2.95KB |
| 16. Joins, Joins, Join!.html |
129B |
| 16. More on Having!.mp4 |
36.51MB |
| 16. More on Having!.srt |
10.20KB |
| 17.1 012 - tables.sql |
199B |
| 17.1 038_-_access.zip |
66.57KB |
| 17.2 012 - tables - cumulative.sql |
600B |
| 17. A Having Exercise Overview.mp4 |
19.45MB |
| 17. A Having Exercise Overview.srt |
5.36KB |
| 17. Exercise Overview.mp4 |
4.30MB |
| 17. Finally... Parallel Tests!.mp4 |
26.53MB |
| 17. Finally... Parallel Tests!.srt |
5.15KB |
| 17. Foreign Key Constraints Around Insertion.mp4 |
27.51MB |
| 17. Foreign Key Constraints Around Insertion.srt |
8.50KB |
| 17. Practice Deleting Records.html |
129B |
| 17. Two Possible Solutions.mp4 |
21.13MB |
| 17. Two Possible Solutions.srt |
4.60KB |
| 18. Constraints Around Deletion.mp4 |
29.38MB |
| 18. Constraints Around Deletion.srt |
7.46KB |
| 18. Practice Yourself Some Having.html |
129B |
| 18. Solution for Deleting Rows.mp4 |
5.44MB |
| 18. Solution for Deleting Rows.srt |
1.96KB |
| 18. Subquery Where's.html |
129B |
| 18. Where with Join.mp4 |
37.79MB |
| 18. Where with Join.srt |
10.03KB |
| 19. A Quick Solution.mp4 |
10.52MB |
| 19. A Quick Solution.srt |
3.69KB |
| 19. Commands You’ll Need for the Next Video.html |
676B |
| 19. Exercise Solution.mp4 |
9.14MB |
| 19. Exercise Solution.srt |
3.02KB |
| 19. Three Way Joins.mp4 |
54.37MB |
| 19. Three Way Joins.srt |
11.90KB |
| 2.1 001 - sq - data.sql |
15.82KB |
| 2.1 002 - db.sql |
375B |
| 2.1 010_-_access.zip |
62.58KB |
| 2. Adding Captions and Locations.mp4 |
11.82MB |
| 2. Adding Captions and Locations.srt |
2.56KB |
| 2. Adding Some Data.mp4 |
21.47MB |
| 2. Adding Some Data.srt |
6.44KB |
| 2. A Few Notes on Union.mp4 |
21.00MB |
| 2. A Few Notes on Union.srt |
5.53KB |
| 2. And the Least Value in a List!.mp4 |
8.69MB |
| 2. And the Least Value in a List!.srt |
2.95KB |
| 2. A Possible Solution for Merging Tables.mp4 |
30.29MB |
| 2. A Possible Solution for Merging Tables.srt |
6.07KB |
| 2. Approaching Database Design.mp4 |
50.45MB |
| 2. Approaching Database Design.srt |
11.75KB |
| 2. A Quick Solution.mp4 |
20.69MB |
| 2. A Quick Solution.srt |
5.49KB |
| 2. Assertions Around User Count.mp4 |
35.32MB |
| 2. Assertions Around User Count.srt |
10.32KB |
| 2. Calculating Cost by Hand.mp4 |
41.84MB |
| 2. Calculating Cost by Hand.srt |
9.82KB |
| 2. Creating and Viewing Tables in PGAdmin.mp4 |
36.26MB |
| 2. Creating and Viewing Tables in PGAdmin.srt |
11.23KB |
| 2. Creating a Repository.mp4 |
38.19MB |
| 2. Creating a Repository.srt |
12.30KB |
| 2. Creating Tables with Checks.mp4 |
67.52MB |
| 2. Creating Tables with Checks.srt |
20.44KB |
| 2. Dangers Around Data Migrations.mp4 |
58.12MB |
| 2. Dangers Around Data Migrations.srt |
14.15KB |
| 2. Data Types.mp4 |
24.48MB |
| 2. Data Types.srt |
6.98KB |
| 2. Exercise Overview.mp4 |
2.02MB |
| 2. Exercise Overview.srt |
874B |
| 2. Explain and Explain Analyze.mp4 |
30.56MB |
| 2. Explain and Explain Analyze.srt |
8.13KB |
| 2. Grouping by Week.mp4 |
25.27MB |
| 2. Grouping by Week.srt |
6.21KB |
| 2. Handling SQL Injection with Prepared Statements.mp4 |
41.57MB |
| 2. Handling SQL Injection with Prepared Statements.srt |
12.46KB |
| 2. How Not to Design a Like System.mp4 |
19.63MB |
| 2. How Not to Design a Like System.srt |
4.71KB |
| 2. Initial Setup.mp4 |
3.46MB |
| 2. Investigating This Dataset.mp4 |
11.06MB |
| 2. Migration Files.mp4 |
32.41MB |
| 2. Migration Files.srt |
7.33KB |
| 2. More on the Where Keyword.mp4 |
13.10MB |
| 2. More on the Where Keyword.srt |
3.75KB |
| 2. PGAdmin Setup on macOS.mp4 |
24.23MB |
| 2. PGAdmin Setup on macOS.srt |
7.53KB |
| 2. Picturing Group By.mp4 |
33.17MB |
| 2. Picturing Group By.srt |
8.05KB |
| 2. Queries with Joins and Aggregations.mp4 |
21.75MB |
| 2. Queries with Joins and Aggregations.srt |
5.06KB |
| 2. Recursive CTE's Step by Step.mp4 |
70.12MB |
| 2. Recursive CTE's Step by Step.srt |
15.15KB |
| 2. Some Sample Data.mp4 |
7.61MB |
| 2. Some Sample Data.srt |
3.06KB |
| 2. Tables for Hashtags.mp4 |
16.81MB |
| 2. Tables for Hashtags.srt |
5.65KB |
| 2. Thinking About the Structure of Data.mp4 |
26.03MB |
| 2. Thinking About the Structure of Data.srt |
7.37KB |
| 2. Two Variations on Sorting.mp4 |
14.18MB |
| 2. Two Variations on Sorting.srt |
4.01KB |
| 2. Using a SQL Design Tool.mp4 |
38.19MB |
| 2. Using a SQL Design Tool.srt |
9.66KB |
| 2. What's an Index.mp4 |
12.93MB |
| 2. What's an Index.srt |
3.88KB |
| 2. What is PostgreSQL All About.mp4 |
21.76MB |
| 2. What is PostgreSQL All About.srt |
7.24KB |
| 2. Where Does Postgres Store Data.mp4 |
38.93MB |
| 2. Where Does Postgres Store Data.srt |
8.63KB |
| 20.1 014 - tables - cumulative.sql |
994B |
| 20.2 014 - tables.sql |
469B |
| 20. A Bit of Practice.mp4 |
26.29MB |
| 20. A Bit of Practice.srt |
7.47KB |
| 20. Testing Deletion Constraints.mp4 |
25.58MB |
| 20. Testing Deletion Constraints.srt |
6.58KB |
| 20. The Not In Operator with a List.mp4 |
25.08MB |
| 20. The Not In Operator with a List.srt |
6.28KB |
| 21.1 015 - tables - cumulative.sql |
1.28KB |
| 21.2 015 - tables.sql |
340B |
| 21. A New Where Operator.mp4 |
43.51MB |
| 21. A New Where Operator.srt |
9.42KB |
| 21. Setting Foreign Keys to Null on Delete.mp4 |
14.71MB |
| 21. Setting Foreign Keys to Null on Delete.srt |
4.29KB |
| 21. Three Way Exercise.html |
129B |
| 22. Exercise Solution.mp4 |
11.96MB |
| 22. Exercise Solution.srt |
3.88KB |
| 22. Finally Some!.mp4 |
35.30MB |
| 22. Finally Some!.srt |
8.03KB |
| 22. What Happens On Delete.html |
129B |
| 23. Adding Some Complexity.mp4 |
13.22MB |
| 23. Adding Some Complexity.srt |
4.66KB |
| 23. Is It A Valid Subquery.html |
129B |
| 24. Exercise Overview.mp4 |
1.72MB |
| 24. Exercise Overview.srt |
741B |
| 25. Practice Your Subqueries!.html |
129B |
| 26. A Quick Solution.mp4 |
6.02MB |
| 26. A Quick Solution.srt |
2.38KB |
| 27. Probably Too Much About Correlated Subqueries.mp4 |
120.99MB |
| 27. Probably Too Much About Correlated Subqueries.srt |
24.57KB |
| 28. More on Correlated Subqueries.mp4 |
54.17MB |
| 28. More on Correlated Subqueries.srt |
12.76KB |
| 29. A Select Without a From.mp4 |
12.47MB |
| 29. A Select Without a From.srt |
5.17KB |
| 3.1 003 - db.sql |
791B |
| 3.1 024_-_access.zip |
64.50KB |
| 3. Accessing the API.mp4 |
17.16MB |
| 3. A Config-based Schema Designer.mp4 |
35.63MB |
| 3. A Config-based Schema Designer.srt |
11.51KB |
| 3. Applying a Null Constraint.mp4 |
32.09MB |
| 3. Applying a Null Constraint.srt |
9.98KB |
| 3. A Touch More on Costs.mp4 |
58.19MB |
| 3. A Touch More on Costs.srt |
11.17KB |
| 3. Commonalities with Intersect.mp4 |
17.12MB |
| 3. Commonalities with Intersect.srt |
4.90KB |
| 3. Compound Where Clauses.mp4 |
24.06MB |
| 3. Compound Where Clauses.srt |
7.41KB |
| 3. Connecting to a DB For Tests.mp4 |
34.03MB |
| 3. Connecting to a DB For Tests.srt |
7.98KB |
| 3. Creating a View.mp4 |
36.46MB |
| 3. Creating a View.srt |
8.29KB |
| 3. Database Design.mp4 |
35.40MB |
| 3. Database Design.srt |
7.97KB |
| 3. Designing a Like System.mp4 |
30.33MB |
| 3. Designing a Like System.srt |
8.07KB |
| 3. Explain Vs Explain Analyze.html |
129B |
| 3. Fast Rules on Numeric Data Types.mp4 |
12.88MB |
| 3. Fast Rules on Numeric Data Types.srt |
3.49KB |
| 3. Heaps, Blocks, and Tuples.mp4 |
17.91MB |
| 3. Heaps, Blocks, and Tuples.srt |
5.62KB |
| 3. How an Index Works.mp4 |
57.11MB |
| 3. How an Index Works.srt |
11.99KB |
| 3. Including the Hashtag Table.mp4 |
20.30MB |
| 3. Including the Hashtag Table.srt |
5.77KB |
| 3. Issues Solved by Migrations.mp4 |
13.40MB |
| 3. Issues Solved by Migrations.srt |
4.39KB |
| 3. Joining Data from Different Tables.mp4 |
48.14MB |
| 3. Joining Data from Different Tables.srt |
11.51KB |
| 3. Let's Design Some Schema.html |
129B |
| 3. Offset and Limit.mp4 |
27.57MB |
| 3. One Fast Migration.mp4 |
29.70MB |
| 3. One Fast Migration.srt |
7.09KB |
| 3. Opening and Closing Transactions.mp4 |
54.67MB |
| 3. Opening and Closing Transactions.srt |
14.75KB |
| 3. Photo Mentions vs Caption Mentions.mp4 |
63.23MB |
| 3. Photo Mentions vs Caption Mentions.srt |
12.33KB |
| 3. Postgres installation on Windows.mp4 |
26.58MB |
| 3. Postgres installation on Windows.srt |
6.41KB |
| 3. Posts Creation.mp4 |
45.39MB |
| 3. Posts Creation.srt |
12.42KB |
| 3. Preventing SQL Injection.mp4 |
40.04MB |
| 3. Preventing SQL Injection.srt |
11.26KB |
| 3. Properly Running Data and Schema Migrations.mp4 |
27.16MB |
| 3. Properly Running Data and Schema Migrations.srt |
8.64KB |
| 3. Reminder on Left Joins.mp4 |
24.53MB |
| 3. Reminder on Left Joins.srt |
6.71KB |
| 3. Restoring from Scratch.mp4 |
23.76MB |
| 3. Restoring from Scratch.srt |
6.80KB |
| 3. Selecting Columns After Grouping.html |
129B |
| 3. Some Group By Practice.mp4 |
4.28MB |
| 3. Some Group By Practice.srt |
1.97KB |
| 3. Some Practice with Distinct.html |
129B |
| 3. So What's a CTE.mp4 |
27.27MB |
| 3. So What's a CTE.srt |
5.62KB |
| 3. The Case Keyword.mp4 |
19.04MB |
| 3. The Case Keyword.srt |
6.53KB |
| 3. What's the Data Look Like.html |
129B |
| 3. Why Use Recursive CTE's.mp4 |
29.10MB |
| 30. Exercise Overview.mp4 |
2.95MB |
| 30. Exercise Overview.srt |
1.19KB |
| 31. From-less Selects.html |
129B |
| 32. Exercise Solution.mp4 |
5.08MB |
| 32. Exercise Solution.srt |
1.70KB |
| 4.1 004 - db.sql |
1.11KB |
| 4.1 005_-_access_-_social-repo.zip |
61.31KB |
| 4.1 025_-_access.zip |
64.51KB |
| 4. A Distinct Solution.mp4 |
2.69MB |
| 4. A Distinct Solution.srt |
929B |
| 4. A Few More User Columns.mp4 |
44.56MB |
| 4. A Few More User Columns.srt |
9.56KB |
| 4. A Few Notes on Migrations Libraries.mp4 |
28.89MB |
| 4. A Few Notes on Migrations Libraries.srt |
7.60KB |
| 4. Aggregate Functions.mp4 |
15.21MB |
| 4. Aggregate Functions.srt |
4.41KB |
| 4. Another Quick Join.mp4 |
14.22MB |
| 4. Another Quick Join.srt |
3.15KB |
| 4. A Where Exercise Overview.mp4 |
2.47MB |
| 4. A Where Exercise Overview.srt |
960B |
| 4. Building a Similar System.html |
129B |
| 4. Building the Users Router.mp4 |
25.24MB |
| 4. Building the Users Router.srt |
6.59KB |
| 4. Calculating Costs.html |
129B |
| 4. Casing Issues.mp4 |
23.21MB |
| 4. Casing Issues.srt |
6.85KB |
| 4. Comments Creation.mp4 |
10.41MB |
| 4. Comments Creation.srt |
3.36KB |
| 4. Considerations on Photo Tags vs Caption Tags.mp4 |
47.45MB |
| 4. Considerations on Photo Tags vs Caption Tags.srt |
11.33KB |
| 4. Creating an Index.mp4 |
19.34MB |
| 4. Creating an Index.srt |
6.09KB |
| 4. Creating a Posts Table.mp4 |
24.14MB |
| 4. Creating a Posts Table.srt |
6.67KB |
| 4. Database Terminology.html |
129B |
| 4. Disconnecting After Tests.mp4 |
16.94MB |
| 4. Disconnecting After Tests.srt |
4.48KB |
| 4. Exercise Overview.mp4 |
1.55MB |
| 4. Exercise Overview.srt |
690B |
| 4. Group By Review.html |
129B |
| 4. Here's the Plan.mp4 |
14.52MB |
| 4. Here's the Plan.srt |
4.15KB |
| 4. Highest User ID's Exercise.mp4 |
7.87MB |
| 4. Highest User ID's Exercise.srt |
3.02KB |
| 4. More on Number Data Types.mp4 |
55.56MB |
| 4. More on Number Data Types.srt |
14.37KB |
| 4. One-to-Many and Many-to-One Relationships.mp4 |
38.57MB |
| 4. One-to-Many and Many-to-One Relationships.srt |
9.84KB |
| 4. Reminder on Post Requests.mp4 |
16.28MB |
| 4. Reminder on Post Requests.srt |
4.06KB |
| 4. Removing Commonalities with Except.mp4 |
29.65MB |
| 4. Removing Commonalities with Except.srt |
9.21KB |
| 4. Solving a Gotcha with Null Constraints.mp4 |
20.54MB |
| 4. Solving a Gotcha with Null Constraints.srt |
6.30KB |
| 4. Solving an Explain Mystery.mp4 |
65.38MB |
| 4. Solving an Explain Mystery.srt |
13.66KB |
| 4. Subqueries in a Select.mp4 |
28.13MB |
| 4. Subqueries in a Select.srt |
8.29KB |
| 4. Terminology Check.html |
129B |
| 4. Transaction Cleanup on Crash.mp4 |
27.59MB |
| 4. Transaction Cleanup on Crash.srt |
5.96KB |
| 4. When to Use a View.mp4 |
26.10MB |
| 4. When to Use a View.srt |
4.85KB |
| 4. Writing a Slow Query.mp4 |
62.54MB |
| 4. Writing a Slow Query.srt |
13.60KB |
| 4. Writing the Query.mp4 |
45.23MB |
| 4. Writing the Query.srt |
11.58KB |
| 5.1 003 - sql.sql |
104B |
| 5.1 005 - db.sql |
1.55KB |
| 5.1 005 - design.dbml |
455B |
| 5.1 005 - index.js |
1.32KB |
| 5.1 019_-_access.zip |
63.56KB |
| 5.1 026_-_access.zip |
64.52KB |
| 5. A 'Has One' or 'Has Many'.html |
129B |
| 5. A Note About Node Installation.html |
264B |
| 5. A Small Web Server.mp4 |
71.67MB |
| 5. A Small Web Server.srt |
20.38KB |
| 5. Benchmarking Queries.mp4 |
27.74MB |
| 5. Benchmarking Queries.srt |
8.29KB |
| 5. Block Data Layout.mp4 |
20.98MB |
| 5. Block Data Layout.srt |
6.75KB |
| 5. Closing Aborted Transactions.mp4 |
9.90MB |
| 5. Closing Aborted Transactions.srt |
2.67KB |
| 5. Combining Group By and Aggregates.mp4 |
22.20MB |
| 5. Combining Group By and Aggregates.srt |
7.03KB |
| 5. Creating and Refreshing Materialized Views.mp4 |
47.82MB |
| 5. Creating NULL Constraints.html |
129B |
| 5. Creating Tables.mp4 |
18.63MB |
| 5. Creating Tables.srt |
7.49KB |
| 5. Deleting and Changing Views.mp4 |
16.51MB |
| 5. Deleting and Changing Views.srt |
3.60KB |
| 5. Exercise Overview.mp4 |
7.84MB |
| 5. Exercise Overview.mp4 |
5.17MB |
| 5. Exercise Overview.srt |
1.73KB |
| 5. Exercise Overview.srt |
1.69KB |
| 5. Fixing Casing.mp4 |
39.39MB |
| 5. Fixing Casing.srt |
9.31KB |
| 5. Group By Review Solution.mp4 |
12.55MB |
| 5. Group By Review Solution.srt |
3.42KB |
| 5. Inserting Users.mp4 |
24.82MB |
| 5. Inserting Users.srt |
6.11KB |
| 5. Likes Creation.mp4 |
35.37MB |
| 5. Likes Creation.srt |
9.73KB |
| 5. Making a Reaction System Instead.mp4 |
8.98MB |
| 5. Making a Reaction System Instead.srt |
2.47KB |
| 5. Multi-DB Setup.mp4 |
28.20MB |
| 5. Multi-DB Setup.srt |
7.31KB |
| 5. Practicing Where Statements.html |
129B |
| 5. Rebuilding Some Schema.mp4 |
31.24MB |
| 5. Rebuilding Some Schema.srt |
10.33KB |
| 5. Reminder on Character Types.mp4 |
24.84MB |
| 5. Reminder on Character Types.srt |
7.33KB |
| 5. Solution for User ID's.mp4 |
6.37MB |
| 5. Solution for User ID's.srt |
1.78KB |
| 5. Sorting, Offsetting, and Limiting.html |
129B |
| 5. Startup vs Total Costs.mp4 |
35.79MB |
| 5. Startup vs Total Costs.srt |
8.87KB |
| 5. Understanding Connection Pools.mp4 |
24.21MB |
| 5. Understanding Connection Pools.srt |
10.34KB |
| 5. Union Exercise Overview.mp4 |
6.06MB |
| 5. Union Exercise Overview.srt |
2.19KB |
| 5. Update For Tags.mp4 |
30.36MB |
| 5. Update For Tags.srt |
7.19KB |
| 5. Walking Through Recursion.mp4 |
77.08MB |
| 5. Walking Through Recursion.srt |
14.59KB |
| 5. Why No Number of Followers or Posts.mp4 |
22.09MB |
| 5. Why No Number of Followers or Posts.srt |
5.90KB |
| 6.1 006 - db.sql |
2.19KB |
| 6.1 027_-_access.zip |
64.52KB |
| 6. A Gotcha with Count.mp4 |
8.09MB |
| 6. A Gotcha with Count.srt |
4.04KB |
| 6. Analyzing CREATE TABLE.mp4 |
19.14MB |
| 6. Analyzing CREATE TABLE.srt |
5.36KB |
| 6. Assumptions Around Content.mp4 |
27.27MB |
| 6. Assumptions Around Content.srt |
8.00KB |
| 6. A Where Solution.mp4 |
3.68MB |
| 6. A Where Solution.srt |
1.31KB |
| 6. Boolean Data Types.mp4 |
13.12MB |
| 6. Boolean Data Types.srt |
3.77KB |
| 6. Costs Flow Up.mp4 |
13.45MB |
| 6. Costs Flow Up.srt |
3.03KB |
| 6. Default Column Values.mp4 |
18.73MB |
| 6. Downsides of Indexes.mp4 |
24.79MB |
| 6. Downsides of Indexes.srt |
8.02KB |
| 6. Embedding in Select.html |
129B |
| 6. Exercise Solution.mp4 |
5.02MB |
| 6. Exercise Solution.srt |
1.99KB |
| 6. Finding Particular Users.mp4 |
28.40MB |
| 6. Finding Particular Users.srt |
7.97KB |
| 6. Handling Updates.mp4 |
29.95MB |
| 6. Handling Updates.srt |
6.61KB |
| 6. Heap File Layout.mp4 |
345.28MB |
| 6. Heap File Layout.srt |
48.34KB |
| 6. Merging Results with Union.html |
129B |
| 6. One-to-One and Many-to-Many Relationships.mp4 |
35.68MB |
| 6. One-to-One and Many-to-Many Relationships.srt |
8.51KB |
| 6. Photo Tags and Caption Tags.mp4 |
28.45MB |
| 6. Photo Tags and Caption Tags.srt |
8.04KB |
| 6. Polymorphic Associations.mp4 |
36.24MB |
| 6. Polymorphic Associations.srt |
9.40KB |
| 6. Posts by a Particular User.mp4 |
6.87MB |
| 6. Posts by a Particular User.srt |
1.72KB |
| 6. Practice Joining Data.html |
129B |
| 6. Project Creation.mp4 |
13.86MB |
| 6. Project Creation.srt |
4.40KB |
| 6. Remember Joins.mp4 |
14.53MB |
| 6. Remember Joins.srt |
3.44KB |
| 6. Validating Connection Credentials.mp4 |
32.43MB |
| 6. Validating Connection Credentials.srt |
10.34KB |
| 6. Views vs Materialized Views.html |
129B |
| 6. Web Server Setup Instructions.html |
1.02KB |
| 7.1 005 - sql.sql |
278B |
| 7.1 007 - db.sql |
2.84KB |
| 7.1 008_-_access.zip |
62.00KB |
| 7.1 021_-_access.zip |
63.66KB |
| 7.1 028_-_access.zip |
65.77KB |
| 7.2 005 - sql - cumulative.sql |
384B |
| 7. Adding the Loc Column.mp4 |
18.15MB |
| 7. Adding the Loc Column.srt |
5.89KB |
| 7. A Joinful Solution.mp4 |
8.71MB |
| 7. A Joinful Solution.srt |
2.50KB |
| 7. And, Finally, Delete.mp4 |
25.91MB |
| 7. And, Finally, Delete.srt |
6.13KB |
| 7. Applying a Unique Constraint to One column.mp4 |
31.04MB |
| 7. Applying a Unique Constraint to One column.srt |
8.63KB |
| 7. Creating Hashtags, Hashtag Posts, and Followers.mp4 |
29.37MB |
| 7. Creating Hashtags, Hashtag Posts, and Followers.srt |
8.81KB |
| 7. Exercise Solution.mp4 |
6.99MB |
| 7. Exercise Solution.srt |
2.02KB |
| 7. Generating and Writing Migrations.mp4 |
38.62MB |
| 7. Generating and Writing Migrations.srt |
10.20KB |
| 7. Identifying One-to-One and Many-to-Many Relationships.html |
129B |
| 7. Index Types.mp4 |
9.83MB |
| 7. Index Types.srt |
2.51KB |
| 7. Inner Join Review.html |
129B |
| 7. Inserting Data Into a Table.mp4 |
19.74MB |
| 7. Inserting Data Into a Table.srt |
7.37KB |
| 7. Issues with Parallel Tests.mp4 |
29.55MB |
| 7. Issues with Parallel Tests.srt |
7.72KB |
| 7. Polymorphic Association Alternative Implementation.mp4 |
42.41MB |
| 7. Polymorphic Association Alternative Implementation.srt |
10.62KB |
| 7. Query and Close.mp4 |
8.85MB |
| 7. Query and Close.srt |
3.03KB |
| 7. Select Solution.mp4 |
5.66MB |
| 7. Select Solution.srt |
1.77KB |
| 7. Solving for Posts by User.mp4 |
13.73MB |
| 7. Solving for Posts by User.srt |
2.74KB |
| 7. Times, Dates, and Timestamps.mp4 |
27.13MB |
| 7. Times, Dates, and Timestamps.srt |
8.15KB |
| 7. Use My Index!.mp4 |
42.47MB |
| 7. Use My Index!.srt |
12.43KB |
| 7. Visualizing More Grouping.mp4 |
15.19MB |
| 7. Visualizing More Grouping.srt |
4.45KB |
| 7. Where With Lists.mp4 |
2.09MB |
| 7. Where With Lists.srt |
1.02KB |
| 8. Alternate Forms of Syntax.mp4 |
28.03MB |
| 8. Alternate Forms of Syntax.srt |
9.11KB |
| 8. A More Challenging 'Where'.html |
129B |
| 8. Applying and Reverting Migrations.mp4 |
43.00MB |
| 8. Applying and Reverting Migrations.srt |
10.90KB |
| 8. Automatically Generated Indexes.mp4 |
21.16MB |
| 8. Automatically Generated Indexes.srt |
5.58KB |
| 8. Exercise Overview.mp4 |
2.65MB |
| 8. Exercise Overview.srt |
1.12KB |
| 8. Isolation with Schemas.mp4 |
22.08MB |
| 8. Isolation with Schemas.srt |
6.39KB |
| 8. Likes Per User.mp4 |
4.78MB |
| 8. Multi-Column Uniqueness.mp4 |
21.30MB |
| 8. Multi-Column Uniqueness.srt |
5.08KB |
| 8. Of Course You Remember!.mp4 |
6.95MB |
| 8. Of Course You Remember!.srt |
2.05KB |
| 8. Primary Keys and Foreign Keys.mp4 |
34.34MB |
| 8. Primary Keys and Foreign Keys.srt |
7.68KB |
| 8. Really Awesome Intervals.mp4 |
23.92MB |
| 8. Really Awesome Intervals.srt |
8.81KB |
| 8. Retrieving Data with Select.mp4 |
9.25MB |
| 8. Retrieving Data with Select.srt |
3.21KB |
| 8. Subqueries in a From.mp4 |
46.93MB |
| 8. Subqueries in a From.srt |
11.68KB |
| 8. The Simplest Alternative.mp4 |
21.64MB |
| 8. The Simplest Alternative.srt |
5.96KB |
| 8. Writing Values to Both Columns.mp4 |
21.57MB |
| 8. Writing Values to Both Columns.srt |
6.30KB |
| 9.1 007 - joins - cumulative.sql |
7.54KB |
| 9. A Where With Lists Solution.mp4 |
7.31MB |
| 9. A Where With Lists Solution.srt |
2.29KB |
| 9. Create, Insert, and Select!.html |
129B |
| 9. Creating and Accessing Schemas.mp4 |
30.01MB |
| 9. Creating and Accessing Schemas.srt |
7.81KB |
| 9. From Subqueries that Return a Value.mp4 |
13.37MB |
| 9. From Subqueries that Return a Value.srt |
4.21KB |
| 9. Generating and Applying a Second Migration.mp4 |
20.05MB |
| 9. Generating and Applying a Second Migration.srt |
5.03KB |
| 9. Is It Unique.html |
129B |
| 9. Missing Data in Joins.mp4 |
36.75MB |
| 9. Missing Data in Joins.srt |
9.53KB |
| 9. Polymorphic Associations.html |
129B |
| 9. Practice For Grouping and Aggregating.html |
129B |
| 9. Solution for Likes Per User.mp4 |
8.17MB |
| 9. Solution for Likes Per User.srt |
2.42KB |
| 9. Transaction Locks.mp4 |
71.18MB |
| 9. Transaction Locks.srt |
21.70KB |
| 9. Understanding Foreign Keys.mp4 |
50.51MB |
| 9. Understanding Foreign Keys.srt |
12.60KB |
| 9. Using Automatically Created Indexes.html |
129B |