种子简介

种子名称： [FreeCourseSite.com] Udemy - 15 Days of SQL The Complete SQL Masterclass 2023
文件类型： 视频
文件数目： 223个文件
文件大小： 5.6 GB
收录时间： 2023-10-3 02:41
已经下载： 3次
资源热度： 104
最近下载： 2024-5-24 04:29

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:b317770fe43db42b49810e0785094b4f5094bd43&dn=[FreeCourseSite.com] Udemy - 15 Days of SQL The Complete SQL Masterclass 2023 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[FreeCourseSite.com] Udemy - 15 Days of SQL The Complete SQL Masterclass 2023.torrent

1. Day 1 - Getting started with SQL!/1. How to get the most out of the course.mp433.66MB

1. Day 1 - Getting started with SQL!/10. Installing PostgreSQL & pgAdmin (MacOS).mp438.31MB

1. Day 1 - Getting started with SQL!/11. Setting up the database.mp427.54MB

1. Day 1 - Getting started with SQL!/12. The Project.mp421.59MB

1. Day 1 - Getting started with SQL!/13. SELECT.mp438.86MB

1. Day 1 - Getting started with SQL!/14. Challenge SELECT.mp46.59MB

1. Day 1 - Getting started with SQL!/15. Solution SELECT.mp425.16MB

1. Day 1 - Getting started with SQL!/16. ORDER BY.mp436.97MB

1. Day 1 - Getting started with SQL!/17. Challenge ORDER BY.mp46.42MB

1. Day 1 - Getting started with SQL!/18. Solution ORDER BY.mp420.98MB

1. Day 1 - Getting started with SQL!/19. SELECT DISTINCT.mp425.46MB

1. Day 1 - Getting started with SQL!/2. How this course works.mp425.15MB

1. Day 1 - Getting started with SQL!/20. Challenge SELECT DISTINCT.mp45.18MB

1. Day 1 - Getting started with SQL!/21. Solution SELECT DISTINCT.mp414.48MB

1. Day 1 - Getting started with SQL!/22. LIMIT.mp426.1MB

1. Day 1 - Getting started with SQL!/23. COUNT().mp421.39MB

1. Day 1 - Getting started with SQL!/24. Today's challenges.mp431.49MB

1. Day 1 - Getting started with SQL!/25. Today's summary.mp432.73MB

1. Day 1 - Getting started with SQL!/3. Why learning SQL.mp424.83MB

1. Day 1 - Getting started with SQL!/5. What is a database.mp419.51MB

1. Day 1 - Getting started with SQL!/7. Different dialects of SQL.mp413.82MB

1. Day 1 - Getting started with SQL!/9. Installing PostgreSQL & pgAdmin (Windows).mp435.61MB

10. Day 10 - Advanced Views & Data Manipulation/1. UPDATE.mp431.45MB

10. Day 10 - Advanced Views & Data Manipulation/10. CREATE VIEW.mp437.75MB

10. Day 10 - Advanced Views & Data Manipulation/13. CREATE MATERIALIZED VIEW.mp431.68MB

10. Day 10 - Advanced Views & Data Manipulation/14. Managing views.mp416.07MB

10. Day 10 - Advanced Views & Data Manipulation/17. Import & Export.mp463.15MB

10. Day 10 - Advanced Views & Data Manipulation/2. Challenge UPDATE.mp45.2MB

10. Day 10 - Advanced Views & Data Manipulation/3. Solution UPDATE.mp424.29MB

10. Day 10 - Advanced Views & Data Manipulation/4. DELETE.mp433.56MB

10. Day 10 - Advanced Views & Data Manipulation/5. Challenge DELETE.mp44.19MB

10. Day 10 - Advanced Views & Data Manipulation/6. Solution DELETE.mp48.79MB

10. Day 10 - Advanced Views & Data Manipulation/7. CREATE TABLE AS.mp421.33MB

10. Day 10 - Advanced Views & Data Manipulation/8. Challenge CREATE TABLE AS.mp43.98MB

10. Day 10 - Advanced Views & Data Manipulation/9. Solution CREATE TABLE AS.mp419.83MB

11. Day 11 - Pro Window Functions/1. OVER() with PARTITION BY.mp466.57MB

11. Day 11 - Pro Window Functions/10. FIRST_VALUE().mp424.85MB

11. Day 11 - Pro Window Functions/11. LEAD & LAG.mp430.92MB

11. Day 11 - Pro Window Functions/12. Challenge LEAD & LAG.mp45.75MB

11. Day 11 - Pro Window Functions/13. Solution LEAD & LAG.mp432.26MB

