SQL classes logo

SQL classes

 


 

 

 

 

  • SQL Beginner Class 

Class Date  City Class Times    Cost  
September        
Sep 16 - Sep 17 Albuquerque 9am - 4pm    $895 Register
Sep 16 - Sep 17 Chicago 9am - 4pm    $895 Register
Sep 16 - Sep 17 Dallas 9am - 4pm    $895 Register
Sep 16 - Sep 17 Denver 9am - 4pm    $895 Register
Sep 16 - Sep 17 Las Vegas 9am - 4pm    $895 Register
Sep 16 - Sep 17 Los Angeles 9am - 4pm    $895 Register
Sep 16 - Sep 17 Minneapolis 9am - 4pm    $895 Register
Sep 16 - Sep 17 Portland 9am - 4pm    $895 Register
Sep 16 - Sep 17 San Diego 9am - 4pm    $895 Register
Sep 16 - Sep 17 San Francisco 9am - 4pm    $895 Register
Sep 23 - Sep 24 Arlington 9am - 4pm    $895 Register
Sep 23 - Sep 24 Atlanta 9am - 4pm    $895 Register
Sep 23 - Sep 24 Austin 9am - 4pm    $895 Register
Sep 23 - Sep 24 Boston 9am - 4pm    $895 Register
Sep 23 - Sep 24 Calgary 9am - 4pm    $895 Register
Sep 23 - Sep 24 Charlotte 9am - 4pm    $895 Register
Sep 23 - Sep 24 Cleveland 9am - 4pm    $895 Register
Sep 23 - Sep 24 Colorado Springs 9am - 4pm    $895 Register
Sep 23 - Sep 24 Houston 9am - 4pm    $895 Register
Sep 23 - Sep 24 Indianapolis 9am - 4pm    $895 Register
Sep 23 - Sep 24 Jacksonville 9am - 4pm    $895 Register
Sep 23 - Sep 24 Miami 9am - 4pm    $895 Register
Sep 23 - Sep 24 Seattle 9am - 4pm    $895 Register
Sep 23 - Sep 24 Virginia Beach 9am - 4pm    $895 Register
Sep 30 - Oct 01 Billings 9am - 4pm    $895 Register
Sep 30 - Oct 01 Kansas City 9am - 4pm    $895 Register
Sep 30 - Oct 01 Louisville 9am - 4pm    $895 Register
Sep 30 - Oct 01 Memphis 9am - 4pm    $895 Register
Sep 30 - Oct 01 Milwaukee 9am - 4pm    $895 Register
Sep 30 - Oct 01 Nashville 9am - 4pm    $895 Register
Sep 30 - Oct 01 Oklahoma City 9am - 4pm    $895 Register
Sep 30 - Oct 01 Sioux Falls 9am - 4pm    $895 Register
October        
Oct 28 - Oct 29 Jacksonville 9am - 4pm    $895 Register
Oct 28 - Oct 29 Sacramento 9am - 4pm    $895 Register
November        
Nov 04 - Nov 05 Boston 9am - 4pm    $895 Register
Nov 04 - Nov 05 Calgary 9am - 4pm    $895 Register
Nov 04 - Nov 05 Charlotte 9am - 4pm    $895 Register
Nov 04 - Nov 05 Cleveland 9am - 4pm    $895 Register
Nov 04 - Nov 05 Colorado Springs 9am - 4pm    $895 Register
Nov 04 - Nov 05 Houston 9am - 4pm    $895 Register
Nov 04 - Nov 05 Indianapolis 9am - 4pm    $895 Register
Nov 04 - Nov 05 Omaha 9am - 4pm    $895 Register
Nov 04 - Nov 05 Orlando 9am - 4pm    $895 Register
Nov 04 - Nov 05 Philadelphia 9am - 4pm    $895 Register
Nov 04 - Nov 05 Phoenix 9am - 4pm    $895 Register
Nov 04 - Nov 05 Raleigh 9am - 4pm    $895 Register
Nov 04 - Nov 05 Salt Lake City 9am - 4pm    $895 Register
Nov 04 - Nov 05 San Antonio 9am - 4pm    $895 Register
Nov 04 - Nov 05 San Jose 9am - 4pm    $895 Register
Nov 04 - Nov 05 St. Louis 9am - 4pm    $895 Register
Nov 04 - Nov 05 St. Paul 9am - 4pm    $895 Register
Nov 04 - Nov 05 Toronto 9am - 4pm    $895 Register
Nov 04 - Nov 05 Tucson 9am - 4pm    $895 Register
Nov 04 - Nov 05 Tulsa 9am - 4pm    $895 Register
Nov 04 - Nov 05 Washington 9am - 4pm    $895 Register
Nov 06 - Nov 07 Columbus 9am - 4pm    $895 Register
Nov 06 - Nov 07 Detroit 9am - 4pm    $895 Register
Nov 06 - Nov 07 Hartford 9am - 4pm    $895 Register
Nov 06 - Nov 07 New York 9am - 4pm    $895 Register
Nov 18 - Nov 19 Albuquerque 9am - 4pm    $895 Register
Nov 18 - Nov 19 Arlington 9am - 4pm    $895 Register
Nov 18 - Nov 19 Atlanta 9am - 4pm    $895 Register
Nov 18 - Nov 19 Austin 9am - 4pm    $895 Register
Nov 18 - Nov 19 Billings 9am - 4pm    $895 Register
Nov 18 - Nov 19 Chicago 9am - 4pm    $895 Register
Nov 18 - Nov 19 Dallas 9am - 4pm    $895 Register
Nov 18 - Nov 19 Denver 9am - 4pm    $895 Register
Nov 18 - Nov 19 Kansas City 9am - 4pm    $895 Register
Nov 18 - Nov 19 Las Vegas 9am - 4pm    $895 Register
Nov 18 - Nov 19 Los Angeles 9am - 4pm    $895 Register
Nov 18 - Nov 19 Louisville 9am - 4pm    $895 Register
Nov 18 - Nov 19 Memphis 9am - 4pm    $895 Register
Nov 18 - Nov 19 Miami 9am - 4pm    $895 Register
Nov 18 - Nov 19 Milwaukee 9am - 4pm    $895 Register
Nov 18 - Nov 19 Minneapolis 9am - 4pm    $895 Register
Nov 18 - Nov 19 Nashville 9am - 4pm    $895 Register
Nov 18 - Nov 19 Oklahoma City 9am - 4pm    $895 Register
Nov 18 - Nov 19 Portland 9am - 4pm    $895 Register
Nov 18 - Nov 19 San Diego 9am - 4pm    $895 Register
Nov 18 - Nov 19 San Francisco 9am - 4pm    $895 Register
Nov 18 - Nov 19 Seattle 9am - 4pm    $895 Register
Nov 18 - Nov 19 Sioux Falls 9am - 4pm    $895 Register
Nov 18 - Nov 19 Virginia Beach 9am - 4pm    $895 Register
January        
Jan 06 - Jan 07 Billings 9am - 4pm    $895 Register
Jan 06 - Jan 07 Columbus 9am - 4pm    $895 Register
Jan 06 - Jan 07 Detroit 9am - 4pm    $895 Register
Jan 06 - Jan 07 Hartford 9am - 4pm    $895 Register
Jan 06 - Jan 07 Kansas City 9am - 4pm    $895 Register
Jan 06 - Jan 07 Louisville 9am - 4pm    $895 Register
Jan 06 - Jan 07 Memphis 9am - 4pm    $895 Register
Jan 06 - Jan 07 Milwaukee 9am - 4pm    $895 Register
Jan 06 - Jan 07 Nashville 9am - 4pm    $895 Register
Jan 06 - Jan 07 New York 9am - 4pm    $895 Register
Jan 06 - Jan 07 Oklahoma City 9am - 4pm    $895 Register
Jan 06 - Jan 07 Sacramento 9am - 4pm    $895 Register
Jan 06 - Jan 07 Salt Lake City 9am - 4pm    $895 Register
Jan 06 - Jan 07 Sioux Falls 9am - 4pm    $895 Register
Jan 06 - Jan 07 St. Louis 9am - 4pm    $895 Register
Jan 06 - Jan 07 St. Paul 9am - 4pm    $895 Register
Jan 06 - Jan 07 Toronto 9am - 4pm    $895 Register
Jan 06 - Jan 07 Tucson 9am - 4pm    $895 Register
Jan 06 - Jan 07 Tulsa 9am - 4pm    $895 Register
Jan 06 - Jan 07 Washington 9am - 4pm    $895 Register
Jan 13 - Jan 14 Omaha 9am - 4pm    $895 Register
Jan 13 - Jan 14 Orlando 9am - 4pm    $895 Register
Jan 13 - Jan 14 Philadelphia 9am - 4pm    $895 Register
Jan 13 - Jan 14 Phoenix 9am - 4pm    $895 Register
Jan 13 - Jan 14 Raleigh 9am - 4pm    $895 Register
Jan 13 - Jan 14 San Antonio 9am - 4pm    $895 Register
Jan 13 - Jan 14 San Jose 9am - 4pm    $895 Register
Jan 21 - Jan 22 Albuquerque 9am - 4pm    $895 Register
Jan 21 - Jan 22 Arlington 9am - 4pm    $895 Register
Jan 21 - Jan 22 Atlanta 9am - 4pm    $895 Register
Jan 21 - Jan 22 Austin 9am - 4pm    $895 Register
Jan 21 - Jan 22 Denver 9am - 4pm    $895 Register
Jan 21 - Jan 22 Las Vegas 9am - 4pm    $895 Register
Jan 21 - Jan 22 Miami 9am - 4pm    $895 Register
Jan 21 - Jan 22 Portland 9am - 4pm    $895 Register
Jan 21 - Jan 22 Seattle 9am - 4pm    $895 Register
Jan 21 - Jan 22 Virginia Beach 9am - 4pm    $895 Register
Jan 27 - Jan 28 Chicago 9am - 4pm    $895 Register
Jan 27 - Jan 28 Dallas 9am - 4pm    $895 Register
Jan 27 - Jan 28 Jacksonville 9am - 4pm    $895 Register
Jan 27 - Jan 28 Los Angeles 9am - 4pm    $895 Register
Jan 27 - Jan 28 Minneapolis 9am - 4pm    $895 Register
Jan 27 - Jan 28 San Diego 9am - 4pm    $895 Register
Jan 27 - Jan 28 San Francisco 9am - 4pm    $895 Register
February        
Feb 03 - Feb 04 Boston 9am - 4pm    $895 Register
Feb 03 - Feb 04 Calgary 9am - 4pm    $895 Register
Feb 03 - Feb 04 Charlotte 9am - 4pm    $895 Register
Feb 03 - Feb 04 Cleveland 9am - 4pm    $895 Register
Feb 03 - Feb 04 Colorado Springs 9am - 4pm    $895 Register
Feb 03 - Feb 04 Houston 9am - 4pm    $895 Register
Feb 03 - Feb 04 Indianapolis 9am - 4pm    $895 Register

