Sample Agenda

INTRO

  • WHAT IS IT?
  • WHAT IS IT USED FOR?
  • WHAT WILL I NEED TO KNOW TO USE IT?
    • OVERVIEW OF ELITE TABLES
    • QUERY ANALYZER/DBACCESS

BASICS

  • CASE
  • FIELDS
  • SQL CHARACTERS
  • ELITE DATABASES
SELECT & FROM
  • WILDCARD USAGE
  • LIMITING FIELDS
  • COLUMN ALIASES
  • CONCATENATING COLUMNS
  • SAMPLES

WHERE PT. 1

  • LIMITS USING RELATIONAL OPERATORS
  • USE OF QUOTATIONS
  • USING DISTINCT
  • SAMPLES

WHERE PT. 2

  • COMPOUND CONDITIONS WITH AND, OR
  • SAMPLES

WHERE PT. 3

  • USING LOGICAL OPERATORS
  • SAMPLES

WHERE PT. 4

  • TABLES JOINS; THE INNER JOIN
  • IDENTIFYING JOINS IN ELITE
  • TABLES ALIASES
  • SAMPLES

AGGREGATES

  • COUNT & SUM
  • SAMPLES

GROUP BY

  • AGGREGATED AND NON-AGGREGATED COLUMNS
  • TOP N/ FIRST N/
  • SAMPLES

HAVING

  • LIMITES ON AGGREGATES
  • SAMPLES

ORDER BY

  • SORTING DATA
  • SAMPLES

ADVANCED SUBSTRING

  • SYNTAX
  • SAMPLES

SUBQUERIES

  • USAGE
  • WITH A COUNT OF RECORDS
  • EXISTS/NOT EXISTS
  • SAMPLES

WORKING WITH DATES

  • FORMATS
  • PARSING
  • CALCULATIONS

MORE AGGREGATES

  • MAX & MIN
  • SAMPLES

OTHER JOINS

  • INNER JOINS USING MORE THAN ONE RELATIONSHIP
  • COMPUTE/COMPUTE BY & WITH ROLLUP/WITH CUBE
  • SELF JOINS
  • OUTER JOINS
  • ISNULL & COLLASCE
  • SAMPLES

TEMPORARY TABLES

  • USAGE
  • WITH INSERT, UPDATE AND DELETE
  • SAMPLES

VARIABLES

  • USAGE
  • SAMPLES