11. Day 11 - Pro Window Functions/14. Additional challenge.mp44.12MB

11. Day 11 - Pro Window Functions/15. Solution Additional Challenge.mp420.2MB

11. Day 11 - Pro Window Functions/2. Challenge OVER() with PARTITION BY.mp49.86MB

11. Day 11 - Pro Window Functions/3. Solution OVER() with PARTITION BY.mp429.65MB

11. Day 11 - Pro Window Functions/4. OVER() with ORDER BY.mp444.79MB

11. Day 11 - Pro Window Functions/5. Challenge OVER() with ORDER BY.mp46.82MB

11. Day 11 - Pro Window Functions/6. Solution OVER() with ORDER BY.mp412.53MB

11. Day 11 - Pro Window Functions/7. RANK().mp448.65MB

11. Day 11 - Pro Window Functions/8. Challenge RANK().mp47.05MB

11. Day 11 - Pro Window Functions/9. Solution RANK().mp420.52MB

12. Day 12 - Pro Grouping sets, rollups, self-joins/1. GROUPING SETS.mp442.07MB

12. Day 12 - Pro Grouping sets, rollups, self-joins/10. Self joins.mp450.83MB

12. Day 12 - Pro Grouping sets, rollups, self-joins/11. Challenge Self joins.mp45.89MB

12. Day 12 - Pro Grouping sets, rollups, self-joins/12. Solution Self joins.mp419.27MB

12. Day 12 - Pro Grouping sets, rollups, self-joins/13. CROSS JOIN.mp426.73MB

12. Day 12 - Pro Grouping sets, rollups, self-joins/14. NATURAL JOIN.mp433.28MB

12. Day 12 - Pro Grouping sets, rollups, self-joins/2. Challenge GROUPING SETS.mp43.22MB

12. Day 12 - Pro Grouping sets, rollups, self-joins/3. Solution GROUPING SETS.mp411.31MB

12. Day 12 - Pro Grouping sets, rollups, self-joins/4. ROLLUP.mp448.87MB

12. Day 12 - Pro Grouping sets, rollups, self-joins/5. Challenge ROLLUP.mp48.16MB

12. Day 12 - Pro Grouping sets, rollups, self-joins/6. Solution ROLLUP.mp420.83MB

12. Day 12 - Pro Grouping sets, rollups, self-joins/7. CUBE.mp431.92MB

14. Day 14 - Pro Stored procedures, transactions & user-defined functions/1. User-defined functions.mp437.23MB

14. Day 14 - Pro Stored procedures, transactions & user-defined functions/10. Challenge Stored procedures.mp47.54MB

14. Day 14 - Pro Stored procedures, transactions & user-defined functions/11. Solution Stored procedure.mp462.25MB

14. Day 14 - Pro Stored procedures, transactions & user-defined functions/2. User-defined functions - Example.mp426.91MB

14. Day 14 - Pro Stored procedures, transactions & user-defined functions/3. Challenge User-defined functions.mp43.6MB

14. Day 14 - Pro Stored procedures, transactions & user-defined functions/4. Solution.mp430.27MB

14. Day 14 - Pro Stored procedures, transactions & user-defined functions/5. Transactions.mp438.72MB

14. Day 14 - Pro Stored procedures, transactions & user-defined functions/6. Challenge Transactions.mp43.84MB

14. Day 14 - Pro Stored procedures, transactions & user-defined functions/7. Solution Transactions.mp430.11MB

14. Day 14 - Pro Stored procedures, transactions & user-defined functions/8. Rollbacks.mp433.11MB

14. Day 14 - Pro Stored procedures, transactions & user-defined functions/9. Stored procedures.mp456.42MB

15. Day 15 - Pro Indexes, Partitining & Query Optimization/1. User management.mp419.76MB

15. Day 15 - Pro Indexes, Partitining & Query Optimization/10. Indexes - Guidelines.mp426.97MB

15. Day 15 - Pro Indexes, Partitining & Query Optimization/11. Creating indexes.mp445.7MB

15. Day 15 - Pro Indexes, Partitining & Query Optimization/13. Execution plan & query performance.mp466.36MB

15. Day 15 - Pro Indexes, Partitining & Query Optimization/2. CREATE USER ROLE.mp447.29MB

15. Day 15 - Pro Indexes, Partitining & Query Optimization/3. GRANT & REVOKE privileges.mp445.62MB

15. Day 15 - Pro Indexes, Partitining & Query Optimization/4. Privileges - Hands-on.mp464.14MB

15. Day 15 - Pro Indexes, Partitining & Query Optimization/7. What are indexes.mp431.8MB

