Module: SQL

Introduction to Structured Query Language.

Learning Outcomes

Be proficient in SQL

You can write single block SQL queries.
You can compose SQL queries using set (and bag) operators.
You can write SQL queries with correlated subqueries.
You can write SQL aggregation queries involving GROUP BY and HAVING clauses.
You can translate a query in English to SQL.

Readings

Chapter 6: SQL

Introduction to SQL

60 pages

SQL

Basics of SQL queries

Lecture Notes

SQL (Part 2)

Nested Queries in SQL

Lecture Notes

SQL (Part 3)

Aggregation Queries in SQL

Lecture Notes

Experiential Learning

Exercise 6

Write basic SQL queries

Exercise 7

Write Nested SQL Queries

Exercise 8

Write Aggregation Queries in SQL

HW2: SQL

Write SQL Queries

Assignment 2