Please click here to chat with a certified trainer
SQL classes logo

SQL classes

 


 

 

 

 

  • SQL Beginner Class 

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

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