Udemy - SQL for Data Analysis Advanced SQL Querying Techniques (1.2025)

01. Getting Started/1. Course Introduction.mp4

14.25 MB

01. Getting Started/1. Course Introduction.vtt

2.52 KB

01. Getting Started/2. Course Structure & Outline.mp4

3.23 MB

01. Getting Started/2. Course Structure & Outline.vtt

3.16 KB

01. Getting Started/3. READ ME Important Notes for New Students.html

4.83 KB

01. Getting Started/4. Advanced SQL Querying.pdf

19.29 MB

01. Getting Started/4. Advanced SQL Querying.zip

4.06 MB

01. Getting Started/4. DOWNLOAD Course Resources.html

548 B

01. Getting Started/5. PREVIEW Final Project.mp4

5.66 MB

01. Getting Started/5. PREVIEW Final Project.vtt

1.69 KB

01. Getting Started/6. Setting Expectations.mp4

18.26 MB

01. Getting Started/6. Setting Expectations.vtt

4.15 KB

02. Installation & Setup/1. Installation & Setup.mp4

5.61 MB

02. Installation & Setup/1. Installation & Setup.vtt

1.88 KB

02. Installation & Setup/10. DEMO Loading Data in Other RDBMSs.mp4

33.68 MB

02. Installation & Setup/10. DEMO Loading Data in Other RDBMSs.vtt

5.87 KB

02. Installation & Setup/2. Where to Write SQL Code.mp4

33.48 MB

02. Installation & Setup/2. Where to Write SQL Code.vtt

9.36 KB

02. Installation & Setup/3. Installing MySQL (Mac).mp4

35.06 MB

02. Installation & Setup/3. Installing MySQL (Mac).vtt

6.19 KB

02. Installation & Setup/4. Installing MySQL Workbench (Mac).mp4

20.73 MB

02. Installation & Setup/4. Installing MySQL Workbench (Mac).vtt

3.68 KB

02. Installation & Setup/5. Installing MySQL (PC).mp4

22.33 MB

02. Installation & Setup/5. Installing MySQL (PC).vtt

5.45 KB

02. Installation & Setup/6. Installing MySQL Workbench (PC).mp4

11.93 MB

02. Installation & Setup/6. Installing MySQL Workbench (PC).vtt

2.78 KB

02. Installation & Setup/7. Getting Started with MySQL Workbench.mp4

9.13 MB

02. Installation & Setup/7. Getting Started with MySQL Workbench.vtt

2.43 KB

02. Installation & Setup/8. Loading Data for This Course.mp4

12.82 MB

02. Installation & Setup/8. Loading Data for This Course.vtt

3.15 KB

02. Installation & Setup/9. DEMO Loading Data in MySQL.mp4

32.69 MB

02. Installation & Setup/9. DEMO Loading Data in MySQL.vtt

5.65 KB

03. SQL Basics Review/1. Section Introduction.mp4

1.88 MB

03. SQL Basics Review/1. Section Introduction.vtt

772 B

03. SQL Basics Review/2. The Big 6.mp4

9.93 MB

03. SQL Basics Review/2. The Big 6.vtt

2.88 KB

03. SQL Basics Review/3. Common SQL Keywords.mp4

30.66 MB

03. SQL Basics Review/3. Common SQL Keywords.vtt

8.38 KB

03. SQL Basics Review/4. DEMO SQL Basics Review.mp4

83.06 MB

03. SQL Basics Review/4. DEMO SQL Basics Review.vtt

15.32 KB

03. SQL Basics Review/5.1 Prerequisite Skills.html

25.03 KB

04. Multi-Table Analysis/1. Section Introduction.mp4

5.27 MB

04. Multi-Table Analysis/1. Section Introduction.vtt

2.12 KB

04. Multi-Table Analysis/10. ASSIGNMENT Self Joins.mp4

4.1 MB

04. Multi-Table Analysis/10. ASSIGNMENT Self Joins.vtt

1015 B

04. Multi-Table Analysis/11. SOLUTION Self Joins.mp4

40.36 MB

04. Multi-Table Analysis/11. SOLUTION Self Joins.vtt

4.84 KB

04. Multi-Table Analysis/12. Cross Joins.mp4

38.51 MB

04. Multi-Table Analysis/12. Cross Joins.vtt

7.38 KB

04. Multi-Table Analysis/13. UNION vs UNION ALL.mp4

47.89 MB

04. Multi-Table Analysis/13. UNION vs UNION ALL.vtt

9.34 KB

04. Multi-Table Analysis/14. Key Takeaways.mp4

11.55 MB

