Udemy - The Advanced SQL Course (11.2024)

File Name

Size

01. Introduction & Course Set Up/01. Course Overview & Prerequisite Knowledge.mp4

6.0 MB

01. Introduction & Course Set Up/01. Course Overview & Prerequisite Knowledge.vtt

4.3 kB

01. Introduction & Course Set Up/02. Oracle APEX Account Set Up.mp4

24 MB

01. Introduction & Course Set Up/02. Oracle APEX Account Set Up.vtt

2.3 kB

01. Introduction & Course Set Up/03. Oracle APEX Overview.mp4

8.0 MB

01. Introduction & Course Set Up/03. Oracle APEX Overview.vtt

1.6 kB

01. Introduction & Course Set Up/04. Dataset Installation (Automatic).mp4

8.6 MB

01. Introduction & Course Set Up/04. Dataset Installation (Automatic).vtt

2.7 kB

01. Introduction & Course Set Up/05. (Optional) Manual Data Installation.html

965 B

01. Introduction & Course Set Up/06. Dataset Overview.mp4

8.8 MB

01. Introduction & Course Set Up/06. Dataset Overview.vtt

3.7 kB

01. Introduction & Course Set Up/07. Dual Table.mp4

4.7 MB

01. Introduction & Course Set Up/07. Dual Table.vtt

2.1 kB

01. Introduction & Course Set Up/08. Understanding Explain Plans In Oracle.mp4

9.6 MB

01. Introduction & Course Set Up/08. Understanding Explain Plans In Oracle.vtt

2.6 kB

01. Introduction & Course Set Up/assets/06. Data-Model-Slides.pptx

61 kB

02. Data Cleansing And Manipulation/01. Section Overview.html

778 B

02. Data Cleansing And Manipulation/02. Coalesce and NVL.mp4

22 MB

02. Data Cleansing And Manipulation/02. Coalesce and NVL.vtt

6.0 kB

02. Data Cleansing And Manipulation/03. Trim and Pad.mp4

15 MB

02. Data Cleansing And Manipulation/03. Trim and Pad.vtt

5.5 kB

02. Data Cleansing And Manipulation/04. Greatest and Least.mp4

4.7 MB

02. Data Cleansing And Manipulation/04. Greatest and Least.vtt

1.5 kB

02. Data Cleansing And Manipulation/05. Pivoting Tables.mp4

15 MB

02. Data Cleansing And Manipulation/05. Pivoting Tables.vtt

4.1 kB

02. Data Cleansing And Manipulation/06. Unpivoting Tables.mp4

12 MB

02. Data Cleansing And Manipulation/06. Unpivoting Tables.vtt

3.8 kB

02. Data Cleansing And Manipulation/07. Assignment Question 1.html

292 B

02. Data Cleansing And Manipulation/08. Assignment Question 1 Solution.mp4

3.2 MB

02. Data Cleansing And Manipulation/08. Assignment Question 1 Solution.vtt

1.3 kB

02. Data Cleansing And Manipulation/09. Assignment Question 1 Solution (SQL Code).html

183 B

02. Data Cleansing And Manipulation/10. Assignment Question 2.html

878 B

02. Data Cleansing And Manipulation/11. Assignment Question 2 Solution.mp4

3.7 MB

02. Data Cleansing And Manipulation/11. Assignment Question 2 Solution.vtt

1.4 kB

02. Data Cleansing And Manipulation/12. Assignment Question 2 Solution (SQL Code).html

162 B

02. Data Cleansing And Manipulation/assets/02. COALESCE-and-NVL.pptx

54 kB

02. Data Cleansing And Manipulation/assets/03. TRIM-and-PAD.pptx

55 kB

02. Data Cleansing And Manipulation/assets/04. GREATEST-and-LEAST.pptx

53 kB

02. Data Cleansing And Manipulation/assets/05. PIVOT.pptx

54 kB

02. Data Cleansing And Manipulation/assets/06. UNPIVOT.pptx

52 kB

03. Regular Expressions (RegEx)/01. Section Overview.html

604 B

