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

SQL classes

 


 

 

 

 

  • SQL Beginner Class 

Class Date  City Class Times    Cost  
August        
Aug 27 - Aug 28 Sacramento 9am - 4pm    $895 Register
Aug 30 - Aug 31 Omaha 9am - 4pm    $895 Register
Aug 30 - Aug 31 Orlando 9am - 4pm    $895 Register
Aug 30 - Aug 31 Philadelphia 9am - 4pm    $895 Register
Aug 30 - Aug 31 Phoenix 9am - 4pm    $895 Register
Aug 30 - Aug 31 Raleigh 9am - 4pm    $895 Register
Aug 30 - Aug 31 Salt Lake City 9am - 4pm    $895 Register
Aug 30 - Aug 31 San Antonio 9am - 4pm    $895 Register
Aug 30 - Aug 31 San Jose 9am - 4pm    $895 Register
Aug 30 - Aug 31 St. Louis 9am - 4pm    $895 Register
Aug 30 - Aug 31 St. Paul 9am - 4pm    $895 Register
Aug 30 - Aug 31 Toronto 9am - 4pm    $895 Register
Aug 30 - Aug 31 Tucson 9am - 4pm    $895 Register
Aug 30 - Aug 31 Tulsa 9am - 4pm    $895 Register
Aug 30 - Aug 31 Washington 9am - 4pm    $895 Register
September        
Sep 06 - Sep 07 Columbus 9am - 4pm    $895 Register
Sep 06 - Sep 07 Detroit 9am - 4pm    $895 Register
Sep 06 - Sep 07 Hartford 9am - 4pm    $895 Register
Sep 06 - Sep 07 New York 9am - 4pm    $895 Register
Sep 12 - Sep 13 Denver 9am - 4pm    $895 Register
Sep 12 - Sep 13 Portland 9am - 4pm    $895 Register
Sep 13 - Sep 14 Chicago 9am - 4pm    $895 Register
Sep 13 - Sep 14 Dallas 9am - 4pm    $895 Register
Sep 13 - Sep 14 Los Angeles 9am - 4pm    $895 Register
Sep 13 - Sep 14 Minneapolis 9am - 4pm    $895 Register
Sep 13 - Sep 14 San Diego 9am - 4pm    $895 Register
Sep 13 - Sep 14 San Francisco 9am - 4pm    $895 Register
Sep 18 - Sep 19 Albuquerque 9am - 4pm    $895 Register
Sep 18 - Sep 19 Las Vegas 9am - 4pm    $895 Register
Sep 19 - Sep 20 Arlington 9am - 4pm    $895 Register
Sep 19 - Sep 20 Atlanta 9am - 4pm    $895 Register
Sep 19 - Sep 20 Austin 9am - 4pm    $895 Register
Sep 19 - Sep 20 Jacksonville 9am - 4pm    $895 Register
Sep 19 - Sep 20 Miami 9am - 4pm    $895 Register
Sep 19 - Sep 20 Seattle 9am - 4pm    $895 Register
Sep 19 - Sep 20 Virginia Beach 9am - 4pm    $895 Register
Sep 20 - Sep 21 Boston 9am - 4pm    $895 Register
Sep 20 - Sep 21 Calgary 9am - 4pm    $895 Register
Sep 20 - Sep 21 Charlotte 9am - 4pm    $895 Register
Sep 20 - Sep 21 Cleveland 9am - 4pm    $895 Register
Sep 20 - Sep 21 Colorado Springs 9am - 4pm    $895 Register
Sep 20 - Sep 21 Houston 9am - 4pm    $895 Register
Sep 20 - Sep 21 Indianapolis 9am - 4pm    $895 Register
Sep 26 - Sep 27 Billings 9am - 4pm    $895 Register
Sep 26 - Sep 27 Kansas City 9am - 4pm    $895 Register
Sep 26 - Sep 27 Louisville 9am - 4pm    $895 Register
Sep 26 - Sep 27 Memphis 9am - 4pm    $895 Register
Sep 26 - Sep 27 Milwaukee 9am - 4pm    $895 Register
Sep 26 - Sep 27 Nashville 9am - 4pm    $895 Register
Sep 26 - Sep 27 Oklahoma City 9am - 4pm    $895 Register
Sep 26 - Sep 27 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
Oct 31 - Nov 01 Boston 9am - 4pm    $895 Register
Oct 31 - Nov 01 Calgary 9am - 4pm    $895 Register
Oct 31 - Nov 01 Charlotte 9am - 4pm    $895 Register
Oct 31 - Nov 01 Cleveland 9am - 4pm    $895 Register
Oct 31 - Nov 01 Colorado Springs 9am - 4pm    $895 Register
Oct 31 - Nov 01 Houston 9am - 4pm    $895 Register
Oct 31 - Nov 01 Indianapolis 9am - 4pm    $895 Register
Oct 31 - Nov 01 Omaha 9am - 4pm    $895 Register
Oct 31 - Nov 01 Orlando 9am - 4pm    $895 Register
Oct 31 - Nov 01 Philadelphia 9am - 4pm    $895 Register
Oct 31 - Nov 01 Phoenix 9am - 4pm    $895 Register
Oct 31 - Nov 01 Raleigh 9am - 4pm    $895 Register
Oct 31 - Nov 01 Salt Lake City 9am - 4pm    $895 Register
Oct 31 - Nov 01 San Antonio 9am - 4pm    $895 Register
Oct 31 - Nov 01 San Jose 9am - 4pm    $895 Register
Oct 31 - Nov 01 St. Louis 9am - 4pm    $895 Register
Oct 31 - Nov 01 St. Paul 9am - 4pm    $895 Register
Oct 31 - Nov 01 Toronto 9am - 4pm    $895 Register
Oct 31 - Nov 01 Tucson 9am - 4pm    $895 Register
Oct 31 - Nov 01 Tulsa 9am - 4pm    $895 Register
Oct 31 - Nov 01 Washington 9am - 4pm    $895 Register
November        
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 14 - Nov 15 Billings 9am - 4pm    $895 Register
Nov 14 - Nov 15 Kansas City 9am - 4pm    $895 Register
Nov 14 - Nov 15 Louisville 9am - 4pm    $895 Register
Nov 14 - Nov 15 Memphis 9am - 4pm    $895 Register
Nov 14 - Nov 15 Milwaukee 9am - 4pm    $895 Register
Nov 14 - Nov 15 Nashville 9am - 4pm    $895 Register
Nov 14 - Nov 15 Oklahoma City 9am - 4pm    $895 Register
Nov 14 - Nov 15 Sioux Falls 9am - 4pm    $895 Register
Nov 19 - Nov 20 Albuquerque 9am - 4pm    $895 Register
Nov 19 - Nov 20 Arlington 9am - 4pm    $895 Register
Nov 19 - Nov 20 Atlanta 9am - 4pm    $895 Register
Nov 19 - Nov 20 Austin 9am - 4pm    $895 Register
Nov 19 - Nov 20 Chicago 9am - 4pm    $895 Register
Nov 19 - Nov 20 Dallas 9am - 4pm    $895 Register
Nov 19 - Nov 20 Denver 9am - 4pm    $895 Register
Nov 19 - Nov 20 Las Vegas 9am - 4pm    $895 Register
Nov 19 - Nov 20 Los Angeles 9am - 4pm    $895 Register
Nov 19 - Nov 20 Miami 9am - 4pm    $895 Register
Nov 19 - Nov 20 Minneapolis 9am - 4pm    $895 Register
Nov 19 - Nov 20 Portland 9am - 4pm    $895 Register
Nov 19 - Nov 20 San Diego 9am - 4pm    $895 Register
Nov 19 - Nov 20 San Francisco 9am - 4pm    $895 Register
Nov 19 - Nov 20 Seattle 9am - 4pm    $895 Register
Nov 19 - Nov 20 Virginia Beach 9am - 4pm    $895 Register

