Please enable JavaScript to use CodeHS


Introduction to SQL

Units

Unit Description
Introduction to SQL: Students will be introduced to the fundamentals of SQL and relational databases. They will learn how to structure data into tables, write basic SELECT queries, and apply simple filters to retrieve relevant information.
SQL Part II: The SQL: Students will deepen their understanding of SQL by practicing advanced filtering, sorting, and data presentation techniques. They will explore the use of logical operators, compound conditions, and the ORDER BY and AS clauses. Additionally, students will learn how to join multiple tables to answer complex data questions and simulate real-world database scenarios.
SQL Functions: Students will learn how to perform data analysis using SQL’s built-in functions. They will use aggregate functions like COUNT and SUM, group data using GROUP BY, filter grouped results with HAVING, and limit result sets using LIMIT. These skills allow students to summarize and extract insights from larger datasets effectively.
Data Aggregation: Students will explore how to aggregate and analyze data using SQL. They will work with a new HousePoint table to calculate totals, ranks, and summaries across different groups using functions like SUM and clauses like GROUP BY, HAVING, and LIMIT. Students apply these tools to rich, real-world-inspired scenarios to draw meaningful insights from data.