SQL classes logo

SQL classes

 


 

 

 

 

  • SQL Beginner Class 

Class Date  City Class Times    Cost  
April        
Apr 28 - Apr 29 Sacramento 9am - 4pm    $895 Register
May        
May 05 - May 06 Billings 9am - 4pm    $895 Register
May 05 - May 06 Kansas City 9am - 4pm    $895 Register
May 05 - May 06 Louisville 9am - 4pm    $895 Register
May 05 - May 06 Memphis 9am - 4pm    $895 Register
May 05 - May 06 Milwaukee 9am - 4pm    $895 Register
May 05 - May 06 Nashville 9am - 4pm    $895 Register
May 05 - May 06 Oklahoma City 9am - 4pm    $895 Register
May 05 - May 06 Omaha 9am - 4pm    $895 Register
May 05 - May 06 Orlando 9am - 4pm    $895 Register
May 05 - May 06 Philadelphia 9am - 4pm    $895 Register
May 05 - May 06 Phoenix 9am - 4pm    $895 Register
May 05 - May 06 Raleigh 9am - 4pm    $895 Register
May 05 - May 06 Salt Lake City 9am - 4pm    $895 Register
May 05 - May 06 San Antonio 9am - 4pm    $895 Register
May 05 - May 06 San Jose 9am - 4pm    $895 Register
May 05 - May 06 Sioux Falls 9am - 4pm    $895 Register
May 05 - May 06 St. Louis 9am - 4pm    $895 Register
May 05 - May 06 St. Paul 9am - 4pm    $895 Register
May 05 - May 06 Toronto 9am - 4pm    $895 Register
May 05 - May 06 Tucson 9am - 4pm    $895 Register
May 05 - May 06 Tulsa 9am - 4pm    $895 Register
May 05 - May 06 Washington 9am - 4pm    $895 Register
May 12 - May 13 Columbus 9am - 4pm    $895 Register
May 12 - May 13 Denver 9am - 4pm    $895 Register
May 12 - May 13 Detroit 9am - 4pm    $895 Register
May 12 - May 13 Hartford 9am - 4pm    $895 Register
May 12 - May 13 New York 9am - 4pm    $895 Register
May 12 - May 13 Portland 9am - 4pm    $895 Register
May 19 - May 20 Albuquerque 9am - 4pm    $895 Register
May 19 - May 20 Chicago 9am - 4pm    $895 Register
May 19 - May 20 Dallas 9am - 4pm    $895 Register
May 19 - May 20 Jacksonville 9am - 4pm    $895 Register
May 19 - May 20 Las Vegas 9am - 4pm    $895 Register
May 19 - May 20 Los Angeles 9am - 4pm    $895 Register
May 19 - May 20 Minneapolis 9am - 4pm    $895 Register
May 19 - May 20 San Diego 9am - 4pm    $895 Register
May 19 - May 20 San Francisco 9am - 4pm    $895 Register
May 27 - May 28 Arlington 9am - 4pm    $895 Register
May 27 - May 28 Atlanta 9am - 4pm    $895 Register
May 27 - May 28 Austin 9am - 4pm    $895 Register
May 27 - May 28 Boston 9am - 4pm    $895 Register
May 27 - May 28 Calgary 9am - 4pm    $895 Register
May 27 - May 28 Charlotte 9am - 4pm    $895 Register
May 27 - May 28 Cleveland 9am - 4pm    $895 Register
May 27 - May 28 Colorado Springs 9am - 4pm    $895 Register
May 27 - May 28 Houston 9am - 4pm    $895 Register
May 27 - May 28 Indianapolis 9am - 4pm    $895 Register
May 27 - May 28 Miami 9am - 4pm    $895 Register
May 27 - May 28 Seattle 9am - 4pm    $895 Register
May 27 - May 28 Virginia Beach 9am - 4pm    $895 Register
June        
Jun 30 - Jul 01 Columbus 9am - 4pm    $895 Register
Jun 30 - Jul 01 Detroit 9am - 4pm    $895 Register
Jun 30 - Jul 01 Hartford 9am - 4pm    $895 Register
Jun 30 - Jul 01 New York 9am - 4pm    $895 Register
Jun 30 - Jul 01 Omaha 9am - 4pm    $895 Register
Jun 30 - Jul 01 Orlando 9am - 4pm    $895 Register
Jun 30 - Jul 01 Philadelphia 9am - 4pm    $895 Register
Jun 30 - Jul 01 Phoenix 9am - 4pm    $895 Register
Jun 30 - Jul 01 Raleigh 9am - 4pm    $895 Register
Jun 30 - Jul 01 Sacramento 9am - 4pm    $895 Register
Jun 30 - Jul 01 Salt Lake City 9am - 4pm    $895 Register
Jun 30 - Jul 01 San Antonio 9am - 4pm    $895 Register
Jun 30 - Jul 01 San Jose 9am - 4pm    $895 Register
Jun 30 - Jul 01 St. Louis 9am - 4pm    $895 Register
Jun 30 - Jul 01 St. Paul 9am - 4pm    $895 Register
Jun 30 - Jul 01 Toronto 9am - 4pm    $895 Register
Jun 30 - Jul 01 Tucson 9am - 4pm    $895 Register
Jun 30 - Jul 01 Tulsa 9am - 4pm    $895 Register
Jun 30 - Jul 01 Washington 9am - 4pm    $895 Register

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