磁石

Udemy - Advanced SQL Bootcamp (8.2022)

正在检测能否在线播放…

大小
3.4 GB
文件数
164
分类
视频
热度
98
最近活跃
1 天前

文件列表

  • 01 - Introduction/001 advanced-sql-course-general-hospital-setup.sql9.0 MB
  • 01 - Introduction/001 Course FAQs.html1.1 KB
  • 01 - Introduction/002 Course Introduction.mp412.1 MB
  • 01 - Introduction/002 Course Introduction.vtt2.0 KB
  • 01 - Introduction/003 Course Curriculum.mp411.9 MB
  • 01 - Introduction/003 Course Curriculum.vtt2.6 KB
  • 01 - Introduction/004 Database Set-up.mp464.3 MB
  • 01 - Introduction/004 Database Set-up.vtt11.3 KB
  • 02 - Subqueries and CTEs/001 Subqueries Overview.mp411.6 MB
  • 02 - Subqueries and CTEs/001 Subqueries Overview.vtt2.4 KB
  • 02 - Subqueries and CTEs/002 Subqueries in FROM Statements.mp447.1 MB
  • 02 - Subqueries and CTEs/002 Subqueries in FROM Statements.vtt8.3 KB
  • 02 - Subqueries and CTEs/003 Common Table Expressions.mp451.4 MB
  • 02 - Subqueries and CTEs/003 Common Table Expressions.vtt8.8 KB
  • 02 - Subqueries and CTEs/004 Subqueries for Comparisons.mp442.1 MB
  • 02 - Subqueries and CTEs/004 Subqueries for Comparisons.vtt7.2 KB
  • 02 - Subqueries and CTEs/005 IN and NOT IN Statements.mp437.7 MB
  • 02 - Subqueries and CTEs/005 IN and NOT IN Statements.vtt6.5 KB
  • 02 - Subqueries and CTEs/006 ANY and ALL statements.mp477.3 MB
  • 02 - Subqueries and CTEs/006 ANY and ALL statements.vtt12.5 KB
  • 02 - Subqueries and CTEs/007 EXISTS clause in Subqueries.mp433.3 MB
  • 02 - Subqueries and CTEs/007 EXISTS clause in Subqueries.vtt6.1 KB
  • 02 - Subqueries and CTEs/008 Recursive CTEs.mp460.3 MB
  • 02 - Subqueries and CTEs/008 Recursive CTEs.vtt11.7 KB
  • 02 - Subqueries and CTEs/009 Subqueries - Exercises.mp410.0 MB
  • 02 - Subqueries and CTEs/009 Subqueries - Exercises.vtt1.8 KB
  • 02 - Subqueries and CTEs/010 Subqueries - Exercise Solutions.mp497.1 MB
  • 02 - Subqueries and CTEs/010 Subqueries - Exercise Solutions.vtt14.0 KB
  • 03 - Window Functions/001 Window Functions Overview.mp419.2 MB
  • 03 - Window Functions/001 Window Functions Overview.vtt4.3 KB
  • 03 - Window Functions/002 OVER, PARTITION and ORDER BY.mp464.5 MB
  • 03 - Window Functions/002 OVER, PARTITION and ORDER BY.vtt11.6 KB
  • 03 - Window Functions/003 WINDOW and Window Functions.mp491.8 MB
  • 03 - Window Functions/003 WINDOW and Window Functions.vtt14.3 KB
  • 03 - Window Functions/004 Window Functions Exercise.mp45.5 MB
  • 03 - Window Functions/004 Window Functions Exercise.vtt853 B
  • 03 - Window Functions/005 Window Functions Exercise - Solutions.mp457.4 MB
  • 03 - Window Functions/005 Window Functions Exercise - Solutions.vtt8.7 KB
  • 04 - Advanced JOIN Operations/001 Self-Joins.mp448.8 MB
  • 04 - Advanced JOIN Operations/001 Self-Joins.vtt8.7 KB
  • 04 - Advanced JOIN Operations/002 Cross-Join.mp421.8 MB
  • 04 - Advanced JOIN Operations/002 Cross-Join.vtt4.5 KB
  • 04 - Advanced JOIN Operations/003 Full Join.mp436.4 MB
  • 04 - Advanced JOIN Operations/003 Full Join.vtt7.8 KB
  • 04 - Advanced JOIN Operations/004 USING Keyword and Natural JOINs.mp429.9 MB
  • 04 - Advanced JOIN Operations/004 USING Keyword and Natural JOINs.vtt6.8 KB
  • 04 - Advanced JOIN Operations/005 Advanced JOINs Exercise.mp46.1 MB
  • 04 - Advanced JOIN Operations/005 Advanced JOINs Exercise.vtt1.0 KB
  • 04 - Advanced JOIN Operations/006 Advanced JOINs Exercise Solutions.mp436.2 MB
  • 04 - Advanced JOIN Operations/006 Advanced JOINs Exercise Solutions.vtt6.2 KB
  • 05 - Set Operations/001 UNION.mp417.5 MB
  • 05 - Set Operations/001 UNION.vtt3.9 KB
  • 05 - Set Operations/002 INTERSECT.mp422.3 MB
  • 05 - Set Operations/002 INTERSECT.vtt4.8 KB
  • 05 - Set Operations/003 EXCEPT.mp419.6 MB
  • 05 - Set Operations/003 EXCEPT.vtt4.5 KB
  • 05 - Set Operations/004 Set Operations - Exercise.mp46.6 MB
  • 05 - Set Operations/004 Set Operations - Exercise.vtt996 B
  • 05 - Set Operations/005 Set Operations - Exercise Solutions.mp428.0 MB
  • 05 - Set Operations/005 Set Operations - Exercise Solutions.vtt5.7 KB
  • 06 - Grouping Sets/001 Grouping Sets Overview.mp456.8 MB
  • 06 - Grouping Sets/001 Grouping Sets Overview.vtt9.5 KB
  • 06 - Grouping Sets/002 CUBE.mp444.7 MB
  • 06 - Grouping Sets/002 CUBE.vtt7.2 KB
  • 06 - Grouping Sets/003 ROLLUP.mp448.2 MB
  • 06 - Grouping Sets/003 ROLLUP.vtt8.0 KB
  • 06 - Grouping Sets/004 Grouping Sets Exercises.mp48.4 MB
  • 06 - Grouping Sets/004 Grouping Sets Exercises.vtt1.1 KB
  • 06 - Grouping Sets/005 Grouping Sets - Exercise Solutions.mp438.3 MB
  • 06 - Grouping Sets/005 Grouping Sets - Exercise Solutions.vtt6.6 KB
  • 07 - Schema Structures and Table Relationships/001 Information Schema.mp464.2 MB
  • 07 - Schema Structures and Table Relationships/001 Information Schema.vtt10.6 KB
  • 07 - Schema Structures and Table Relationships/002 COMMENT.mp462.7 MB
  • 07 - Schema Structures and Table Relationships/002 COMMENT.vtt12.5 KB
  • 07 - Schema Structures and Table Relationships/003 Adding and Dropping Constraints.mp453.1 MB
  • 07 - Schema Structures and Table Relationships/003 Adding and Dropping Constraints.vtt10.0 KB
  • 07 - Schema Structures and Table Relationships/004 Adding and Dropping Foreign Keys.mp447.2 MB
  • 07 - Schema Structures and Table Relationships/004 Adding and Dropping Foreign Keys.vtt8.4 KB
  • 07 - Schema Structures and Table Relationships/005 Schema Structure Exercises.mp48.7 MB
  • 07 - Schema Structures and Table Relationships/005 Schema Structure Exercises.vtt1.4 KB
  • 07 - Schema Structures and Table Relationships/006 Schema Structure - Exercise Solutions.mp451.8 MB
  • 07 - Schema Structures and Table Relationships/006 Schema Structure - Exercise Solutions.vtt9.0 KB
  • 08 - Transactions/001 Transactions Overview.mp428.2 MB
  • 08 - Transactions/001 Transactions Overview.vtt5.8 KB
  • 08 - Transactions/002 UPDATE and SET.mp430.7 MB
  • 08 - Transactions/002 UPDATE and SET.vtt6.0 KB
  • 08 - Transactions/003 Beginning and Ending Transactions.mp436.8 MB
  • 08 - Transactions/003 Beginning and Ending Transactions.vtt8.6 KB
  • 08 - Transactions/004 SAVEPOINT.mp455.1 MB
  • 08 - Transactions/004 SAVEPOINT.vtt10.7 KB
  • 08 - Transactions/005 Database Locks.mp431.1 MB
  • 08 - Transactions/005 Database Locks.vtt6.4 KB
  • 08 - Transactions/006 Transactions Exercises.mp49.3 MB
  • 08 - Transactions/006 Transactions Exercises.vtt1.5 KB
  • 08 - Transactions/007 Transactions Exercise - Solutions.mp437.7 MB
  • 08 - Transactions/007 Transactions Exercise - Solutions.vtt6.6 KB
  • 09 - Table Inheritance and Partioning/001 Range Partitioning.mp498.0 MB
  • 09 - Table Inheritance and Partioning/001 Range Partitioning.vtt17.9 KB
  • 09 - Table Inheritance and Partioning/002 List Partitioning.mp449.4 MB
  • 09 - Table Inheritance and Partioning/002 List Partitioning.vtt9.7 KB
  • 09 - Table Inheritance and Partioning/003 Hash Partitioning.mp470.6 MB
  • 09 - Table Inheritance and Partioning/003 Hash Partitioning.vtt13.1 KB
  • 09 - Table Inheritance and Partioning/004 Table Inheritance.mp477.8 MB
  • 09 - Table Inheritance and Partioning/004 Table Inheritance.vtt18.1 KB
  • 09 - Table Inheritance and Partioning/005 Table Partitioning Exercises.mp46.3 MB
  • 09 - Table Inheritance and Partioning/005 Table Partitioning Exercises.vtt1.1 KB
  • 09 - Table Inheritance and Partioning/006 Table Partitioning Exercises - Solutions.mp484.8 MB
  • 09 - Table Inheritance and Partioning/006 Table Partitioning Exercises - Solutions.vtt15.8 KB
  • 10 - Views/001 Creating Views.mp461.2 MB
  • 10 - Views/001 Creating Views.vtt11.4 KB
  • 10 - Views/002 Modifying and Deleting Views.mp444.9 MB
  • 10 - Views/002 Modifying and Deleting Views.vtt8.6 KB
  • 10 - Views/003 Updatable Views.mp475.3 MB
  • 10 - Views/003 Updatable Views.vtt15.7 KB
  • 10 - Views/004 Materialized Views.mp460.7 MB
  • 10 - Views/004 Materialized Views.vtt11.4 KB
  • 10 - Views/005 Recursive Views.mp448.7 MB
  • 10 - Views/005 Recursive Views.vtt9.4 KB
  • 10 - Views/006 Views Exercise.mp415.3 MB
  • 10 - Views/006 Views Exercise.vtt2.5 KB
  • 10 - Views/007 Views Exercise - Solutions.mp465.2 MB
  • 10 - Views/007 Views Exercise - Solutions.vtt11.3 KB
  • 11 - SQL Functions/001 Creating Functions.mp481.5 MB
  • 11 - SQL Functions/001 Creating Functions.vtt18.8 KB
  • 11 - SQL Functions/002 Modifying Functions.mp445.4 MB
  • 11 - SQL Functions/002 Modifying Functions.vtt9.4 KB
  • 11 - SQL Functions/003 Functions Exercises.mp48.8 MB
  • 11 - SQL Functions/003 Functions Exercises.vtt1.3 KB
  • 11 - SQL Functions/004 Functions Exercise - Solutions.mp432.9 MB
  • 11 - SQL Functions/004 Functions Exercise - Solutions.vtt7.3 KB
  • 12 - Stored Procedures/001 Creating Stored Procedures.mp453.8 MB
  • 12 - Stored Procedures/001 Creating Stored Procedures.vtt12.9 KB
  • 12 - Stored Procedures/002 Modifying Stored Procedures.mp441.0 MB
  • 12 - Stored Procedures/002 Modifying Stored Procedures.vtt8.5 KB
  • 12 - Stored Procedures/003 Stored Procedures Exercise.mp47.7 MB
  • 12 - Stored Procedures/003 Stored Procedures Exercise.vtt1.2 KB
  • 12 - Stored Procedures/004 Stored Procedures Exercise - Solutions.mp459.8 MB
  • 12 - Stored Procedures/004 Stored Procedures Exercise - Solutions.vtt10.3 KB
  • 13 - Triggers/001 Creating Triggers.mp487.6 MB
  • 13 - Triggers/001 Creating Triggers.vtt19.2 KB
  • 13 - Triggers/002 Enabling and Disabling Triggers.mp430.6 MB
  • 13 - Triggers/002 Enabling and Disabling Triggers.vtt6.8 KB
  • 13 - Triggers/003 Modifying and Dropping Triggers.mp426.2 MB
  • 13 - Triggers/003 Modifying and Dropping Triggers.vtt5.4 KB
  • 13 - Triggers/004 Triggers Exercises.mp46.9 MB
  • 13 - Triggers/004 Triggers Exercises.vtt1.2 KB
  • 13 - Triggers/005 Triggers Exercises - Solutions.mp443.8 MB
  • 13 - Triggers/005 Triggers Exercises - Solutions.vtt8.2 KB
  • 14 - Useful Methods and Tools/001 EXPLAIN and EXPLAIN ANALYZE.mp469.7 MB
  • 14 - Useful Methods and Tools/001 EXPLAIN and EXPLAIN ANALYZE.vtt11.7 KB
  • 14 - Useful Methods and Tools/002 Dropping Data with TRUNCATE.mp427.3 MB
  • 14 - Useful Methods and Tools/002 Dropping Data with TRUNCATE.vtt5.7 KB
  • 14 - Useful Methods and Tools/003 Exporting and Importing Data with COPY.mp439.0 MB
  • 14 - Useful Methods and Tools/003 Exporting and Importing Data with COPY.vtt7.8 KB
  • 14 - Useful Methods and Tools/004 Array and Array Functions.mp462.4 MB
  • 14 - Useful Methods and Tools/004 Array and Array Functions.vtt9.6 KB
  • 14 - Useful Methods and Tools/005 JSON and JSON Functions.mp443.6 MB
  • 14 - Useful Methods and Tools/005 JSON and JSON Functions.vtt7.5 KB
  • 14 - Useful Methods and Tools/006 Modules and Extensions.mp486.6 MB
  • 14 - Useful Methods and Tools/006 Modules and Extensions.vtt13.3 KB
  • 14 - Useful Methods and Tools/007 Useful Methods and Tools Exercises.mp45.9 MB
  • 14 - Useful Methods and Tools/007 Useful Methods and Tools Exercises.vtt991 B
  • 14 - Useful Methods and Tools/008 Useful Methods and Tools Exercises - Solutions.mp425.9 MB
  • 14 - Useful Methods and Tools/008 Useful Methods and Tools Exercises - Solutions.vtt4.5 KB

相关资源

举报这个资源