15. Day 15 - Pro Indexes, Partitining & Query Optimization/8. B-Tree index.mp421.09MB

15. Day 15 - Pro Indexes, Partitining & Query Optimization/9. Bitmap index.mp422.5MB

2. Day 2 - Basics Filtering/1. WHERE.mp427.67MB

2. Day 2 - Basics Filtering/10. BETWEEN.mp434.95MB

2. Day 2 - Basics Filtering/11. Challenge BETWEEN.mp44.75MB

2. Day 2 - Basics Filtering/12. Solution BETWEEN.mp417.08MB

2. Day 2 - Basics Filtering/13. IN.mp422.62MB

2. Day 2 - Basics Filtering/14. Challenge IN.mp47.04MB

2. Day 2 - Basics Filtering/15. Solution IN.mp414.46MB

2. Day 2 - Basics Filtering/16. LIKE.mp446.47MB

2. Day 2 - Basics Filtering/17. Challenge LIKE.mp47.22MB

2. Day 2 - Basics Filtering/18. Solution LIKE.mp435.27MB

2. Day 2 - Basics Filtering/19. Comments & Aliases.mp441.81MB

2. Day 2 - Basics Filtering/2. Challenge WHERE.mp45.56MB

2. Day 2 - Basics Filtering/20. Today's summary.mp427.47MB

2. Day 2 - Basics Filtering/21. Today's challenges.mp435.34MB

2. Day 2 - Basics Filtering/3. Solution WHERE.mp421.25MB

2. Day 2 - Basics Filtering/4. WHERE operators.mp428.08MB

2. Day 2 - Basics Filtering/5. Challenge WHERE operators.mp47.64MB

2. Day 2 - Basics Filtering/6. Solution WHERE operators.mp413.53MB

2. Day 2 - Basics Filtering/7. WHERE with ANDOR.mp445.17MB

2. Day 2 - Basics Filtering/8. Challenge WHERE with ANDOR.mp48.91MB

2. Day 2 - Basics Filtering/9. Solution WHERE with ANDOR.mp422.16MB

3. Day 3 - Basics Grouping/1. Today's plan.mp48.7MB

3. Day 3 - Basics Grouping/10. HAVING.mp422.85MB

3. Day 3 - Basics Grouping/11. Challenge HAVING.mp417.16MB

3. Day 3 - Basics Grouping/12. Solution HAVING.mp426.74MB

3. Day 3 - Basics Grouping/13. Introducing the second project.mp429.78MB

3. Day 3 - Basics Grouping/14. Today's summary.mp413.67MB

3. Day 3 - Basics Grouping/2. Aggregate functions.mp431.75MB

3. Day 3 - Basics Grouping/3. Challenge Aggregate function.mp410.43MB

3. Day 3 - Basics Grouping/4. GROUP BY.mp431.24MB

3. Day 3 - Basics Grouping/5. Challenge GROUP BY.mp410.11MB

3. Day 3 - Basics Grouping/6. Solution GROUP BY.mp420.09MB

3. Day 3 - Basics Grouping/7. GROUP BY multiple columns.mp421.59MB

3. Day 3 - Basics Grouping/8. Challenge GROUP BY multiple columns.mp416.41MB

3. Day 3 - Basics Grouping/9. Solution GROUP BY multiple columns.mp425.85MB

4. Day 4 - Intermediate Functions/1. Today's plan.mp411.53MB

4. Day 4 - Intermediate Functions/10. Solution Concatenate.mp412.39MB

4. Day 4 - Intermediate Functions/11. POSITION.mp422.4MB

4. Day 4 - Intermediate Functions/12. Challenge POSITION.mp47.9MB

4. Day 4 - Intermediate Functions/13. Solution POSITION.mp416.28MB

4. Day 4 - Intermediate Functions/14. SUBSTRING.mp446.87MB

4. Day 4 - Intermediate Functions/15. Challenge SUBSTRING.mp46.78MB

4. Day 4 - Intermediate Functions/16. Solution SUBSTRING.mp434.54MB

4. Day 4 - Intermediate Functions/17. EXTRACT.mp449.97MB

4. Day 4 - Intermediate Functions/18. Challenge EXTRACT.mp48.84MB

4. Day 4 - Intermediate Functions/19. Solution EXTRACT.mp432.75MB

4. Day 4 - Intermediate Functions/2. LENGTH, LOWER & UPPER.mp436.07MB

4. Day 4 - Intermediate Functions/20. TO_CHAR.mp452.44MB

4. Day 4 - Intermediate Functions/21. Challenge TO_CHAR.mp46.69MB