Class Date  City Class Times    Cost  
 
Sep 16 - Sep 17 Albuquerque 9am - 4pm    $895 Register
Nov 18 - Nov 19 Albuquerque 9am - 4pm    $895 Register
Jan 21 - Jan 22 Albuquerque 9am - 4pm    $895 Register
 
Sep 23 - Sep 24 Arlington 9am - 4pm    $895 Register
Nov 18 - Nov 19 Arlington 9am - 4pm    $895 Register
Jan 21 - Jan 22 Arlington 9am - 4pm    $895 Register
 
Sep 23 - Sep 24 Atlanta 9am - 4pm    $895 Register
Nov 18 - Nov 19 Atlanta 9am - 4pm    $895 Register
Jan 21 - Jan 22 Atlanta 9am - 4pm    $895 Register
 
Sep 23 - Sep 24 Austin 9am - 4pm    $895 Register
Nov 18 - Nov 19 Austin 9am - 4pm    $895 Register
Jan 21 - Jan 22 Austin 9am - 4pm    $895 Register
 
Sep 30 - Oct 01 Billings 9am - 4pm    $895 Register
Nov 18 - Nov 19 Billings 9am - 4pm    $895 Register
Jan 06 - Jan 07 Billings 9am - 4pm    $895 Register
 
Sep 23 - Sep 24 Boston 9am - 4pm    $895 Register
Nov 04 - Nov 05 Boston 9am - 4pm    $895 Register
Feb 03 - Feb 04 Boston 9am - 4pm    $895 Register
 
