Python SQL Intermediate

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.