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