03. Regular Expressions (RegEx)/015 Quiz.html

22 kB

03. Regular Expressions (RegEx)/02. Regular Expressions And Metacharacters.mp4

20 MB

03. Regular Expressions (RegEx)/02. Regular Expressions And Metacharacters.vtt

4.1 kB

03. Regular Expressions (RegEx)/03. Pattern Matching With The '.' '+' '' '' Metacharacters.mp4

21 MB

03. Regular Expressions (RegEx)/03. Pattern Matching With The '.' '+' '' '' Metacharacters.vtt

7.3 kB

03. Regular Expressions (RegEx)/04. Pattern Matching With The 'd' and 'w' Metacharacters.mp4

11 MB

03. Regular Expressions (RegEx)/04. Pattern Matching With The 'd' and 'w' Metacharacters.vtt

5.4 kB

03. Regular Expressions (RegEx)/05. Pattern Matching With Intervals, Lists and Groups.mp4

50 MB

03. Regular Expressions (RegEx)/05. Pattern Matching With Intervals, Lists and Groups.vtt

9.4 kB

03. Regular Expressions (RegEx)/06. Pattern Matching Continued.mp4

28 MB

03. Regular Expressions (RegEx)/06. Pattern Matching Continued.vtt

9.4 kB

03. Regular Expressions (RegEx)/07. Introduction To RegEx Functions In Oracle.mp4

4.4 MB

03. Regular Expressions (RegEx)/07. Introduction To RegEx Functions In Oracle.vtt

1.3 kB

03. Regular Expressions (RegEx)/08. REGEXP_LIKE & Assignment Questions.mp4

20 MB

03. Regular Expressions (RegEx)/08. REGEXP_LIKE & Assignment Questions.vtt

7.0 kB

03. Regular Expressions (RegEx)/09. REGEXP_INSTR & Assignment Questions.mp4

47 MB

03. Regular Expressions (RegEx)/09. REGEXP_INSTR & Assignment Questions.vtt

5.3 kB

03. Regular Expressions (RegEx)/10. REGEXP_SUBSTR & Assignment Questions.mp4

9.3 MB

03. Regular Expressions (RegEx)/10. REGEXP_SUBSTR & Assignment Questions.vtt

4.5 kB

03. Regular Expressions (RegEx)/11. REGEXP_REPLACE & Assignment Questions.mp4

14 MB

03. Regular Expressions (RegEx)/11. REGEXP_REPLACE & Assignment Questions.vtt

5.7 kB

03. Regular Expressions (RegEx)/12. Class Metacharacters.mp4

5.1 MB

03. Regular Expressions (RegEx)/12. Class Metacharacters.vtt

1.9 kB

03. Regular Expressions (RegEx)/13. Concluding Thoughts On RegEx.mp4

1.4 MB

03. Regular Expressions (RegEx)/13. Concluding Thoughts On RegEx.vtt

1.6 kB

03. Regular Expressions (RegEx)/14. Useful External Resources.html

1.4 kB

03. Regular Expressions (RegEx)/assets/02. Regular-Expressions-and-Metacharacters.pptx

57 kB

03. Regular Expressions (RegEx)/assets/03. Pattern-Matching-1.pptx

78 kB

03. Regular Expressions (RegEx)/assets/04. Pattern-Matching-2.pptx

74 kB

03. Regular Expressions (RegEx)/assets/05. Pattern-Matching-3.pptx

88 kB

03. Regular Expressions (RegEx)/assets/06. Pattern-Matching-4.pptx

96 kB

03. Regular Expressions (RegEx)/assets/08. REGEXP-LIKE.pptx

53 kB

03. Regular Expressions (RegEx)/assets/09. REGEXP-INSTR.pptx

52 kB

03. Regular Expressions (RegEx)/assets/10. REGEXP-SUBSTR.pptx

48 kB

03. Regular Expressions (RegEx)/assets/11. REGEXP-REPLACE.pptx

49 kB

04. Analytical (Window) Functions/01. Section Overview.html

801 B

