Udemy SQL for Data Analysis Advanced SQL Querying Techniques 2025

Udemy SQL for Data Analysis Advanced SQL Querying Techniques 2025

Name	Udemy - SQL for Data Analysis Advanced SQL Querying Techniques (1.2025)	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	4.1 GB
Total Files	250
Last Seen
Hash	F066E2B6600B4F00065865CEE15F3DF8CE09B18F

/01. Getting Started/
1. Course Introduction.mp4	14.9 MB
01. Getting Started/
1. Course Introduction.vtt	2.6 KB
2. Course Structure & Outline.mp4	3.4 MB
2. Course Structure & Outline.vtt	3.2 KB
3. READ ME Important Notes for New Students.html	5.0 KB
4. Advanced SQL Querying.pdf	20.2 MB
4. Advanced SQL Querying.zip	4.3 MB
4. DOWNLOAD Course Resources.html	0.5 KB
5. PREVIEW Final Project.mp4	5.9 MB
5. PREVIEW Final Project.vtt	1.7 KB
6. Setting Expectations.mp4	19.2 MB
6. Setting Expectations.vtt	4.3 KB
02. Installation & Setup/
1. Installation & Setup.mp4	5.9 MB
1. Installation & Setup.vtt	1.9 KB
10. DEMO Loading Data in Other RDBMSs.mp4	35.3 MB
10. DEMO Loading Data in Other RDBMSs.vtt	6.0 KB
2. Where to Write SQL Code.mp4	35.1 MB
2. Where to Write SQL Code.vtt	9.6 KB
3. Installing MySQL (Mac).mp4	36.8 MB
3. Installing MySQL (Mac).vtt	6.3 KB
4. Installing MySQL Workbench (Mac).mp4	21.7 MB
4. Installing MySQL Workbench (Mac).vtt	3.8 KB
5. Installing MySQL (PC).mp4	23.4 MB
5. Installing MySQL (PC).vtt	5.6 KB
6. Installing MySQL Workbench (PC).mp4	12.5 MB
6. Installing MySQL Workbench (PC).vtt	2.8 KB
7. Getting Started with MySQL Workbench.mp4	9.6 MB
7. Getting Started with MySQL Workbench.vtt	2.5 KB
8. Loading Data for This Course.mp4	13.4 MB
8. Loading Data for This Course.vtt	3.2 KB
9. DEMO Loading Data in MySQL.mp4	34.3 MB
9. DEMO Loading Data in MySQL.vtt	5.8 KB
03. SQL Basics Review/
1. Section Introduction.mp4	2.0 MB
1. Section Introduction.vtt	0.8 KB
2. The Big 6.mp4	10.4 MB
2. The Big 6.vtt	2.9 KB
3. Common SQL Keywords.mp4	32.1 MB
3. Common SQL Keywords.vtt	8.6 KB
4. DEMO SQL Basics Review.mp4	87.1 MB
4. DEMO SQL Basics Review.vtt	15.7 KB
5.1 Prerequisite Skills.html	25.6 KB
04. Multi-Table Analysis/
1. Section Introduction.mp4	5.5 MB
1. Section Introduction.vtt	2.2 KB
10. ASSIGNMENT Self Joins.mp4	4.3 MB
10. ASSIGNMENT Self Joins.vtt	1.0 KB
11. SOLUTION Self Joins.mp4	42.3 MB
11. SOLUTION Self Joins.vtt	5.0 KB
12. Cross Joins.mp4	40.4 MB
12. Cross Joins.vtt	7.6 KB
13. UNION vs UNION ALL.mp4	50.2 MB
13. UNION vs UNION ALL.vtt	9.6 KB
14. Key Takeaways.mp4	12.1 MB
14. Key Takeaways.vtt	3.2 KB
15.2 Multi-Table Analysis.html	21.5 KB
2. Working with Multiple Tables.mp4	17.4 MB
2. Working with Multiple Tables.vtt	3.6 KB
3. Basic Joins.mp4	65.7 MB
3. Basic Joins.vtt	11.2 KB
4. Basic Join Types.mp4	59.4 MB
4. Basic Join Types.vtt	12.7 KB
5. ASSIGNMENT Basic Joins.mp4	3.2 MB
5. ASSIGNMENT Basic Joins.vtt	1.0 KB
6. SOLUTION Basic Joins.mp4	56.0 MB
6. SOLUTION Basic Joins.vtt	9.4 KB
7. Joining on Multiple Columns.mp4	39.1 MB
7. Joining on Multiple Columns.vtt	6.2 KB
8. Joining Multiple Tables.mp4	59.7 MB
8. Joining Multiple Tables.vtt	9.2 KB
9. Self Joins.mp4	88.3 MB
9. Self Joins.vtt	17.5 KB
05. Subqueries & CTEs/
1. Section Introduction.mp4	3.6 MB
1. Section Introduction.vtt	1.2 KB
10. Subqueries in the WHERE & HAVING Clauses.mp4	30.7 MB
10. Subqueries in the WHERE & HAVING Clauses.vtt	5.0 KB
11. ANY vs ALL.mp4	38.6 MB
11. ANY vs ALL.vtt	6.4 KB
12. EXISTS and Correlated Subqueries.mp4	61.3 MB
12. EXISTS and Correlated Subqueries.vtt	10.7 KB
13. ASSIGNMENT Subqueries in the WHERE Clause.mp4	3.5 MB
13. ASSIGNMENT Subqueries in the WHERE Clause.vtt	0.9 KB
14. SOLUTION Subqueries in the WHERE Clause.mp4	22.5 MB
14. SOLUTION Subqueries in the WHERE Clause.vtt	3.6 KB
15. Common Table Expressions.mp4	20.3 MB
15. Common Table Expressions.vtt	5.6 KB
16. Subqueries vs CTEs.mp4	31.1 MB
16. Subqueries vs CTEs.vtt	5.1 KB
17. Referencing a CTE Multiple Times.mp4	59.2 MB
17. Referencing a CTE Multiple Times.vtt	8.6 KB
18. ASSIGNMENT CTEs.mp4	2.8 MB
18. ASSIGNMENT CTEs.vtt	0.8 KB
19. SOLUTION CTEs.mp4	49.3 MB
19. SOLUTION CTEs.vtt	7.1 KB
2. Subquery Basics.mp4	14.7 MB
2. Subquery Basics.vtt	4.1 KB
20. Multiple CTEs.mp4	60.3 MB
20. Multiple CTEs.vtt	9.8 KB
21. ASSIGNMENT Multiple CTEs.mp4	2.8 MB
21. ASSIGNMENT Multiple CTEs.vtt	0.7 KB
22. SOLUTION Multiple CTEs.mp4	15.5 MB
22. SOLUTION Multiple CTEs.vtt	2.3 KB
23. Recursive CTEs.mp4	45.5 MB
23. Recursive CTEs.vtt	12.9 KB
24. Subqueries vs CTEs vs Temp Tables vs Views.mp4	58.8 MB
24. Subqueries vs CTEs vs Temp Tables vs Views.vtt	12.5 KB
25. Key Takeaways.mp4	20.3 MB
25. Key Takeaways.vtt	5.3 KB
26.3 Subqueries & CTEs.html	21.3 KB
3. Subqueries in the SELECT Clause.mp4	29.7 MB
4. ASSIGNMENT Subqueries in the SELECT Clause.mp4	3.7 MB
5. SOLUTION Subqueries in the SELECT Clause.mp4	31.4 MB
5. SOLUTION Subqueries in the SELECT Clause.vtt	4.2 KB
6. Subqueries in the FROM Clause.mp4	54.8 MB
6. Subqueries in the FROM Clause.vtt	8.7 KB
7. Multiple Subqueries.mp4	84.8 MB
7. Multiple Subqueries.vtt	13.5 KB
8. ASSIGNMENT Subqueries in the FROM Clause.mp4	3.2 MB
8. ASSIGNMENT Subqueries in the FROM Clause.vtt	0.8 KB
9. SOLUTION Subqueries in the FROM Clause.mp4	32.9 MB
9. SOLUTION Subqueries in the FROM Clause.vtt	5.2 KB
06. Window Functions/
1. Section Introduction.mp4	6.4 MB
1. Section Introduction.vtt	2.0 KB
10. FIRST_VALUE, LAST_VALUE & NTH_VALUE.mp4	82.5 MB
10. FIRST_VALUE, LAST_VALUE & NTH_VALUE.vtt	16.0 KB
11. ASSIGNMENT Value Within a Window.mp4	2.9 MB
11. ASSIGNMENT Value Within a Window.vtt	0.7 KB
12. SOLUTION Value Within a Window.mp4	31.0 MB
12. SOLUTION Value Within a Window.vtt	3.5 KB
13. LEAD & LAG.mp4	54.2 MB
13. LEAD & LAG.vtt	9.7 KB
14. ASSIGNMENT Value Relative to a Row.mp4	3.6 MB
14. ASSIGNMENT Value Relative to a Row.vtt	0.9 KB
15. SOLUTION Value Relative to a Row.mp4	83.1 MB
15. SOLUTION Value Relative to a Row.vtt	11.1 KB
16. NTILE.mp4	66.3 MB
16. NTILE.vtt	10.4 KB
17. ASSIGNMENT Statistical Functions.mp4	2.6 MB
17. ASSIGNMENT Statistical Functions.vtt	0.7 KB
18. SOLUTION Statistical Functions.mp4	59.5 MB
18. SOLUTION Statistical Functions.vtt	8.5 KB
19. PREVIEW Moving Average Calculations.mp4	8.9 MB
19. PREVIEW Moving Average Calculations.vtt	1.8 KB
2. Window Function Basics.mp4	15.9 MB
2. Window Function Basics.vtt	3.7 KB
20. Key Takeaways.mp4	13.1 MB
20. Key Takeaways.vtt	3.3 KB
21.4 Window Functions.html	21.3 KB
3. Breaking Down a Window Function.mp4	67.0 MB
3. Breaking Down a Window Function.vtt	13.6 KB
4. ASSIGNMENT Window Functions.mp4	4.2 MB
4. ASSIGNMENT Window Functions.vtt	1.0 KB
5. SOLUTION Window Functions.mp4	22.0 MB
5. SOLUTION Window Functions.vtt	3.2 KB
6. Functions for Window Functions.mp4	7.0 MB
6. Functions for Window Functions.vtt	2.2 KB
7. ROW_NUMBER, RANK & DENSE_RANK.mp4	30.7 MB
7. ROW_NUMBER, RANK & DENSE_RANK.vtt	6.7 KB
8. ASSIGNMENT Row Numbering.mp4	3.6 MB
8. ASSIGNMENT Row Numbering.vtt	0.9 KB
9. SOLUTION Row Numbering.mp4	36.4 MB
9. SOLUTION Row Numbering.vtt	4.5 KB
07. Functions By Data Type/
1. Section Introduction.mp4	5.6 MB
1. Section Introduction.vtt	2.0 KB
10. String Functions.mp4	52.3 MB
10. String Functions.vtt	8.2 KB
11. ASSIGNMENT String Functions.mp4	3.1 MB
11. ASSIGNMENT String Functions.vtt	0.7 KB
12. SOLUTION String Functions.mp4	26.3 MB
12. SOLUTION String Functions.vtt	3.5 KB
13. Pattern Matching.mp4	33.2 MB
13. Pattern Matching.vtt	7.3 KB
14. DEMO Pattern Matching.mp4	76.8 MB
14. DEMO Pattern Matching.vtt	11.8 KB
15. ASSIGNMENT Pattern Matching.mp4	3.1 MB
15. ASSIGNMENT Pattern Matching.vtt	0.8 KB
16. SOLUTION Pattern Matching.mp4	36.7 MB
16. SOLUTION Pattern Matching.vtt	5.5 KB
17. NULL Functions.mp4	46.3 MB
17. NULL Functions.vtt	8.1 KB
18. ASSIGNMENT NULL Functions.mp4	6.0 MB
18. ASSIGNMENT NULL Functions.vtt	1.3 KB
19. SOLUTION NULL Functions.mp4	83.3 MB
19. SOLUTION NULL Functions.vtt	11.5 KB
2. Function Basics.mp4	30.4 MB
2. Function Basics.vtt	7.2 KB
20. Key Takeaways.mp4	10.3 MB
20. Key Takeaways.vtt	3.0 KB
21.5 Functions By Data Type.html	20.8 KB
3. Numeric Functions.mp4	69.7 MB
3. Numeric Functions.vtt	12.8 KB
4. CAST & CONVERT.mp4	46.9 MB
4. CAST & CONVERT.vtt	10.3 KB
5. ASSIGNMENT Numeric Functions.mp4	2.8 MB
5. ASSIGNMENT Numeric Functions.vtt	0.8 KB
6. SOLUTION Numeric Functions.mp4	39.6 MB
6. SOLUTION Numeric Functions.vtt	5.6 KB
7. DateTime Functions.mp4	81.9 MB
7. DateTime Functions.vtt	11.8 KB
8. ASSIGNMENT DateTime Functions.mp4	3.8 MB
8. ASSIGNMENT DateTime Functions.vtt	0.9 KB
9. SOLUTION DateTime Functions.mp4	19.0 MB
9. SOLUTION DateTime Functions.vtt	2.2 KB
08. Data Analysis Applications/
1. Section Introduction.mp4	9.2 MB
1. Section Introduction.vtt	2.5 KB
10. SOLUTION Pivoting.mp4	53.1 MB
10. SOLUTION Pivoting.vtt	7.6 KB
11. Rolling Calculations.mp4	21.9 MB
11. Rolling Calculations.vtt	4.5 KB
12. DEMO Rolling Calculations.mp4	91.7 MB
12. DEMO Rolling Calculations.vtt	14.5 KB
13. ASSIGNMENT Rolling Calculations.mp4	4.9 MB
13. ASSIGNMENT Rolling Calculations.vtt	1.2 KB
14. SOLUTION Rolling Calculations.mp4	56.3 MB
14. SOLUTION Rolling Calculations.vtt	7.7 KB
15. DEMO Imputing NULL Values.mp4	54.1 MB
15. DEMO Imputing NULL Values.vtt	9.3 KB
16. Key Takeaways.mp4	12.6 MB
16. Key Takeaways.vtt	3.3 KB
17.6 Data Analysis Applications.html	21.1 KB
2. Duplicate Values.mp4	73.6 MB
2. Duplicate Values.vtt	14.2 KB
3. ASSIGNMENT Duplicate Values.mp4	3.3 MB
3. ASSIGNMENT Duplicate Values.vtt	0.8 KB
4. SOLUTION Duplicate Values.mp4	26.8 MB
4. SOLUTION Duplicate Values.vtt	3.4 KB
5. Min Max Value Filtering.mp4	64.7 MB
5. Min Max Value Filtering.vtt	11.6 KB
6. ASSIGNMENT Min Max Value Filtering.mp4	2.3 MB
6. ASSIGNMENT Min Max Value Filtering.vtt	0.6 KB
7. SOLUTION Min Max Value Filtering.mp4	71.9 MB
7. SOLUTION Min Max Value Filtering.vtt	10.4 KB
8. Pivoting.mp4	33.3 MB
8. Pivoting.vtt	5.6 KB
9. ASSIGNMENT Pivoting.mp4	2.1 MB
9. ASSIGNMENT Pivoting.vtt	0.6 KB
09. Final Project/
1. Final Project Overview.mp4	17.4 MB
1. Final Project Overview.vtt	2.9 KB
2. ASSIGNMENT School Analysis.html	0.8 KB
3. SOLUTION School Analysis.mp4	78.4 MB
3. SOLUTION School Analysis.vtt	10.9 KB
4. ASSIGNMENT Salary Analysis.html	0.8 KB
5. SOLUTION Salary Analysis.mp4	96.8 MB
5. SOLUTION Salary Analysis.vtt	14.2 KB
6. ASSIGNMENT Player Career Analysis.html	0.9 KB
7. SOLUTION Player Career Analysis.mp4	114.1 MB
7. SOLUTION Player Career Analysis.vtt	14.4 KB
8. ASSIGNMENT Player Comparison Analysis.html	0.9 KB
9. SOLUTION Player Comparison Analysis.mp4	140.4 MB
9. SOLUTION Player Comparison Analysis.vtt	19.1 KB
10. Next Steps/
1. 2023-09-26_17-36-30-fe18b28990bd3345572d56124cd324bb.png	119.8 KB
1. BONUS LESSON.html	12.4 KB
Total files 250