Udemy - Access SQL Essentials for Excel Power Users

seeders: 0
leechers: 0
Added 4 months ago by freecoursewb in Other

Download Fast Safe Anonymous
movies, software, shows...

Files

Udemy - Access SQL Essentials for Excel Power Users (Size: 1.5 GB)
  Bonus Resources.txt 102.4 B
  Get Bonus Downloads Here.url 204.8 B
  ~Get Your Files Here !
  1 - Introduction
  1. Introduction.mp4 90.1 MB
  1. Pre Course Assessment (Description).html 716.8 B
  1. Pre Course Assessment.html 11.3 KB
  10 - Module 3 Practice Exercises
  11 - Module 3 Quiz GROUP BY & Aggregates
  10. Code Analysis Questions.html 6.6 KB
  12 - Course Wrap Up
  2 - Practice Database Setup Guide
  2. What's Included in the Practice Database.html 819.2 B
  3 - Module 1 SQL Basics
  10. WHERE Clause.mp4 145 MB
  11. ORDER BY.mp4 80.5 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 MB
  22. Common Questions on Aggregate Functions.html 1.1 KB
  23. Excel to SQL Translation.html 921.6 B
  24. GROUP BY Fundamentals.mp4 122 MB
  25. Common Questions on GROUP BY.html 1.2 KB
  26. Combining with WHERE.mp4 71 MB
  27. Common Questions on Combining with WHERE.html 1.4 KB
  28. Decision Tree WHERE v HAVING.html 1 KB
  29. Saving & Reusing Queries.mp4 61.7 MB
  30. Common Questions on Saving & Reusing Queries.html 1.3 KB
  8. The Mental Model.mp4 37.3 MB
  9. SELECT Statement.mp4 54.1 MB
  3. Access Excel accdb.bin 544 KB
  3. Exercise Files.html 409.6 B
  3. SalesData Practice Database xlsx.xlsx 32.6 KB
  4. Method 1 Import Excel Worksheets into Access (Description).html 716.8 B
  4. Method 1 Import Excel Worksheets into Access.html 1.9 KB
  5. Method 2 Link Excel File to Access (Description).html 716.8 B
  5. Method 2 Link Excel File to Access.html 1.5 KB
  6. Troubleshooting Common Issues.html 921.6 B
  7. You're Ready to Begin.html 716.8 B
  33. Wrap Up.mp4 7.1 MB
  34. SQL to Excel Translation Cheat Sheet (Description).html 716.8 B
  34. SQL to Excel Translation Cheat Sheet.html 512 B
  35. Comprehensive Glossary of Terms.html 15.1 KB
  36. [BONUS LECTURE].html 1.4 KB
  8. TRUE FALSE Questions.html 5.9 KB
  9. Multiple Choice Questions.html 7.8 KB
  31. Final Exercise Question.html 614.4 B
  32. Final Exercise Walkthrough.mp4 77.5 MB

Description


Access SQL Essentials for Excel Power Users

https://WebToolTip.com

Published 1/2026
Created by IsáBel .
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Intermediate | Genre: eLearning | Language: English | Duration: 36 Lectures ( 2h 21m ) | Size: 1.6 GB

Learn SQL Queries to Replace VLOOKUP, Filters, and PivotTables

What you'll learn
✓ Understand the Fundamental Difference Between Excel and SQL
✓ Write Fundamental SQL Queries to Extract and Filter Data
✓ Connect Related Data Using SQL JOINs
✓ Generate Summary Reports with GROUP BY and Aggregate Functions
✓ Save and Reuse SQL Queries for Automated Reporting

Requirements
● Microsoft Access 2016 or Later
● Comfortable with Excel formulas (VLOOKUP/XLOOKUP)
● Experience creating and using PivotTables
● Familiarity with Excel filters and data sorting

Related Torrents

torrent name size uploader age seed leech
0
0
0
0
3