[GigaCourse.Com] Udemy - Advanced SQL Bootcamp

File Name

Size

0. Websites you may like/[CourseClub.Me].url

122 B

0. Websites you may like/[GigaCourse.Com].url

49 B

01 - Introduction/001 Course FAQs.html

1.1 kB

01 - Introduction/001 advanced-sql-course-general-hospital-setup.sql

9.0 MB

01 - Introduction/002 Course Introduction.mp4

12 MB

01 - Introduction/002 Course Introduction_en.vtt

2.0 kB

01 - Introduction/003 Course Curriculum.mp4

12 MB

01 - Introduction/003 Course Curriculum_en.vtt

2.6 kB

01 - Introduction/004 Database Set-up.mp4

64 MB

01 - Introduction/004 Database Set-up_en.vtt

11 kB

01 - Introduction/[CourseClub.Me].url

122 B

01 - Introduction/[GigaCourse.Com].url

49 B

02 - Subqueries and CTEs/001 Subqueries Overview.mp4

12 MB

02 - Subqueries and CTEs/001 Subqueries Overview_en.vtt

2.4 kB

02 - Subqueries and CTEs/002 Subqueries in FROM Statements.mp4

47 MB

02 - Subqueries and CTEs/002 Subqueries in FROM Statements_en.vtt

8.3 kB

02 - Subqueries and CTEs/003 Common Table Expressions.mp4

51 MB

02 - Subqueries and CTEs/003 Common Table Expressions_en.vtt

8.8 kB

02 - Subqueries and CTEs/004 Subqueries for Comparisons.mp4

42 MB

02 - Subqueries and CTEs/004 Subqueries for Comparisons_en.vtt

7.2 kB

02 - Subqueries and CTEs/005 IN and NOT IN Statements.mp4

38 MB

02 - Subqueries and CTEs/005 IN and NOT IN Statements_en.vtt

6.5 kB

02 - Subqueries and CTEs/006 ANY and ALL statements.mp4

77 MB

02 - Subqueries and CTEs/006 ANY and ALL statements_en.vtt

12 kB

02 - Subqueries and CTEs/007 EXISTS clause in Subqueries.mp4

33 MB

02 - Subqueries and CTEs/007 EXISTS clause in Subqueries_en.vtt

6.1 kB

02 - Subqueries and CTEs/008 Recursive CTEs.mp4

60 MB

02 - Subqueries and CTEs/008 Recursive CTEs_en.vtt

12 kB

02 - Subqueries and CTEs/009 Subqueries - Exercises.mp4

10 MB

02 - Subqueries and CTEs/009 Subqueries - Exercises_en.vtt

1.8 kB

02 - Subqueries and CTEs/010 Subqueries - Exercise Solutions.mp4

97 MB

02 - Subqueries and CTEs/010 Subqueries - Exercise Solutions_en.vtt

14 kB

03 - Window Functions/001 Window Functions Overview.mp4

19 MB

03 - Window Functions/001 Window Functions Overview_en.vtt

4.3 kB

03 - Window Functions/002 OVER, PARTITION and ORDER BY.mp4

64 MB

03 - Window Functions/002 OVER, PARTITION and ORDER BY_en.vtt

12 kB

03 - Window Functions/003 WINDOW and Window Functions.mp4

92 MB

03 - Window Functions/003 WINDOW and Window Functions_en.vtt

14 kB

03 - Window Functions/004 Window Functions Exercise.mp4

5.5 MB

03 - Window Functions/004 Window Functions Exercise_en.vtt

853 B

03 - Window Functions/005 Window Functions Exercise - Solutions.mp4

57 MB

03 - Window Functions/005 Window Functions Exercise - Solutions_en.vtt

8.7 kB

04 - Advanced JOIN Operations/001 Self-Joins.mp4

49 MB

04 - Advanced JOIN Operations/001 Self-Joins_en.vtt

8.7 kB

04 - Advanced JOIN Operations/002 Cross-Join.mp4

22 MB

04 - Advanced JOIN Operations/002 Cross-Join_en.vtt

4.5 kB

04 - Advanced JOIN Operations/003 Full Join.mp4

36 MB

04 - Advanced JOIN Operations/003 Full Join_en.vtt

7.8 kB

04 - Advanced JOIN Operations/004 USING Keyword and Natural JOINs.mp4

30 MB

04 - Advanced JOIN Operations/004 USING Keyword and Natural JOINs_en.vtt

6.8 kB

04 - Advanced JOIN Operations/005 Advanced JOINs Exercise.mp4

6.1 MB

04 - Advanced JOIN Operations/005 Advanced JOINs Exercise_en.vtt

1.0 kB

04 - Advanced JOIN Operations/006 Advanced JOINs Exercise Solutions.mp4

36 MB

04 - Advanced JOIN Operations/006 Advanced JOINs Exercise Solutions_en.vtt

6.2 kB

04 - Advanced JOIN Operations/[CourseClub.Me].url

122 B

04 - Advanced JOIN Operations/[GigaCourse.Com].url

49 B