04. Multi-Table Analysis/14. Key Takeaways.vtt

3.16 KB

04. Multi-Table Analysis/15.2 Multi-Table Analysis.html

21.02 KB

04. Multi-Table Analysis/2. Working with Multiple Tables.mp4

16.55 MB

04. Multi-Table Analysis/2. Working with Multiple Tables.vtt

3.53 KB

04. Multi-Table Analysis/3. Basic Joins.mp4

62.7 MB

04. Multi-Table Analysis/3. Basic Joins.vtt

10.89 KB

04. Multi-Table Analysis/4. Basic Join Types.mp4

56.67 MB

04. Multi-Table Analysis/4. Basic Join Types.vtt

12.35 KB

04. Multi-Table Analysis/5. ASSIGNMENT Basic Joins.mp4

3.04 MB

04. Multi-Table Analysis/5. ASSIGNMENT Basic Joins.vtt

984 B

04. Multi-Table Analysis/6. SOLUTION Basic Joins.mp4

53.45 MB

04. Multi-Table Analysis/6. SOLUTION Basic Joins.vtt

9.13 KB

04. Multi-Table Analysis/7. Joining on Multiple Columns.mp4

37.26 MB

04. Multi-Table Analysis/7. Joining on Multiple Columns.vtt

6.02 KB

04. Multi-Table Analysis/8. Joining Multiple Tables.mp4

56.94 MB

04. Multi-Table Analysis/8. Joining Multiple Tables.vtt

8.96 KB

04. Multi-Table Analysis/9. Self Joins.mp4

84.16 MB

04. Multi-Table Analysis/9. Self Joins.vtt

17.05 KB

05. Subqueries & CTEs/1. Section Introduction.mp4

3.4 MB

05. Subqueries & CTEs/1. Section Introduction.vtt

1.17 KB

05. Subqueries & CTEs/10. Subqueries in the WHERE & HAVING Clauses.mp4

29.26 MB

05. Subqueries & CTEs/10. Subqueries in the WHERE & HAVING Clauses.vtt

4.88 KB

05. Subqueries & CTEs/11. ANY vs ALL.mp4

36.77 MB

05. Subqueries & CTEs/11. ANY vs ALL.vtt

6.29 KB

05. Subqueries & CTEs/12. EXISTS and Correlated Subqueries.mp4

58.42 MB

05. Subqueries & CTEs/12. EXISTS and Correlated Subqueries.vtt

10.45 KB

05. Subqueries & CTEs/13. ASSIGNMENT Subqueries in the WHERE Clause.mp4

3.36 MB

05. Subqueries & CTEs/13. ASSIGNMENT Subqueries in the WHERE Clause.vtt

893 B

05. Subqueries & CTEs/14. SOLUTION Subqueries in the WHERE Clause.mp4

21.45 MB

05. Subqueries & CTEs/14. SOLUTION Subqueries in the WHERE Clause.vtt

3.53 KB

05. Subqueries & CTEs/15. Common Table Expressions.mp4

19.32 MB

05. Subqueries & CTEs/15. Common Table Expressions.vtt

5.44 KB

05. Subqueries & CTEs/16. Subqueries vs CTEs.mp4

29.68 MB

05. Subqueries & CTEs/16. Subqueries vs CTEs.vtt

5.02 KB

05. Subqueries & CTEs/17. Referencing a CTE Multiple Times.mp4

56.41 MB

05. Subqueries & CTEs/17. Referencing a CTE Multiple Times.vtt

8.43 KB

05. Subqueries & CTEs/18. ASSIGNMENT CTEs.mp4

2.71 MB

05. Subqueries & CTEs/18. ASSIGNMENT CTEs.vtt

827 B

05. Subqueries & CTEs/19. SOLUTION CTEs.mp4

46.98 MB

05. Subqueries & CTEs/19. SOLUTION CTEs.vtt

6.91 KB

05. Subqueries & CTEs/2. Subquery Basics.mp4

14.03 MB

05. Subqueries & CTEs/2. Subquery Basics.vtt

4.04 KB

05. Subqueries & CTEs/20. Multiple CTEs.mp4

57.51 MB

05. Subqueries & CTEs/20. Multiple CTEs.vtt

9.57 KB

05. Subqueries & CTEs/21. ASSIGNMENT Multiple CTEs.mp4

2.72 MB

05. Subqueries & CTEs/21. ASSIGNMENT Multiple CTEs.vtt

667 B

05. Subqueries & CTEs/22. SOLUTION Multiple CTEs.mp4

14.82 MB

