Udemy - Advanced SQL Bootcamp (8.2022)
File List
| File | Size |
|---|---|
| 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 |
Trackers
No trackers found.