Resources

Lectures and Class Files

• Find course files and example programs in the CpS 301 GitHub Repository.
• Watch recordings of the class lectures on Panopto

Learning SQL

• Online SQL Reference
• SQL By Example book - especially chapters 2, 3, 4, and 7

Learning MySQL

• Dr. Schaub’s MySQL Videos
• YouTube: MySQL Workbench Demo Videos
• MySQL Workbench Manual
• MySQL Reference

Learning Microsoft Access

• Dr. Schaub’s Access Videos
• Sample Access Database (univdb.accdb)

Sample Databases

See the sample databases used in class.

For the MySQL versions:

• University Database
• Orders Database