04. Analytical (Window) Functions/02. Introduction to Analytical Functions.mp4

53 MB

04. Analytical (Window) Functions/02. Introduction to Analytical Functions.vtt

9.4 kB

04. Analytical (Window) Functions/03. An Introduction To The Over Clause.mp4

3.1 MB

04. Analytical (Window) Functions/03. An Introduction To The Over Clause.vtt

1.7 kB

04. Analytical (Window) Functions/04. The Over Clause - Partition By.mp4

8.7 MB

04. Analytical (Window) Functions/04. The Over Clause - Partition By.vtt

2.7 kB

04. Analytical (Window) Functions/05. The Over Clause - Order By.mp4

27 MB

04. Analytical (Window) Functions/05. The Over Clause - Order By.vtt

2.2 kB

04. Analytical (Window) Functions/06. An Introduction To Window Frames.mp4

24 MB

04. Analytical (Window) Functions/06. An Introduction To Window Frames.vtt

7.8 kB

04. Analytical (Window) Functions/07. Window Frame - Rows.mp4

20 MB

04. Analytical (Window) Functions/07. Window Frame - Rows.vtt

5.5 kB

04. Analytical (Window) Functions/08. Window Frame - Range.mp4

12 MB

04. Analytical (Window) Functions/08. Window Frame - Range.vtt

3.1 kB

04. Analytical (Window) Functions/09. Window Frame - Default Behaviour.mp4

16 MB

04. Analytical (Window) Functions/09. Window Frame - Default Behaviour.vtt

4.2 kB

04. Analytical (Window) Functions/10. Quick Note on Window Frames.mp4

6.9 MB

04. Analytical (Window) Functions/10. Quick Note on Window Frames.vtt

2.5 kB

04. Analytical (Window) Functions/11. Main Types Of Window Functions.mp4

2.1 MB

04. Analytical (Window) Functions/11. Main Types Of Window Functions.vtt

721 B

04. Analytical (Window) Functions/12. Aggregate Functions - SUM, AVG, MAX, MIN and COUNT.mp4

7.8 MB

04. Analytical (Window) Functions/12. Aggregate Functions - SUM, AVG, MAX, MIN and COUNT.vtt

2.8 kB

04. Analytical (Window) Functions/13. Analytical Functions - LAG, LEAD, NTILE and NTH_VALUE.mp4

58 MB

04. Analytical (Window) Functions/13. Analytical Functions - LAG, LEAD, NTILE and NTH_VALUE.vtt

7.7 kB

04. Analytical (Window) Functions/14. Ranking Functions - ROW_NUMBER, RANK and DENSE_RANK.mp4

11 MB

04. Analytical (Window) Functions/14. Ranking Functions - ROW_NUMBER, RANK and DENSE_RANK.vtt

4.3 kB

04. Analytical (Window) Functions/15. Distribution Functions - PERCENT_RANK and CUME_DIST.mp4

35 MB

04. Analytical (Window) Functions/15. Distribution Functions - PERCENT_RANK and CUME_DIST.vtt

2.8 kB

04. Analytical (Window) Functions/16. Order of Execution.mp4

1.1 MB

04. Analytical (Window) Functions/16. Order of Execution.vtt

673 B

04. Analytical (Window) Functions/17. Practice Scenario Walkthrough 1.mp4

3.3 MB

04. Analytical (Window) Functions/17. Practice Scenario Walkthrough 1.vtt

1.5 kB

04. Analytical (Window) Functions/18. Practice Scenario Walkthrough 2.mp4

4.1 MB

04. Analytical (Window) Functions/18. Practice Scenario Walkthrough 2.vtt

1.9 kB

04. Analytical (Window) Functions/19. Practice Scenario Walkthrough 3.mp4

8.6 MB

04. Analytical (Window) Functions/19. Practice Scenario Walkthrough 3.vtt

2.5 kB

04. Analytical (Window) Functions/20. Practice Scenario Walkthrough 4.mp4

15 MB

04. Analytical (Window) Functions/20. Practice Scenario Walkthrough 4.vtt

1.4 kB

