Day 1: Session 1 & 2 Introduction and objectives; Introduction to relational database mgmt system SQL Examples Creating and Populating a Database Insert, Delete, Update Introduce the “sample database” SELECT statement Day 2: Session 3 & 4 SELECT statement cont’d Filtering Multi-Table Queries (Joins), Foreign keys, referential integrity Working with Sets Data Generation, Conversion, and Manipulation Day 3: Session 5 & 6 Grouping and Aggregates Subqueries Joins Revisited Conditional Logic Day 4: Session 7 & 8 Transactions, Locking strategies Indexes and Constraints Views, Security Metadata Page navigation ↑ SQL Programming (Basic) – Welcome ← SQL: Textbook SQL: Classmate Introductions →