05 - Set Operations/001 UNION.mp4

18 MB

05 - Set Operations/001 UNION_en.vtt

3.9 kB

05 - Set Operations/002 INTERSECT.mp4

22 MB

05 - Set Operations/002 INTERSECT_en.vtt

4.8 kB

05 - Set Operations/003 EXCEPT.mp4

20 MB

05 - Set Operations/003 EXCEPT_en.vtt

4.5 kB

05 - Set Operations/004 Set Operations - Exercise.mp4

6.6 MB

05 - Set Operations/004 Set Operations - Exercise_en.vtt

996 B

05 - Set Operations/005 Set Operations - Exercise Solutions.mp4

28 MB

05 - Set Operations/005 Set Operations - Exercise Solutions_en.vtt

5.7 kB

06 - Grouping Sets/001 Grouping Sets Overview.mp4

57 MB

06 - Grouping Sets/001 Grouping Sets Overview_en.vtt

9.5 kB

06 - Grouping Sets/002 CUBE.mp4

45 MB

06 - Grouping Sets/002 CUBE_en.vtt

7.2 kB

06 - Grouping Sets/003 ROLLUP.mp4

48 MB

06 - Grouping Sets/003 ROLLUP_en.vtt

8.0 kB

06 - Grouping Sets/004 Grouping Sets Exercises.mp4

8.4 MB

06 - Grouping Sets/004 Grouping Sets Exercises_en.vtt

1.1 kB

06 - Grouping Sets/005 Grouping Sets - Exercise Solutions.mp4

38 MB

06 - Grouping Sets/005 Grouping Sets - Exercise Solutions_en.vtt

6.6 kB

07 - Schema Structures and Table Relationships/001 Information Schema.mp4

64 MB

07 - Schema Structures and Table Relationships/001 Information Schema_en.vtt

11 kB

07 - Schema Structures and Table Relationships/002 COMMENT.mp4

63 MB

07 - Schema Structures and Table Relationships/002 COMMENT_en.vtt

12 kB

07 - Schema Structures and Table Relationships/003 Adding and Dropping Constraints.mp4

53 MB

07 - Schema Structures and Table Relationships/003 Adding and Dropping Constraints_en.vtt

10 kB

07 - Schema Structures and Table Relationships/004 Adding and Dropping Foreign Keys.mp4

47 MB

07 - Schema Structures and Table Relationships/004 Adding and Dropping Foreign Keys_en.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_en.vtt

1.4 kB

07 - Schema Structures and Table Relationships/006 Schema Structure - Exercise Solutions.mp4

52 MB

07 - Schema Structures and Table Relationships/006 Schema Structure - Exercise Solutions_en.vtt

9.0 kB

08 - Transactions/001 Transactions Overview.mp4

28 MB

08 - Transactions/001 Transactions Overview_en.vtt

5.8 kB

08 - Transactions/002 UPDATE and SET.mp4

31 MB

08 - Transactions/002 UPDATE and SET_en.vtt

6.0 kB

08 - Transactions/003 Beginning and Ending Transactions.mp4

37 MB

08 - Transactions/003 Beginning and Ending Transactions_en.vtt

8.6 kB

08 - Transactions/004 SAVEPOINT.mp4

55 MB

08 - Transactions/004 SAVEPOINT_en.vtt

11 kB

08 - Transactions/005 Database Locks.mp4

31 MB

08 - Transactions/005 Database Locks_en.vtt

6.4 kB

08 - Transactions/006 Transactions Exercises.mp4

9.3 MB

08 - Transactions/006 Transactions Exercises_en.vtt

1.5 kB

08 - Transactions/007 Transactions Exercise - Solutions.mp4

38 MB

08 - Transactions/007 Transactions Exercise - Solutions_en.vtt

6.6 kB

09 - Table Inheritance and Partioning/001 Range Partitioning.mp4

98 MB

09 - Table Inheritance and Partioning/001 Range Partitioning_en.vtt

18 kB

09 - Table Inheritance and Partioning/002 List Partitioning.mp4

49 MB

09 - Table Inheritance and Partioning/002 List Partitioning_en.vtt

9.7 kB

09 - Table Inheritance and Partioning/003 Hash Partitioning.mp4

71 MB

09 - Table Inheritance and Partioning/003 Hash Partitioning_en.vtt

13 kB

09 - Table Inheritance and Partioning/004 Table Inheritance.mp4

78 MB

09 - Table Inheritance and Partioning/004 Table Inheritance_en.vtt

18 kB

09 - Table Inheritance and Partioning/005 Table Partitioning Exercises.mp4

6.3 MB

09 - Table Inheritance and Partioning/005 Table Partitioning Exercises_en.vtt

1.1 kB

09 - Table Inheritance and Partioning/006 Table Partitioning Exercises - Solutions.mp4

85 MB

09 - Table Inheritance and Partioning/006 Table Partitioning Exercises - Solutions_en.vtt

16 kB

09 - Table Inheritance and Partioning/[CourseClub.Me].url

122 B

09 - Table Inheritance and Partioning/[GigaCourse.Com].url