04. Analytical (Window) Functions/21. Assignment Data Preparation.mp4

9.6 MB

04. Analytical (Window) Functions/21. Assignment Data Preparation.vtt

4.1 kB

04. Analytical (Window) Functions/22. Assignment Data Preparation (SQL Code).html

303 B

04. Analytical (Window) Functions/23. Assignment Question 1.html

254 B

04. Analytical (Window) Functions/24. Assignment Question 1 Solution.mp4

2.4 MB

04. Analytical (Window) Functions/24. Assignment Question 1 Solution.vtt

1.0 kB

04. Analytical (Window) Functions/25. Assignment Question 1 Solution (SQL Code).html

189 B

04. Analytical (Window) Functions/26. Assignment Question 2.html

286 B

04. Analytical (Window) Functions/27. Assignment Question 2 Solution.mp4

20 MB

04. Analytical (Window) Functions/27. Assignment Question 2 Solution.vtt

2.4 kB

04. Analytical (Window) Functions/28. Assignment Question 2 Solution (SQL Code).html

258 B

04. Analytical (Window) Functions/29. Assignment Question 3.html

425 B

04. Analytical (Window) Functions/30. Assignment Question 3 Solution.mp4

12 MB

04. Analytical (Window) Functions/30. Assignment Question 3 Solution.vtt

3.6 kB

04. Analytical (Window) Functions/31. Note on Assignment Solution.html

395 B

04. Analytical (Window) Functions/32. Assignment Question 3 Solution (SQL Code).html

384 B

04. Analytical (Window) Functions/33. BONUS (Running Totals) Assignment Question 4.html

459 B

04. Analytical (Window) Functions/34. BONUS (Running Totals) Assignment Question 4 Solution (SQL Code).html

457 B

04. Analytical (Window) Functions/assets/02. Intro-to-Analytical-Functions.pptx

58 kB

04. Analytical (Window) Functions/assets/04. Partition-By.pptx

49 kB

04. Analytical (Window) Functions/assets/05. Order-By.pptx

49 kB

04. Analytical (Window) Functions/assets/06. Window-Frames.pptx

61 kB

04. Analytical (Window) Functions/assets/07. Window-Frames-Rows.pptx

54 kB

04. Analytical (Window) Functions/assets/08. Window-Frames-Range.pptx

54 kB

04. Analytical (Window) Functions/assets/09. Window-Frames-Default.pptx

53 kB

04. Analytical (Window) Functions/assets/11. Types-of-Window-Functions.pptx

56 kB

04. Analytical (Window) Functions/assets/13. Analytical-Functions-LAG-LEAD-NTILE-NTH-VALUE.pptx

61 kB

04. Analytical (Window) Functions/assets/14. Ranking-Functions.pptx

51 kB

04. Analytical (Window) Functions/assets/15. Distribution-Functions.pptx

51 kB

04. Analytical (Window) Functions/assets/16. Order-of-Operations.pptx

48 kB

05. Group By Extensions/01. Section Overview.html

445 B

05. Group By Extensions/02. Introduction To Group By Extensions.mp4

3.1 MB

05. Group By Extensions/02. Introduction To Group By Extensions.vtt

1.0 kB

05. Group By Extensions/03. ROLLUP.mp4

17 MB

05. Group By Extensions/03. ROLLUP.vtt

8.2 kB

05. Group By Extensions/04. CUBE.mp4

12 MB

05. Group By Extensions/04. CUBE.vtt

4.5 kB

05. Group By Extensions/05. Quick Video On Why I Am Using NVL().mp4

6.4 MB

05. Group By Extensions/05. Quick Video On Why I Am Using NVL().vtt

2.4 kB

05. Group By Extensions/06. GROUPING_ID Function.mp4

16 MB

05. Group By Extensions/06. GROUPING_ID Function.vtt

4.6 kB

05. Group By Extensions/07. Grouping Sets.mp4

9.2 MB

05. Group By Extensions/07. Grouping Sets.vtt

4.1 kB

05. Group By Extensions/08. Combining Columns.mp4

