磁力链接

magnet:?xt=urn:btih:EF1F1B1C6A503C66D0D04D3CF5D817AB66241E47
推荐使用PIKPAK网盘下载资源,PIKPAK是目前最好用网盘,10T超大空间,不和谐任何资源,支持无限次数离线下载,视频在线观看

资源截图

API Integration

文件列表

  • 03. Day 3 - Basics Grouping/19. flights_db.tar 103.9 MB
  • 16. Extra Day CTEs (Common Table Expressions)/6. Common Table Expressions - Using Multiple CTEs.mp4 85.1 MB
  • 06. Day 6 - Intermediate Joins/2. INNER JOIN - Theory.mp4 74.8 MB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/13. Execution plan & query performance.mp4 74.7 MB
  • 11. Day 11 - Pro Window Functions/1. OVER() with PARTITION BY.mp4 74.3 MB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/4. Privileges - Hands-on.mp4 71.9 MB
  • 10. Day 10 - Advanced Views & Data Manipulation/17. Import & Export.mp4 70.8 MB
  • 07. Day 7 - Advanced UNION & Subqueries/19. Solution More challenges.mp4 69.6 MB
  • 09. Day 9 - Advanced Managing tables & databases/4. Data Types.mp4 64.4 MB
  • 07. Day 7 - Advanced UNION & Subqueries/14. Correlated Subqueries in WHERE.mp4 63.3 MB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/9. Stored procedures.mp4 63.1 MB
  • 04. Day 4 - Intermediate Functions/22. TO_CHAR.mp4 58.8 MB
  • 08. Day 8 - Advanced Course project/16. Solution 13.mp4 58.5 MB
  • 06. Day 6 - Intermediate Joins/3. INNER JOIN - Practice.mp4 57.9 MB
  • 16. Extra Day CTEs (Common Table Expressions)/10. Recursive CTEs - Hierarchical Data.mp4 57.3 MB
  • 05. Day 5 - Intermediate Conditional Expressions/10. Solution CASE WHEN.mp4 57.1 MB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/12. Self joins.mp4 56.9 MB
  • 04. Day 4 - Intermediate Functions/19. EXTRACT.mp4 55.9 MB
  • 03. Day 3 - Basics Grouping/17. Introducing the second project.mp4 55.8 MB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/6. ROLLUP.mp4 54.7 MB
  • 09. Day 9 - Advanced Managing tables & databases/20. Solution CHECK.mp4 54.7 MB
  • 11. Day 11 - Pro Window Functions/7. RANK().mp4 54.4 MB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/2. CREATE USER ROLE.mp4 52.8 MB
  • 04. Day 4 - Intermediate Functions/16. SUBSTRING.mp4 52.4 MB
  • 08. Day 8 - Advanced Course project/1. Project Introduction.mp4 52.3 MB
  • 05. Day 5 - Intermediate Conditional Expressions/11. CASE WHEN & SUM.mp4 52.3 MB
  • 02. Day 2 - Basics Filtering/22. LIKE.mp4 52.0 MB
  • 06. Day 6 - Intermediate Joins/14. Joins on multiple conditions.mp4 51.7 MB
  • 16. Extra Day CTEs (Common Table Expressions)/3. Common Table Expressions - More Complex Example.mp4 51.4 MB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/11. Creating indexes.mp4 51.1 MB
  • 07. Day 7 - Advanced UNION & Subqueries/1. UNION.mp4 50.8 MB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/3. GRANT & REVOKE privileges.mp4 50.6 MB
  • 16. Extra Day CTEs (Common Table Expressions)/2. Common Table Expressions (CTEs) - First Example.mp4 50.6 MB
  • 02. Day 2 - Basics Filtering/9. WHERE with ANDOR.mp4 50.5 MB
  • 11. Day 11 - Pro Window Functions/4. OVER() with ORDER BY.mp4 50.4 MB
  • 05. Day 5 - Intermediate Conditional Expressions/6. CASE WHEN - Hands-on.mp4 49.1 MB
  • 09. Day 9 - Advanced Managing tables & databases/10. CREATE TABLE.mp4 48.8 MB
  • 06. Day 6 - Intermediate Joins/6. FULL OUTER JOIN.mp4 48.6 MB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/1. GROUPING SETS.mp4 47.4 MB
  • 02. Day 2 - Basics Filtering/26. Comments & Aliases.mp4 46.9 MB
  • 06. Day 6 - Intermediate Joins/8. LEFT OUTER JOIN.mp4 46.1 MB
  • 05. Day 5 - Intermediate Conditional Expressions/15. CAST.mp4 45.8 MB
  • 05. Day 5 - Intermediate Conditional Expressions/5. CASE WHEN - Theory.mp4 45.3 MB
  • 16. Extra Day CTEs (Common Table Expressions)/11. Recursive CTEs - Termination Condition.mp4 45.3 MB
  • 08. Day 8 - Advanced Course project/17. Solution 14.mp4 45.1 MB
  • 09. Day 9 - Advanced Managing tables & databases/16. Solution ALTER TABLE.mp4 44.8 MB
  • 06. Day 6 - Intermediate Joins/17. Joining multiple tables - Practice.mp4 44.3 MB
  • 05. Day 5 - Intermediate Conditional Expressions/1. Mathematical functions and operators.mp4 43.8 MB
  • 07. Day 7 - Advanced UNION & Subqueries/3. Subqueries in WHERE.mp4 43.3 MB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/5. Transactions.mp4 43.3 MB
  • 01. Day 1 - Getting started with SQL!/17. SELECT.mp4 43.0 MB
  • 07. Day 7 - Advanced UNION & Subqueries/7. Solution More challenges.mp4 42.3 MB
  • 06. Day 6 - Intermediate Joins/10. Solution LEFT OUTER JOIN.mp4 42.1 MB
  • 01. Day 1 - Getting started with SQL!/13. Installing PostgreSQL & pgAdmin (MacOS).mp4 42.0 MB
  • 10. Day 10 - Advanced Views & Data Manipulation/10. CREATE VIEW.mp4 42.0 MB
  • 08. Day 8 - Advanced Course project/15. Solution 12.mp4 41.6 MB
  • 01. Day 1 - Getting started with SQL!/21. ORDER BY.mp4 41.5 MB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/1. User-defined functions.mp4 41.2 MB
  • 04. Day 4 - Intermediate Functions/2. LENGTH, LOWER & UPPER.mp4 40.8 MB
  • 02. Day 2 - Basics Filtering/25. Solution LIKE.mp4 39.8 MB
  • 02. Day 2 - Basics Filtering/28. Today's challenges.mp4 39.3 MB
  • 02. Day 2 - Basics Filtering/14. BETWEEN.mp4 39.3 MB
  • 04. Day 4 - Intermediate Functions/18. Solution SUBSTRING.mp4 39.0 MB
  • 06. Day 6 - Intermediate Joins/16. Joining multiple tables.mp4 38.8 MB
  • 06. Day 6 - Intermediate Joins/19. Solution Joining multiple tables.mp4 38.5 MB
  • 09. Day 9 - Advanced Managing tables & databases/18. CHECK.mp4 37.8 MB
  • 07. Day 7 - Advanced UNION & Subqueries/2. UNION - Practice.mp4 37.8 MB
  • 10. Day 10 - Advanced Views & Data Manipulation/4. DELETE.mp4 37.5 MB
  • 01. Day 1 - Getting started with SQL!/2. How to get the most out of the course.mp4 37.4 MB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/16. NATURAL JOIN.mp4 36.9 MB
  • 04. Day 4 - Intermediate Functions/21. Solution EXTRACT.mp4 36.9 MB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/8. Rollbacks.mp4 36.9 MB
  • 04. Day 4 - Intermediate Functions/25. Intervals & Timestamps.mp4 36.8 MB
  • 16. Extra Day CTEs (Common Table Expressions)/9. Recursive CTEs - Concept.mp4 36.7 MB
  • 04. Day 4 - Intermediate Functions/24. Solution TO_CHAR.mp4 36.7 MB
  • 11. Day 11 - Pro Window Functions/13. Solution LEAD & LAG.mp4 36.1 MB
  • 01. Day 1 - Getting started with SQL!/33. Today's summary.mp4 36.0 MB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/9. CUBE.mp4 35.8 MB
  • 10. Day 10 - Advanced Views & Data Manipulation/13. CREATE MATERIALIZED VIEW.mp4 35.5 MB
  • 10. Day 10 - Advanced Views & Data Manipulation/1. UPDATE.mp4 35.3 MB
  • 03. Day 3 - Basics Grouping/2. Aggregate functions.mp4 35.3 MB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/7. What are indexes.mp4 35.1 MB
  • 01. Day 1 - Getting started with SQL!/32. Today's challenges.mp4 34.9 MB
  • 03. Day 3 - Basics Grouping/5. GROUP BY.mp4 34.9 MB
  • 11. Day 11 - Pro Window Functions/11. LEAD & LAG.mp4 34.8 MB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/4. Solution.mp4 34.2 MB
  • 06. Day 6 - Intermediate Joins/11. RIGHT OUTER JOIN.mp4 34.2 MB
  • 09. Day 9 - Advanced Managing tables & databases/12. INSERT.mp4 34.1 MB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/7. Solution Transactions.mp4 33.7 MB
  • 11. Day 11 - Pro Window Functions/3. Solution OVER() with PARTITION BY.mp4 33.3 MB
  • 07. Day 7 - Advanced UNION & Subqueries/5. Solution Subqueries in WHERE.mp4 32.8 MB
  • 09. Day 9 - Advanced Managing tables & databases/6. Constraints.mp4 32.3 MB
  • 07. Day 7 - Advanced UNION & Subqueries/17. Correlated Subquery in SELECT.mp4 31.6 MB
  • 09. Day 9 - Advanced Managing tables & databases/8. Primary Key & Foreign Key.mp4 31.5 MB
  • 02. Day 2 - Basics Filtering/5. WHERE operators.mp4 31.4 MB
  • 02. Day 2 - Basics Filtering/1. WHERE.mp4 31.2 MB
  • 06. Day 6 - Intermediate Joins/13. Solution Joins.mp4 31.1 MB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/11. Solution Stored procedure.mp4 31.1 MB
  • 01. Day 1 - Getting started with SQL!/14. Setting up the database.mp4 31.0 MB
  • 09. Day 9 - Advanced Managing tables & databases/2. CREATE DATABASE.mp4 30.6 MB
  • 02. Day 2 - Basics Filtering/27. Today's summary.mp4 30.6 MB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/2. User-defined functions - Example.mp4 30.5 MB
  • 03. Day 3 - Basics Grouping/16. Solution HAVING.mp4 30.1 MB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/15. CROSS JOIN.mp4 29.8 MB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/10. Indexes - Guidelines.mp4 29.7 MB
  • 05. Day 5 - Intermediate Conditional Expressions/18. REPLACE.mp4 29.3 MB
  • 09. Day 9 - Advanced Managing tables & databases/17. TRUNCATE & DROP TABLE.mp4 29.3 MB
  • 03. Day 3 - Basics Grouping/12. Solution GROUP BY multiple columns.mp4 29.2 MB
  • 01. Day 1 - Getting started with SQL!/28. LIMIT.mp4 29.2 MB
  • 08. Day 8 - Advanced Course project/13. Solution 10.mp4 28.7 MB
  • 07. Day 7 - Advanced UNION & Subqueries/11. Subqueries in SELECT.mp4 28.7 MB
  • 01. Day 1 - Getting started with SQL!/20. Solution SELECT.mp4 28.5 MB
  • 05. Day 5 - Intermediate Conditional Expressions/4. Solution Mathematical functions and operators.mp4 28.4 MB
  • 01. Day 1 - Getting started with SQL!/25. SELECT DISTINCT.mp4 28.4 MB
  • 11. Day 11 - Pro Window Functions/10. FIRST_VALUE().mp4 27.9 MB
  • 01. Day 1 - Getting started with SQL!/3. How this course works.mp4 27.8 MB
  • 06. Day 6 - Intermediate Joins/7. JOIN & WHERE.mp4 27.8 MB
  • 01. Day 1 - Getting started with SQL!/4. Why learning SQL.mp4 27.4 MB
  • 10. Day 10 - Advanced Views & Data Manipulation/3. Solution UPDATE.mp4 27.3 MB
  • 04. Day 4 - Intermediate Functions/6. LEFT & RIGHT.mp4 27.1 MB
  • 08. Day 8 - Advanced Course project/12. Solution 9.mp4 26.1 MB
  • 07. Day 7 - Advanced UNION & Subqueries/8. Subqueries in FROM.mp4 25.6 MB
  • 02. Day 2 - Basics Filtering/18. IN.mp4 25.6 MB
  • 03. Day 3 - Basics Grouping/13. HAVING.mp4 25.6 MB
  • 05. Day 5 - Intermediate Conditional Expressions/13. COALESCE.mp4 25.6 MB
  • 08. Day 8 - Advanced Course project/5. Solution 2.mp4 25.3 MB
  • 04. Day 4 - Intermediate Functions/13. POSITION.mp4 25.3 MB
  • 02. Day 2 - Basics Filtering/12. Solution WHERE with ANDOR.mp4 25.0 MB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/9. Bitmap index.mp4 24.9 MB
  • 03. Day 3 - Basics Grouping/9. GROUP BY multiple columns.mp4 24.4 MB
  • 02. Day 2 - Basics Filtering/4. Solution WHERE.mp4 24.0 MB
  • 01. Day 1 - Getting started with SQL!/24. Solution ORDER BY.mp4 24.0 MB
  • 09. Day 9 - Advanced Managing tables & databases/1. Managing databases & tables.mp4 23.9 MB
  • 10. Day 10 - Advanced Views & Data Manipulation/7. CREATE TABLE AS.mp4 23.8 MB
  • 01. Day 1 - Getting started with SQL!/16. The Project.mp4 23.8 MB
  • 08. Day 8 - Advanced Course project/6. Solution 3.mp4 23.8 MB
  • 01. Day 1 - Getting started with SQL!/30. COUNT().mp4 23.8 MB
  • 08. Day 8 - Advanced Course project/9. Solution 6.mp4 23.5 MB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/8. Solution ROLLUP.mp4 23.4 MB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/8. B-Tree index.mp4 23.3 MB
  • 11. Day 11 - Pro Window Functions/9. Solution RANK().mp4 23.0 MB
  • 03. Day 3 - Basics Grouping/8. Solution GROUP BY.mp4 22.7 MB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/5. Solution Additional Challenge.mp4 22.6 MB
  • 03. Day 3 - Basics Grouping/17. flight_database.zip 22.5 MB
  • 08. Day 8 - Advanced Course project/8. Solution 5.mp4 22.5 MB
  • 10. Day 10 - Advanced Views & Data Manipulation/9. Solution CREATE TABLE AS.mp4 22.4 MB
  • 06. Day 6 - Intermediate Joins/1. What are joins.mp4 22.2 MB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/1. User management.mp4 21.7 MB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/14. Solution Self joins.mp4 21.7 MB
  • 01. Day 1 - Getting started with SQL!/7. What is a database.mp4 21.4 MB
  • 01. Day 1 - Getting started with SQL!/1. Welcome!.mp4 21.4 MB
  • 08. Day 8 - Advanced Course project/10. Solution 7.mp4 20.7 MB
  • 04. Day 4 - Intermediate Functions/9. Concatenate.mp4 20.4 MB
  • 08. Day 8 - Advanced Course project/14. Solution 11.mp4 20.3 MB
  • 09. Day 9 - Advanced Managing tables & databases/14. ALTER TABLE.mp4 19.8 MB
  • 07. Day 7 - Advanced UNION & Subqueries/16. Solution Correlated subqueries in WHERE.mp4 19.6 MB
  • 02. Day 2 - Basics Filtering/17. Solution BETWEEN.mp4 19.4 MB
  • 03. Day 3 - Basics Grouping/15. Challenge HAVING.mp4 19.2 MB
  • 03. Day 3 - Basics Grouping/11. Challenge GROUP BY multiple columns.mp4 18.5 MB
  • 04. Day 4 - Intermediate Functions/15. Solution POSITION.mp4 18.3 MB
  • 10. Day 10 - Advanced Views & Data Manipulation/14. Managing views.mp4 17.8 MB
  • 09. Day 9 - Advanced Managing tables & databases/15. Challenge ALTER TABLE.mp4 17.5 MB
  • 07. Day 7 - Advanced UNION & Subqueries/18. More challenges Correlated subqueres.mp4 17.2 MB
  • 02. Day 2 - Basics Filtering/21. Solution IN.mp4 16.4 MB
  • 01. Day 1 - Getting started with SQL!/27. Solution SELECT DISTINCT.mp4 16.4 MB
  • 07. Day 7 - Advanced UNION & Subqueries/10. Solution Subqueries in FROM.mp4 15.9 MB
  • 05. Day 5 - Intermediate Conditional Expressions/3. Challenge Mathematical functions and operators.mp4 15.4 MB
  • 04. Day 4 - Intermediate Functions/8. Solution LEFT & RIGHT.mp4 15.3 MB
  • 01. Day 1 - Getting started with SQL!/9. Different dialects of SQL.mp4 15.3 MB
  • 02. Day 2 - Basics Filtering/8. Solution WHERE operators.mp4 15.2 MB
  • 03. Day 3 - Basics Grouping/20. Today's summary.mp4 15.2 MB
  • 06. Day 6 - Intermediate Joins/15. Solution Joins on multiple conditions.mp4 14.7 MB
  • 11. Day 11 - Pro Window Functions/6. Solution OVER() with ORDER BY.mp4 14.1 MB
  • 04. Day 4 - Intermediate Functions/12. Solution Concatenate.mp4 13.9 MB
  • 04. Day 4 - Intermediate Functions/5. Solution LENGTH, LOWER & UPPER.mp4 13.9 MB
  • 09. Day 9 - Advanced Managing tables & databases/19. Challenge CHECK.mp4 13.6 MB
  • 04. Day 4 - Intermediate Functions/1. Today's plan.mp4 13.1 MB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/3. Solution GROUPING SETS.mp4 12.7 MB
  • 08. Day 8 - Advanced Course project/11. Solution 8.mp4 12.6 MB
  • 04. Day 4 - Intermediate Functions/27. Solution Intervals & Timestamps.mp4 12.5 MB
  • 05. Day 5 - Intermediate Conditional Expressions/8. 3 Challenge CASE WHEN.mp4 12.4 MB
  • 05. Day 5 - Intermediate Conditional Expressions/17. Solution CAST & COALESCE.mp4 12.1 MB
  • 01. Day 1 - Getting started with SQL!/11. Installing PostgreSQL & pgAdmin (Windows).mp4 11.8 MB
  • 03. Day 3 - Basics Grouping/4. Challenge Aggregate function.mp4 11.6 MB
  • 07. Day 7 - Advanced UNION & Subqueries/13. Solution Subqueries in SELECT.mp4 11.5 MB
  • 03. Day 3 - Basics Grouping/7. Challenge GROUP BY.mp4 11.2 MB
  • 06. Day 6 - Intermediate Joins/9. Challenge LEFT OUTER JOIN.mp4 11.2 MB
  • 11. Day 11 - Pro Window Functions/2. Challenge OVER() with PARTITION BY.mp4 11.0 MB
  • 01. Day 1 - Getting started with SQL!/5. All slides.pdf 10.6 MB
  • 08. Day 8 - Advanced Course project/7. Solution 4.mp4 10.3 MB
  • 04. Day 4 - Intermediate Functions/20. Challenge EXTRACT.mp4 9.9 MB
  • 03. Day 3 - Basics Grouping/1. Today's plan.mp4 9.9 MB
  • 10. Day 10 - Advanced Views & Data Manipulation/6. Solution DELETE.mp4 9.9 MB
  • 02. Day 2 - Basics Filtering/11. Challenge WHERE with ANDOR.mp4 9.8 MB
  • 07. Day 7 - Advanced UNION & Subqueries/6. More challenges Subqueries in WHERE.mp4 9.6 MB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/7. Challenge ROLLUP.mp4 9.1 MB
  • 08. Day 8 - Advanced Course project/4. Solution 1.mp4 8.8 MB
  • 04. Day 4 - Intermediate Functions/14. Challenge POSITION.mp4 8.7 MB
  • 02. Day 2 - Basics Filtering/7. Challenge WHERE operators.mp4 8.5 MB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/10. Challenge Stored procedures.mp4 8.4 MB
  • 05. Day 5 - Intermediate Conditional Expressions/16. Challenge CAST & COALESCE.mp4 8.2 MB
  • 06. Day 6 - Intermediate Joins/12. Challenge Joins.mp4 8.0 MB
  • 02. Day 2 - Basics Filtering/24. Challenge LIKE.mp4 8.0 MB
  • 11. Day 11 - Pro Window Functions/8. Challenge RANK().mp4 7.8 MB
  • 02. Day 2 - Basics Filtering/20. Challenge IN.mp4 7.8 MB
  • 11. Day 11 - Pro Window Functions/5. Challenge OVER() with ORDER BY.mp4 7.6 MB
  • 04. Day 4 - Intermediate Functions/11. Challenge Concatenate.mp4 7.6 MB
  • 04. Day 4 - Intermediate Functions/17. Challenge SUBSTRING.mp4 7.6 MB
  • 04. Day 4 - Intermediate Functions/26. Challenge Intervals & Timestamps.mp4 7.5 MB
  • 04. Day 4 - Intermediate Functions/23. Challenge TO_CHAR.mp4 7.4 MB
  • 01. Day 1 - Getting started with SQL!/19. Challenge SELECT.mp4 7.2 MB
  • 07. Day 7 - Advanced UNION & Subqueries/4. Challenge Subqueries in WHERE.mp4 7.1 MB
  • 01. Day 1 - Getting started with SQL!/23. Challenge ORDER BY.mp4 7.1 MB
  • 04. Day 4 - Intermediate Functions/7. Challenge LEFT & RIGHT.mp4 6.8 MB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/13. Challenge Self joins.mp4 6.5 MB
  • 07. Day 7 - Advanced UNION & Subqueries/15. Challenge Correlated subqueries in WHERE.mp4 6.5 MB
  • 04. Day 4 - Intermediate Functions/4. Challenge LENGTH, LOWER & UPPER.mp4 6.5 MB
  • 11. Day 11 - Pro Window Functions/12. Challenge LEAD & LAG.mp4 6.4 MB
  • 02. Day 2 - Basics Filtering/3. Challenge WHERE.mp4 6.2 MB
  • 01. Day 1 - Getting started with SQL!/26. Challenge SELECT DISTINCT.mp4 5.7 MB
  • 10. Day 10 - Advanced Views & Data Manipulation/2. Challenge UPDATE.mp4 5.7 MB
  • 02. Day 2 - Basics Filtering/16. Challenge BETWEEN.mp4 5.2 MB
  • 10. Day 10 - Advanced Views & Data Manipulation/5. Challenge DELETE.mp4 4.7 MB
  • 07. Day 7 - Advanced UNION & Subqueries/12. Challenge Subqueries in SELECT.mp4 4.6 MB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/4. Additional challenge.mp4 4.6 MB
  • 10. Day 10 - Advanced Views & Data Manipulation/8. Challenge CREATE TABLE AS.mp4 4.5 MB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/6. Challenge Transactions.mp4 4.2 MB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/3. Challenge User-defined functions.mp4 4.0 MB
  • 06. Day 6 - Intermediate Joins/18. Challenge Joining multiple tables.mp4 3.9 MB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/2. Challenge GROUPING SETS.mp4 3.6 MB
  • 07. Day 7 - Advanced UNION & Subqueries/9. Challenge Subqueries in FROM.mp4 3.0 MB
  • 06. Day 6 - Intermediate Joins/4. Challenge INNER JOIN.mp4 2.9 MB
  • 01. Day 1 - Getting started with SQL!/33. Day 1 - Course slides.pdf 2.1 MB
  • 09. Day 9 - Advanced Managing tables & databases/21. Day 9 - Course slides.pdf 2.0 MB
  • 17. Bonus/1. 2024-01-30_07-17-50-21a899f2574db3ff4baf37d9f163de3b.JPG 2.0 MB
  • 06. Day 6 - Intermediate Joins/22. Day 6 - Course slides.pdf 1.6 MB
  • 02. Day 2 - Basics Filtering/27. Day 2 - Course slides.pdf 1.1 MB
  • 07. Day 7 - Advanced UNION & Subqueries/20. Day 7 - Course slides.pdf 1.0 MB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/14. Day 15 - Course slides.pdf 1.0 MB
  • 10. Day 10 - Advanced Views & Data Manipulation/18. Day 10 - Course slides.pdf 891.6 kB
  • 04. Day 4 - Intermediate Functions/28. Day 4 - Course slides.pdf 761.3 kB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/12. Day 14 - Course slides.pdf 755.2 kB
  • 05. Day 5 - Intermediate Conditional Expressions/19. Day 5 - Course slides.pdf 750.4 kB
  • 11. Day 11 - Pro Window Functions/14. Day 11 - Course slides.pdf 728.3 kB
  • 01. Day 1 - Getting started with SQL!/14. pagila-master.zip 701.6 kB
  • 03. Day 3 - Basics Grouping/20. Day 3 - Course slides.pdf 659.1 kB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/17. Day 12 - Course slides.pdf 627.5 kB
  • 03. Day 3 - Basics Grouping/20. Day+3+-+Course+slides.pdf 610.0 kB
  • 03. Day 3 - Basics Grouping/19. 2023-01-31_10-38-37-c8c2d4a3e9d240953b0585f660bf5ed7.png 191.9 kB
  • 01. Day 1 - Getting started with SQL!/12. 2022-09-07_12-34-54-f40c284ed636467884ba52a6ee9bbf2f.png 148.7 kB
  • 03. Day 3 - Basics Grouping/17. ER_diagram_flights_db.png 122.9 kB
  • 03. Day 3 - Basics Grouping/19. 2022-09-07_12-34-54-f40c284ed636467884ba52a6ee9bbf2f.png 111.8 kB
  • 01. Day 1 - Getting started with SQL!/12. 2022-09-07_12-34-54-47e1ca5d3ee08b5851605849314610d7.png 110.8 kB
  • 03. Day 3 - Basics Grouping/19. 2022-09-07_12-34-54-47e1ca5d3ee08b5851605849314610d7.png 110.8 kB
  • 03. Day 3 - Basics Grouping/19. 2023-01-31_10-38-37-a411ee5247b6632ddfb1b3da53c01260.png 110.4 kB
  • 10. Day 10 - Advanced Views & Data Manipulation/17. Fact_sales.csv 73.6 kB
  • 01. Day 1 - Getting started with SQL!/12. 2022-09-07_12-34-53-bb78b2cd840131afea3195bf697ca8d0.png 59.0 kB
  • 03. Day 3 - Basics Grouping/19. 2022-09-07_12-34-53-bb78b2cd840131afea3195bf697ca8d0.png 59.0 kB
  • 02. Day 2 - Basics Filtering/13. 2022-09-07_11-07-05-c83708a81bbc36ecd09c1bbf0156166f.png 35.4 kB
  • 13. Day 13 - Pro Course project/2. 2022-08-10_14-06-46-32f81b87932bc2494dfa2409327905ec.png 26.5 kB
  • 03. Day 3 - Basics Grouping/19. 2023-01-31_10-38-38-393c5817c6c2e54ca675401a577ff453.png 22.5 kB
  • 03. Day 3 - Basics Grouping/19. 2023-01-31_10-38-38-4c4330adbefe30a33a830eaf96a80297.png 22.4 kB
  • 13. Day 13 - Pro Course project/2. 2022-08-10_14-06-45-ee080b7812d315118f52b676dfbfac4b.png 21.6 kB
  • 09. Day 9 - Advanced Managing tables & databases/5.3 Data Types.html 19.6 kB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/10. 2022-08-09_08-58-09-0c0e6114b042ff98a9e83a6e10f82d8e.png 18.9 kB
  • 13. Day 13 - Pro Course project/2. 2022-08-10_14-06-46-ee4c62ade30194de367965d239f4229e.png 17.8 kB
  • 01. Day 1 - Getting started with SQL!/5. 2023-01-25_13-27-59-e7d43bf66057db438a7ecf26be68fc13.png 17.7 kB
  • 09. Day 9 - Advanced Managing tables & databases/9.5 Primary & Foreign Key.html 17.5 kB
  • 01. Day 1 - Getting started with SQL!/10.2 Dialects of SQL.html 17.5 kB
  • 09. Day 9 - Advanced Managing tables & databases/7.4 Constraints.html 17.3 kB
  • 03. Day 3 - Basics Grouping/19. 2022-09-07_13-34-16-83c120d05b6098b20fd4fb5dfb4cf3ae.png 16.8 kB
  • 01. Day 1 - Getting started with SQL!/8.1 Databases.html 16.5 kB
  • 13. Day 13 - Pro Course project/2. 2024-09-06_13-23-35-39d73910d47148cf287bb323b5c49df2.png 14.9 kB
  • 13. Day 13 - Pro Course project/2. 2022-08-10_14-06-46-8a896f85dd6552df023234ecbc02897b.png 13.7 kB
  • 13. Day 13 - Pro Course project/2. 2022-08-10_14-06-46-64c69bb4a9cabf9cc434a4e754dc7b93.png 13.2 kB
  • 16. Extra Day CTEs (Common Table Expressions)/6. Common Table Expressions - Using Multiple CTEs.vtt 12.4 kB
  • 06. Day 6 - Intermediate Joins/2. INNER JOIN - Theory.vtt 12.4 kB
  • 13. Day 13 - Pro Course project/2. 2022-08-10_14-06-45-028cd4a57cda9324639786daf3ae607d.png 12.2 kB
  • 16. Extra Day CTEs (Common Table Expressions)/1. 2024-06-04_10-51-42-bc9ad906edace8d58aac839f7e56ed5d.png 12.0 kB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/13. Execution plan & query performance.vtt 11.9 kB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/4. Privileges - Hands-on.vtt 11.8 kB
  • 09. Day 9 - Advanced Managing tables & databases/4. Data Types.vtt 11.6 kB
  • 03. Day 3 - Basics Grouping/19. 2023-01-31_10-38-37-f733bcd44e44ef1d146fa360213c636c.png 11.5 kB
  • 13. Day 13 - Pro Course project/2. The challenges.html 11.5 kB
  • 13. Day 13 - Pro Course project/2. 2022-08-10_14-06-45-9481317717076af04727664bc6344aec.png 11.4 kB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/9. Stored procedures.vtt 11.4 kB
  • 03. Day 3 - Basics Grouping/19. 2023-01-31_10-38-37-1859562130e2741dc2e211f525fac2cd.png 10.8 kB
  • 11. Day 11 - Pro Window Functions/1. OVER() with PARTITION BY.vtt 10.7 kB
  • 03. Day 3 - Basics Grouping/17. Introducing the second project.vtt 10.4 kB
  • 10. Day 10 - Advanced Views & Data Manipulation/17. Import & Export.vtt 10.2 kB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/11. Solution Stored procedure.vtt 10.1 kB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/2. CREATE USER ROLE.vtt 10.1 kB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/6. ROLLUP.vtt 9.6 kB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/3. GRANT & REVOKE privileges.vtt 9.5 kB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/12. Self joins.vtt 9.4 kB
  • 04. Day 4 - Intermediate Functions/19. EXTRACT.vtt 9.4 kB
  • 16. Extra Day CTEs (Common Table Expressions)/10. Recursive CTEs - Hierarchical Data.vtt 9.3 kB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/11. Creating indexes.vtt 9.2 kB
  • 08. Day 8 - Advanced Course project/1. Project Introduction.vtt 8.9 kB
  • 08. Day 8 - Advanced Course project/16. Solution 13.vtt 8.9 kB
  • 09. Day 9 - Advanced Managing tables & databases/10. CREATE TABLE.vtt 8.8 kB
  • 05. Day 5 - Intermediate Conditional Expressions/5. CASE WHEN - Theory.vtt 8.7 kB
  • 01. Day 1 - Getting started with SQL!/11. Installing PostgreSQL & pgAdmin (Windows).vtt 8.7 kB
  • 07. Day 7 - Advanced UNION & Subqueries/14. Correlated Subqueries in WHERE.vtt 8.6 kB
  • 05. Day 5 - Intermediate Conditional Expressions/10. Solution CASE WHEN.vtt 8.6 kB
  • 09. Day 9 - Advanced Managing tables & databases/20. Solution CHECK.vtt 8.6 kB
  • 04. Day 4 - Intermediate Functions/16. SUBSTRING.vtt 8.5 kB
  • 02. Day 2 - Basics Filtering/26. Comments & Aliases.vtt 8.3 kB
  • 13. Day 13 - Pro Course project/3. Solutions.html 8.3 kB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/1. User-defined functions.vtt 8.2 kB
  • 05. Day 5 - Intermediate Conditional Expressions/11. CASE WHEN & SUM.vtt 8.2 kB
  • 07. Day 7 - Advanced UNION & Subqueries/19. Solution More challenges.vtt 8.1 kB
  • 01. Day 1 - Getting started with SQL!/17. SELECT.vtt 8.1 kB
  • 05. Day 5 - Intermediate Conditional Expressions/6. CASE WHEN - Hands-on.vtt 8.1 kB
  • 16. Extra Day CTEs (Common Table Expressions)/2. Common Table Expressions (CTEs) - First Example.vtt 8.1 kB
  • 02. Day 2 - Basics Filtering/22. LIKE.vtt 8.0 kB
  • 02. Day 2 - Basics Filtering/9. WHERE with ANDOR.vtt 8.0 kB
  • 11. Day 11 - Pro Window Functions/7. RANK().vtt 7.9 kB
  • 06. Day 6 - Intermediate Joins/6. FULL OUTER JOIN.vtt 7.7 kB
  • 04. Day 4 - Intermediate Functions/22. TO_CHAR.vtt 7.7 kB
  • 06. Day 6 - Intermediate Joins/14. Joins on multiple conditions.vtt 7.6 kB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/5. Transactions.vtt 7.6 kB
  • 06. Day 6 - Intermediate Joins/5. 2024-04-25_17-55-25-a0412a72cd4af374756faecf074b5312.png 7.5 kB
  • 16. Extra Day CTEs (Common Table Expressions)/3. Common Table Expressions - More Complex Example.vtt 7.5 kB
  • 07. Day 7 - Advanced UNION & Subqueries/1. UNION.vtt 7.5 kB
  • 01. Day 1 - Getting started with SQL!/32. Today's challenges.vtt 7.5 kB
  • 05. Day 5 - Intermediate Conditional Expressions/1. Mathematical functions and operators.vtt 7.5 kB
  • 06. Day 6 - Intermediate Joins/3. INNER JOIN - Practice.vtt 7.4 kB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/1. GROUPING SETS.vtt 7.4 kB
  • 05. Day 5 - Intermediate Conditional Expressions/15. CAST.vtt 7.2 kB
  • 02. Day 2 - Basics Filtering/28. Today's challenges.vtt 7.2 kB
  • 03. Day 3 - Basics Grouping/2. Aggregate functions.vtt 7.1 kB
  • 06. Day 6 - Intermediate Joins/10. Solution LEFT OUTER JOIN.vtt 7.1 kB
  • 17. Bonus/1. Bonus.html 7.1 kB
  • 01. Day 1 - Getting started with SQL!/14. Setting up the database.vtt 7.1 kB
  • 11. Day 11 - Pro Window Functions/4. OVER() with ORDER BY.vtt 7.1 kB
  • 09. Day 9 - Advanced Managing tables & databases/2. CREATE DATABASE.vtt 7.0 kB
  • 01. Day 1 - Getting started with SQL!/21. ORDER BY.vtt 7.0 kB
  • 08. Day 8 - Advanced Course project/17. Solution 14.vtt 6.9 kB
  • 03. Day 3 - Basics Grouping/19. 2023-01-31_10-38-37-23459267be87bc20d358592f88bf352a.png 6.9 kB
  • 04. Day 4 - Intermediate Functions/18. Solution SUBSTRING.vtt 6.9 kB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/4. Solution.vtt 6.9 kB
  • 10. Day 10 - Advanced Views & Data Manipulation/10. CREATE VIEW.vtt 6.8 kB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/7. What are indexes.vtt 6.7 kB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/16. NATURAL JOIN.vtt 6.6 kB
  • 01. Day 1 - Getting started with SQL!/2. How to get the most out of the course.vtt 6.6 kB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/2. User-defined functions - Example.vtt 6.6 kB
  • 04. Day 4 - Intermediate Functions/10.17 Concatenate.html 6.4 kB
  • 06. Day 6 - Intermediate Joins/8. LEFT OUTER JOIN.vtt 6.4 kB
  • 09. Day 9 - Advanced Managing tables & databases/18. CHECK.vtt 6.4 kB
  • 07. Day 7 - Advanced UNION & Subqueries/2. UNION - Practice.vtt 6.4 kB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/8. Rollbacks.vtt 6.3 kB
  • 09. Day 9 - Advanced Managing tables & databases/14. ALTER TABLE.vtt 6.3 kB
  • 07. Day 7 - Advanced UNION & Subqueries/3. Subqueries in WHERE.vtt 6.3 kB
  • 03. Day 3 - Basics Grouping/5. GROUP BY.vtt 6.3 kB
  • 16. Extra Day CTEs (Common Table Expressions)/9. Recursive CTEs - Concept.vtt 6.3 kB
  • 16. Extra Day CTEs (Common Table Expressions)/11. Recursive CTEs - Termination Condition.vtt 6.3 kB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/10. Indexes - Guidelines.vtt 6.3 kB
  • 02. Day 2 - Basics Filtering/1. WHERE.vtt 6.3 kB
  • 04. Day 4 - Intermediate Functions/21. Solution EXTRACT.vtt 6.3 kB
  • 07. Day 7 - Advanced UNION & Subqueries/7. Solution More challenges.vtt 6.2 kB
  • 08. Day 8 - Advanced Course project/15. Solution 12.vtt 6.2 kB
  • 02. Day 2 - Basics Filtering/25. Solution LIKE.vtt 6.2 kB
  • 09. Day 9 - Advanced Managing tables & databases/16. Solution ALTER TABLE.vtt 6.2 kB
  • 01. Day 1 - Getting started with SQL!/33. Today's summary.vtt 6.0 kB
  • 06. Day 6 - Intermediate Joins/16. Joining multiple tables.vtt 6.0 kB
  • 09. Day 9 - Advanced Managing tables & databases/12. INSERT.vtt 6.0 kB
  • 09. Day 9 - Advanced Managing tables & databases/6. Constraints.vtt 5.9 kB
  • 06. Day 6 - Intermediate Joins/17. Joining multiple tables - Practice.vtt 5.8 kB
  • 02. Day 2 - Basics Filtering/27. Today's summary.vtt 5.8 kB
  • 08. Day 8 - Advanced Course project/2. Challenges.html 5.8 kB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/9. CUBE.vtt 5.8 kB
  • 10. Day 10 - Advanced Views & Data Manipulation/4. DELETE.vtt 5.7 kB
  • 05. Day 5 - Intermediate Conditional Expressions/8. 3 Challenge CASE WHEN.vtt 5.7 kB
  • 09. Day 9 - Advanced Managing tables & databases/17. TRUNCATE & DROP TABLE.vtt 5.7 kB
  • 10. Day 10 - Advanced Views & Data Manipulation/1. UPDATE.vtt 5.7 kB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/15. CROSS JOIN.vtt 5.5 kB
  • 04. Day 4 - Intermediate Functions/2. LENGTH, LOWER & UPPER.vtt 5.5 kB
  • 04. Day 4 - Intermediate Functions/25. Intervals & Timestamps.vtt 5.5 kB
  • 01. Day 1 - Getting started with SQL!/13. Installing PostgreSQL & pgAdmin (MacOS).vtt 5.5 kB
  • 02. Day 2 - Basics Filtering/5. WHERE operators.vtt 5.4 kB
  • 03. Day 3 - Basics Grouping/19. Important Problems & solutions of setting up the database.html 5.4 kB
  • 02. Day 2 - Basics Filtering/14. BETWEEN.vtt 5.4 kB
  • 08. Day 8 - Advanced Course project/3. Solutions.html 5.4 kB
  • 10. Day 10 - Advanced Views & Data Manipulation/13. CREATE MATERIALIZED VIEW.vtt 5.4 kB
  • 01. Day 1 - Getting started with SQL!/30. COUNT().vtt 5.2 kB
  • 05. Day 5 - Intermediate Conditional Expressions/7.19 CASE WHEN.html 5.2 kB
  • 04. Day 4 - Intermediate Functions/24. Solution TO_CHAR.vtt 5.2 kB
  • 07. Day 7 - Advanced UNION & Subqueries/5. Solution Subqueries in WHERE.vtt 5.2 kB
  • 01. Day 1 - Getting started with SQL!/4. Why learning SQL.vtt 5.1 kB
  • 06. Day 6 - Intermediate Joins/19. Solution Joining multiple tables.vtt 5.1 kB
  • 01. Day 1 - Getting started with SQL!/15. 2022-09-07_13-19-43-87939fa943016dfbe8f793fe1eccec7f.png 5.0 kB
  • 01. Day 1 - Getting started with SQL!/20. Solution SELECT.vtt 5.0 kB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/8. B-Tree index.vtt 5.0 kB
  • 01. Day 1 - Getting started with SQL!/3. How this course works.vtt 4.9 kB
  • 08. Day 8 - Advanced Course project/13. Solution 10.vtt 4.9 kB
  • 01. Day 1 - Getting started with SQL!/25. SELECT DISTINCT.vtt 4.9 kB
  • 05. Day 5 - Intermediate Conditional Expressions/12.20 CASE WHEN & SUM.html 4.9 kB
  • 06. Day 6 - Intermediate Joins/11. RIGHT OUTER JOIN.vtt 4.8 kB
  • 11. Day 11 - Pro Window Functions/3. Solution OVER() with PARTITION BY.vtt 4.8 kB
  • 05. Day 5 - Intermediate Conditional Expressions/14.21 COALESCE.html 4.8 kB
  • 03. Day 3 - Basics Grouping/6.13 GROUP BY.html 4.8 kB
  • 13. Day 13 - Pro Course project/2. 2022-08-10_14-06-45-ba2470af10baa81827a89a554c5f57c0.png 4.7 kB
  • 05. Day 5 - Intermediate Conditional Expressions/13. COALESCE.vtt 4.7 kB
  • 03. Day 3 - Basics Grouping/16. Solution HAVING.vtt 4.7 kB
  • 11. Day 11 - Pro Window Functions/11. LEAD & LAG.vtt 4.7 kB
  • 04. Day 4 - Intermediate Functions/6. LEFT & RIGHT.vtt 4.7 kB
  • 09. Day 9 - Advanced Managing tables & databases/8. Primary Key & Foreign Key.vtt 4.7 kB
  • 01. Day 1 - Getting started with SQL!/28. LIMIT.vtt 4.7 kB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/9. Bitmap index.vtt 4.6 kB
  • 03. Day 3 - Basics Grouping/3.12 Aggregate functions.html 4.6 kB
  • 05. Day 5 - Intermediate Conditional Expressions/18. REPLACE.vtt 4.6 kB
  • 11. Day 11 - Pro Window Functions/13. Solution LEAD & LAG.vtt 4.6 kB
  • 03. Day 3 - Basics Grouping/10.14 GROUP BY multiple columns.html 4.6 kB
  • 02. Day 2 - Basics Filtering/10.8 WHERE with ANDOR.html 4.5 kB
  • 08. Day 8 - Advanced Course project/12. Solution 9.vtt 4.5 kB
  • 05. Day 5 - Intermediate Conditional Expressions/2.18 Mathematical functions and operators.html 4.5 kB
  • 02. Day 2 - Basics Filtering/2.6 WHERE.html 4.5 kB
  • 02. Day 2 - Basics Filtering/6.7 WHERE operators.html 4.5 kB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/1. User management.vtt 4.5 kB
  • 04. Day 4 - Intermediate Functions/3.16 LENGTH, LOWER & UPPER.html 4.4 kB
  • 05. Day 5 - Intermediate Conditional Expressions/4. Solution Mathematical functions and operators.vtt 4.4 kB
  • 01. Day 1 - Getting started with SQL!/6.1 Let's get started!.html 4.4 kB
  • 09. Day 9 - Advanced Managing tables & databases/1. Managing databases & tables.vtt 4.4 kB
  • 01. Day 1 - Getting started with SQL!/29.4 SELECT DISTINCT & LIMIT.html 4.4 kB
  • 03. Day 3 - Basics Grouping/14.15 HAVING.html 4.4 kB
  • 02. Day 2 - Basics Filtering/23.11 LIKE.html 4.3 kB
  • 03. Day 3 - Basics Grouping/8. Solution GROUP BY.vtt 4.3 kB
  • 01. Day 1 - Getting started with SQL!/31.5 COUNT().html 4.3 kB
  • 02. Day 2 - Basics Filtering/15.9 BETWEEN.html 4.3 kB
  • 07. Day 7 - Advanced UNION & Subqueries/8. Subqueries in FROM.vtt 4.3 kB
  • 01. Day 1 - Getting started with SQL!/24. Solution ORDER BY.vtt 4.3 kB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/7. Solution Transactions.vtt 4.2 kB
  • 03. Day 3 - Basics Grouping/12. Solution GROUP BY multiple columns.vtt 4.2 kB
  • 03. Day 3 - Basics Grouping/13. HAVING.vtt 4.2 kB
  • 02. Day 2 - Basics Filtering/19.10 IN operator.html 4.2 kB
  • 06. Day 6 - Intermediate Joins/7. JOIN & WHERE.vtt 4.1 kB
  • 07. Day 7 - Advanced UNION & Subqueries/17. Correlated Subquery in SELECT.vtt 4.1 kB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/8. Solution ROLLUP.vtt 4.1 kB
  • 06. Day 6 - Intermediate Joins/13. Solution Joins.vtt 4.1 kB
  • 08. Day 8 - Advanced Course project/6. Solution 3.vtt 4.1 kB
  • 02. Day 2 - Basics Filtering/18. IN.vtt 4.1 kB
  • 16. Extra Day CTEs (Common Table Expressions)/8. Solution 2 Using Multiple CTEs.html 4.1 kB
  • 07. Day 7 - Advanced UNION & Subqueries/11. Subqueries in SELECT.vtt 4.1 kB
  • 01. Day 1 - Getting started with SQL!/18.2 SELECT.html 4.1 kB
  • 01. Day 1 - Getting started with SQL!/22.3 SELECT & ORDER BY.html 4.0 kB
  • 10. Day 10 - Advanced Views & Data Manipulation/7. CREATE TABLE AS.vtt 4.0 kB
  • 09. Day 9 - Advanced Managing tables & databases/3.22 CREATE & DROP DATABASE.html 4.0 kB
  • 04. Day 4 - Intermediate Functions/13. POSITION.vtt 4.0 kB
  • 07. Day 7 - Advanced UNION & Subqueries/18. More challenges Correlated subqueres.vtt 4.0 kB
  • 10. Day 10 - Advanced Views & Data Manipulation/3. Solution UPDATE.vtt 3.9 kB
  • 06. Day 6 - Intermediate Joins/1. What are joins.vtt 3.9 kB
  • 10. Day 10 - Advanced Views & Data Manipulation/9. Solution CREATE TABLE AS.vtt 3.8 kB
  • 01. Day 1 - Getting started with SQL!/1. Welcome!.vtt 3.8 kB
  • 03. Day 3 - Basics Grouping/9. GROUP BY multiple columns.vtt 3.7 kB
  • 08. Day 8 - Advanced Course project/5. Solution 2.vtt 3.7 kB
  • 11. Day 11 - Pro Window Functions/10. FIRST_VALUE().vtt 3.7 kB
  • 02. Day 2 - Basics Filtering/12. Solution WHERE with ANDOR.vtt 3.7 kB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/14. Solution Self joins.vtt 3.7 kB
  • 09. Day 9 - Advanced Managing tables & databases/13.2 Assignment-INSERT.html 3.6 kB
  • 09. Day 9 - Advanced Managing tables & databases/11.1 Assignment-CREATE TABLE.html 3.6 kB
  • 10. Day 10 - Advanced Views & Data Manipulation/14. Managing views.vtt 3.5 kB
  • 03. Day 3 - Basics Grouping/15. Challenge HAVING.vtt 3.5 kB
  • 04. Day 4 - Intermediate Functions/9. Concatenate.vtt 3.4 kB
  • 08. Day 8 - Advanced Course project/14. Solution 11.vtt 3.4 kB
  • 08. Day 8 - Advanced Course project/10. Solution 7.vtt 3.4 kB
  • 01. Day 1 - Getting started with SQL!/7. What is a database.vtt 3.3 kB
  • 01. Day 1 - Getting started with SQL!/27. Solution SELECT DISTINCT.vtt 3.3 kB
  • 08. Day 8 - Advanced Course project/9. Solution 6.vtt 3.2 kB
  • 02. Day 2 - Basics Filtering/17. Solution BETWEEN.vtt 3.2 kB
  • 11. Day 11 - Pro Window Functions/9. Solution RANK().vtt 3.2 kB
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/12.3 Assignment-Creating indexes.html 3.2 kB
  • 03. Day 3 - Basics Grouping/11. Challenge GROUP BY multiple columns.vtt 3.2 kB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/5. Solution Additional Challenge.vtt 3.2 kB
  • 07. Day 7 - Advanced UNION & Subqueries/16. Solution Correlated subqueries in WHERE.vtt 3.1 kB
  • 01. Day 1 - Getting started with SQL!/16. The Project.vtt 3.1 kB
  • 08. Day 8 - Advanced Course project/8. Solution 5.vtt 3.0 kB
  • 04. Day 4 - Intermediate Functions/15. Solution POSITION.vtt 3.0 kB
  • 03. Day 3 - Basics Grouping/20. Today's summary.vtt 3.0 kB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/6. Challenge_Transactions.txt 2.9 kB
  • 01. Day 1 - Getting started with SQL!/9. Different dialects of SQL.vtt 2.8 kB
  • 02. Day 2 - Basics Filtering/21. Solution IN.vtt 2.8 kB
  • 02. Day 2 - Basics Filtering/8. Solution WHERE operators.vtt 2.7 kB
  • 06. Day 6 - Intermediate Joins/9. Challenge LEFT OUTER JOIN.vtt 2.7 kB
  • 04. Day 4 - Intermediate Functions/12. Solution Concatenate.vtt 2.6 kB
  • 11. Day 11 - Pro Window Functions/6. Solution OVER() with ORDER BY.vtt 2.6 kB
  • 03. Day 3 - Basics Grouping/4. Challenge Aggregate function.vtt 2.5 kB
  • 07. Day 7 - Advanced UNION & Subqueries/10. Solution Subqueries in FROM.vtt 2.5 kB
  • 09. Day 9 - Advanced Managing tables & databases/15. Challenge ALTER TABLE.vtt 2.4 kB
  • 04. Day 4 - Intermediate Functions/8. Solution LEFT & RIGHT.vtt 2.4 kB
  • 05. Day 5 - Intermediate Conditional Expressions/3. Challenge Mathematical functions and operators.vtt 2.4 kB
  • 09. Day 9 - Advanced Managing tables & databases/19. Challenge CHECK.vtt 2.3 kB
  • 04. Day 4 - Intermediate Functions/5. Solution LENGTH, LOWER & UPPER.vtt 2.3 kB
  • 08. Day 8 - Advanced Course project/11. Solution 8.vtt 2.3 kB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/7. Challenge ROLLUP.vtt 2.2 kB
  • 07. Day 7 - Advanced UNION & Subqueries/6. More challenges Subqueries in WHERE.vtt 2.2 kB
  • 07. Day 7 - Advanced UNION & Subqueries/4. Challenge Subqueries in WHERE.vtt 2.1 kB
  • 03. Day 3 - Basics Grouping/7. Challenge GROUP BY.vtt 2.1 kB
  • 06. Day 6 - Intermediate Joins/15. Solution Joins on multiple conditions.vtt 2.1 kB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/3. Solution GROUPING SETS.vtt 2.1 kB
  • 06. Day 6 - Intermediate Joins/5. Solution INNER JOIN.html 2.1 kB
  • 11. Day 11 - Pro Window Functions/2. Challenge OVER() with PARTITION BY.vtt 2.0 kB
  • 08. Day 8 - Advanced Course project/4. Solution 1.vtt 2.0 kB
  • 04. Day 4 - Intermediate Functions/20. Challenge EXTRACT.vtt 2.0 kB
  • 01. Day 1 - Getting started with SQL!/5. Let the Joruney Begin!.html 1.9 kB
  • 06. Day 6 - Intermediate Joins/12. Challenge Joins.vtt 1.9 kB
  • 02. Day 2 - Basics Filtering/7. Challenge WHERE operators.vtt 1.9 kB
  • 04. Day 4 - Intermediate Functions/1. Today's plan.vtt 1.9 kB
  • 02. Day 2 - Basics Filtering/11. Challenge WHERE with ANDOR.vtt 1.8 kB
  • 08. Day 8 - Advanced Course project/7. Solution 4.vtt 1.8 kB
  • 02. Day 2 - Basics Filtering/24. Challenge LIKE.vtt 1.8 kB
  • 16. Extra Day CTEs (Common Table Expressions)/7. Challenge 2 Using Multiple CTEs.html 1.8 kB
  • 04. Day 4 - Intermediate Functions/23. Challenge TO_CHAR.vtt 1.8 kB
  • 05. Day 5 - Intermediate Conditional Expressions/9. Solutions.html 1.7 kB
  • 07. Day 7 - Advanced UNION & Subqueries/13. Solution Subqueries in SELECT.vtt 1.7 kB
  • 04. Day 4 - Intermediate Functions/27. Solution Intervals & Timestamps.vtt 1.7 kB
  • 10. Day 10 - Advanced Views & Data Manipulation/6. Solution DELETE.vtt 1.7 kB
  • 01. Day 1 - Getting started with SQL!/19. Challenge SELECT.vtt 1.7 kB
  • 16. Extra Day CTEs (Common Table Expressions)/1. Why an extra day.html 1.7 kB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/10. Challenge Stored procedures.vtt 1.7 kB
  • 03. Day 3 - Basics Grouping/1. Today's plan.vtt 1.6 kB
  • 11. Day 11 - Pro Window Functions/5. Challenge OVER() with ORDER BY.vtt 1.6 kB
  • 06. Day 6 - Intermediate Joins/21. Solutions.html 1.6 kB
  • 16. Extra Day CTEs (Common Table Expressions)/12. Challenge 3 Recursive CTE.html 1.6 kB
  • 02. Day 2 - Basics Filtering/3. Challenge WHERE.vtt 1.6 kB
  • 04. Day 4 - Intermediate Functions/14. Challenge POSITION.vtt 1.6 kB
  • 02. Day 2 - Basics Filtering/20. Challenge IN.vtt 1.6 kB
  • 13. Day 13 - Pro Course project/1. Project introduction.html 1.5 kB
  • 05. Day 5 - Intermediate Conditional Expressions/17. Solution CAST & COALESCE.vtt 1.5 kB
  • 04. Day 4 - Intermediate Functions/17. Challenge SUBSTRING.vtt 1.5 kB
  • 04. Day 4 - Intermediate Functions/26. Challenge Intervals & Timestamps.vtt 1.5 kB
  • 06. Day 6 - Intermediate Joins/4. Challenge INNER JOIN.vtt 1.5 kB
  • 01. Day 1 - Getting started with SQL!/23. Challenge ORDER BY.vtt 1.5 kB
  • 07. Day 7 - Advanced UNION & Subqueries/15. Challenge Correlated subqueries in WHERE.vtt 1.4 kB
  • 11. Day 11 - Pro Window Functions/12. Challenge LEAD & LAG.vtt 1.4 kB
  • 03. Day 3 - Basics Grouping/18. Note for Mac users.html 1.4 kB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/13. Challenge Self joins.vtt 1.4 kB
  • 04. Day 4 - Intermediate Functions/11. Challenge Concatenate.vtt 1.4 kB
  • 11. Day 11 - Pro Window Functions/8. Challenge RANK().vtt 1.4 kB
  • 04. Day 4 - Intermediate Functions/7. Challenge LEFT & RIGHT.vtt 1.4 kB
  • 04. Day 4 - Intermediate Functions/4. Challenge LENGTH, LOWER & UPPER.vtt 1.4 kB
  • 02. Day 2 - Basics Filtering/29. Introducing Role Plays.html 1.3 kB
  • 10. Day 10 - Advanced Views & Data Manipulation/2. Challenge UPDATE.vtt 1.2 kB
  • 05. Day 5 - Intermediate Conditional Expressions/16. Challenge CAST & COALESCE.vtt 1.2 kB
  • 16. Extra Day CTEs (Common Table Expressions)/4. Challenge 1 Create a simple CTE.html 1.2 kB
  • 01. Day 1 - Getting started with SQL!/26. Challenge SELECT DISTINCT.vtt 1.2 kB
  • 10. Day 10 - Advanced Views & Data Manipulation/16. Solution Managing views.html 1.1 kB
  • 16. Extra Day CTEs (Common Table Expressions)/5. Solution 1 Create a simple CTE.html 1.1 kB
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/4. Additional challenge.vtt 1.0 kB
  • 10. Day 10 - Advanced Views & Data Manipulation/8. Challenge CREATE TABLE AS.vtt 1.0 kB
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/6. Challenge Transactions.vtt 982 Bytes
  • 06. Day 6 - Intermediate Joins/18. Challenge Joining multiple tables.vtt 972 Bytes
  • 02. Day 2 - Basics Filtering/16. Challenge BETWEEN.vtt 970 Bytes
  • 07. Day 7 - Advanced UNION & Subqueries/12. Challenge Subqueries in SELECT.vtt 966 Bytes
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/3. Challenge User-defined functions.vtt 959 Bytes
  • 01. Day 1 - Getting started with SQL!/15. Common problems Slow performance.html 881 Bytes
  • 16. Extra Day CTEs (Common Table Expressions)/13. Solution 3 Recursive CTE.html 857 Bytes
  • 01. Day 1 - Getting started with SQL!/12. Common problems Set binary paths.html 843 Bytes
  • 10. Day 10 - Advanced Views & Data Manipulation/15. Challenge Managing views.html 830 Bytes
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/4. privileges.txt 802 Bytes
  • 10. Day 10 - Advanced Views & Data Manipulation/5. Challenge DELETE.vtt 740 Bytes
  • 07. Day 7 - Advanced UNION & Subqueries/9. Challenge Subqueries in FROM.vtt 719 Bytes
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/2. Challenge GROUPING SETS.vtt 703 Bytes
  • 02. Day 2 - Basics Filtering/13. Quick note on time zones.html 685 Bytes
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/5. Challenge Privileges.html 613 Bytes
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/6. Solution Privileges.html 562 Bytes
  • 06. Day 6 - Intermediate Joins/20. More challenges.html 531 Bytes
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/13. execution_plan_query_performance.txt 522 Bytes
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/11. Solution CUBE.html 483 Bytes
  • 15. Day 15 - Pro Indexes, Partitining & Query Optimization/14. Today's slides.html 422 Bytes
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/10. Challenge CUBE.html 391 Bytes
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/12. CreateTable.txt 380 Bytes
  • 07. Day 7 - Advanced UNION & Subqueries/20. Today's slides.html 370 Bytes
  • 10. Day 10 - Advanced Views & Data Manipulation/18. Today's slides.html 324 Bytes
  • 10. Day 10 - Advanced Views & Data Manipulation/12. Solution CREATE VIEW.html 317 Bytes
  • 09. Day 9 - Advanced Managing tables & databases/17. DROP & TRUNCATE.txt 297 Bytes
  • 10. Day 10 - Advanced Views & Data Manipulation/11. Challenge CREATE VIEW.html 295 Bytes
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/5. TRANSACTIONS.txt 271 Bytes
  • 12. Day 12 - Pro Grouping sets, rollups, self-joins/17. Today's slides.html 265 Bytes
  • 14. Day 14 - Pro Stored procedures, transactions & user-defined functions/12. Today's slides.html 254 Bytes
  • 05. Day 5 - Intermediate Conditional Expressions/19. Today's slides.html 234 Bytes
  • 09. Day 9 - Advanced Managing tables & databases/21. Today's slides.html 231 Bytes
  • 06. Day 6 - Intermediate Joins/22. Today's slides.html 229 Bytes
  • 11. Day 11 - Pro Window Functions/14. Today's slides.html 220 Bytes
  • 04. Day 4 - Intermediate Functions/28. Today's slides.html 213 Bytes
  • 10. Day 10 - Advanced Views & Data Manipulation/17. Create table.txt 185 Bytes

温馨提示

本站不存储任何资源内容,只收集BT种子元数据(例如文件名和文件大小)和磁力链接(BT种子标识符),并提供查询服务,是一个完全合法的搜索引擎系统。网站不提供种子下载服务,用户可以通过第三方链接或磁力链接获取到相关的种子资源。本站也不对BT种子真实性及合法性负责,请用户注意甄别!