Class Date  City Class Times    Cost  
 
Sep 18 - Sep 19 Albuquerque 9am - 4pm    $895 Register
Nov 19 - Nov 20 Albuquerque 9am - 4pm    $895 Register
 
Sep 19 - Sep 20 Arlington 9am - 4pm    $895 Register
Nov 19 - Nov 20 Arlington 9am - 4pm    $895 Register
 
Sep 19 - Sep 20 Atlanta 9am - 4pm    $895 Register
Nov 19 - Nov 20 Atlanta 9am - 4pm    $895 Register
 
Sep 19 - Sep 20 Austin 9am - 4pm    $895 Register
Nov 19 - Nov 20 Austin 9am - 4pm    $895 Register
 
Sep 26 - Sep 27 Billings 9am - 4pm    $895 Register
Nov 14 - Nov 15 Billings 9am - 4pm    $895 Register
 
Sep 20 - Sep 21 Boston 9am - 4pm    $895 Register
Oct 31 - Nov 01 Boston 9am - 4pm    $895 Register
 
Sep 20 - Sep 21 Calgary 9am - 4pm    $895 Register
Oct 31 - Nov 01 Calgary 9am - 4pm    $895 Register
 
Sep 20 - Sep 21 Charlotte 9am - 4pm    $895 Register
Oct 31 - Nov 01 Charlotte 9am - 4pm    $895 Register
 