Sep 23 - Sep 24 Calgary 9am - 4pm    $895 Register
Nov 04 - Nov 05 Calgary 9am - 4pm    $895 Register
Feb 03 - Feb 04 Calgary 9am - 4pm    $895 Register
 
Sep 23 - Sep 24 Charlotte 9am - 4pm    $895 Register
Nov 04 - Nov 05 Charlotte 9am - 4pm    $895 Register
Feb 03 - Feb 04 Charlotte 9am - 4pm    $895 Register
 
Sep 16 - Sep 17 Chicago 9am - 4pm    $895 Register
Nov 18 - Nov 19 Chicago 9am - 4pm    $895 Register
Jan 27 - Jan 28 Chicago 9am - 4pm    $895 Register
 
Sep 23 - Sep 24 Cleveland 9am - 4pm    $895 Register
Nov 04 - Nov 05 Cleveland 9am - 4pm    $895 Register
Feb 03 - Feb 04 Cleveland 9am - 4pm    $895 Register
 
Sep 23 - Sep 24 Colorado Springs 9am - 4pm    $895 Register
Nov 04 - Nov 05 Colorado Springs 9am - 4pm    $895 Register
Feb 03 - Feb 04 Colorado Springs 9am - 4pm    $895 Register
 
Nov 06 - Nov 07 Columbus 9am - 4pm    $895 Register
Jan 06 - Jan 07 Columbus 9am - 4pm    $895 Register
 
