Use SQL to conduct advanced data querying, cleaning, and aggregation.
Introduction to SQL
• Navigate a relational database.
• Practice writing and executing SQL queries, including SELECT, FROM, WHERE, and DISTINCT SELECT.
• Work with logical and comparison operators in SQL.
Grouping in SQL
• Work with CASE to handle multiple conditions.
• Practice writing aggregate functions: MIN, MAX, SUM, AVG, and COUNT.
• Use advanced SQL commands such as GROUP BY and HAVING to group and filter data.
Combining Data With JOINs and UNIONs
• Combine data from multiple sources using INNER and LEFT JOINs.
• Compile data using UNION and UNION ALL.
• Compare use cases for JOINs and UNIONs.
Advanced JOINs and NULLs
• Practice the concepts and syntax of advanced JOINs such as EXCEPT, FULL, and OUTER.
• Handle NULLs in SQL
• Practice query optimization techniques.
Subqueries in SQL
• Construct subqueries for multi-step operations.
• Identify subquery use cases for various business scenarios.
• Practice common table expressions (CTEs) with SELECT statements.
Functions in SQL
• Apply string, math, and date functions in SQL to prepare and analyze data.
• Practice writing SQL queries with advanced functions to solve business problems.
Project: Apply what you’ve learned in SQL and present your process, findings, and challenges to the class, giving and receiving peer-to-peer feedback.