Sep 13 - Sep 14 Chicago 9am - 4pm    $895 Register
Nov 19 - Nov 20 Chicago 9am - 4pm    $895 Register
 
Sep 20 - Sep 21 Cleveland 9am - 4pm    $895 Register
Oct 31 - Nov 01 Cleveland 9am - 4pm    $895 Register
 
Sep 20 - Sep 21 Colorado Springs 9am - 4pm    $895 Register
Oct 31 - Nov 01 Colorado Springs 9am - 4pm    $895 Register
 
Sep 06 - Sep 07 Columbus 9am - 4pm    $895 Register
Nov 07 - Nov 08 Columbus 9am - 4pm    $895 Register
 
Sep 13 - Sep 14 Dallas 9am - 4pm    $895 Register
Nov 19 - Nov 20 Dallas 9am - 4pm    $895 Register
 
Sep 12 - Sep 13 Denver 9am - 4pm    $895 Register
Nov 19 - Nov 20 Denver 9am - 4pm    $895 Register
 
Sep 06 - Sep 07 Detroit 9am - 4pm    $895 Register
Nov 07 - Nov 08 Detroit 9am - 4pm    $895 Register
 
Sep 06 - Sep 07 Hartford 9am - 4pm    $895 Register
Nov 07 - Nov 08 Hartford 9am - 4pm    $895 Register
 
Sep 20 - Sep 21 Houston 9am - 4pm    $895 Register
Oct 31 - Nov 01 Houston 9am - 4pm    $895 Register
 
Sep 20 - Sep 21 Indianapolis 9am - 4pm    $895 Register
Oct 31 - Nov 01 Indianapolis 9am - 4pm    $895 Register
 
Sep 19 - Sep 20 Jacksonville 9am - 4pm    $895 Register
Oct 30 - Oct 31 Jacksonville 9am - 4pm    $895 Register
 
Sep 26 - Sep 27 Kansas City 9am - 4pm    $895 Register
Nov 14 - Nov 15 Kansas City 9am - 4pm    $895 Register
 
Sep 18 - Sep 19 Las Vegas 9am - 4pm    $895 Register
Nov 19 - Nov 20 Las Vegas 9am - 4pm    $895 Register
 
Sep 13 - Sep 14 Los Angeles 9am - 4pm    $895 Register
Nov 19 - Nov 20 Los Angeles 9am - 4pm    $895 Register
 
Sep 26 - Sep 27 Louisville 9am - 4pm    $895 Register
Nov 14 - Nov 15 Louisville 9am - 4pm    $895 Register
 
Sep 26 - Sep 27 Memphis 9am - 4pm    $895 Register
Nov 14 - Nov 15 Memphis 9am - 4pm    $895 Register
 
Sep 19 - Sep 20 Miami 9am - 4pm    $895 Register
Nov 19 - Nov 20 Miami 9am - 4pm    $895 Register
 
Sep 26 - Sep 27 Milwaukee 9am - 4pm    $895 Register
Nov 14 - Nov 15 Milwaukee 9am - 4pm    $895 Register
 
