Notes
Worksheets
- 3NF - PDF
- Accelerating SQL Queries - PDF
- B Plus Trees - PDF
- BCNF Decomposition - PDF
- ERD Basics - PDF
- Expressing Constraints Relational Algebra - PDF
- Expressing Constraints SQL - PDF
- Functional Dependencies and Keys - PDF
- Grouping and Sorting - PDF
- Intro SQL - PDF
- IO Model of Computation - PDF
- Join Algorithm - PDF
- Logging - PDF
- Logical Query Plans - PDF
- Physical Query Plans - PDF
- Projecting Functional Dependencies - PDF
- RAID Schemes - PDF
- Reading Keys from ERD - PDF
- Relational Operators - PDF
- Sub-Queries In SQL - PDF
- Transaction Isolation Levels - PDF
- Weak Entities and Sub-Classes - PDF
Quiz Assessments
Midterm Assessments
- Study Sheets
- Practice Midterms
- Practice Midterm Solutions
- Midterms