Sep 16 - Sep 17 Dallas 9am - 4pm    $895 Register
Nov 18 - Nov 19 Dallas 9am - 4pm    $895 Register
Jan 27 - Jan 28 Dallas 9am - 4pm    $895 Register
 
Sep 16 - Sep 17 Denver 9am - 4pm    $895 Register
Nov 18 - Nov 19 Denver 9am - 4pm    $895 Register
Jan 21 - Jan 22 Denver 9am - 4pm    $895 Register
 
Nov 06 - Nov 07 Detroit 9am - 4pm    $895 Register
Jan 06 - Jan 07 Detroit 9am - 4pm    $895 Register
 
Nov 06 - Nov 07 Hartford 9am - 4pm    $895 Register
Jan 06 - Jan 07 Hartford 9am - 4pm    $895 Register
 
Sep 23 - Sep 24 Houston 9am - 4pm    $895 Register
Nov 04 - Nov 05 Houston 9am - 4pm    $895 Register
Feb 03 - Feb 04 Houston 9am - 4pm    $895 Register
 
Sep 23 - Sep 24 Indianapolis 9am - 4pm    $895 Register
Nov 04 - Nov 05 Indianapolis 9am - 4pm    $895 Register
Feb 03 - Feb 04 Indianapolis 9am - 4pm    $895 Register
 
Sep 23 - Sep 24 Jacksonville 9am - 4pm    $895 Register
Oct 28 - Oct 29 Jacksonville 9am - 4pm    $895 Register
Jan 27 - Jan 28 Jacksonville 9am - 4pm    $895 Register
 
Sep 30 - Oct 01 Kansas City 9am - 4pm    $895 Register
Nov 18 - Nov 19 Kansas City 9am - 4pm    $895 Register
Jan 06 - Jan 07 Kansas City 9am - 4pm    $895 Register
 
