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