zhongziso种子搜
首页
功能
磁力转BT
BT转磁力
使用教程
免责声明
关于
zhongziso
搜索
[FreeCourseSite.com] Udemy - 15 Days of SQL The Complete SQL Masterclass 2023
magnet:?xt=urn:btih:b317770fe43db42b49810e0785094b4f5094bd43&dn=[FreeCourseSite.com] Udemy - 15 Days of SQL The Complete SQL Masterclass 2023
磁力链接详情
Hash值:
b317770fe43db42b49810e0785094b4f5094bd43
点击数:
113
文件大小:
5.6 GB
文件数量:
223
创建日期:
2023-10-3 02:41
最后访问:
2024-6-11 10:24
访问标签:
FreeCourseSite
com
Udemy
-
15
Days
of
SQL
The
Complete
SQL
Masterclass
2023
文件列表详情
1. Day 1 - Getting started with SQL!/1. How to get the most out of the course.mp4 33.66 MB
1. Day 1 - Getting started with SQL!/10. Installing PostgreSQL & pgAdmin (MacOS).mp4 38.31 MB
1. Day 1 - Getting started with SQL!/11. Setting up the database.mp4 27.54 MB
1. Day 1 - Getting started with SQL!/12. The Project.mp4 21.59 MB
1. Day 1 - Getting started with SQL!/13. SELECT.mp4 38.86 MB
1. Day 1 - Getting started with SQL!/14. Challenge SELECT.mp4 6.59 MB
1. Day 1 - Getting started with SQL!/15. Solution SELECT.mp4 25.16 MB
1. Day 1 - Getting started with SQL!/16. ORDER BY.mp4 36.97 MB
1. Day 1 - Getting started with SQL!/17. Challenge ORDER BY.mp4 6.42 MB
1. Day 1 - Getting started with SQL!/18. Solution ORDER BY.mp4 20.98 MB
1. Day 1 - Getting started with SQL!/19. SELECT DISTINCT.mp4 25.46 MB
1. Day 1 - Getting started with SQL!/2. How this course works.mp4 25.15 MB
1. Day 1 - Getting started with SQL!/20. Challenge SELECT DISTINCT.mp4 5.18 MB
1. Day 1 - Getting started with SQL!/21. Solution SELECT DISTINCT.mp4 14.48 MB
1. Day 1 - Getting started with SQL!/22. LIMIT.mp4 26.1 MB
1. Day 1 - Getting started with SQL!/23. COUNT().mp4 21.39 MB
1. Day 1 - Getting started with SQL!/24. Today's challenges.mp4 31.49 MB
1. Day 1 - Getting started with SQL!/25. Today's summary.mp4 32.73 MB
1. Day 1 - Getting started with SQL!/3. Why learning SQL.mp4 24.83 MB
1. Day 1 - Getting started with SQL!/5. What is a database.mp4 19.51 MB
1. Day 1 - Getting started with SQL!/7. Different dialects of SQL.mp4 13.82 MB
1. Day 1 - Getting started with SQL!/9. Installing PostgreSQL & pgAdmin (Windows).mp4 35.61 MB
10. Day 10 - Advanced Views & Data Manipulation/1. UPDATE.mp4 31.45 MB
10. Day 10 - Advanced Views & Data Manipulation/10. CREATE VIEW.mp4 37.75 MB
10. Day 10 - Advanced Views & Data Manipulation/13. CREATE MATERIALIZED VIEW.mp4 31.68 MB
10. Day 10 - Advanced Views & Data Manipulation/14. Managing views.mp4 16.07 MB
10. Day 10 - Advanced Views & Data Manipulation/17. Import & Export.mp4 63.15 MB
10. Day 10 - Advanced Views & Data Manipulation/2. Challenge UPDATE.mp4 5.2 MB
10. Day 10 - Advanced Views & Data Manipulation/3. Solution UPDATE.mp4 24.29 MB
10. Day 10 - Advanced Views & Data Manipulation/4. DELETE.mp4 33.56 MB
10. Day 10 - Advanced Views & Data Manipulation/5. Challenge DELETE.mp4 4.19 MB
10. Day 10 - Advanced Views & Data Manipulation/6. Solution DELETE.mp4 8.79 MB
10. Day 10 - Advanced Views & Data Manipulation/7. CREATE TABLE AS.mp4 21.33 MB
10. Day 10 - Advanced Views & Data Manipulation/8. Challenge CREATE TABLE AS.mp4 3.98 MB
10. Day 10 - Advanced Views & Data Manipulation/9. Solution CREATE TABLE AS.mp4 19.83 MB
11. Day 11 - Pro Window Functions/1. OVER() with PARTITION BY.mp4 66.57 MB
11. Day 11 - Pro Window Functions/10. FIRST_VALUE().mp4 24.85 MB
11. Day 11 - Pro Window Functions/11. LEAD & LAG.mp4 30.92 MB
11. Day 11 - Pro Window Functions/12. Challenge LEAD & LAG.mp4 5.75 MB
11. Day 11 - Pro Window Functions/13. Solution LEAD & LAG.mp4 32.26 MB
11. Day 11 - Pro Window Functions/14. Additional challenge.mp4 4.12 MB
11. Day 11 - Pro Window Functions/15. Solution Additional Challenge.mp4 20.2 MB
11. Day 11 - Pro Window Functions/2. Challenge OVER() with PARTITION BY.mp4 9.86 MB
11. Day 11 - Pro Window Functions/3. Solution OVER() with PARTITION BY.mp4 29.65 MB
11. Day 11 - Pro Window Functions/4. OVER() with ORDER BY.mp4 44.79 MB
11. Day 11 - Pro Window Functions/5. Challenge OVER() with ORDER BY.mp4 6.82 MB
11. Day 11 - Pro Window Functions/6. Solution OVER() with ORDER BY.mp4 12.53 MB
11. Day 11 - Pro Window Functions/7. RANK().mp4 48.65 MB
11. Day 11 - Pro Window Functions/8. Challenge RANK().mp4 7.05 MB
11. Day 11 - Pro Window Functions/9. Solution RANK().mp4 20.52 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/1. GROUPING SETS.mp4 42.07 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/10. Self joins.mp4 50.83 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/11. Challenge Self joins.mp4 5.89 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/12. Solution Self joins.mp4 19.27 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/13. CROSS JOIN.mp4 26.73 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/14. NATURAL JOIN.mp4 33.28 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/2. Challenge GROUPING SETS.mp4 3.22 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/3. Solution GROUPING SETS.mp4 11.31 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/4. ROLLUP.mp4 48.87 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/5. Challenge ROLLUP.mp4 8.16 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/6. Solution ROLLUP.mp4 20.83 MB
12. Day 12 - Pro Grouping sets, rollups, self-joins/7. CUBE.mp4 31.92 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/1. User-defined functions.mp4 37.23 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/10. Challenge Stored procedures.mp4 7.54 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/11. Solution Stored procedure.mp4 62.25 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/2. User-defined functions - Example.mp4 26.91 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/3. Challenge User-defined functions.mp4 3.6 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/4. Solution.mp4 30.27 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/5. Transactions.mp4 38.72 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/6. Challenge Transactions.mp4 3.84 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/7. Solution Transactions.mp4 30.11 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/8. Rollbacks.mp4 33.11 MB
14. Day 14 - Pro Stored procedures, transactions & user-defined functions/9. Stored procedures.mp4 56.42 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/1. User management.mp4 19.76 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/10. Indexes - Guidelines.mp4 26.97 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/11. Creating indexes.mp4 45.7 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/13. Execution plan & query performance.mp4 66.36 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/2. CREATE USER ROLE.mp4 47.29 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/3. GRANT & REVOKE privileges.mp4 45.62 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/4. Privileges - Hands-on.mp4 64.14 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/7. What are indexes.mp4 31.8 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/8. B-Tree index.mp4 21.09 MB
15. Day 15 - Pro Indexes, Partitining & Query Optimization/9. Bitmap index.mp4 22.5 MB
2. Day 2 - Basics Filtering/1. WHERE.mp4 27.67 MB
2. Day 2 - Basics Filtering/10. BETWEEN.mp4 34.95 MB
2. Day 2 - Basics Filtering/11. Challenge BETWEEN.mp4 4.75 MB
2. Day 2 - Basics Filtering/12. Solution BETWEEN.mp4 17.08 MB
2. Day 2 - Basics Filtering/13. IN.mp4 22.62 MB
2. Day 2 - Basics Filtering/14. Challenge IN.mp4 7.04 MB
2. Day 2 - Basics Filtering/15. Solution IN.mp4 14.46 MB
2. Day 2 - Basics Filtering/16. LIKE.mp4 46.47 MB
2. Day 2 - Basics Filtering/17. Challenge LIKE.mp4 7.22 MB
2. Day 2 - Basics Filtering/18. Solution LIKE.mp4 35.27 MB
2. Day 2 - Basics Filtering/19. Comments & Aliases.mp4 41.81 MB
2. Day 2 - Basics Filtering/2. Challenge WHERE.mp4 5.56 MB
2. Day 2 - Basics Filtering/20. Today's summary.mp4 27.47 MB
2. Day 2 - Basics Filtering/21. Today's challenges.mp4 35.34 MB
2. Day 2 - Basics Filtering/3. Solution WHERE.mp4 21.25 MB
2. Day 2 - Basics Filtering/4. WHERE operators.mp4 28.08 MB
2. Day 2 - Basics Filtering/5. Challenge WHERE operators.mp4 7.64 MB
2. Day 2 - Basics Filtering/6. Solution WHERE operators.mp4 13.53 MB
2. Day 2 - Basics Filtering/7. WHERE with ANDOR.mp4 45.17 MB
2. Day 2 - Basics Filtering/8. Challenge WHERE with ANDOR.mp4 8.91 MB
2. Day 2 - Basics Filtering/9. Solution WHERE with ANDOR.mp4 22.16 MB
3. Day 3 - Basics Grouping/1. Today's plan.mp4 8.7 MB
3. Day 3 - Basics Grouping/10. HAVING.mp4 22.85 MB
3. Day 3 - Basics Grouping/11. Challenge HAVING.mp4 17.16 MB
3. Day 3 - Basics Grouping/12. Solution HAVING.mp4 26.74 MB
3. Day 3 - Basics Grouping/13. Introducing the second project.mp4 29.78 MB
3. Day 3 - Basics Grouping/14. Today's summary.mp4 13.67 MB
3. Day 3 - Basics Grouping/2. Aggregate functions.mp4 31.75 MB
3. Day 3 - Basics Grouping/3. Challenge Aggregate function.mp4 10.43 MB
3. Day 3 - Basics Grouping/4. GROUP BY.mp4 31.24 MB
3. Day 3 - Basics Grouping/5. Challenge GROUP BY.mp4 10.11 MB
3. Day 3 - Basics Grouping/6. Solution GROUP BY.mp4 20.09 MB
3. Day 3 - Basics Grouping/7. GROUP BY multiple columns.mp4 21.59 MB
3. Day 3 - Basics Grouping/8. Challenge GROUP BY multiple columns.mp4 16.41 MB
3. Day 3 - Basics Grouping/9. Solution GROUP BY multiple columns.mp4 25.85 MB
4. Day 4 - Intermediate Functions/1. Today's plan.mp4 11.53 MB
4. Day 4 - Intermediate Functions/10. Solution Concatenate.mp4 12.39 MB
4. Day 4 - Intermediate Functions/11. POSITION.mp4 22.4 MB
4. Day 4 - Intermediate Functions/12. Challenge POSITION.mp4 7.9 MB
4. Day 4 - Intermediate Functions/13. Solution POSITION.mp4 16.28 MB
4. Day 4 - Intermediate Functions/14. SUBSTRING.mp4 46.87 MB
4. Day 4 - Intermediate Functions/15. Challenge SUBSTRING.mp4 6.78 MB
4. Day 4 - Intermediate Functions/16. Solution SUBSTRING.mp4 34.54 MB
4. Day 4 - Intermediate Functions/17. EXTRACT.mp4 49.97 MB
4. Day 4 - Intermediate Functions/18. Challenge EXTRACT.mp4 8.84 MB
4. Day 4 - Intermediate Functions/19. Solution EXTRACT.mp4 32.75 MB
4. Day 4 - Intermediate Functions/2. LENGTH, LOWER & UPPER.mp4 36.07 MB
4. Day 4 - Intermediate Functions/20. TO_CHAR.mp4 52.44 MB
4. Day 4 - Intermediate Functions/21. Challenge TO_CHAR.mp4 6.69 MB
4. Day 4 - Intermediate Functions/22. Solution TO_CHAR.mp4 32.95 MB
4. Day 4 - Intermediate Functions/23. Intervals & Timestamps.mp4 32.56 MB
4. Day 4 - Intermediate Functions/24. Challenge Intervals & Timestamps.mp4 6.72 MB
4. Day 4 - Intermediate Functions/25. Solution Intervals & Timestamps.mp4 11.08 MB
4. Day 4 - Intermediate Functions/3. Challenge LENGTH, LOWER & UPPER.mp4 5.8 MB
4. Day 4 - Intermediate Functions/4. Solution LENGTH, LOWER & UPPER.mp4 12.31 MB
4. Day 4 - Intermediate Functions/5. LEFT & RIGHT.mp4 23.99 MB
4. Day 4 - Intermediate Functions/6. Challenge LEFT & RIGHT.mp4 6.08 MB
4. Day 4 - Intermediate Functions/7. Solution LEFT & RIGHT.mp4 13.65 MB
4. Day 4 - Intermediate Functions/8. Concatenate.mp4 18.07 MB
4. Day 4 - Intermediate Functions/9. Challenge Concatenate.mp4 6.8 MB
5. Day 5 - Intermediate Conditional Expressions/1. Mathematical functions and operators.mp4 39.21 MB
5. Day 5 - Intermediate Conditional Expressions/10. COALESCE.mp4 23 MB
5. Day 5 - Intermediate Conditional Expressions/11. CAST.mp4 40.92 MB
5. Day 5 - Intermediate Conditional Expressions/12. Challenge CAST & COALESCE.mp4 7.29 MB
5. Day 5 - Intermediate Conditional Expressions/13. Solution CAST & COALESCE.mp4 10.65 MB
5. Day 5 - Intermediate Conditional Expressions/14. REPLACE.mp4 26.13 MB
5. Day 5 - Intermediate Conditional Expressions/2. Challenge Mathematical functions and operators.mp4 13.8 MB
5. Day 5 - Intermediate Conditional Expressions/3. Solution Mathematical functions and operators.mp4 25.27 MB
5. Day 5 - Intermediate Conditional Expressions/4. CASE WHEN - Theory.mp4 40.66 MB
5. Day 5 - Intermediate Conditional Expressions/5. CASE WHEN - Hands-on.mp4 43.67 MB
5. Day 5 - Intermediate Conditional Expressions/6. 3 Challenge CASE WHEN.mp4 26.32 MB
5. Day 5 - Intermediate Conditional Expressions/8. Solution CASE WHEN.mp4 51.1 MB
5. Day 5 - Intermediate Conditional Expressions/9. CASE WHEN & SUM.mp4 46.32 MB
6. Day 6 - Intermediate Joins/1. What are joins.mp4 20.01 MB
6. Day 6 - Intermediate Joins/10. Solution LEFT OUTER JOIN.mp4 37.45 MB
6. Day 6 - Intermediate Joins/11. RIGHT OUTER JOIN.mp4 30.71 MB
6. Day 6 - Intermediate Joins/12. Challenge Joins.mp4 7.18 MB
6. Day 6 - Intermediate Joins/13. Solution Joins.mp4 27.75 MB
6. Day 6 - Intermediate Joins/14. Joins on multiple conditions.mp4 46.16 MB
6. Day 6 - Intermediate Joins/15. Solution Joins on multiple conditions.mp4 13.03 MB
6. Day 6 - Intermediate Joins/16. Joining multiple tables.mp4 34.92 MB
6. Day 6 - Intermediate Joins/17. Joining multiple tables - Practice.mp4 39.42 MB
6. Day 6 - Intermediate Joins/18. Challenge Joining multiple tables.mp4 3.54 MB
6. Day 6 - Intermediate Joins/19. Solution Joining multiple tables.mp4 34.35 MB
6. Day 6 - Intermediate Joins/2. INNER JOIN - Theory.mp4 67.36 MB
6. Day 6 - Intermediate Joins/3. INNER JOIN - Practice.mp4 51.29 MB
6. Day 6 - Intermediate Joins/4. Challenge INNER JOIN.mp4 4.68 MB
6. Day 6 - Intermediate Joins/5. Solution INNER JOIN.mp4 15.89 MB
6. Day 6 - Intermediate Joins/6. FULL OUTER JOIN.mp4 43.67 MB
6. Day 6 - Intermediate Joins/7. JOIN & WHERE.mp4 24.78 MB
6. Day 6 - Intermediate Joins/8. LEFT OUTER JOIN.mp4 41.23 MB
6. Day 6 - Intermediate Joins/9. Challenge LEFT OUTER JOIN.mp4 10.05 MB
7. Day 7 - Advanced UNION & Subqueries/1. UNION.mp4 46.06 MB
7. Day 7 - Advanced UNION & Subqueries/10. Solution Subqueries in FROM.mp4 14.07 MB
7. Day 7 - Advanced UNION & Subqueries/11. Subqueries in SELECT.mp4 25.64 MB
7. Day 7 - Advanced UNION & Subqueries/12. Challenge Subqueries in SELECT.mp4 4.17 MB
7. Day 7 - Advanced UNION & Subqueries/13. Solution Subqueries in SELECT.mp4 10.22 MB
7. Day 7 - Advanced UNION & Subqueries/14. Correlated Subqueries in WHERE.mp4 56.6 MB
7. Day 7 - Advanced UNION & Subqueries/15. Challenge Correlated subqueries in WHERE.mp4 5.87 MB
7. Day 7 - Advanced UNION & Subqueries/16. Solution Correlated subqueries in WHERE.mp4 17.47 MB
7. Day 7 - Advanced UNION & Subqueries/17. Correlated Subquery in SELECT.mp4 28.14 MB
7. Day 7 - Advanced UNION & Subqueries/18. More challenges Correlated subqueres.mp4 15.51 MB
7. Day 7 - Advanced UNION & Subqueries/19. Solution More challenges.mp4 61.89 MB
7. Day 7 - Advanced UNION & Subqueries/2. UNION - Practice.mp4 33.54 MB
7. Day 7 - Advanced UNION & Subqueries/3. Subqueries in WHERE.mp4 38.56 MB
7. Day 7 - Advanced UNION & Subqueries/4. Challenge Subqueries in WHERE.mp4 6.47 MB
7. Day 7 - Advanced UNION & Subqueries/5. Solution Subqueries in WHERE.mp4 29.23 MB
7. Day 7 - Advanced UNION & Subqueries/6. More challenges Subqueries in WHERE.mp4 8.74 MB
7. Day 7 - Advanced UNION & Subqueries/7. Solution More challenges.mp4 37.85 MB
7. Day 7 - Advanced UNION & Subqueries/8. Subqueries in FROM.mp4 22.73 MB
7. Day 7 - Advanced UNION & Subqueries/9. Challenge Subqueries in FROM.mp4 2.75 MB
8. Day 8 - Advanced Course project/1. Project Introduction.mp4 47.22 MB
8. Day 8 - Advanced Course project/10. Solution 7.mp4 18.39 MB
8. Day 8 - Advanced Course project/11. Solution 8.mp4 11.32 MB
8. Day 8 - Advanced Course project/12. Solution 9.mp4 23.19 MB
8. Day 8 - Advanced Course project/13. Solution 10.mp4 25.54 MB
8. Day 8 - Advanced Course project/14. Solution 11.mp4 18 MB
8. Day 8 - Advanced Course project/15. Solution 12.mp4 37.02 MB
8. Day 8 - Advanced Course project/16. Solution 13.mp4 52.51 MB
8. Day 8 - Advanced Course project/17. Solution 14.mp4 40.4 MB
8. Day 8 - Advanced Course project/4. Solution 1.mp4 7.81 MB
8. Day 8 - Advanced Course project/5. Solution 2.mp4 22.57 MB
8. Day 8 - Advanced Course project/6. Solution 3.mp4 21.27 MB
8. Day 8 - Advanced Course project/7. Solution 4.mp4 9.22 MB
8. Day 8 - Advanced Course project/8. Solution 5.mp4 19.99 MB
8. Day 8 - Advanced Course project/9. Solution 6.mp4 20.9 MB
9. Day 9 - Advanced Managing tables & databases/1. Managing databases & tables.mp4 21.62 MB
9. Day 9 - Advanced Managing tables & databases/10. CREATE TABLE.mp4 43.74 MB
9. Day 9 - Advanced Managing tables & databases/12. INSERT.mp4 30.78 MB
9. Day 9 - Advanced Managing tables & databases/14. ALTER TABLE.mp4 32.19 MB
9. Day 9 - Advanced Managing tables & databases/15. Challenge ALTER TABLE.mp4 15.64 MB
9. Day 9 - Advanced Managing tables & databases/16. Solution ALTER TABLE.mp4 40.05 MB
9. Day 9 - Advanced Managing tables & databases/17. TRUNCATE & DROP TABLE.mp4 26.27 MB
9. Day 9 - Advanced Managing tables & databases/18. CHECK.mp4 34.07 MB
9. Day 9 - Advanced Managing tables & databases/19. Challenge CHECK.mp4 12.25 MB
9. Day 9 - Advanced Managing tables & databases/2. CREATE DATABASE.mp4 27.39 MB
9. Day 9 - Advanced Managing tables & databases/20. Solution CHECK.mp4 48.68 MB
9. Day 9 - Advanced Managing tables & databases/4. Data Types.mp4 58.15 MB
9. Day 9 - Advanced Managing tables & databases/6. Constraints.mp4 29.01 MB
9. Day 9 - Advanced Managing tables & databases/8. Primary Key & Foreign Key.mp4 28.56 MB
其他位置