GigaCourse Com Udemy - Advanced SQL Bootcamp

1. 01 - Introduction/002 Course Introduction.mp412.13MB
2. 01 - Introduction/003 Course Curriculum.mp411.86MB
3. 01 - Introduction/004 Database Set-up.mp464.28MB
4. 02 - Subqueries and CTEs/001 Subqueries Overview.mp411.58MB
5. 02 - Subqueries and CTEs/002 Subqueries in FROM Statements.mp447.1MB
6. 02 - Subqueries and CTEs/003 Common Table Expressions.mp451.41MB
7. 02 - Subqueries and CTEs/004 Subqueries for Comparisons.mp442.09MB
8. 02 - Subqueries and CTEs/005 IN and NOT IN Statements.mp437.69MB
9. 02 - Subqueries and CTEs/006 ANY and ALL statements.mp477.25MB
10. 02 - Subqueries and CTEs/007 EXISTS clause in Subqueries.mp433.32MB
11. 02 - Subqueries and CTEs/008 Recursive CTEs.mp460.32MB
12. 02 - Subqueries and CTEs/009 Subqueries - Exercises.mp410.04MB
13. 02 - Subqueries and CTEs/010 Subqueries - Exercise Solutions.mp497.13MB
14. 03 - Window Functions/001 Window Functions Overview.mp419.18MB
15. 03 - Window Functions/002 OVER, PARTITION and ORDER BY.mp464.52MB
16. 03 - Window Functions/003 WINDOW and Window Functions.mp491.76MB
17. 03 - Window Functions/004 Window Functions Exercise.mp45.53MB
18. 03 - Window Functions/005 Window Functions Exercise - Solutions.mp457.41MB
19. 04 - Advanced JOIN Operations/001 Self-Joins.mp448.78MB
20. 04 - Advanced JOIN Operations/002 Cross-Join.mp421.84MB
21. 04 - Advanced JOIN Operations/003 Full Join.mp436.45MB
22. 04 - Advanced JOIN Operations/004 USING Keyword and Natural JOINs.mp429.88MB
23. 04 - Advanced JOIN Operations/005 Advanced JOINs Exercise.mp46.12MB
24. 04 - Advanced JOIN Operations/006 Advanced JOINs Exercise Solutions.mp436.17MB
25. 05 - Set Operations/001 UNION.mp417.52MB
26. 05 - Set Operations/002 INTERSECT.mp422.29MB
27. 05 - Set Operations/003 EXCEPT.mp419.62MB
28. 05 - Set Operations/004 Set Operations - Exercise.mp46.56MB
29. 05 - Set Operations/005 Set Operations - Exercise Solutions.mp427.99MB
30. 06 - Grouping Sets/001 Grouping Sets Overview.mp456.79MB
31. 06 - Grouping Sets/002 CUBE.mp444.72MB
32. 06 - Grouping Sets/003 ROLLUP.mp448.17MB
33. 06 - Grouping Sets/004 Grouping Sets Exercises.mp48.41MB
34. 06 - Grouping Sets/005 Grouping Sets - Exercise Solutions.mp438.27MB
35. 07 - Schema Structures and Table Relationships/001 Information Schema.mp464.24MB
36. 07 - Schema Structures and Table Relationships/002 COMMENT.mp462.73MB
37. 07 - Schema Structures and Table Relationships/003 Adding and Dropping Constraints.mp453.13MB
38. 07 - Schema Structures and Table Relationships/004 Adding and Dropping Foreign Keys.mp447.18MB
39. 07 - Schema Structures and Table Relationships/005 Schema Structure Exercises.mp48.7MB
40. 07 - Schema Structures and Table Relationships/006 Schema Structure - Exercise Solutions.mp451.77MB
41. 08 - Transactions/001 Transactions Overview.mp428.21MB
42. 08 - Transactions/002 UPDATE and SET.mp430.71MB
43. 08 - Transactions/003 Beginning and Ending Transactions.mp436.85MB
44. 08 - Transactions/004 SAVEPOINT.mp455.14MB
45. 08 - Transactions/005 Database Locks.mp431.12MB
46. 08 - Transactions/006 Transactions Exercises.mp49.25MB
47. 08 - Transactions/007 Transactions Exercise - Solutions.mp437.7MB
48. 09 - Table Inheritance and Partioning/001 Range Partitioning.mp498.04MB
49. 09 - Table Inheritance and Partioning/002 List Partitioning.mp449.36MB
50. 09 - Table Inheritance and Partioning/003 Hash Partitioning.mp470.6MB
51. 09 - Table Inheritance and Partioning/004 Table Inheritance.mp477.82MB
52. 09 - Table Inheritance and Partioning/005 Table Partitioning Exercises.mp46.26MB
53. 09 - Table Inheritance and Partioning/006 Table Partitioning Exercises - Solutions.mp484.79MB
54. 10 - Views/001 Creating Views.mp461.24MB
55. 10 - Views/002 Modifying and Deleting Views.mp444.87MB
56. 10 - Views/003 Updatable Views.mp475.3MB
57. 10 - Views/004 Materialized Views.mp460.74MB
58. 10 - Views/005 Recursive Views.mp448.66MB
59. 10 - Views/006 Views Exercise.mp415.3MB
60. 10 - Views/007 Views Exercise - Solutions.mp465.2MB
61. 11 - SQL Functions/001 Creating Functions.mp481.48MB
62. 11 - SQL Functions/002 Modifying Functions.mp445.44MB
63. 11 - SQL Functions/003 Functions Exercises.mp48.77MB
64. 11 - SQL Functions/004 Functions Exercise - Solutions.mp432.89MB
65. 12 - Stored Procedures/001 Creating Stored Procedures.mp453.81MB
66. 12 - Stored Procedures/002 Modifying Stored Procedures.mp441.01MB
67. 12 - Stored Procedures/003 Stored Procedures Exercise.mp47.68MB
68. 12 - Stored Procedures/004 Stored Procedures Exercise - Solutions.mp459.79MB
69. 13 - Triggers/001 Creating Triggers.mp487.55MB
70. 13 - Triggers/002 Enabling and Disabling Triggers.mp430.63MB
71. 13 - Triggers/003 Modifying and Dropping Triggers.mp426.22MB
72. 13 - Triggers/004 Triggers Exercises.mp46.93MB
73. 13 - Triggers/005 Triggers Exercises - Solutions.mp443.81MB
74. 14 - Useful Methods and Tools/001 EXPLAIN and EXPLAIN ANALYZE.mp469.67MB
75. 14 - Useful Methods and Tools/002 Dropping Data with TRUNCATE.mp427.34MB
76. 14 - Useful Methods and Tools/003 Exporting and Importing Data with COPY.mp439.03MB
77. 14 - Useful Methods and Tools/004 Array and Array Functions.mp462.42MB
78. 14 - Useful Methods and Tools/005 JSON and JSON Functions.mp443.63MB
79. 14 - Useful Methods and Tools/006 Modules and Extensions.mp486.61MB
80. 14 - Useful Methods and Tools/007 Useful Methods and Tools Exercises.mp45.93MB
81. 14 - Useful Methods and Tools/008 Useful Methods and Tools Exercises - Solutions.mp425.92MB