Sep 16 - Sep 17 Las Vegas 9am - 4pm    $895 Register
Nov 18 - Nov 19 Las Vegas 9am - 4pm    $895 Register
Jan 21 - Jan 22 Las Vegas 9am - 4pm    $895 Register
 
Sep 16 - Sep 17 Los Angeles 9am - 4pm    $895 Register
Nov 18 - Nov 19 Los Angeles 9am - 4pm    $895 Register
Jan 27 - Jan 28 Los Angeles 9am - 4pm    $895 Register
 
Sep 30 - Oct 01 Louisville 9am - 4pm    $895 Register
Nov 18 - Nov 19 Louisville 9am - 4pm    $895 Register
Jan 06 - Jan 07 Louisville 9am - 4pm    $895 Register
 
Sep 30 - Oct 01 Memphis 9am - 4pm    $895 Register
Nov 18 - Nov 19 Memphis 9am - 4pm    $895 Register
Jan 06 - Jan 07 Memphis 9am - 4pm    $895 Register
 
Sep 23 - Sep 24 Miami 9am - 4pm    $895 Register
Nov 18 - Nov 19 Miami 9am - 4pm    $895 Register
Jan 21 - Jan 22 Miami 9am - 4pm    $895 Register
 
Sep 30 - Oct 01 Milwaukee 9am - 4pm    $895 Register
Nov 18 - Nov 19 Milwaukee 9am - 4pm    $895 Register
Jan 06 - Jan 07 Milwaukee 9am - 4pm    $895 Register
 
Sep 16 - Sep 17 Minneapolis 9am - 4pm    $895 Register
Nov 18 - Nov 19 Minneapolis 9am - 4pm    $895 Register
Jan 27 - Jan 28 Minneapolis 9am - 4pm    $895 Register
 
Sep 30 - Oct 01 Nashville 9am - 4pm    $895 Register
Nov 18 - Nov 19 Nashville 9am - 4pm    $895 Register
Jan 06 - Jan 07 Nashville 9am - 4pm    $895 Register
 
Nov 06 - Nov 07 New York 9am - 4pm    $895 Register
Jan 06 - Jan 07 New York 9am - 4pm    $895 Register
 
Sep 30 - Oct 01 Oklahoma City 9am - 4pm    $895 Register
Nov 18 - Nov 19 Oklahoma City 9am - 4pm    $895 Register
Jan 06 - Jan 07 Oklahoma City 9am - 4pm    $895 Register
 
Nov 04 - Nov 05 Omaha 9am - 4pm    $895 Register
Jan 13 - Jan 14 Omaha 9am - 4pm    $895 Register
 
Nov 04 - Nov 05 Orlando 9am - 4pm    $895 Register
Jan 13 - Jan 14 Orlando 9am - 4pm    $895 Register
 
Nov 04 - Nov 05 Philadelphia 9am - 4pm    $895 Register
Jan 13 - Jan 14 Philadelphia 9am - 4pm    $895 Register
 
Nov 04 - Nov 05 Phoenix 9am - 4pm    $895 Register
Jan 13 - Jan 14 Phoenix 9am - 4pm    $895 Register
 
Sep 16 - Sep 17 Portland 9am - 4pm    $895 Register
Nov 18 - Nov 19 Portland 9am - 4pm    $895 Register
Jan 21 - Jan 22 Portland 9am - 4pm    $895 Register
 
Nov 04 - Nov 05 Raleigh 9am - 4pm    $895 Register
Jan 13 - Jan 14 Raleigh 9am - 4pm    $895 Register
 
Oct 28 - Oct 29 Sacramento 9am - 4pm    $895 Register
Jan 06 - Jan 07 Sacramento 9am - 4pm    $895 Register
 
Nov 04 - Nov 05 Salt Lake City 9am - 4pm    $895 Register
Jan 06 - Jan 07 Salt Lake City 9am - 4pm    $895 Register
 
