Day 1: Session 1 & 2

  • General overview
  • data types
  • and database normalization
  • SELECT statement elements
  • table joins
  • comparison predicates
  • Logical operators
  • date functions
  • string functions

Day 2: Session 3 & 4

  • Logical operators
  • date functions
  • string functions
  • NULLs
  • expressions
  • views
  • derived tables
  • temporary tables
  • Math functions
  • aggregates with advanced groupings
  • Working with database metadata
  • Working with cursors

Day 3: Session 5 & 6

  • Working with database metadata
  • Working with cursors
  • Windowing functions
  • functions
  • stored procedures
  • SQL query performance tuning