Udemy - Access SQL Essentials for Excel Power Users

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction
• 1. Introduction.mp4 (90.1 MB)
• 1. Pre Course Assessment (Description).html (0.7 KB)
• 1. Pre Course Assessment.html (11.3 KB)
10 - Module 3 Practice Exercises
• 31. Final Exercise Question.html (0.6 KB)
• 32. Final Exercise Walkthrough.mp4 (77.5 MB)
11 - Module 3 Quiz GROUP BY & Aggregates
• 10. Code Analysis Questions.html (6.6 KB)
• 8. TRUE FALSE Questions.html (5.9 KB)
• 9. Multiple Choice Questions.html (7.8 KB)
12 - Course Wrap Up
• 33. Wrap Up.mp4 (7.1 MB)
• 34. SQL to Excel Translation Cheat Sheet (Description).html (0.7 KB)
• 34. SQL to Excel Translation Cheat Sheet.html (0.5 KB)
• 35. Comprehensive Glossary of Terms.html (15.1 KB)
• 36. [BONUS LECTURE].html (1.4 KB)
2 - Practice Database Setup Guide
• 2. What's Included in the Practice Database.html (0.8 KB)
• 3. Access Excel accdb.bin (544.0 KB)
• 3. Exercise Files.html (0.4 KB)
• 3. SalesData Practice Database xlsx.xlsx (32.6 KB)
• 4. Method 1 Import Excel Worksheets into Access (Description).html (0.7 KB)
• 4. Method 1 Import Excel Worksheets into Access.html (1.9 KB)
• 5. Method 2 Link Excel File to Access (Description).html (0.7 KB)
• 5. Method 2 Link Excel File to Access.html (1.5 KB)
• 6. Troubleshooting Common Issues.html (0.9 KB)
• 7. You're Ready to Begin.html (0.7 KB)
3 - Module 1 SQL Basics
• 10. WHERE Clause.mp4 (145.0 MB)
• 11. ORDER BY.mp4 (80.5 MB)
• 8. The Mental Model.mp4 (37.3 MB)
• 9. SELECT Statement.mp4 (54.1 MB)
4 - Module 1 Practice Exercises
• 12. Exercise Questions.html (1.2 KB)
• 13. Exercise Walkthroughs.mp4 (140.7 MB)
5 - Module 1 Quiz SQL Basics
• 2. TRUE FALSE Questions.html (5.8 KB)
• 3. Multiple Choice Questions.html (7.9 KB)
• 4. Code Analysis Questions.html (6.4 KB)
6 - Module 2 Joins Made Simple
• 14. Why VLOOKUP Breaks.mp4 (142.5 MB)
• 15. INNER JOIN Explained.mp4 (130.9 MB)
• 16. Common Questions on INNER JOINs.html (1.2 KB)
• 17. LEFT JOIN Deep Dive.mp4 (102.1 MB)
• 18. Common Questions on LEFT JOINs.html (1.2 KB)
7 - Module 2 Practice Exercises
• 19. Exercise Questions.html (1.1 KB)
• 20. Exercise Walkthrough.mp4 (198.4 MB)
8 - Module 2 Quiz JOINs
• 5. TRUE FALSE Questions.html (5.9 KB)
• 6. Multiple Choice Questions.html (7.8 KB)
• 7. Code Analysis Questions.html (6.7 KB)
9 - Module 3 GROUP BY & Aggregates
• 21. Aggregate Functions.mp4 (88.0 MB)
• 22. Common Questions on Aggregate Functions.html (1.1 KB)
• 23. Excel to SQL Translation.html (0.9 KB)
• 24. GROUP BY Fundamentals.mp4 (122.0 MB)
• 25. Common Questions on GROUP BY.html (1.2 KB)
• 26. Combining with WHERE.mp4 (71.0 MB)
• 27. Common Questions on Combining with WHERE.html (1.4 KB)
• 28. Decision Tree WHERE v HAVING.html (1.0 KB)
• 29. Saving & Reusing Queries.mp4 (61.7 MB)
• 30. Common Questions on Saving & Reusing Queries.html (1.3 KB)
• Bonus Resources.txt (0.1 KB)