Chapter 2 - Intro to the Relational Model

Projection
Selection
Cross Product and Natural Join
Practice exercises

Chapter 3 - Intro to SQL

SQL Revision History Slides | Paper
Aggregate operaters
Arithmetic expressions
Division
Except
Exists clause
GROUP BY functionality
Nested queries
Nested queries with correlation
NULL values
Search queries with strings
SELECT DISTINCT
Set comparison operators
Unions
Where Not Exists

Chapter 4 - Intermediate SQL

Chapter 5 - Advanced SQL

Chapter 6 - Relational Algebra

Projection
Selection
Cross Product and Natural Join
Combining Operations
In Class Example

Chapter 7 - E/R Design

Aggregation
Entity vs attribute
ISA relationships
Participation and cardinality
Weak entity sets
Converting Entities
Converting Relationships
Converting Weak Entities
Ensuring Entity Integrity
Ensuring Referential Integrity
Creating a view at CSU
Updateable views

Chapter 8 - Database Design / Normalization

BCNF
Closure sets and Armstrong's Axioms
Decomposition into BCNF
Finding the candidate keys
Functional dependencies
Identifying Normal Formas
Lossless join and dependency preserving
Multivalued dependencies
Normal forms
Recognizing normal forms
Stanford Quizzes

Chapter 11 - Indexing and Hashing

Tree Indexing
Hashing
Extendible Hashing
Linear Hashing

Chapter 14 - Transaction Management

Serializable Schedules
Locking
Aborts

Chapter 15 - Concurrency Control

Concurrency Examples
Lock Manager
Validation protocols
Multiversion timestamp example

Chapter 18 - Recovery

Aries example - Analysis phase
Aries example - Redo phase
Aries example - Undo phase
Additional ARIES Examples
CLR records
Recovery