Learning path topics
-
Week 1: SQL Basics
The lesson is to be followed in class, and the game given as homework.
Time estimation: 5 hours
Learning Objectives
- Explain the difference between a table, a record, and a field.
- Explain the difference between a database and a database manager.
- Write a query to select all values...
-
Week 2: Advanced SQL
Today we introduce complex operations like Joins.
Time estimation: 3 hours
Learning Objectives
- Define aggregation and give examples of its use.
- Write queries that compute aggregated values.
- Trace the execution of a query that performs aggregation.
- Explain how missing data is... -
Week 3: SQL in other languages
Based on which language you’re teaching alongside SQL, you can choose one of the following lessons which have the same content for different programming languages.
Time estimation: 1 hour 30 minutes
Learning Objectives
- Write short programs that execute SQL queries.
- Trace the...