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

正在检测能否在线播放…

大小: 3.8 GB
文件数: 250
分类: 视频
热度: 52
最近活跃: 2 天前

文件列表

01. Getting Started/1. Course Introduction.mp414.2 MB
01. Getting Started/1. Course Introduction.vtt2.5 KB
01. Getting Started/2. Course Structure & Outline.mp43.2 MB
01. Getting Started/2. Course Structure & Outline.vtt3.2 KB
01. Getting Started/3. READ ME Important Notes for New Students.html4.8 KB
01. Getting Started/4. Advanced SQL Querying.pdf19.3 MB
01. Getting Started/4. Advanced SQL Querying.zip4.1 MB
01. Getting Started/4. DOWNLOAD Course Resources.html548 B
01. Getting Started/5. PREVIEW Final Project.mp45.7 MB
01. Getting Started/5. PREVIEW Final Project.vtt1.7 KB
01. Getting Started/6. Setting Expectations.mp418.3 MB
01. Getting Started/6. Setting Expectations.vtt4.2 KB
02. Installation & Setup/1. Installation & Setup.mp45.6 MB
02. Installation & Setup/1. Installation & Setup.vtt1.9 KB
02. Installation & Setup/10. DEMO Loading Data in Other RDBMSs.mp433.7 MB
02. Installation & Setup/10. DEMO Loading Data in Other RDBMSs.vtt5.9 KB
02. Installation & Setup/2. Where to Write SQL Code.mp433.5 MB
02. Installation & Setup/2. Where to Write SQL Code.vtt9.4 KB
02. Installation & Setup/3. Installing MySQL (Mac).mp435.1 MB
02. Installation & Setup/3. Installing MySQL (Mac).vtt6.2 KB
02. Installation & Setup/4. Installing MySQL Workbench (Mac).mp420.7 MB
02. Installation & Setup/4. Installing MySQL Workbench (Mac).vtt3.7 KB
02. Installation & Setup/5. Installing MySQL (PC).mp422.3 MB
02. Installation & Setup/5. Installing MySQL (PC).vtt5.4 KB
02. Installation & Setup/6. Installing MySQL Workbench (PC).mp411.9 MB
02. Installation & Setup/6. Installing MySQL Workbench (PC).vtt2.8 KB
02. Installation & Setup/7. Getting Started with MySQL Workbench.mp49.1 MB
02. Installation & Setup/7. Getting Started with MySQL Workbench.vtt2.4 KB
02. Installation & Setup/8. Loading Data for This Course.mp412.8 MB
02. Installation & Setup/8. Loading Data for This Course.vtt3.2 KB
02. Installation & Setup/9. DEMO Loading Data in MySQL.mp432.7 MB
02. Installation & Setup/9. DEMO Loading Data in MySQL.vtt5.6 KB
03. SQL Basics Review/1. Section Introduction.mp41.9 MB
03. SQL Basics Review/1. Section Introduction.vtt772 B
03. SQL Basics Review/2. The Big 6.mp49.9 MB
03. SQL Basics Review/2. The Big 6.vtt2.9 KB
03. SQL Basics Review/3. Common SQL Keywords.mp430.7 MB
03. SQL Basics Review/3. Common SQL Keywords.vtt8.4 KB
03. SQL Basics Review/4. DEMO SQL Basics Review.mp483.1 MB
03. SQL Basics Review/4. DEMO SQL Basics Review.vtt15.3 KB
03. SQL Basics Review/5.1 Prerequisite Skills.html25.0 KB
04. Multi-Table Analysis/1. Section Introduction.mp45.3 MB
04. Multi-Table Analysis/1. Section Introduction.vtt2.1 KB
04. Multi-Table Analysis/10. ASSIGNMENT Self Joins.mp44.1 MB
04. Multi-Table Analysis/10. ASSIGNMENT Self Joins.vtt1015 B
04. Multi-Table Analysis/11. SOLUTION Self Joins.mp440.4 MB
04. Multi-Table Analysis/11. SOLUTION Self Joins.vtt4.8 KB
04. Multi-Table Analysis/12. Cross Joins.mp438.5 MB
04. Multi-Table Analysis/12. Cross Joins.vtt7.4 KB
04. Multi-Table Analysis/13. UNION vs UNION ALL.mp447.9 MB
04. Multi-Table Analysis/13. UNION vs UNION ALL.vtt9.3 KB
04. Multi-Table Analysis/14. Key Takeaways.mp411.6 MB
04. Multi-Table Analysis/14. Key Takeaways.vtt3.2 KB
04. Multi-Table Analysis/15.2 Multi-Table Analysis.html21.0 KB
04. Multi-Table Analysis/2. Working with Multiple Tables.mp416.6 MB
04. Multi-Table Analysis/2. Working with Multiple Tables.vtt3.5 KB
04. Multi-Table Analysis/3. Basic Joins.mp462.7 MB
04. Multi-Table Analysis/3. Basic Joins.vtt10.9 KB
04. Multi-Table Analysis/4. Basic Join Types.mp456.7 MB
04. Multi-Table Analysis/4. Basic Join Types.vtt12.4 KB
04. Multi-Table Analysis/5. ASSIGNMENT Basic Joins.mp43.0 MB
04. Multi-Table Analysis/5. ASSIGNMENT Basic Joins.vtt984 B
04. Multi-Table Analysis/6. SOLUTION Basic Joins.mp453.5 MB
04. Multi-Table Analysis/6. SOLUTION Basic Joins.vtt9.1 KB
04. Multi-Table Analysis/7. Joining on Multiple Columns.mp437.3 MB
04. Multi-Table Analysis/7. Joining on Multiple Columns.vtt6.0 KB
04. Multi-Table Analysis/8. Joining Multiple Tables.mp456.9 MB
04. Multi-Table Analysis/8. Joining Multiple Tables.vtt9.0 KB
04. Multi-Table Analysis/9. Self Joins.mp484.2 MB
04. Multi-Table Analysis/9. Self Joins.vtt17.1 KB
05. Subqueries & CTEs/1. Section Introduction.mp43.4 MB
05. Subqueries & CTEs/1. Section Introduction.vtt1.2 KB
05. Subqueries & CTEs/10. Subqueries in the WHERE & HAVING Clauses.mp429.3 MB
05. Subqueries & CTEs/10. Subqueries in the WHERE & HAVING Clauses.vtt4.9 KB
05. Subqueries & CTEs/11. ANY vs ALL.mp436.8 MB
05. Subqueries & CTEs/11. ANY vs ALL.vtt6.3 KB
05. Subqueries & CTEs/12. EXISTS and Correlated Subqueries.mp458.4 MB
05. Subqueries & CTEs/12. EXISTS and Correlated Subqueries.vtt10.4 KB
05. Subqueries & CTEs/13. ASSIGNMENT Subqueries in the WHERE Clause.mp43.4 MB
05. Subqueries & CTEs/13. ASSIGNMENT Subqueries in the WHERE Clause.vtt893 B
05. Subqueries & CTEs/14. SOLUTION Subqueries in the WHERE Clause.mp421.5 MB
05. Subqueries & CTEs/14. SOLUTION Subqueries in the WHERE Clause.vtt3.5 KB
05. Subqueries & CTEs/15. Common Table Expressions.mp419.3 MB
05. Subqueries & CTEs/15. Common Table Expressions.vtt5.4 KB
05. Subqueries & CTEs/16. Subqueries vs CTEs.mp429.7 MB
05. Subqueries & CTEs/16. Subqueries vs CTEs.vtt5.0 KB
05. Subqueries & CTEs/17. Referencing a CTE Multiple Times.mp456.4 MB
05. Subqueries & CTEs/17. Referencing a CTE Multiple Times.vtt8.4 KB
05. Subqueries & CTEs/18. ASSIGNMENT CTEs.mp42.7 MB
05. Subqueries & CTEs/18. ASSIGNMENT CTEs.vtt827 B
05. Subqueries & CTEs/19. SOLUTION CTEs.mp447.0 MB
05. Subqueries & CTEs/19. SOLUTION CTEs.vtt6.9 KB
05. Subqueries & CTEs/2. Subquery Basics.mp414.0 MB
05. Subqueries & CTEs/2. Subquery Basics.vtt4.0 KB
05. Subqueries & CTEs/20. Multiple CTEs.mp457.5 MB
05. Subqueries & CTEs/20. Multiple CTEs.vtt9.6 KB
05. Subqueries & CTEs/21. ASSIGNMENT Multiple CTEs.mp42.7 MB
05. Subqueries & CTEs/21. ASSIGNMENT Multiple CTEs.vtt667 B
05. Subqueries & CTEs/22. SOLUTION Multiple CTEs.mp414.8 MB
05. Subqueries & CTEs/22. SOLUTION Multiple CTEs.vtt2.2 KB
05. Subqueries & CTEs/23. Recursive CTEs.mp443.4 MB
05. Subqueries & CTEs/23. Recursive CTEs.vtt12.6 KB
05. Subqueries & CTEs/24. Subqueries vs CTEs vs Temp Tables vs Views.mp456.1 MB
05. Subqueries & CTEs/24. Subqueries vs CTEs vs Temp Tables vs Views.vtt12.2 KB
05. Subqueries & CTEs/25. Key Takeaways.mp419.4 MB
05. Subqueries & CTEs/25. Key Takeaways.vtt5.1 KB
05. Subqueries & CTEs/26.3 Subqueries & CTEs.html20.8 KB
05. Subqueries & CTEs/3. Subqueries in the SELECT Clause.mp428.4 MB
05. Subqueries & CTEs/4. ASSIGNMENT Subqueries in the SELECT Clause.mp43.5 MB
05. Subqueries & CTEs/5. SOLUTION Subqueries in the SELECT Clause.mp429.9 MB
05. Subqueries & CTEs/5. SOLUTION Subqueries in the SELECT Clause.vtt4.1 KB
05. Subqueries & CTEs/6. Subqueries in the FROM Clause.mp452.2 MB
05. Subqueries & CTEs/6. Subqueries in the FROM Clause.vtt8.5 KB
05. Subqueries & CTEs/7. Multiple Subqueries.mp480.8 MB
05. Subqueries & CTEs/7. Multiple Subqueries.vtt13.2 KB
05. Subqueries & CTEs/8. ASSIGNMENT Subqueries in the FROM Clause.mp43.0 MB
05. Subqueries & CTEs/8. ASSIGNMENT Subqueries in the FROM Clause.vtt752 B
05. Subqueries & CTEs/9. SOLUTION Subqueries in the FROM Clause.mp431.4 MB
05. Subqueries & CTEs/9. SOLUTION Subqueries in the FROM Clause.vtt5.1 KB
06. Window Functions/1. Section Introduction.mp46.1 MB
06. Window Functions/1. Section Introduction.vtt2.0 KB
06. Window Functions/10. FIRST_VALUE, LAST_VALUE & NTH_VALUE.mp478.7 MB
06. Window Functions/10. FIRST_VALUE, LAST_VALUE & NTH_VALUE.vtt15.6 KB
06. Window Functions/11. ASSIGNMENT Value Within a Window.mp42.8 MB
06. Window Functions/11. ASSIGNMENT Value Within a Window.vtt709 B
06. Window Functions/12. SOLUTION Value Within a Window.mp429.5 MB
06. Window Functions/12. SOLUTION Value Within a Window.vtt3.5 KB
06. Window Functions/13. LEAD & LAG.mp451.6 MB
06. Window Functions/13. LEAD & LAG.vtt9.4 KB
06. Window Functions/14. ASSIGNMENT Value Relative to a Row.mp43.4 MB
06. Window Functions/14. ASSIGNMENT Value Relative to a Row.vtt923 B
06. Window Functions/15. SOLUTION Value Relative to a Row.mp479.3 MB
06. Window Functions/15. SOLUTION Value Relative to a Row.vtt10.9 KB
06. Window Functions/16. NTILE.mp463.2 MB
06. Window Functions/16. NTILE.vtt10.2 KB
06. Window Functions/17. ASSIGNMENT Statistical Functions.mp42.5 MB
06. Window Functions/17. ASSIGNMENT Statistical Functions.vtt668 B
06. Window Functions/18. SOLUTION Statistical Functions.mp456.7 MB
06. Window Functions/18. SOLUTION Statistical Functions.vtt8.3 KB
06. Window Functions/19. PREVIEW Moving Average Calculations.mp48.5 MB
06. Window Functions/19. PREVIEW Moving Average Calculations.vtt1.7 KB
06. Window Functions/2. Window Function Basics.mp415.2 MB
06. Window Functions/2. Window Function Basics.vtt3.7 KB
06. Window Functions/20. Key Takeaways.mp412.5 MB
06. Window Functions/20. Key Takeaways.vtt3.2 KB
06. Window Functions/21.4 Window Functions.html20.8 KB
06. Window Functions/3. Breaking Down a Window Function.mp463.9 MB
06. Window Functions/3. Breaking Down a Window Function.vtt13.3 KB
06. Window Functions/4. ASSIGNMENT Window Functions.mp44.0 MB
06. Window Functions/4. ASSIGNMENT Window Functions.vtt953 B
06. Window Functions/5. SOLUTION Window Functions.mp421.0 MB
06. Window Functions/5. SOLUTION Window Functions.vtt3.1 KB
06. Window Functions/6. Functions for Window Functions.mp46.7 MB
06. Window Functions/6. Functions for Window Functions.vtt2.1 KB
06. Window Functions/7. ROW_NUMBER, RANK & DENSE_RANK.mp429.2 MB
06. Window Functions/7. ROW_NUMBER, RANK & DENSE_RANK.vtt6.6 KB
06. Window Functions/8. ASSIGNMENT Row Numbering.mp43.4 MB
06. Window Functions/8. ASSIGNMENT Row Numbering.vtt912 B
06. Window Functions/9. SOLUTION Row Numbering.mp434.7 MB
06. Window Functions/9. SOLUTION Row Numbering.vtt4.4 KB
07. Functions By Data Type/1. Section Introduction.mp45.4 MB
07. Functions By Data Type/1. Section Introduction.vtt1.9 KB
07. Functions By Data Type/10. String Functions.mp449.9 MB
07. Functions By Data Type/10. String Functions.vtt8.1 KB
07. Functions By Data Type/11. ASSIGNMENT String Functions.mp43.0 MB
07. Functions By Data Type/11. ASSIGNMENT String Functions.vtt727 B
07. Functions By Data Type/12. SOLUTION String Functions.mp425.1 MB
07. Functions By Data Type/12. SOLUTION String Functions.vtt3.4 KB
07. Functions By Data Type/13. Pattern Matching.mp431.6 MB
07. Functions By Data Type/13. Pattern Matching.vtt7.1 KB
07. Functions By Data Type/14. DEMO Pattern Matching.mp473.2 MB
07. Functions By Data Type/14. DEMO Pattern Matching.vtt11.5 KB
07. Functions By Data Type/15. ASSIGNMENT Pattern Matching.mp42.9 MB
07. Functions By Data Type/15. ASSIGNMENT Pattern Matching.vtt830 B
07. Functions By Data Type/16. SOLUTION Pattern Matching.mp435.0 MB
07. Functions By Data Type/16. SOLUTION Pattern Matching.vtt5.3 KB
07. Functions By Data Type/17. NULL Functions.mp444.2 MB
07. Functions By Data Type/17. NULL Functions.vtt8.0 KB
07. Functions By Data Type/18. ASSIGNMENT NULL Functions.mp45.8 MB
07. Functions By Data Type/18. ASSIGNMENT NULL Functions.vtt1.3 KB
07. Functions By Data Type/19. SOLUTION NULL Functions.mp479.5 MB
07. Functions By Data Type/19. SOLUTION NULL Functions.vtt11.2 KB
07. Functions By Data Type/2. Function Basics.mp429.0 MB
07. Functions By Data Type/2. Function Basics.vtt7.1 KB
07. Functions By Data Type/20. Key Takeaways.mp49.8 MB
07. Functions By Data Type/20. Key Takeaways.vtt2.9 KB
07. Functions By Data Type/21.5 Functions By Data Type.html20.3 KB
07. Functions By Data Type/3. Numeric Functions.mp466.5 MB
07. Functions By Data Type/3. Numeric Functions.vtt12.5 KB
07. Functions By Data Type/4. CAST & CONVERT.mp444.7 MB
07. Functions By Data Type/4. CAST & CONVERT.vtt10.1 KB
07. Functions By Data Type/5. ASSIGNMENT Numeric Functions.mp42.6 MB
07. Functions By Data Type/5. ASSIGNMENT Numeric Functions.vtt776 B
07. Functions By Data Type/6. SOLUTION Numeric Functions.mp437.7 MB
07. Functions By Data Type/6. SOLUTION Numeric Functions.vtt5.5 KB
07. Functions By Data Type/7. DateTime Functions.mp478.1 MB
07. Functions By Data Type/7. DateTime Functions.vtt11.6 KB
07. Functions By Data Type/8. ASSIGNMENT DateTime Functions.mp43.7 MB
07. Functions By Data Type/8. ASSIGNMENT DateTime Functions.vtt850 B
07. Functions By Data Type/9. SOLUTION DateTime Functions.mp418.2 MB
07. Functions By Data Type/9. SOLUTION DateTime Functions.vtt2.2 KB
08. Data Analysis Applications/1. Section Introduction.mp48.7 MB
08. Data Analysis Applications/1. Section Introduction.vtt2.5 KB
08. Data Analysis Applications/10. SOLUTION Pivoting.mp450.6 MB
08. Data Analysis Applications/10. SOLUTION Pivoting.vtt7.4 KB
08. Data Analysis Applications/11. Rolling Calculations.mp420.9 MB
08. Data Analysis Applications/11. Rolling Calculations.vtt4.4 KB
08. Data Analysis Applications/12. DEMO Rolling Calculations.mp487.5 MB
08. Data Analysis Applications/12. DEMO Rolling Calculations.vtt14.2 KB
08. Data Analysis Applications/13. ASSIGNMENT Rolling Calculations.mp44.7 MB
08. Data Analysis Applications/13. ASSIGNMENT Rolling Calculations.vtt1.1 KB
08. Data Analysis Applications/14. SOLUTION Rolling Calculations.mp453.7 MB
08. Data Analysis Applications/14. SOLUTION Rolling Calculations.vtt7.5 KB
08. Data Analysis Applications/15. DEMO Imputing NULL Values.mp451.6 MB
08. Data Analysis Applications/15. DEMO Imputing NULL Values.vtt9.1 KB
08. Data Analysis Applications/16. Key Takeaways.mp412.0 MB
08. Data Analysis Applications/16. Key Takeaways.vtt3.2 KB
08. Data Analysis Applications/17.6 Data Analysis Applications.html20.6 KB
08. Data Analysis Applications/2. Duplicate Values.mp470.2 MB
08. Data Analysis Applications/2. Duplicate Values.vtt13.8 KB
08. Data Analysis Applications/3. ASSIGNMENT Duplicate Values.mp43.1 MB
08. Data Analysis Applications/3. ASSIGNMENT Duplicate Values.vtt781 B
08. Data Analysis Applications/4. SOLUTION Duplicate Values.mp425.5 MB
08. Data Analysis Applications/4. SOLUTION Duplicate Values.vtt3.3 KB
08. Data Analysis Applications/5. Min Max Value Filtering.mp461.7 MB
08. Data Analysis Applications/5. Min Max Value Filtering.vtt11.3 KB
08. Data Analysis Applications/6. ASSIGNMENT Min Max Value Filtering.mp42.2 MB
08. Data Analysis Applications/6. ASSIGNMENT Min Max Value Filtering.vtt564 B
08. Data Analysis Applications/7. SOLUTION Min Max Value Filtering.mp468.6 MB
08. Data Analysis Applications/7. SOLUTION Min Max Value Filtering.vtt10.1 KB
08. Data Analysis Applications/8. Pivoting.mp431.8 MB
08. Data Analysis Applications/8. Pivoting.vtt5.4 KB
08. Data Analysis Applications/9. ASSIGNMENT Pivoting.mp42.0 MB
08. Data Analysis Applications/9. ASSIGNMENT Pivoting.vtt646 B
09. Final Project/1. Final Project Overview.mp416.5 MB
09. Final Project/1. Final Project Overview.vtt2.8 KB
09. Final Project/2. ASSIGNMENT School Analysis.html793 B
09. Final Project/3. SOLUTION School Analysis.mp474.8 MB
09. Final Project/3. SOLUTION School Analysis.vtt10.6 KB
09. Final Project/4. ASSIGNMENT Salary Analysis.html790 B
09. Final Project/5. SOLUTION Salary Analysis.mp492.3 MB
09. Final Project/5. SOLUTION Salary Analysis.vtt13.9 KB
09. Final Project/6. ASSIGNMENT Player Career Analysis.html875 B
09. Final Project/7. SOLUTION Player Career Analysis.mp4108.8 MB
09. Final Project/7. SOLUTION Player Career Analysis.vtt14.0 KB
09. Final Project/8. ASSIGNMENT Player Comparison Analysis.html864 B
09. Final Project/9. SOLUTION Player Comparison Analysis.mp4133.9 MB
09. Final Project/9. SOLUTION Player Comparison Analysis.vtt18.6 KB
10. Next Steps/1. 2023-09-26_17-36-30-fe18b28990bd3345572d56124cd324bb.png117.0 KB
10. Next Steps/1. BONUS LESSON.html12.1 KB

举报这个资源

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

播放列表

文件列表

相关资源