SQL online classes - live, instructor led and certified
Please click here to chat with a certified trainer
SQL classes logo

SQL classes

 


 

 

 

SQL - Beginners

SQL class

Class Date  Days  Class Times    Cost  
December 4th - December 5th 2
9:00AM - 1:00PM PT    $695 Register
January 22nd - January 23rd 2
9:00AM - 1:00PM ET    $695 Register
February 20th - February 21st 2
9:00AM - 1:00PM PT    $695 Register
March 26th - March 27th 2
9:00AM - 1:00PM ET    $695 Register
April 17th - April 18th 2
9:00AM - 1:00PM PT    $695 Register
May 30th - May 31st 2
9:00AM - 1:00PM ET    $695 Register
June 18th - June 19th 2
9:00AM - 1:00PM PT    $695 Register
July 31st - August 1st 2
9:00AM - 1:00PM ET    $695 Register
August 20th - August 21st 2
9:00AM - 1:00PM PT    $695 Register
September 3rd - September 4th 2
9:00AM - 1:00PM ET    $695 Register
September 17th - September 18th 2
9:00AM - 1:00PM ET    $695 Register

SQL 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 beginner class
Course Details:


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
  •