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

SQL classes
in Columbus

 


 


  • SQL Beginner Class 

Class Date  City Class Times    Cost  
May 10 - May 11 Columbus 9am - 4pm    $895 Register
Jul 05 - Jul 06 Columbus 9am - 4pm    $895 Register

SQL level 1 beginner class in Columbus

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 in Columbus

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 course. We may change or alter the course topics to meet the objectives of a particular course.

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