2.9 MB

05. Group By Extensions/08. Combining Columns.vtt

1.4 kB

05. Group By Extensions/09. Useful External Resources.html

910 B

05. Group By Extensions/10. Assignment Question 1.html

397 B

05. Group By Extensions/11. Assignment Question 1 Solution.mp4

3.6 MB

05. Group By Extensions/11. Assignment Question 1 Solution.vtt

1.8 kB

05. Group By Extensions/12. Assignment Question 1 Solution (SQL Code).html

225 B

05. Group By Extensions/13. Assignment Question 2.html

513 B

05. Group By Extensions/14. Assignment Question 2 Solution.mp4

3.8 MB

05. Group By Extensions/14. Assignment Question 2 Solution.vtt

1.7 kB

05. Group By Extensions/15. Assignment Question 2 Solution (SQL Code).html

306 B

05. Group By Extensions/16. Assignment Question 3.html

390 B

05. Group By Extensions/17. Assignment Question 3 Solution.mp4

4.3 MB

05. Group By Extensions/17. Assignment Question 3 Solution.vtt

1.9 kB

05. Group By Extensions/18. Assignment Question 3 Solution (SQL Code).html

317 B

05. Group By Extensions/assets/02. Extensions-To-Group-By-Introduction.pptx

54 kB

05. Group By Extensions/assets/03. ROLLUP.pptx

52 kB

05. Group By Extensions/assets/04. CUBE.pptx

52 kB

05. Group By Extensions/assets/06. GROUPING-ID.pptx

55 kB

05. Group By Extensions/assets/07. Grouping-Sets.pptx

52 kB

05. Group By Extensions/assets/08. Composite-Columns.pptx

50 kB

06. Hierarchical Queries/01. Section Overview.html

601 B

06. Hierarchical Queries/02. Introduction To Hierarchical Queries.mp4

13 MB

06. Hierarchical Queries/02. Introduction To Hierarchical Queries.vtt

2.9 kB

06. Hierarchical Queries/03. The Connect By & Start With Clauses.mp4

40 MB

06. Hierarchical Queries/03. The Connect By & Start With Clauses.vtt

4.5 kB

06. Hierarchical Queries/04. The Level Pseudocolumn.mp4

6.5 MB

06. Hierarchical Queries/04. The Level Pseudocolumn.vtt

2.3 kB

06. Hierarchical Queries/05. CONNECT_BY_ROOT & SYS_CONNECT_BY_PATH.mp4

28 MB

06. Hierarchical Queries/05. CONNECT_BY_ROOT & SYS_CONNECT_BY_PATH.vtt

3.6 kB

06. Hierarchical Queries/06. Ordering Your Hierarchical Query Results.mp4

17 MB

06. Hierarchical Queries/06. Ordering Your Hierarchical Query Results.vtt

1.6 kB

06. Hierarchical Queries/07. Formatting Your Hierarchical Query.mp4

13 MB

06. Hierarchical Queries/07. Formatting Your Hierarchical Query.vtt

2.1 kB

06. Hierarchical Queries/08. Filtering Your Results.mp4

4.2 MB

06. Hierarchical Queries/08. Filtering Your Results.vtt

1.5 kB

06. Hierarchical Queries/09. Hierarchical Query Processing.html

711 B

06. Hierarchical Queries/10. Assignment Question 1.html

126 B

06. Hierarchical Queries/11. Assignment Question 1 Solution.mp4

1.0 MB

06. Hierarchical Queries/11. Assignment Question 1 Solution.vtt

456 B

06. Hierarchical Queries/12. Assignment Question 1 Solution (SQL Code).html

125 B

06. Hierarchical Queries/13. Assignment Question 2.html

166 B

06. Hierarchical Queries/14. Assignment Question 2 Solution.mp4

1.5 MB

06. Hierarchical Queries/14. Assignment Question 2 Solution.vtt

605 B

06. Hierarchical Queries/15. Assignment Question 2 Solution (SQL Code).html

148 B

06. Hierarchical Queries/16. Assignment Question 3.html