05. Subqueries & CTEs/22. SOLUTION Multiple CTEs.vtt

2.23 KB

05. Subqueries & CTEs/23. Recursive CTEs.mp4

43.41 MB

05. Subqueries & CTEs/23. Recursive CTEs.vtt

12.55 KB

05. Subqueries & CTEs/24. Subqueries vs CTEs vs Temp Tables vs Views.mp4

56.11 MB

05. Subqueries & CTEs/24. Subqueries vs CTEs vs Temp Tables vs Views.vtt

12.25 KB

05. Subqueries & CTEs/25. Key Takeaways.mp4

19.38 MB

05. Subqueries & CTEs/25. Key Takeaways.vtt

5.14 KB

05. Subqueries & CTEs/26.3 Subqueries & CTEs.html

20.8 KB

05. Subqueries & CTEs/3. Subqueries in the SELECT Clause.mp4

28.37 MB

05. Subqueries & CTEs/4. ASSIGNMENT Subqueries in the SELECT Clause.mp4

3.49 MB

05. Subqueries & CTEs/5. SOLUTION Subqueries in the SELECT Clause.mp4

29.92 MB

05. Subqueries & CTEs/5. SOLUTION Subqueries in the SELECT Clause.vtt

4.08 KB

05. Subqueries & CTEs/6. Subqueries in the FROM Clause.mp4

52.24 MB

05. Subqueries & CTEs/6. Subqueries in the FROM Clause.vtt

8.54 KB

05. Subqueries & CTEs/7. Multiple Subqueries.mp4

80.84 MB

05. Subqueries & CTEs/7. Multiple Subqueries.vtt

13.22 KB

05. Subqueries & CTEs/8. ASSIGNMENT Subqueries in the FROM Clause.mp4

3.01 MB

05. Subqueries & CTEs/8. ASSIGNMENT Subqueries in the FROM Clause.vtt

752 B

05. Subqueries & CTEs/9. SOLUTION Subqueries in the FROM Clause.mp4

31.42 MB

05. Subqueries & CTEs/9. SOLUTION Subqueries in the FROM Clause.vtt

5.08 KB

06. Window Functions/1. Section Introduction.mp4

6.11 MB

06. Window Functions/1. Section Introduction.vtt

1.96 KB

06. Window Functions/10. FIRST_VALUE, LAST_VALUE & NTH_VALUE.mp4

78.68 MB

06. Window Functions/10. FIRST_VALUE, LAST_VALUE & NTH_VALUE.vtt

15.64 KB

06. Window Functions/11. ASSIGNMENT Value Within a Window.mp4

2.81 MB

06. Window Functions/11. ASSIGNMENT Value Within a Window.vtt

709 B

06. Window Functions/12. SOLUTION Value Within a Window.mp4

29.54 MB

06. Window Functions/12. SOLUTION Value Within a Window.vtt

3.46 KB

06. Window Functions/13. LEAD & LAG.mp4

51.65 MB

06. Window Functions/13. LEAD & LAG.vtt

9.43 KB

06. Window Functions/14. ASSIGNMENT Value Relative to a Row.mp4

3.43 MB

06. Window Functions/14. ASSIGNMENT Value Relative to a Row.vtt

923 B

06. Window Functions/15. SOLUTION Value Relative to a Row.mp4

79.28 MB

06. Window Functions/15. SOLUTION Value Relative to a Row.vtt

10.89 KB

06. Window Functions/16. NTILE.mp4

63.2 MB

06. Window Functions/16. NTILE.vtt

10.2 KB

06. Window Functions/17. ASSIGNMENT Statistical Functions.mp4

2.49 MB

06. Window Functions/17. ASSIGNMENT Statistical Functions.vtt

668 B

06. Window Functions/18. SOLUTION Statistical Functions.mp4

56.7 MB

06. Window Functions/18. SOLUTION Statistical Functions.vtt

8.29 KB

06. Window Functions/19. PREVIEW Moving Average Calculations.mp4

8.46 MB

06. Window Functions/19. PREVIEW Moving Average Calculations.vtt

1.74 KB

06. Window Functions/2. Window Function Basics.mp4

15.2 MB

06. Window Functions/2. Window Function Basics.vtt

3.66 KB

06. Window Functions/20. Key Takeaways.mp4

12.53 MB

06. Window Functions/20. Key Takeaways.vtt

3.18 KB

06. Window Functions/21.4 Window Functions.html

20.78 KB

06. Window Functions/3. Breaking Down a Window Function.mp4

63.87 MB

06. Window Functions/3. Breaking Down a Window Function.vtt

13.3 KB

