SQL Practice: Queries to Analytics
Progress from filtering and joins to analytical windows, time-series queries and recursive SQL, with focused database lessons and a data-export repository capstone.
- SELECT, WHERE, ORDER BY
- JOINs
- GROUP BY and aggregation
3 more topics
- Subqueries and CTEs
- Window functions
- Query optimization