Handouts:
- Syllabus
- H01 – Day 1 Slides
- H02 – Relational Data Model Slides
- H03 – More Relational Data Model
- H04 – Relational Algebra Worksheet
- H05 – Relational Algebra Worksheet 2
- H06 – SQL
- H07 – Joins
- H08 – Employee Database
- H09 – Employee Database Queries Worksheet
- H10 – Back end Web Dev – Getting Started
- H11 – Express
Useful Links:
- Sample Midterm
- Docker
- DBMS History on Wikipedia
- The Relational Model
- Ch 8 of Foundations of Computer Science book by Aho and Ullman
- Relational Model on Wikipedia
- Relational Algebra on Wikipedia
- Jeffrey Ullman’s Relational Algebra Slide Deck
- Relational Databases
- MySQL
- MySQL Cheat Sheet
- (My)SQL Cheat Sheet
- Wikipedia MySQL Cheat Sheet
- Blog post for setting up a MySQL Server in Docker.
Database Books
- These are available through the SMU Libraries Website (May require you to log in with your SMU credentials)
- Churcher, C. Beginning Database Design: From Novice to Professional. APress, 2007.
- Allen, S. Beginning Relational Data Modeling. Apress, 2005.