Textbook Readings and Other Materials
Note: Efforts have been made to provide links to legitimate resources online where available, or to where they can be purchased.
- 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.
**If the link to the Database Master redirects to a broken link, you can view the same Database Master contents as a PDF.