49 B

10 - Views/001 Creating Views.mp4

61 MB

10 - Views/001 Creating Views_en.vtt

11 kB

10 - Views/002 Modifying and Deleting Views.mp4

45 MB

10 - Views/002 Modifying and Deleting Views_en.vtt

8.6 kB

10 - Views/003 Updatable Views.mp4

75 MB

10 - Views/003 Updatable Views_en.vtt

16 kB

10 - Views/004 Materialized Views.mp4

61 MB

10 - Views/004 Materialized Views_en.vtt

11 kB

10 - Views/005 Recursive Views.mp4

49 MB

10 - Views/005 Recursive Views_en.vtt

9.4 kB

10 - Views/006 Views Exercise.mp4

15 MB

10 - Views/006 Views Exercise_en.vtt

2.5 kB

10 - Views/007 Views Exercise - Solutions.mp4

65 MB

10 - Views/007 Views Exercise - Solutions_en.vtt

11 kB

11 - SQL Functions/001 Creating Functions.mp4

82 MB

11 - SQL Functions/001 Creating Functions_en.vtt

19 kB

11 - SQL Functions/002 Modifying Functions.mp4

45 MB

11 - SQL Functions/002 Modifying Functions_en.vtt

9.4 kB

11 - SQL Functions/003 Functions Exercises.mp4

8.8 MB

11 - SQL Functions/003 Functions Exercises_en.vtt

1.3 kB

11 - SQL Functions/004 Functions Exercise - Solutions.mp4

33 MB

11 - SQL Functions/004 Functions Exercise - Solutions_en.vtt

7.3 kB

12 - Stored Procedures/001 Creating Stored Procedures.mp4

54 MB

12 - Stored Procedures/001 Creating Stored Procedures_en.vtt

13 kB

12 - Stored Procedures/002 Modifying Stored Procedures.mp4

41 MB

12 - Stored Procedures/002 Modifying Stored Procedures_en.vtt

8.5 kB

12 - Stored Procedures/003 Stored Procedures Exercise.mp4

7.7 MB

12 - Stored Procedures/003 Stored Procedures Exercise_en.vtt

1.2 kB

12 - Stored Procedures/004 Stored Procedures Exercise - Solutions.mp4

60 MB

12 - Stored Procedures/004 Stored Procedures Exercise - Solutions_en.vtt

10 kB

13 - Triggers/001 Creating Triggers.mp4

88 MB

13 - Triggers/001 Creating Triggers_en.vtt

19 kB

13 - Triggers/002 Enabling and Disabling Triggers.mp4

31 MB

13 - Triggers/002 Enabling and Disabling Triggers_en.vtt

6.8 kB

13 - Triggers/003 Modifying and Dropping Triggers.mp4

26 MB

13 - Triggers/003 Modifying and Dropping Triggers_en.vtt

5.4 kB

13 - Triggers/004 Triggers Exercises.mp4

6.9 MB

13 - Triggers/004 Triggers Exercises_en.vtt

1.2 kB

13 - Triggers/005 Triggers Exercises - Solutions.mp4

44 MB

13 - Triggers/005 Triggers Exercises - Solutions_en.vtt

8.2 kB

13 - Triggers/[CourseClub.Me].url

122 B

13 - Triggers/[GigaCourse.Com].url

49 B

14 - Useful Methods and Tools/001 EXPLAIN and EXPLAIN ANALYZE.mp4

70 MB

14 - Useful Methods and Tools/001 EXPLAIN and EXPLAIN ANALYZE_en.vtt

12 kB

14 - Useful Methods and Tools/002 Dropping Data with TRUNCATE.mp4

27 MB

14 - Useful Methods and Tools/002 Dropping Data with TRUNCATE_en.vtt

5.7 kB

14 - Useful Methods and Tools/003 Exporting and Importing Data with COPY.mp4

39 MB

14 - Useful Methods and Tools/003 Exporting and Importing Data with COPY_en.vtt

7.8 kB

14 - Useful Methods and Tools/004 Array and Array Functions.mp4

62 MB

14 - Useful Methods and Tools/004 Array and Array Functions_en.vtt

9.6 kB

14 - Useful Methods and Tools/005 JSON and JSON Functions.mp4

44 MB

14 - Useful Methods and Tools/005 JSON and JSON Functions_en.vtt

7.5 kB

14 - Useful Methods and Tools/006 Modules and Extensions.mp4

87 MB

14 - Useful Methods and Tools/006 Modules and Extensions_en.vtt

13 kB

14 - Useful Methods and Tools/007 Useful Methods and Tools Exercises.mp4

5.9 MB

14 - Useful Methods and Tools/007 Useful Methods and Tools Exercises_en.vtt

991 B

14 - Useful Methods and Tools/008 Useful Methods and Tools Exercises - Solutions.mp4

26 MB

14 - Useful Methods and Tools/008 Useful Methods and Tools Exercises - Solutions_en.vtt

4.5 kB

[CourseClub.Me].url

122 B

[GigaCourse.Com].url

49 B