CSE 344: Topics

1. Relational Model and Basic SQL

What is a "relation"? How can we use it to store data? How can we access the data stored in a relation?

• Lectures
  • Relational Model: Notes, Whiteboards.
  • SQL basics: Slides, Demo.
• Section: Slides, Demo.
• Homework 1.

2. Joins, NULL, and database design microcosm

How can we use more than one table in our queries? What happens if values are "missing"? When we want to store a list of items in a single cell, and James says not to, what should we do instead?

• Lectures
  • Inner Joins: Slides, Demo.
  • Outer Joins, NULL, and more about Joins: Slides, demo.
  • Designing tables to model collections: Whiteboards.
• Section: Slides, Demo, Worksheet, Worksheet solutions.
• Homework 2.

3. Aggregation and grouping

Aggregates let us to summarize columns across multiple rows into a single value. By default, an aggregate summarizes the entire results table, but with SQL GROUP BY, the results can be divided into groups and each group summarized separately.

• Lecture: Slides, Demo
• Section: Slides, Worksheet, Worksheet solutions.
• Homework 3.

4. Subqueries and Relational Algebra

• Lecture: Slides, Demo
• Section Slides, Worksheet, Worksheet solutions
• Homework 4.

5. Database design for applications

• Lecture: Slides, Demo