Skip to main content

Non-registered mode. Register to save your course progress.

By exploring the course, you are agreeing to our Terms of Service and Privacy Policy. Please read them carefully.

Textbook Readings and Other Materials

  • A First Course in Database Systems (3rd edition) by Ullman and Widom (U/W)
    (same material and sections as Database Systems: The Complete Book (2nd edition) by Garcia-Molina, Ullman, and Widom)
  • Database Management Systems (3rd edition) by Ramakrishnan and Gehrke (R/G)
  • Fundamentals of Database Systems (6th edition) by Elmasri and Navathe (E/N)
  • Database System Concepts (6th edition) by Silberschatz, Korth, and Sudarshan (S/K/S)

SQL

All SQL scripts use the same schema and data, and work in SQLite, MySQL, and Postgres except as noted. See our quick guide to SQL for installing and using these systems. All SQL demos use the Database Master interface.
Introduction to SQL
U/W
---
R/G
---
E/N
---
S/K/S
---
Basic SELECT statement
U/W
6.1
R/G
5.2
E/N
4.3
S/K/S
3.3
Table variables and set operators
U/W
6.2
R/G
5.3
E/N
4.3
S/K/S
3.4 - 3.5
Subqueries in WHERE clause
U/W
6.3
R/G
5.4
E/N
5.1.2 - 5.1.6
S/K/S
3.8
Subequeries in FROM and SELECT
U/W
6.3
R/G
5.4
E/N
5.1.2 - 5.1.6
S/K/S
3.8
The JOIN family of operators
U/W
5.2.7, 6.3.6-8
R/G
5.6.4
E/N
5.1.6
S/K/S
4.1
Aggregation
U/W
6.4.3 - 6.4.7
R/G
5.5
E/N
5.1.7 - 5.1.8
S/K/S
3.7
NULL values
U/W
6.1.6-7, 6.4.6
R/G
5.6
E/N
5.1.1 - 5.1.8
S/K/S
3.7
Data modification statements
U/W
6.5
R/G
3.1.1
E/N
4.4
S/K/S
3.9
Other Readings
In addition to the textbook material, there are many entire books specifically about getting started with SQL; try searching for SQL in Amazon for a representative selection.