Back to All Events

MODULE 3: Dating and Relationships.

Lecture followed by Workshop.

  • Joins in Queries
    1. Why are they needed
    2. Understanding the database structure
    3. Inner joins
    4. Outer joins
    5. Find unmatched records
    6. Full joins
  • Using Functions in Queries
    1. Finding available functions
    2. Understand parameters
    3. Getting help on functions
    4. Nesting functions
  • Working with Text in Queries
    1. Concatenating strings of text
    2. Concatenating text and numbers
    3. Text functions
    4. Separating strings of text
Earlier Event: December 6
MODULE 2: Chopping Up Data.
Later Event: December 20
MODULE 4: Group Therapy.