Introduction to SQL
- Level High School
- Contact Hours 20
- Timeframe Month
In this beginner-friendly course, students will explore the foundational concepts of SQL (Structured Query Language), the standard language used to manage and manipulate relational databases. No prior experience with SQL or databases is required, making this course an ideal starting point for anyone interested in data organization, analysis, or backend development.
To view the entire syllabus, click here or click to explore the full course.
|
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. |
Create and organize Assignments in any CodeHS course that you're teaching. You can even add custom assignments to pre-existing CodeHS courses.
Learn MoreDidn't find what you were looking for? Here are a few links that might be useful to you.
