Back to All Events

MODULE 2: Chopping Up Data.

Lecture followed by Workshop.

  • The WHERE Clause
    1. Using number criteria
    2. Text Criteria & Wildcards
    3. Date Criteria
    4. Using AND and OR operators
  • Creating Calculated Columns
    1. Where to write calculations
    2. Sorting results in calculations
    3. Using calculations in criteria
    4. Data Types and cautionary tips
  • The CASE statement
    1. Why are they used
    2. Using CASE statements with numbers, text and dates
Earlier Event: November 29
MODULE 1: What the Hell is SQL?
Later Event: December 13
MODULE 3: Dating and Relationships.