This intermediate SQL workshop builds on foundational skills to deepen your ability to work with relational databases in Python. We focus on more advanced querying techniques essential for real-world data analysis. You’ll gain hands-on experience with multi-table operations, subqueries, and window functions. These are key tools for structuring powerful and efficient queries.
After completing SQL Intermediate, you will be able to:
- Combine data from multiple tables using different types of JOINs (INNER, LEFT, SELF).
- Understand the role of primary and foreign keys in establishing table relationships.
- Write and use subqueries to break down complex queries with multiple logical steps.
- Simplify complex queries using Common Table Expressions (CTEs).
- Transform data between row and column orientations with pivoting and unpivoting techniques.
- Apply window functions to perform calculations across specified sets of rows.