Back to All Events

MODULE 4: Group Therapy.

  • The Breather 64 West 3rd Street New York, NY, 10012 United States (map)

MODULE 4: Group Therapy.

  • Working with Dates in Queries
    1. Formatting dates
    2. Creating custom date formats
    3. Calculating the difference between dates
    4. Calculating age in years accurately
  • Aggregate Functions
    1. What are aggregate functions
    2. Five most commonly used functions
    3. Cautions with data types and functions
  • Grouping Data
    1. The GROUP BY clause
    2. Adding grand totals
    3. Using criteria in grouping queries
    4. Grouping by multiple columns