06. Window Functions/4. ASSIGNMENT Window Functions.mp4

4.05 MB

06. Window Functions/4. ASSIGNMENT Window Functions.vtt

953 B

06. Window Functions/5. SOLUTION Window Functions.mp4

20.98 MB

06. Window Functions/5. SOLUTION Window Functions.vtt

3.1 KB

06. Window Functions/6. Functions for Window Functions.mp4

6.68 MB

06. Window Functions/6. Functions for Window Functions.vtt

2.14 KB

06. Window Functions/7. ROW_NUMBER, RANK & DENSE_RANK.mp4

29.25 MB

06. Window Functions/7. ROW_NUMBER, RANK & DENSE_RANK.vtt

6.58 KB

06. Window Functions/8. ASSIGNMENT Row Numbering.mp4

3.44 MB

06. Window Functions/8. ASSIGNMENT Row Numbering.vtt

912 B

06. Window Functions/9. SOLUTION Row Numbering.mp4

34.75 MB

06. Window Functions/9. SOLUTION Row Numbering.vtt

4.42 KB

07. Functions By Data Type/1. Section Introduction.mp4

5.38 MB

07. Functions By Data Type/1. Section Introduction.vtt

1.94 KB

07. Functions By Data Type/10. String Functions.mp4

49.88 MB

07. Functions By Data Type/10. String Functions.vtt

8.05 KB

07. Functions By Data Type/11. ASSIGNMENT String Functions.mp4

2.97 MB

07. Functions By Data Type/11. ASSIGNMENT String Functions.vtt

727 B

07. Functions By Data Type/12. SOLUTION String Functions.mp4

25.13 MB

07. Functions By Data Type/12. SOLUTION String Functions.vtt

3.41 KB

07. Functions By Data Type/13. Pattern Matching.mp4

31.62 MB

07. Functions By Data Type/13. Pattern Matching.vtt

7.1 KB

07. Functions By Data Type/14. DEMO Pattern Matching.mp4

73.23 MB

07. Functions By Data Type/14. DEMO Pattern Matching.vtt

11.51 KB

07. Functions By Data Type/15. ASSIGNMENT Pattern Matching.mp4

2.93 MB

07. Functions By Data Type/15. ASSIGNMENT Pattern Matching.vtt

830 B

07. Functions By Data Type/16. SOLUTION Pattern Matching.mp4

35.01 MB

07. Functions By Data Type/16. SOLUTION Pattern Matching.vtt

5.34 KB

07. Functions By Data Type/17. NULL Functions.mp4

44.2 MB

07. Functions By Data Type/17. NULL Functions.vtt

7.95 KB

07. Functions By Data Type/18. ASSIGNMENT NULL Functions.mp4

5.75 MB

07. Functions By Data Type/18. ASSIGNMENT NULL Functions.vtt

1.31 KB

07. Functions By Data Type/19. SOLUTION NULL Functions.mp4

79.46 MB

07. Functions By Data Type/19. SOLUTION NULL Functions.vtt

11.2 KB

07. Functions By Data Type/2. Function Basics.mp4

28.98 MB

07. Functions By Data Type/2. Function Basics.vtt

7.08 KB

07. Functions By Data Type/20. Key Takeaways.mp4

9.79 MB

07. Functions By Data Type/20. Key Takeaways.vtt

2.89 KB

07. Functions By Data Type/21.5 Functions By Data Type.html

20.29 KB

07. Functions By Data Type/3. Numeric Functions.mp4

66.5 MB

07. Functions By Data Type/3. Numeric Functions.vtt

12.54 KB

07. Functions By Data Type/4. CAST & CONVERT.mp4

44.72 MB

07. Functions By Data Type/4. CAST & CONVERT.vtt

10.06 KB

07. Functions By Data Type/5. ASSIGNMENT Numeric Functions.mp4

2.63 MB

07. Functions By Data Type/5. ASSIGNMENT Numeric Functions.vtt

776 B

07. Functions By Data Type/6. SOLUTION Numeric Functions.mp4

37.72 MB

07. Functions By Data Type/6. SOLUTION Numeric Functions.vtt

5.51 KB

07. Functions By Data Type/7. DateTime Functions.mp4

78.13 MB

07. Functions By Data Type/7. DateTime Functions.vtt

11.57 KB

07. Functions By Data Type/8. ASSIGNMENT DateTime Functions.mp4

3.66 MB

07. Functions By Data Type/8. ASSIGNMENT DateTime Functions.vtt

850 B

07. Functions By Data Type/9. SOLUTION DateTime Functions.mp4

18.16 MB