Sep 13 - Sep 14 Minneapolis 9am - 4pm    $895 Register
Nov 19 - Nov 20 Minneapolis 9am - 4pm    $895 Register
 
Sep 26 - Sep 27 Nashville 9am - 4pm    $895 Register
Nov 14 - Nov 15 Nashville 9am - 4pm    $895 Register
 
Sep 06 - Sep 07 New York 9am - 4pm    $895 Register
Nov 07 - Nov 08 New York 9am - 4pm    $895 Register
 
Sep 26 - Sep 27 Oklahoma City 9am - 4pm    $895 Register
Nov 14 - Nov 15 Oklahoma City 9am - 4pm    $895 Register
 
Aug 30 - Aug 31 Omaha 9am - 4pm    $895 Register
Oct 31 - Nov 01 Omaha 9am - 4pm    $895 Register
 
Aug 30 - Aug 31 Orlando 9am - 4pm    $895 Register
Oct 31 - Nov 01 Orlando 9am - 4pm    $895 Register
 
Aug 30 - Aug 31 Philadelphia 9am - 4pm    $895 Register
Oct 31 - Nov 01 Philadelphia 9am - 4pm    $895 Register
 
Aug 30 - Aug 31 Phoenix 9am - 4pm    $895 Register
Oct 31 - Nov 01 Phoenix 9am - 4pm    $895 Register
 
Sep 12 - Sep 13 Portland 9am - 4pm    $895 Register
Nov 19 - Nov 20 Portland 9am - 4pm    $895 Register
 
Aug 30 - Aug 31 Raleigh 9am - 4pm    $895 Register
Oct 31 - Nov 01 Raleigh 9am - 4pm    $895 Register
 
Aug 27 - Aug 28 Sacramento 9am - 4pm    $895 Register
Oct 30 - Oct 31 Sacramento 9am - 4pm    $895 Register
 
Aug 30 - Aug 31 Salt Lake City 9am - 4pm    $895 Register
Oct 31 - Nov 01 Salt Lake City 9am - 4pm    $895 Register
 
Aug 30 - Aug 31 San Antonio 9am - 4pm    $895 Register
Oct 31 - Nov 01 San Antonio 9am - 4pm    $895 Register
 
Sep 13 - Sep 14 San Diego 9am - 4pm    $895 Register
Nov 19 - Nov 20 San Diego 9am - 4pm    $895 Register
 
Sep 13 - Sep 14 San Francisco 9am - 4pm    $895 Register
Nov 19 - Nov 20 San Francisco 9am - 4pm    $895 Register
 
Aug 30 - Aug 31 San Jose 9am - 4pm    $895 Register
Oct 31 - Nov 01 San Jose 9am - 4pm    $895 Register
 
Sep 19 - Sep 20 Seattle 9am - 4pm    $895 Register
Nov 19 - Nov 20 Seattle 9am - 4pm    $895 Register
 
Sep 26 - Sep 27 Sioux Falls 9am - 4pm    $895 Register
Nov 14 - Nov 15 Sioux Falls 9am - 4pm    $895 Register
 
Aug 30 - Aug 31 St. Louis 9am - 4pm    $895 Register
Oct 31 - Nov 01 St. Louis 9am - 4pm    $895 Register
 
Aug 30 - Aug 31 St. Paul 9am - 4pm    $895 Register
Oct 31 - Nov 01 St. Paul 9am - 4pm    $895 Register
 
Aug 30 - Aug 31 Toronto 9am - 4pm    $895 Register
Oct 31 - Nov 01 Toronto 9am - 4pm    $895 Register
 
Aug 30 - Aug 31 Tucson 9am - 4pm    $895 Register
Oct 31 - Nov 01 Tucson 9am - 4pm    $895 Register
 
Aug 30 - Aug 31 Tulsa 9am - 4pm    $895 Register
Oct 31 - Nov 01 Tulsa 9am - 4pm    $895 Register
 
Sep 19 - Sep 20 Virginia Beach 9am - 4pm    $895 Register
Nov 19 - Nov 20 Virginia Beach 9am - 4pm    $895 Register
 
Aug 30 - Aug 31 Washington 9am - 4pm    $895 Register
Oct 31 - Nov 01 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.