Nov 04 - Nov 05 San Antonio 9am - 4pm    $895 Register
Jan 13 - Jan 14 San Antonio 9am - 4pm    $895 Register
 
Sep 16 - Sep 17 San Diego 9am - 4pm    $895 Register
Nov 18 - Nov 19 San Diego 9am - 4pm    $895 Register
Jan 27 - Jan 28 San Diego 9am - 4pm    $895 Register
 
Sep 16 - Sep 17 San Francisco 9am - 4pm    $895 Register
Nov 18 - Nov 19 San Francisco 9am - 4pm    $895 Register
Jan 27 - Jan 28 San Francisco 9am - 4pm    $895 Register
 
Nov 04 - Nov 05 San Jose 9am - 4pm    $895 Register
Jan 13 - Jan 14 San Jose 9am - 4pm    $895 Register
 
Sep 23 - Sep 24 Seattle 9am - 4pm    $895 Register
Nov 18 - Nov 19 Seattle 9am - 4pm    $895 Register
Jan 21 - Jan 22 Seattle 9am - 4pm    $895 Register
 
Sep 30 - Oct 01 Sioux Falls 9am - 4pm    $895 Register
Nov 18 - Nov 19 Sioux Falls 9am - 4pm    $895 Register
Jan 06 - Jan 07 Sioux Falls 9am - 4pm    $895 Register
 
Nov 04 - Nov 05 St. Louis 9am - 4pm    $895 Register
Jan 06 - Jan 07 St. Louis 9am - 4pm    $895 Register
 
Nov 04 - Nov 05 St. Paul 9am - 4pm    $895 Register
Jan 06 - Jan 07 St. Paul 9am - 4pm    $895 Register
 
Nov 04 - Nov 05 Toronto 9am - 4pm    $895 Register
Jan 06 - Jan 07 Toronto 9am - 4pm    $895 Register
 
Nov 04 - Nov 05 Tucson 9am - 4pm    $895 Register
Jan 06 - Jan 07 Tucson 9am - 4pm    $895 Register
 
Nov 04 - Nov 05 Tulsa 9am - 4pm    $895 Register
Jan 06 - Jan 07 Tulsa 9am - 4pm    $895 Register
 
Sep 23 - Sep 24 Virginia Beach 9am - 4pm    $895 Register
Nov 18 - Nov 19 Virginia Beach 9am - 4pm    $895 Register
Jan 21 - Jan 22 Virginia Beach 9am - 4pm    $895 Register
 
Nov 04 - Nov 05 Washington 9am - 4pm    $895 Register
Jan 06 - Jan 07 Washington 9am - 4pm    $895 Register

SQL level 1 beginner class


Course Description:

SQL or Structured Query Language is a standard language used to communicate with almost any database including MySQL, Microsoft SQL Server, Microsoft Access and Oracle. This course will teach you all you need to know about SQL from basics to advanced joins.

SQL level 1 beginner class


Course Outline:

Introduction
  • What is SQL
  • Relational Databases
  • SQL and Standards
  • SQL Implementations
  • Client - Server
  • SQL Syntax

    • Select Statements
  • Overview of select
  • Selecting One Field
  • Selecting Multiple Fields
  • Using a Wild Card
  • Calculations

    • Filtering Results
  • Limiting rows
  • Exercise
  • Using WHERE
  • Using AND/OR and NOT
  • Using LIKE

    • Functions
  • String Functions
  • Numeric Functions
  • Date Functions
  • Aggregate (Group) Functions

    • Sorting and Grouping
  • Sorting Results
  • Grouping Results
  • Column Aliases
  • Filtering Using Having

    • Joins
  • Inner Joins
  • Self Joins
  • Outer Joins
  • Joining Multiple Tables

    • Sub Queries Create,Drop Delete and Alter

  • Create Database
  • Create Schema
  • Create TablData Types
  • Field Modifiers
  • Create Select
  • Create View
  • Drop Queries
  • Delete
    • ALTER TABLE
  • INSERT
  • INDEXES
  • Update Queries
  • Transactions
  • Database Design

    •  

    Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.