07. Functions By Data Type/9. SOLUTION DateTime Functions.vtt

2.19 KB

08. Data Analysis Applications/1. Section Introduction.mp4

8.73 MB

08. Data Analysis Applications/1. Section Introduction.vtt

2.46 KB

08. Data Analysis Applications/10. SOLUTION Pivoting.mp4

50.64 MB

08. Data Analysis Applications/10. SOLUTION Pivoting.vtt

7.45 KB

08. Data Analysis Applications/11. Rolling Calculations.mp4

20.92 MB

08. Data Analysis Applications/11. Rolling Calculations.vtt

4.44 KB

08. Data Analysis Applications/12. DEMO Rolling Calculations.mp4

87.48 MB

08. Data Analysis Applications/12. DEMO Rolling Calculations.vtt

14.18 KB

08. Data Analysis Applications/13. ASSIGNMENT Rolling Calculations.mp4

4.69 MB

08. Data Analysis Applications/13. ASSIGNMENT Rolling Calculations.vtt

1.15 KB

08. Data Analysis Applications/14. SOLUTION Rolling Calculations.mp4

53.71 MB

08. Data Analysis Applications/14. SOLUTION Rolling Calculations.vtt

7.54 KB

08. Data Analysis Applications/15. DEMO Imputing NULL Values.mp4

51.56 MB

08. Data Analysis Applications/15. DEMO Imputing NULL Values.vtt

9.05 KB

08. Data Analysis Applications/16. Key Takeaways.mp4

11.98 MB

08. Data Analysis Applications/16. Key Takeaways.vtt

3.22 KB

08. Data Analysis Applications/17.6 Data Analysis Applications.html

20.63 KB

08. Data Analysis Applications/2. Duplicate Values.mp4

70.22 MB

08. Data Analysis Applications/2. Duplicate Values.vtt

13.83 KB

08. Data Analysis Applications/3. ASSIGNMENT Duplicate Values.mp4

3.14 MB

08. Data Analysis Applications/3. ASSIGNMENT Duplicate Values.vtt

781 B

08. Data Analysis Applications/4. SOLUTION Duplicate Values.mp4

25.52 MB

08. Data Analysis Applications/4. SOLUTION Duplicate Values.vtt

3.32 KB

08. Data Analysis Applications/5. Min Max Value Filtering.mp4

61.67 MB

08. Data Analysis Applications/5. Min Max Value Filtering.vtt

11.33 KB

08. Data Analysis Applications/6. ASSIGNMENT Min Max Value Filtering.mp4

2.17 MB

08. Data Analysis Applications/6. ASSIGNMENT Min Max Value Filtering.vtt

564 B

08. Data Analysis Applications/7. SOLUTION Min Max Value Filtering.mp4

68.57 MB

08. Data Analysis Applications/7. SOLUTION Min Max Value Filtering.vtt

10.14 KB

08. Data Analysis Applications/8. Pivoting.mp4

31.76 MB

08. Data Analysis Applications/8. Pivoting.vtt

5.43 KB

08. Data Analysis Applications/9. ASSIGNMENT Pivoting.mp4

1.96 MB

08. Data Analysis Applications/9. ASSIGNMENT Pivoting.vtt

646 B

09. Final Project/1. Final Project Overview.mp4

16.55 MB

09. Final Project/1. Final Project Overview.vtt

2.84 KB

09. Final Project/2. ASSIGNMENT School Analysis.html

793 B

09. Final Project/3. SOLUTION School Analysis.mp4

74.81 MB

09. Final Project/3. SOLUTION School Analysis.vtt

10.61 KB

09. Final Project/4. ASSIGNMENT Salary Analysis.html

790 B

09. Final Project/5. SOLUTION Salary Analysis.mp4

92.3 MB

09. Final Project/5. SOLUTION Salary Analysis.vtt

13.89 KB

09. Final Project/6. ASSIGNMENT Player Career Analysis.html

875 B

09. Final Project/7. SOLUTION Player Career Analysis.mp4

108.83 MB

09. Final Project/7. SOLUTION Player Career Analysis.vtt

14.05 KB

09. Final Project/8. ASSIGNMENT Player Comparison Analysis.html

864 B

09. Final Project/9. SOLUTION Player Comparison Analysis.mp4

133.87 MB

09. Final Project/9. SOLUTION Player Comparison Analysis.vtt

18.63 KB

10. Next Steps/1. 2023-09-26_17-36-30-fe18b28990bd3345572d56124cd324bb.png

116.98 KB

10. Next Steps/1. BONUS LESSON.html

12.14 KB

资源详情

免责声明