Udemy - SQL for Data Analysis Advanced SQL Querying Techniques (1.2025)
| Creation Time | Total Size | Total Files | Info Hash |
|---|---|---|---|
| 2026-03-07 08:33:07 | 3.78 GB | 250 | f066e2b6600b4f00065865cee15f3df8ce09b18f |
Download
To download this file, you need a free bitTorrent client such as qBittorrent.
Related Torrents
Files
- 01. Getting Started/1. Course Introduction.mp414.25 MB
- 01. Getting Started/1. Course Introduction.vtt2.52 KB
- 01. Getting Started/2. Course Structure & Outline.mp43.23 MB
- 01. Getting Started/2. Course Structure & Outline.vtt3.16 KB
- 01. Getting Started/3. READ ME Important Notes for New Students.html4.83 KB
- 01. Getting Started/4. Advanced SQL Querying.pdf19.29 MB
- 01. Getting Started/4. Advanced SQL Querying.zip4.06 MB
- 01. Getting Started/4. DOWNLOAD Course Resources.html548 B
- 01. Getting Started/5. PREVIEW Final Project.mp45.66 MB
- 01. Getting Started/5. PREVIEW Final Project.vtt1.69 KB
- 01. Getting Started/6. Setting Expectations.mp418.26 MB
- 01. Getting Started/6. Setting Expectations.vtt4.15 KB
- 02. Installation & Setup/1. Installation & Setup.mp45.61 MB
- 02. Installation & Setup/1. Installation & Setup.vtt1.88 KB
- 02. Installation & Setup/10. DEMO Loading Data in Other RDBMSs.mp433.68 MB
- 02. Installation & Setup/10. DEMO Loading Data in Other RDBMSs.vtt5.87 KB
- 02. Installation & Setup/2. Where to Write SQL Code.mp433.48 MB
- 02. Installation & Setup/2. Where to Write SQL Code.vtt9.36 KB
- 02. Installation & Setup/3. Installing MySQL (Mac).mp435.06 MB
- 02. Installation & Setup/3. Installing MySQL (Mac).vtt6.19 KB
- 02. Installation & Setup/4. Installing MySQL Workbench (Mac).mp420.73 MB
- 02. Installation & Setup/4. Installing MySQL Workbench (Mac).vtt3.68 KB
- 02. Installation & Setup/5. Installing MySQL (PC).mp422.33 MB
- 02. Installation & Setup/5. Installing MySQL (PC).vtt5.45 KB
- 02. Installation & Setup/6. Installing MySQL Workbench (PC).mp411.93 MB
- 02. Installation & Setup/6. Installing MySQL Workbench (PC).vtt2.78 KB
- 02. Installation & Setup/7. Getting Started with MySQL Workbench.mp49.13 MB
- 02. Installation & Setup/7. Getting Started with MySQL Workbench.vtt2.43 KB
- 02. Installation & Setup/8. Loading Data for This Course.mp412.82 MB
- 02. Installation & Setup/8. Loading Data for This Course.vtt3.15 KB
- 02. Installation & Setup/9. DEMO Loading Data in MySQL.mp432.69 MB
- 02. Installation & Setup/9. DEMO Loading Data in MySQL.vtt5.65 KB
- 03. SQL Basics Review/1. Section Introduction.mp41.88 MB
- 03. SQL Basics Review/1. Section Introduction.vtt772 B
- 03. SQL Basics Review/2. The Big 6.mp49.93 MB
- 03. SQL Basics Review/2. The Big 6.vtt2.88 KB
- 03. SQL Basics Review/3. Common SQL Keywords.mp430.66 MB
- 03. SQL Basics Review/3. Common SQL Keywords.vtt8.38 KB
- 03. SQL Basics Review/4. DEMO SQL Basics Review.mp483.06 MB
- 03. SQL Basics Review/4. DEMO SQL Basics Review.vtt15.32 KB
- 03. SQL Basics Review/5.1 Prerequisite Skills.html25.03 KB
- 04. Multi-Table Analysis/1. Section Introduction.mp45.27 MB
- 04. Multi-Table Analysis/1. Section Introduction.vtt2.12 KB
- 04. Multi-Table Analysis/10. ASSIGNMENT Self Joins.mp44.10 MB
- 04. Multi-Table Analysis/10. ASSIGNMENT Self Joins.vtt1015 B
- 04. Multi-Table Analysis/11. SOLUTION Self Joins.mp440.36 MB
- 04. Multi-Table Analysis/11. SOLUTION Self Joins.vtt4.84 KB
- 04. Multi-Table Analysis/12. Cross Joins.mp438.51 MB
- 04. Multi-Table Analysis/12. Cross Joins.vtt7.38 KB
- 04. Multi-Table Analysis/13. UNION vs UNION ALL.mp447.89 MB
- 04. Multi-Table Analysis/13. UNION vs UNION ALL.vtt9.34 KB
- 04. Multi-Table Analysis/14. Key Takeaways.mp411.55 MB
- 04. Multi-Table Analysis/14. Key Takeaways.vtt3.16 KB
- 04. Multi-Table Analysis/15.2 Multi-Table Analysis.html21.02 KB
- 04. Multi-Table Analysis/2. Working with Multiple Tables.mp416.55 MB
- 04. Multi-Table Analysis/2. Working with Multiple Tables.vtt3.53 KB
- 04. Multi-Table Analysis/3. Basic Joins.mp462.70 MB
- 04. Multi-Table Analysis/3. Basic Joins.vtt10.89 KB
- 04. Multi-Table Analysis/4. Basic Join Types.mp456.67 MB
- 04. Multi-Table Analysis/4. Basic Join Types.vtt12.35 KB
- 04. Multi-Table Analysis/5. ASSIGNMENT Basic Joins.mp43.04 MB
- 04. Multi-Table Analysis/5. ASSIGNMENT Basic Joins.vtt984 B
- 04. Multi-Table Analysis/6. SOLUTION Basic Joins.mp453.45 MB
- 04. Multi-Table Analysis/6. SOLUTION Basic Joins.vtt9.13 KB
- 04. Multi-Table Analysis/7. Joining on Multiple Columns.mp437.26 MB
- 04. Multi-Table Analysis/7. Joining on Multiple Columns.vtt6.02 KB
- 04. Multi-Table Analysis/8. Joining Multiple Tables.mp456.94 MB
- 04. Multi-Table Analysis/8. Joining Multiple Tables.vtt8.96 KB
- 04. Multi-Table Analysis/9. Self Joins.mp484.16 MB
- 04. Multi-Table Analysis/9. Self Joins.vtt17.05 KB
- 05. Subqueries & CTEs/1. Section Introduction.mp43.40 MB
- 05. Subqueries & CTEs/1. Section Introduction.vtt1.17 KB
- 05. Subqueries & CTEs/10. Subqueries in the WHERE & HAVING Clauses.mp429.26 MB
- 05. Subqueries & CTEs/10. Subqueries in the WHERE & HAVING Clauses.vtt4.88 KB
- 05. Subqueries & CTEs/11. ANY vs ALL.mp436.77 MB
- 05. Subqueries & CTEs/11. ANY vs ALL.vtt6.29 KB
- 05. Subqueries & CTEs/12. EXISTS and Correlated Subqueries.mp458.42 MB
- 05. Subqueries & CTEs/12. EXISTS and Correlated Subqueries.vtt10.45 KB
- 05. Subqueries & CTEs/13. ASSIGNMENT Subqueries in the WHERE Clause.mp43.36 MB
- 05. Subqueries & CTEs/13. ASSIGNMENT Subqueries in the WHERE Clause.vtt893 B
- 05. Subqueries & CTEs/14. SOLUTION Subqueries in the WHERE Clause.mp421.45 MB
- 05. Subqueries & CTEs/14. SOLUTION Subqueries in the WHERE Clause.vtt3.53 KB
- 05. Subqueries & CTEs/15. Common Table Expressions.mp419.32 MB
- 05. Subqueries & CTEs/15. Common Table Expressions.vtt5.44 KB
- 05. Subqueries & CTEs/16. Subqueries vs CTEs.mp429.68 MB
- 05. Subqueries & CTEs/16. Subqueries vs CTEs.vtt5.02 KB
- 05. Subqueries & CTEs/17. Referencing a CTE Multiple Times.mp456.41 MB
- 05. Subqueries & CTEs/17. Referencing a CTE Multiple Times.vtt8.43 KB
- 05. Subqueries & CTEs/18. ASSIGNMENT CTEs.mp42.71 MB
- 05. Subqueries & CTEs/18. ASSIGNMENT CTEs.vtt827 B
- 05. Subqueries & CTEs/19. SOLUTION CTEs.mp446.98 MB
- 05. Subqueries & CTEs/19. SOLUTION CTEs.vtt6.91 KB
- 05. Subqueries & CTEs/2. Subquery Basics.mp414.03 MB
- 05. Subqueries & CTEs/2. Subquery Basics.vtt4.04 KB
- 05. Subqueries & CTEs/20. Multiple CTEs.mp457.51 MB
- 05. Subqueries & CTEs/20. Multiple CTEs.vtt9.57 KB
- 05. Subqueries & CTEs/21. ASSIGNMENT Multiple CTEs.mp42.72 MB
- 05. Subqueries & CTEs/21. ASSIGNMENT Multiple CTEs.vtt667 B
- 05. Subqueries & CTEs/22. SOLUTION Multiple CTEs.mp414.82 MB
- 05. Subqueries & CTEs/22. SOLUTION Multiple CTEs.vtt2.23 KB
- 05. Subqueries & CTEs/23. Recursive CTEs.mp443.41 MB
- 05. Subqueries & CTEs/23. Recursive CTEs.vtt12.55 KB
- 05. Subqueries & CTEs/24. Subqueries vs CTEs vs Temp Tables vs Views.mp456.11 MB
- 05. Subqueries & CTEs/24. Subqueries vs CTEs vs Temp Tables vs Views.vtt12.25 KB
- 05. Subqueries & CTEs/25. Key Takeaways.mp419.38 MB
- 05. Subqueries & CTEs/25. Key Takeaways.vtt5.14 KB
- 05. Subqueries & CTEs/26.3 Subqueries & CTEs.html20.80 KB
- 05. Subqueries & CTEs/3. Subqueries in the SELECT Clause.mp428.37 MB
- 05. Subqueries & CTEs/4. ASSIGNMENT Subqueries in the SELECT Clause.mp43.49 MB
- 05. Subqueries & CTEs/5. SOLUTION Subqueries in the SELECT Clause.mp429.92 MB
- 05. Subqueries & CTEs/5. SOLUTION Subqueries in the SELECT Clause.vtt4.08 KB
- 05. Subqueries & CTEs/6. Subqueries in the FROM Clause.mp452.24 MB
- 05. Subqueries & CTEs/6. Subqueries in the FROM Clause.vtt8.54 KB
- 05. Subqueries & CTEs/7. Multiple Subqueries.mp480.84 MB
- 05. Subqueries & CTEs/7. Multiple Subqueries.vtt13.22 KB
- 05. Subqueries & CTEs/8. ASSIGNMENT Subqueries in the FROM Clause.mp43.01 MB
- 05. Subqueries & CTEs/8. ASSIGNMENT Subqueries in the FROM Clause.vtt752 B
- 05. Subqueries & CTEs/9. SOLUTION Subqueries in the FROM Clause.mp431.42 MB
- 05. Subqueries & CTEs/9. SOLUTION Subqueries in the FROM Clause.vtt5.08 KB
- 06. Window Functions/1. Section Introduction.mp46.11 MB
- 06. Window Functions/1. Section Introduction.vtt1.96 KB
- 06. Window Functions/10. FIRST_VALUE, LAST_VALUE & NTH_VALUE.mp478.68 MB
- 06. Window Functions/10. FIRST_VALUE, LAST_VALUE & NTH_VALUE.vtt15.64 KB
- 06. Window Functions/11. ASSIGNMENT Value Within a Window.mp42.81 MB
- 06. Window Functions/11. ASSIGNMENT Value Within a Window.vtt709 B
- 06. Window Functions/12. SOLUTION Value Within a Window.mp429.54 MB
- 06. Window Functions/12. SOLUTION Value Within a Window.vtt3.46 KB
- 06. Window Functions/13. LEAD & LAG.mp451.65 MB
- 06. Window Functions/13. LEAD & LAG.vtt9.43 KB
- 06. Window Functions/14. ASSIGNMENT Value Relative to a Row.mp43.43 MB
- 06. Window Functions/14. ASSIGNMENT Value Relative to a Row.vtt923 B
- 06. Window Functions/15. SOLUTION Value Relative to a Row.mp479.28 MB
- 06. Window Functions/15. SOLUTION Value Relative to a Row.vtt10.89 KB
- 06. Window Functions/16. NTILE.mp463.20 MB
- 06. Window Functions/16. NTILE.vtt10.20 KB
- 06. Window Functions/17. ASSIGNMENT Statistical Functions.mp42.49 MB
- 06. Window Functions/17. ASSIGNMENT Statistical Functions.vtt668 B
- 06. Window Functions/18. SOLUTION Statistical Functions.mp456.70 MB
- 06. Window Functions/18. SOLUTION Statistical Functions.vtt8.29 KB
- 06. Window Functions/19. PREVIEW Moving Average Calculations.mp48.46 MB
- 06. Window Functions/19. PREVIEW Moving Average Calculations.vtt1.74 KB
- 06. Window Functions/2. Window Function Basics.mp415.20 MB
- 06. Window Functions/2. Window Function Basics.vtt3.66 KB
- 06. Window Functions/20. Key Takeaways.mp412.53 MB
- 06. Window Functions/20. Key Takeaways.vtt3.18 KB
- 06. Window Functions/21.4 Window Functions.html20.78 KB
- 06. Window Functions/3. Breaking Down a Window Function.mp463.87 MB
- 06. Window Functions/3. Breaking Down a Window Function.vtt13.30 KB
- 06. Window Functions/4. ASSIGNMENT Window Functions.mp44.05 MB
- 06. Window Functions/4. ASSIGNMENT Window Functions.vtt953 B
- 06. Window Functions/5. SOLUTION Window Functions.mp420.98 MB
- 06. Window Functions/5. SOLUTION Window Functions.vtt3.10 KB
- 06. Window Functions/6. Functions for Window Functions.mp46.68 MB
- 06. Window Functions/6. Functions for Window Functions.vtt2.14 KB
- 06. Window Functions/7. ROW_NUMBER, RANK & DENSE_RANK.mp429.25 MB
- 06. Window Functions/7. ROW_NUMBER, RANK & DENSE_RANK.vtt6.58 KB
- 06. Window Functions/8. ASSIGNMENT Row Numbering.mp43.44 MB
- 06. Window Functions/8. ASSIGNMENT Row Numbering.vtt912 B
- 06. Window Functions/9. SOLUTION Row Numbering.mp434.75 MB
- 06. Window Functions/9. SOLUTION Row Numbering.vtt4.42 KB
- 07. Functions By Data Type/1. Section Introduction.mp45.38 MB
- 07. Functions By Data Type/1. Section Introduction.vtt1.94 KB
- 07. Functions By Data Type/10. String Functions.mp449.88 MB
- 07. Functions By Data Type/10. String Functions.vtt8.05 KB
- 07. Functions By Data Type/11. ASSIGNMENT String Functions.mp42.97 MB
- 07. Functions By Data Type/11. ASSIGNMENT String Functions.vtt727 B
- 07. Functions By Data Type/12. SOLUTION String Functions.mp425.13 MB
- 07. Functions By Data Type/12. SOLUTION String Functions.vtt3.41 KB
- 07. Functions By Data Type/13. Pattern Matching.mp431.62 MB
- 07. Functions By Data Type/13. Pattern Matching.vtt7.10 KB
- 07. Functions By Data Type/14. DEMO Pattern Matching.mp473.23 MB
- 07. Functions By Data Type/14. DEMO Pattern Matching.vtt11.51 KB
- 07. Functions By Data Type/15. ASSIGNMENT Pattern Matching.mp42.93 MB
- 07. Functions By Data Type/15. ASSIGNMENT Pattern Matching.vtt830 B
- 07. Functions By Data Type/16. SOLUTION Pattern Matching.mp435.01 MB
- 07. Functions By Data Type/16. SOLUTION Pattern Matching.vtt5.34 KB
- 07. Functions By Data Type/17. NULL Functions.mp444.20 MB
- 07. Functions By Data Type/17. NULL Functions.vtt7.95 KB
- 07. Functions By Data Type/18. ASSIGNMENT NULL Functions.mp45.75 MB
- 07. Functions By Data Type/18. ASSIGNMENT NULL Functions.vtt1.31 KB
- 07. Functions By Data Type/19. SOLUTION NULL Functions.mp479.46 MB
- 07. Functions By Data Type/19. SOLUTION NULL Functions.vtt11.20 KB
- 07. Functions By Data Type/2. Function Basics.mp428.98 MB
- 07. Functions By Data Type/2. Function Basics.vtt7.08 KB
- 07. Functions By Data Type/20. Key Takeaways.mp49.79 MB
- 07. Functions By Data Type/20. Key Takeaways.vtt2.89 KB
- 07. Functions By Data Type/21.5 Functions By Data Type.html20.29 KB
- 07. Functions By Data Type/3. Numeric Functions.mp466.50 MB
- 07. Functions By Data Type/3. Numeric Functions.vtt12.54 KB
- 07. Functions By Data Type/4. CAST & CONVERT.mp444.72 MB
- 07. Functions By Data Type/4. CAST & CONVERT.vtt10.06 KB
- 07. Functions By Data Type/5. ASSIGNMENT Numeric Functions.mp42.63 MB
- 07. Functions By Data Type/5. ASSIGNMENT Numeric Functions.vtt776 B
- 07. Functions By Data Type/6. SOLUTION Numeric Functions.mp437.72 MB
- 07. Functions By Data Type/6. SOLUTION Numeric Functions.vtt5.51 KB
- 07. Functions By Data Type/7. DateTime Functions.mp478.13 MB
- 07. Functions By Data Type/7. DateTime Functions.vtt11.57 KB
- 07. Functions By Data Type/8. ASSIGNMENT DateTime Functions.mp43.66 MB
- 07. Functions By Data Type/8. ASSIGNMENT DateTime Functions.vtt850 B
- 07. Functions By Data Type/9. SOLUTION DateTime Functions.mp418.16 MB
- 07. Functions By Data Type/9. SOLUTION DateTime Functions.vtt2.19 KB
- 08. Data Analysis Applications/1. Section Introduction.mp48.73 MB
- 08. Data Analysis Applications/1. Section Introduction.vtt2.46 KB
- 08. Data Analysis Applications/10. SOLUTION Pivoting.mp450.64 MB
- 08. Data Analysis Applications/10. SOLUTION Pivoting.vtt7.45 KB
- 08. Data Analysis Applications/11. Rolling Calculations.mp420.92 MB
- 08. Data Analysis Applications/11. Rolling Calculations.vtt4.44 KB
- 08. Data Analysis Applications/12. DEMO Rolling Calculations.mp487.48 MB
- 08. Data Analysis Applications/12. DEMO Rolling Calculations.vtt14.18 KB
- 08. Data Analysis Applications/13. ASSIGNMENT Rolling Calculations.mp44.69 MB
- 08. Data Analysis Applications/13. ASSIGNMENT Rolling Calculations.vtt1.15 KB
- 08. Data Analysis Applications/14. SOLUTION Rolling Calculations.mp453.71 MB
- 08. Data Analysis Applications/14. SOLUTION Rolling Calculations.vtt7.54 KB
- 08. Data Analysis Applications/15. DEMO Imputing NULL Values.mp451.56 MB
- 08. Data Analysis Applications/15. DEMO Imputing NULL Values.vtt9.05 KB
- 08. Data Analysis Applications/16. Key Takeaways.mp411.98 MB
- 08. Data Analysis Applications/16. Key Takeaways.vtt3.22 KB
- 08. Data Analysis Applications/17.6 Data Analysis Applications.html20.63 KB
- 08. Data Analysis Applications/2. Duplicate Values.mp470.22 MB
- 08. Data Analysis Applications/2. Duplicate Values.vtt13.83 KB
- 08. Data Analysis Applications/3. ASSIGNMENT Duplicate Values.mp43.14 MB
- 08. Data Analysis Applications/3. ASSIGNMENT Duplicate Values.vtt781 B
- 08. Data Analysis Applications/4. SOLUTION Duplicate Values.mp425.52 MB
- 08. Data Analysis Applications/4. SOLUTION Duplicate Values.vtt3.32 KB
- 08. Data Analysis Applications/5. Min Max Value Filtering.mp461.67 MB
- 08. Data Analysis Applications/5. Min Max Value Filtering.vtt11.33 KB
- 08. Data Analysis Applications/6. ASSIGNMENT Min Max Value Filtering.mp42.17 MB
- 08. Data Analysis Applications/6. ASSIGNMENT Min Max Value Filtering.vtt564 B
- 08. Data Analysis Applications/7. SOLUTION Min Max Value Filtering.mp468.57 MB
- 08. Data Analysis Applications/7. SOLUTION Min Max Value Filtering.vtt10.14 KB
- 08. Data Analysis Applications/8. Pivoting.mp431.76 MB
- 08. Data Analysis Applications/8. Pivoting.vtt5.43 KB
- 08. Data Analysis Applications/9. ASSIGNMENT Pivoting.mp41.96 MB
- 08. Data Analysis Applications/9. ASSIGNMENT Pivoting.vtt646 B
- 09. Final Project/1. Final Project Overview.mp416.55 MB
- 09. Final Project/1. Final Project Overview.vtt2.84 KB
- 09. Final Project/2. ASSIGNMENT School Analysis.html793 B
- 09. Final Project/3. SOLUTION School Analysis.mp474.81 MB
- 09. Final Project/3. SOLUTION School Analysis.vtt10.61 KB
- 09. Final Project/4. ASSIGNMENT Salary Analysis.html790 B
- 09. Final Project/5. SOLUTION Salary Analysis.mp492.30 MB
- 09. Final Project/5. SOLUTION Salary Analysis.vtt13.89 KB
- 09. Final Project/6. ASSIGNMENT Player Career Analysis.html875 B
- 09. Final Project/7. SOLUTION Player Career Analysis.mp4108.83 MB
- 09. Final Project/7. SOLUTION Player Career Analysis.vtt14.05 KB
- 09. Final Project/8. ASSIGNMENT Player Comparison Analysis.html864 B
- 09. Final Project/9. SOLUTION Player Comparison Analysis.mp4133.87 MB
- 09. Final Project/9. SOLUTION Player Comparison Analysis.vtt18.63 KB
- 10. Next Steps/1. 2023-09-26_17-36-30-fe18b28990bd3345572d56124cd324bb.png116.98 KB
- 10. Next Steps/1. BONUS LESSON.html12.14 KB