Udemy - Advanced SQL Bootcamp (8.2022)
大小
3.35 GB
文件数
164
Info Hash:
CCF6A2C7ACFFAD5F6D83D0DC786799276F5C3D8C
收录时间
2026-01-07 22:00:07
更新时间
2026-01-07 22:00:11
文件列表 (164)
01 - Introduction/001 advanced-sql-course-general-hospital-setup.sql
9.03 MB
01 - Introduction/001 Course FAQs.html
1.13 KB
01 - Introduction/002 Course Introduction.mp4
12.13 MB
01 - Introduction/002 Course Introduction.vtt
2.01 KB
01 - Introduction/003 Course Curriculum.mp4
11.86 MB
01 - Introduction/003 Course Curriculum.vtt
2.55 KB
01 - Introduction/004 Database Set-up.mp4
64.28 MB
01 - Introduction/004 Database Set-up.vtt
11.3 KB
02 - Subqueries and CTEs/001 Subqueries Overview.mp4
11.58 MB
02 - Subqueries and CTEs/001 Subqueries Overview.vtt
2.37 KB
02 - Subqueries and CTEs/002 Subqueries in FROM Statements.mp4
47.1 MB
02 - Subqueries and CTEs/002 Subqueries in FROM Statements.vtt
8.28 KB
02 - Subqueries and CTEs/003 Common Table Expressions.mp4
51.41 MB
02 - Subqueries and CTEs/003 Common Table Expressions.vtt
8.84 KB
02 - Subqueries and CTEs/004 Subqueries for Comparisons.mp4
42.09 MB
02 - Subqueries and CTEs/004 Subqueries for Comparisons.vtt
7.16 KB
02 - Subqueries and CTEs/005 IN and NOT IN Statements.mp4
37.69 MB
02 - Subqueries and CTEs/005 IN and NOT IN Statements.vtt
6.5 KB
02 - Subqueries and CTEs/006 ANY and ALL statements.mp4
77.25 MB
02 - Subqueries and CTEs/006 ANY and ALL statements.vtt
12.45 KB
02 - Subqueries and CTEs/007 EXISTS clause in Subqueries.mp4
33.32 MB
02 - Subqueries and CTEs/007 EXISTS clause in Subqueries.vtt
6.13 KB
02 - Subqueries and CTEs/008 Recursive CTEs.mp4
60.32 MB
02 - Subqueries and CTEs/008 Recursive CTEs.vtt
11.65 KB
02 - Subqueries and CTEs/009 Subqueries - Exercises.mp4
10.04 MB
02 - Subqueries and CTEs/009 Subqueries - Exercises.vtt
1.77 KB
02 - Subqueries and CTEs/010 Subqueries - Exercise Solutions.mp4
97.13 MB
02 - Subqueries and CTEs/010 Subqueries - Exercise Solutions.vtt
13.99 KB
03 - Window Functions/001 Window Functions Overview.mp4
19.18 MB
03 - Window Functions/001 Window Functions Overview.vtt
4.35 KB
03 - Window Functions/002 OVER, PARTITION and ORDER BY.mp4
64.52 MB
03 - Window Functions/002 OVER, PARTITION and ORDER BY.vtt
11.64 KB
03 - Window Functions/003 WINDOW and Window Functions.mp4
91.76 MB
03 - Window Functions/003 WINDOW and Window Functions.vtt
14.32 KB
03 - Window Functions/004 Window Functions Exercise.mp4
5.53 MB
03 - Window Functions/004 Window Functions Exercise.vtt
853 B
03 - Window Functions/005 Window Functions Exercise - Solutions.mp4
57.41 MB
03 - Window Functions/005 Window Functions Exercise - Solutions.vtt
8.7 KB
04 - Advanced JOIN Operations/001 Self-Joins.mp4
48.78 MB
04 - Advanced JOIN Operations/001 Self-Joins.vtt
8.71 KB
04 - Advanced JOIN Operations/002 Cross-Join.mp4
21.84 MB
04 - Advanced JOIN Operations/002 Cross-Join.vtt
4.46 KB
04 - Advanced JOIN Operations/003 Full Join.mp4
36.45 MB
04 - Advanced JOIN Operations/003 Full Join.vtt
7.83 KB
04 - Advanced JOIN Operations/004 USING Keyword and Natural JOINs.mp4
29.88 MB
04 - Advanced JOIN Operations/004 USING Keyword and Natural JOINs.vtt
6.76 KB
04 - Advanced JOIN Operations/005 Advanced JOINs Exercise.mp4
6.12 MB
04 - Advanced JOIN Operations/005 Advanced JOINs Exercise.vtt
1.01 KB
04 - Advanced JOIN Operations/006 Advanced JOINs Exercise Solutions.mp4
36.17 MB
04 - Advanced JOIN Operations/006 Advanced JOINs Exercise Solutions.vtt
6.22 KB
05 - Set Operations/001 UNION.mp4
17.52 MB
05 - Set Operations/001 UNION.vtt
3.94 KB
05 - Set Operations/002 INTERSECT.mp4
22.29 MB
05 - Set Operations/002 INTERSECT.vtt
4.83 KB
05 - Set Operations/003 EXCEPT.mp4
19.62 MB
05 - Set Operations/003 EXCEPT.vtt
4.5 KB
05 - Set Operations/004 Set Operations - Exercise.mp4
6.56 MB
05 - Set Operations/004 Set Operations - Exercise.vtt
996 B
05 - Set Operations/005 Set Operations - Exercise Solutions.mp4
27.99 MB
05 - Set Operations/005 Set Operations - Exercise Solutions.vtt
5.68 KB
06 - Grouping Sets/001 Grouping Sets Overview.mp4
56.79 MB
06 - Grouping Sets/001 Grouping Sets Overview.vtt
9.53 KB
06 - Grouping Sets/002 CUBE.mp4
44.72 MB
06 - Grouping Sets/002 CUBE.vtt
7.16 KB
06 - Grouping Sets/003 ROLLUP.mp4
48.17 MB
06 - Grouping Sets/003 ROLLUP.vtt
8 KB
06 - Grouping Sets/004 Grouping Sets Exercises.mp4
8.41 MB
06 - Grouping Sets/004 Grouping Sets Exercises.vtt
1.13 KB
06 - Grouping Sets/005 Grouping Sets - Exercise Solutions.mp4
38.27 MB
06 - Grouping Sets/005 Grouping Sets - Exercise Solutions.vtt
6.61 KB
07 - Schema Structures and Table Relationships/001 Information Schema.mp4
64.24 MB
07 - Schema Structures and Table Relationships/001 Information Schema.vtt
10.64 KB
07 - Schema Structures and Table Relationships/002 COMMENT.mp4
62.73 MB
07 - Schema Structures and Table Relationships/002 COMMENT.vtt
12.5 KB
07 - Schema Structures and Table Relationships/003 Adding and Dropping Constraints.mp4
53.13 MB
07 - Schema Structures and Table Relationships/003 Adding and Dropping Constraints.vtt
10.04 KB
07 - Schema Structures and Table Relationships/004 Adding and Dropping Foreign Keys.mp4
47.18 MB
07 - Schema Structures and Table Relationships/004 Adding and Dropping Foreign Keys.vtt
8.4 KB
07 - Schema Structures and Table Relationships/005 Schema Structure Exercises.mp4
8.7 MB
07 - Schema Structures and Table Relationships/005 Schema Structure Exercises.vtt
1.37 KB
07 - Schema Structures and Table Relationships/006 Schema Structure - Exercise Solutions.mp4
51.77 MB
07 - Schema Structures and Table Relationships/006 Schema Structure - Exercise Solutions.vtt
9.04 KB
08 - Transactions/001 Transactions Overview.mp4
28.21 MB
08 - Transactions/001 Transactions Overview.vtt
5.83 KB
08 - Transactions/002 UPDATE and SET.mp4
30.71 MB
08 - Transactions/002 UPDATE and SET.vtt
6.03 KB
08 - Transactions/003 Beginning and Ending Transactions.mp4
36.85 MB
08 - Transactions/003 Beginning and Ending Transactions.vtt
8.56 KB
08 - Transactions/004 SAVEPOINT.mp4
55.14 MB
08 - Transactions/004 SAVEPOINT.vtt
10.72 KB
08 - Transactions/005 Database Locks.mp4
31.12 MB
08 - Transactions/005 Database Locks.vtt
6.39 KB
08 - Transactions/006 Transactions Exercises.mp4
9.25 MB
08 - Transactions/006 Transactions Exercises.vtt
1.48 KB
08 - Transactions/007 Transactions Exercise - Solutions.mp4
37.7 MB
08 - Transactions/007 Transactions Exercise - Solutions.vtt
6.62 KB
09 - Table Inheritance and Partioning/001 Range Partitioning.mp4
98.04 MB
09 - Table Inheritance and Partioning/001 Range Partitioning.vtt
17.94 KB
09 - Table Inheritance and Partioning/002 List Partitioning.mp4
49.36 MB
09 - Table Inheritance and Partioning/002 List Partitioning.vtt
9.68 KB
09 - Table Inheritance and Partioning/003 Hash Partitioning.mp4
70.6 MB
09 - Table Inheritance and Partioning/003 Hash Partitioning.vtt
13.11 KB
09 - Table Inheritance and Partioning/004 Table Inheritance.mp4
77.82 MB
09 - Table Inheritance and Partioning/004 Table Inheritance.vtt
18.06 KB
09 - Table Inheritance and Partioning/005 Table Partitioning Exercises.mp4
6.26 MB
09 - Table Inheritance and Partioning/005 Table Partitioning Exercises.vtt
1.08 KB
09 - Table Inheritance and Partioning/006 Table Partitioning Exercises - Solutions.mp4
84.79 MB
09 - Table Inheritance and Partioning/006 Table Partitioning Exercises - Solutions.vtt
15.82 KB
10 - Views/001 Creating Views.mp4
61.24 MB
10 - Views/001 Creating Views.vtt
11.36 KB
10 - Views/002 Modifying and Deleting Views.mp4
44.87 MB
10 - Views/002 Modifying and Deleting Views.vtt
8.61 KB
10 - Views/003 Updatable Views.mp4
75.3 MB
10 - Views/003 Updatable Views.vtt
15.67 KB
10 - Views/004 Materialized Views.mp4
60.74 MB
10 - Views/004 Materialized Views.vtt
11.39 KB
10 - Views/005 Recursive Views.mp4
48.66 MB
10 - Views/005 Recursive Views.vtt
9.4 KB
10 - Views/006 Views Exercise.mp4
15.3 MB
10 - Views/006 Views Exercise.vtt
2.48 KB
10 - Views/007 Views Exercise - Solutions.mp4
65.2 MB
10 - Views/007 Views Exercise - Solutions.vtt
11.32 KB
11 - SQL Functions/001 Creating Functions.mp4
81.48 MB
11 - SQL Functions/001 Creating Functions.vtt
18.83 KB
11 - SQL Functions/002 Modifying Functions.mp4
45.44 MB
11 - SQL Functions/002 Modifying Functions.vtt
9.38 KB
11 - SQL Functions/003 Functions Exercises.mp4
8.77 MB
11 - SQL Functions/003 Functions Exercises.vtt
1.25 KB
11 - SQL Functions/004 Functions Exercise - Solutions.mp4
32.89 MB
11 - SQL Functions/004 Functions Exercise - Solutions.vtt
7.32 KB
12 - Stored Procedures/001 Creating Stored Procedures.mp4
53.81 MB
12 - Stored Procedures/001 Creating Stored Procedures.vtt
12.9 KB
12 - Stored Procedures/002 Modifying Stored Procedures.mp4
41.01 MB
12 - Stored Procedures/002 Modifying Stored Procedures.vtt
8.49 KB
12 - Stored Procedures/003 Stored Procedures Exercise.mp4
7.68 MB
12 - Stored Procedures/003 Stored Procedures Exercise.vtt
1.22 KB
12 - Stored Procedures/004 Stored Procedures Exercise - Solutions.mp4
59.79 MB
12 - Stored Procedures/004 Stored Procedures Exercise - Solutions.vtt
10.27 KB
13 - Triggers/001 Creating Triggers.mp4
87.55 MB
13 - Triggers/001 Creating Triggers.vtt
19.19 KB
13 - Triggers/002 Enabling and Disabling Triggers.mp4
30.63 MB
13 - Triggers/002 Enabling and Disabling Triggers.vtt
6.81 KB
13 - Triggers/003 Modifying and Dropping Triggers.mp4
26.22 MB
13 - Triggers/003 Modifying and Dropping Triggers.vtt
5.38 KB
13 - Triggers/004 Triggers Exercises.mp4
6.93 MB
13 - Triggers/004 Triggers Exercises.vtt
1.21 KB
13 - Triggers/005 Triggers Exercises - Solutions.mp4
43.81 MB
13 - Triggers/005 Triggers Exercises - Solutions.vtt
8.25 KB
14 - Useful Methods and Tools/001 EXPLAIN and EXPLAIN ANALYZE.mp4
69.67 MB
14 - Useful Methods and Tools/001 EXPLAIN and EXPLAIN ANALYZE.vtt
11.7 KB
14 - Useful Methods and Tools/002 Dropping Data with TRUNCATE.mp4
27.34 MB
14 - Useful Methods and Tools/002 Dropping Data with TRUNCATE.vtt
5.75 KB
14 - Useful Methods and Tools/003 Exporting and Importing Data with COPY.mp4
39.03 MB
14 - Useful Methods and Tools/003 Exporting and Importing Data with COPY.vtt
7.79 KB
14 - Useful Methods and Tools/004 Array and Array Functions.mp4
62.42 MB
14 - Useful Methods and Tools/004 Array and Array Functions.vtt
9.6 KB
14 - Useful Methods and Tools/005 JSON and JSON Functions.mp4
43.63 MB
14 - Useful Methods and Tools/005 JSON and JSON Functions.vtt
7.53 KB
14 - Useful Methods and Tools/006 Modules and Extensions.mp4
86.61 MB
14 - Useful Methods and Tools/006 Modules and Extensions.vtt
13.32 KB
14 - Useful Methods and Tools/007 Useful Methods and Tools Exercises.mp4
5.93 MB
14 - Useful Methods and Tools/007 Useful Methods and Tools Exercises.vtt
991 B
14 - Useful Methods and Tools/008 Useful Methods and Tools Exercises - Solutions.mp4
25.92 MB
14 - Useful Methods and Tools/008 Useful Methods and Tools Exercises - Solutions.vtt
4.52 KB