4. Day 4 - Intermediate Functions/22. Solution TO_CHAR.mp432.95MB

4. Day 4 - Intermediate Functions/23. Intervals & Timestamps.mp432.56MB

4. Day 4 - Intermediate Functions/24. Challenge Intervals & Timestamps.mp46.72MB

4. Day 4 - Intermediate Functions/25. Solution Intervals & Timestamps.mp411.08MB

4. Day 4 - Intermediate Functions/3. Challenge LENGTH, LOWER & UPPER.mp45.8MB

4. Day 4 - Intermediate Functions/4. Solution LENGTH, LOWER & UPPER.mp412.31MB

4. Day 4 - Intermediate Functions/5. LEFT & RIGHT.mp423.99MB

4. Day 4 - Intermediate Functions/6. Challenge LEFT & RIGHT.mp46.08MB

4. Day 4 - Intermediate Functions/7. Solution LEFT & RIGHT.mp413.65MB

4. Day 4 - Intermediate Functions/8. Concatenate.mp418.07MB

4. Day 4 - Intermediate Functions/9. Challenge Concatenate.mp46.8MB

5. Day 5 - Intermediate Conditional Expressions/1. Mathematical functions and operators.mp439.21MB

5. Day 5 - Intermediate Conditional Expressions/10. COALESCE.mp423MB

5. Day 5 - Intermediate Conditional Expressions/11. CAST.mp440.92MB

5. Day 5 - Intermediate Conditional Expressions/12. Challenge CAST & COALESCE.mp47.29MB

5. Day 5 - Intermediate Conditional Expressions/13. Solution CAST & COALESCE.mp410.65MB

5. Day 5 - Intermediate Conditional Expressions/14. REPLACE.mp426.13MB

5. Day 5 - Intermediate Conditional Expressions/2. Challenge Mathematical functions and operators.mp413.8MB

5. Day 5 - Intermediate Conditional Expressions/3. Solution Mathematical functions and operators.mp425.27MB

5. Day 5 - Intermediate Conditional Expressions/4. CASE WHEN - Theory.mp440.66MB

5. Day 5 - Intermediate Conditional Expressions/5. CASE WHEN - Hands-on.mp443.67MB

5. Day 5 - Intermediate Conditional Expressions/6. 3 Challenge CASE WHEN.mp426.32MB

5. Day 5 - Intermediate Conditional Expressions/8. Solution CASE WHEN.mp451.1MB

5. Day 5 - Intermediate Conditional Expressions/9. CASE WHEN & SUM.mp446.32MB

6. Day 6 - Intermediate Joins/1. What are joins.mp420.01MB

6. Day 6 - Intermediate Joins/10. Solution LEFT OUTER JOIN.mp437.45MB

6. Day 6 - Intermediate Joins/11. RIGHT OUTER JOIN.mp430.71MB

6. Day 6 - Intermediate Joins/12. Challenge Joins.mp47.18MB

6. Day 6 - Intermediate Joins/13. Solution Joins.mp427.75MB

6. Day 6 - Intermediate Joins/14. Joins on multiple conditions.mp446.16MB

6. Day 6 - Intermediate Joins/15. Solution Joins on multiple conditions.mp413.03MB

6. Day 6 - Intermediate Joins/16. Joining multiple tables.mp434.92MB

6. Day 6 - Intermediate Joins/17. Joining multiple tables - Practice.mp439.42MB

6. Day 6 - Intermediate Joins/18. Challenge Joining multiple tables.mp43.54MB

6. Day 6 - Intermediate Joins/19. Solution Joining multiple tables.mp434.35MB

6. Day 6 - Intermediate Joins/2. INNER JOIN - Theory.mp467.36MB

6. Day 6 - Intermediate Joins/3. INNER JOIN - Practice.mp451.29MB

6. Day 6 - Intermediate Joins/4. Challenge INNER JOIN.mp44.68MB

6. Day 6 - Intermediate Joins/5. Solution INNER JOIN.mp415.89MB

6. Day 6 - Intermediate Joins/6. FULL OUTER JOIN.mp443.67MB

6. Day 6 - Intermediate Joins/7. JOIN & WHERE.mp424.78MB

6. Day 6 - Intermediate Joins/8. LEFT OUTER JOIN.mp441.23MB

6. Day 6 - Intermediate Joins/9. Challenge LEFT OUTER JOIN.mp410.05MB

7. Day 7 - Advanced UNION & Subqueries/1. UNION.mp446.06MB

7. Day 7 - Advanced UNION & Subqueries/10. Solution Subqueries in FROM.mp414.07MB