195 B

06. Hierarchical Queries/17. Assignment Question 3 Solution.mp4

2.0 MB

06. Hierarchical Queries/17. Assignment Question 3 Solution.vtt

1.0 kB

06. Hierarchical Queries/18. Assignment Question 3 Solution (SQL Code).html

115 B

06. Hierarchical Queries/19. Assignment Question 4.html

144 B

06. Hierarchical Queries/20. Assignment Question 4 Solution.mp4

3.9 MB

06. Hierarchical Queries/20. Assignment Question 4 Solution.vtt

1.6 kB

06. Hierarchical Queries/21. Assignment Question 4 Solution (SQL Code).html

202 B

06. Hierarchical Queries/assets/02. Heirarchical-Queries-HQ.pptx

60 kB

06. Hierarchical Queries/assets/03. Connect-By-Prior-and-Start-With.pptx

54 kB

06. Hierarchical Queries/assets/04. LEVEL.pptx

51 kB

06. Hierarchical Queries/assets/05. Connect-By-Root-and-Connect-By-Path.pptx

53 kB

06. Hierarchical Queries/assets/06. Order-By-Siblings.pptx

50 kB

07. Correlated Subqueries And Common Table Expressions (CTEs)/01. Section Overview.html

596 B

07. Correlated Subqueries And Common Table Expressions (CTEs)/02. Recap On Subqueries.mp4

19 MB

07. Correlated Subqueries And Common Table Expressions (CTEs)/02. Recap On Subqueries.vtt

3.5 kB

07. Correlated Subqueries And Common Table Expressions (CTEs)/03. Correlated Subqueries, Where Exists And Where Not Exists.mp4

57 MB

07. Correlated Subqueries And Common Table Expressions (CTEs)/03. Correlated Subqueries, Where Exists And Where Not Exists.vtt

6.8 kB

07. Correlated Subqueries And Common Table Expressions (CTEs)/04. Common Table Expressions (CTEs).mp4

9.1 MB

07. Correlated Subqueries And Common Table Expressions (CTEs)/04. Common Table Expressions (CTEs).vtt

3.2 kB

07. Correlated Subqueries And Common Table Expressions (CTEs)/05. Recursive CTEs.mp4

30 MB

07. Correlated Subqueries And Common Table Expressions (CTEs)/05. Recursive CTEs.vtt

12 kB

07. Correlated Subqueries And Common Table Expressions (CTEs)/06. Assignment Question 1.html

105 B

07. Correlated Subqueries And Common Table Expressions (CTEs)/07. Assignment Question 1 Solution.mp4

2.0 MB

07. Correlated Subqueries And Common Table Expressions (CTEs)/07. Assignment Question 1 Solution.vtt

790 B

07. Correlated Subqueries And Common Table Expressions (CTEs)/08. Assignment Question 1 Solution (SQL Code).html

111 B

07. Correlated Subqueries And Common Table Expressions (CTEs)/09. Assignment Question 2.html

127 B

07. Correlated Subqueries And Common Table Expressions (CTEs)/10. Assignment Question 2 Solution.mp4

3.7 MB

07. Correlated Subqueries And Common Table Expressions (CTEs)/10. Assignment Question 2 Solution.vtt

1.4 kB

07. Correlated Subqueries And Common Table Expressions (CTEs)/11. Assignment Question 2 Solution (SQL Code).html

282 B

07. Correlated Subqueries And Common Table Expressions (CTEs)/12. Assignment Question 3.html

263 B

07. Correlated Subqueries And Common Table Expressions (CTEs)/13. Assignment Question 3 Solution.mp4

4.6 MB

07. Correlated Subqueries And Common Table Expressions (CTEs)/13. Assignment Question 3 Solution.vtt

2.2 kB

07. Correlated Subqueries And Common Table Expressions (CTEs)/14. Assignment Question 3 Solution (SQL Code).html

323 B

07. Correlated Subqueries And Common Table Expressions (CTEs)/assets/02. Recap-on-Subqueries.pptx

69 kB

