Original PromptSQL Crash Course for Excel Users
Format: PDF workbook + Practice problem set + Cheat sheet
What's Included:
├─ Module 1: What is SQL? Why you need it (5 pages, visuals)
├─ Module 2: SELECT & WHERE (7 pages, with SQL screenshots)
├─ Module 3: JOIN (join the most important concept) (6 pages)
├─ Module 4: GROUP BY & Aggregations (5 pages)
├─ Module 5: Window Functions & CTEs (4 pages)
└─ Module 6: Real-world queries (finance, HR, ops) (3 pages), create a workbook
This learning resource explores the transition from traditional spreadsheet tools like Excel to SQL, a structured language for managing relational databases. It includes a module that emphasizes understanding the relational mindset, foundational SQL commands, and the syntax for querying data effectively. The workbook provides practical exercises that contrast Excel operations with SQL functionalities, showcasing how SQL can efficiently handle large datasets and complex queries. Students learn how to construct SELECT statements, filter data, and utilize various SQL commands while developing their ability to think relationally about data organization.