7. Day 7 - Advanced UNION & Subqueries/11. Subqueries in SELECT.mp425.64MB

7. Day 7 - Advanced UNION & Subqueries/12. Challenge Subqueries in SELECT.mp44.17MB

7. Day 7 - Advanced UNION & Subqueries/13. Solution Subqueries in SELECT.mp410.22MB

7. Day 7 - Advanced UNION & Subqueries/14. Correlated Subqueries in WHERE.mp456.6MB

7. Day 7 - Advanced UNION & Subqueries/15. Challenge Correlated subqueries in WHERE.mp45.87MB

7. Day 7 - Advanced UNION & Subqueries/16. Solution Correlated subqueries in WHERE.mp417.47MB

7. Day 7 - Advanced UNION & Subqueries/17. Correlated Subquery in SELECT.mp428.14MB

7. Day 7 - Advanced UNION & Subqueries/18. More challenges Correlated subqueres.mp415.51MB

7. Day 7 - Advanced UNION & Subqueries/19. Solution More challenges.mp461.89MB

7. Day 7 - Advanced UNION & Subqueries/2. UNION - Practice.mp433.54MB

7. Day 7 - Advanced UNION & Subqueries/3. Subqueries in WHERE.mp438.56MB

7. Day 7 - Advanced UNION & Subqueries/4. Challenge Subqueries in WHERE.mp46.47MB

7. Day 7 - Advanced UNION & Subqueries/5. Solution Subqueries in WHERE.mp429.23MB

7. Day 7 - Advanced UNION & Subqueries/6. More challenges Subqueries in WHERE.mp48.74MB

7. Day 7 - Advanced UNION & Subqueries/7. Solution More challenges.mp437.85MB

7. Day 7 - Advanced UNION & Subqueries/8. Subqueries in FROM.mp422.73MB

7. Day 7 - Advanced UNION & Subqueries/9. Challenge Subqueries in FROM.mp42.75MB

8. Day 8 - Advanced Course project/1. Project Introduction.mp447.22MB

8. Day 8 - Advanced Course project/10. Solution 7.mp418.39MB

8. Day 8 - Advanced Course project/11. Solution 8.mp411.32MB

8. Day 8 - Advanced Course project/12. Solution 9.mp423.19MB

8. Day 8 - Advanced Course project/13. Solution 10.mp425.54MB

8. Day 8 - Advanced Course project/14. Solution 11.mp418MB

8. Day 8 - Advanced Course project/15. Solution 12.mp437.02MB

8. Day 8 - Advanced Course project/16. Solution 13.mp452.51MB

8. Day 8 - Advanced Course project/17. Solution 14.mp440.4MB

8. Day 8 - Advanced Course project/4. Solution 1.mp47.81MB

8. Day 8 - Advanced Course project/5. Solution 2.mp422.57MB

8. Day 8 - Advanced Course project/6. Solution 3.mp421.27MB

8. Day 8 - Advanced Course project/7. Solution 4.mp49.22MB

8. Day 8 - Advanced Course project/8. Solution 5.mp419.99MB

8. Day 8 - Advanced Course project/9. Solution 6.mp420.9MB

9. Day 9 - Advanced Managing tables & databases/1. Managing databases & tables.mp421.62MB

9. Day 9 - Advanced Managing tables & databases/10. CREATE TABLE.mp443.74MB

9. Day 9 - Advanced Managing tables & databases/12. INSERT.mp430.78MB

9. Day 9 - Advanced Managing tables & databases/14. ALTER TABLE.mp432.19MB

9. Day 9 - Advanced Managing tables & databases/15. Challenge ALTER TABLE.mp415.64MB

9. Day 9 - Advanced Managing tables & databases/16. Solution ALTER TABLE.mp440.05MB

9. Day 9 - Advanced Managing tables & databases/17. TRUNCATE & DROP TABLE.mp426.27MB

9. Day 9 - Advanced Managing tables & databases/18. CHECK.mp434.07MB

9. Day 9 - Advanced Managing tables & databases/19. Challenge CHECK.mp412.25MB

9. Day 9 - Advanced Managing tables & databases/2. CREATE DATABASE.mp427.39MB

9. Day 9 - Advanced Managing tables & databases/20. Solution CHECK.mp448.68MB

9. Day 9 - Advanced Managing tables & databases/4. Data Types.mp458.15MB

9. Day 9 - Advanced Managing tables & databases/6. Constraints.mp429.01MB

9. Day 9 - Advanced Managing tables & databases/8. Primary Key & Foreign Key.mp428.56MB