07. Correlated Subqueries And Common Table Expressions (CTEs)/assets/03. Correlated-Subqueries.pptx

58 kB

07. Correlated Subqueries And Common Table Expressions (CTEs)/assets/04. CTE.pptx

52 kB

07. Correlated Subqueries And Common Table Expressions (CTEs)/assets/05. Recursive-CTE.pptx

66 kB

08. Materialized Views/01. Section Overview.html

426 B

08. Materialized Views/014 Quiz.html

28 kB

08. Materialized Views/02. Quick Recap On Views.mp4

7.8 MB

08. Materialized Views/02. Quick Recap On Views.vtt

3.1 kB

08. Materialized Views/03. What Are Materialized Views.mp4

25 MB

08. Materialized Views/03. What Are Materialized Views.vtt

4.7 kB

08. Materialized Views/04. Syntax.mp4

5.9 MB

08. Materialized Views/04. Syntax.vtt

2.7 kB

08. Materialized Views/05. Simple And Complex Materialized Views.mp4

1.5 MB

08. Materialized Views/05. Simple And Complex Materialized Views.vtt

798 B

08. Materialized Views/06. Refresh Types.mp4

20 MB

08. Materialized Views/06. Refresh Types.vtt

6.1 kB

08. Materialized Views/07. On Commit On Demand.mp4

63 MB

08. Materialized Views/07. On Commit On Demand.vtt

6.7 kB

08. Materialized Views/08. Manually Refreshing Your Materialized View.mp4

8.3 MB

08. Materialized Views/08. Manually Refreshing Your Materialized View.vtt

3.2 kB

08. Materialized Views/09. Build Deferred.mp4

4.7 MB

08. Materialized Views/09. Build Deferred.vtt

1.9 kB

08. Materialized Views/10. Query Rewrite.mp4

4.0 MB

08. Materialized Views/10. Query Rewrite.vtt

1.5 kB

08. Materialized Views/11. Converting An Existing Table Into A Materialized View.mp4

15 MB

08. Materialized Views/11. Converting An Existing Table Into A Materialized View.vtt

3.9 kB

08. Materialized Views/12. Additional Guidance.mp4

5.2 MB

08. Materialized Views/12. Additional Guidance.vtt

2.3 kB

08. Materialized Views/13. Useful Links And Resources.html

1.1 kB

08. Materialized Views/assets/04. Materialized-Views-Syntax.pptx

49 kB

08. Materialized Views/assets/05. Simple-vs-Complex-MVs.pptx

48 kB

08. Materialized Views/assets/06. MV-Refresh-Types.pptx

53 kB

08. Materialized Views/assets/07. On-Commit-vs-On-Demand.pptx

48 kB

08. Materialized Views/assets/08. Manual-Refresh-Procedures.pptx

44 kB

08. Materialized Views/assets/11. On-Prebuilt-Table.pptx

49 kB

09. Appendix Manual Dataset Installation (Optional)/01. Countries Dataset Installation (Manual).mp4

21 MB

09. Appendix Manual Dataset Installation (Optional)/01. Countries Dataset Installation (Manual).vtt

5.7 kB

09. Appendix Manual Dataset Installation (Optional)/02. Employees (EMPDEPT) Dataset Installation (Manual).mp4

38 MB

09. Appendix Manual Dataset Installation (Optional)/02. Employees (EMPDEPT) Dataset Installation (Manual).vtt

4.8 kB

09. Appendix Manual Dataset Installation (Optional)/03. Customer Orders Dataset Installation (Manual).mp4

14 MB

09. Appendix Manual Dataset Installation (Optional)/03. Customer Orders Dataset Installation (Manual).vtt

4.9 kB

09. Appendix Manual Dataset Installation (Optional)/assets/01. Countries.zip

20 kB

09. Appendix Manual Dataset Installation (Optional)/assets/02. Employees.zip

5.2 kB

09. Appendix Manual Dataset Installation (Optional)/assets/03. Customer-Orders.zip

78 kB

10. Keep learning with me/01. BONUS Check out my other courses.html

3.4 kB