SQL Training: Onsite and Online

Whether you're looking for customized in-person SQL training for a private group or a public online SQL class you can join, Webucator has the solution for you.

SQL is used to store, manipulate and retrieve data from relational databases.

Webucator offers introductory and advanced SQL courses for individuals using SQL Server, Oracle and MySQL.

Filter and Sort

5-min Narrated Presentation on SQL

  • History of SQL
  • Purpose of SQL
  • SQL: Difficulty Level
  • SQL: The Good
  • SQL: The Future
  • SQL Syntax

History of SQL

  • SQL (Structured Query Language) was developed by IBM in the late 1970s for IBM's DB2 RDBMS
  • SQL became the language for relational database development
  • ANSI formalized SQL as a standard in 1986
  • SQL is vital to developing databases in major platforms such as Oracle, MySQL and Microsoft SQL Server

SQL Is Three Languages

  • SQL is actually three languages!
  • Data Definition Language (DDL) for the creation, alteration and dropping of database objects (e.g., tables)
  • Data Manipulation Language (DML) for querying and updating relational data
  • Data Control Language (DCL) for securing data

Sample Uses of SQL

  • Interactive through GUI interfaces such as Microsoft Access query grids
  • Embedded in GUI and console business applications
  • Embedded in Java EE and Microsoft .NET web applications

SQL Difficulty Level

  • SQL is a high-level data access language
  • SQL was designed to be written by end users and developers
  • SQL is not a programming language
  • Commonly used in programming courses

Learning SQL

  • SQL is relatively straightforward to learn
  • Design query grids such as offered by Microsoft Access expedite learning SQL
  • Excellent documentation is available from all major vendors such as MySQL: https://dev.mysql.com/doc/refman/5.7/en/
  • SQL lexicon consists of understandable commands such as SELECT, INSERT, UPDATE and DELETE

SQL: The Good

  • Relatively straightforward to learn
  • Cross-platform
  • Excellent documentation from major vendors (e.g., Oracle, IBM, Microsoft)
  • Well respected in the IT industry

SQL: The Bad

  • SQL is a computer language and may present challenges to students with no computer language background.

SQL: The Future

  • SQL has a bright future!
  • Both ANSI and ISO publish standards for SQL usage
  • Tremendous corporate investment in SQL-based applications
  • Full support by major vendors such as Oracle, Microsoft and IBM

Syntax

  • Syntax was originally established by IBM based on the company's PL/I programming language
  • The language keywords are not case sensitive although capitalization is standard practice
  • The syntax is based on easily-understandable verbs:
    • SELECT
    • INSERT
    • UPDATE
    • DELETE

Creating a Table

CREATE TABLE GardenTools
(
id			INT NOT NULL,
description	VARCHAR(1000),
price			NUMERIC (9,2))

Comments

--Single-line comments follow 2 hyphens

/*
This is a 
	multi-line comment.
*/

Strings

  • Fixed-length strings are defined as char:
    • Customer_name CHAR(25) DEFAULT 'BestCo Ltd.'
  • Varying-length strings are defined as varchar:
    • Address_line VARCHAR(100) DEFAULT '2017 Anywhere Lane'

Integer, Decimal, and Float Column Types

  • quantity_on_hand INT DEFAULT 0
  • item_price DECIMAL(9,2)
  • population_of_asia FLOAT

Date and Time Column Types

  • date_of_order DATE
  • time_of_order TIME

Selecting Data from a Table

  • SELECT * FROM GardenTools
  • SELECT id, description FROM GardenTools WHERE price > 9.99

Inserting a Row into a Table

  • INSERT INTO GardenTools VALUES (202, 'Large rake', 24.49)
  • INSERT INTO GardenTools (id, description) VALUES (219, 'Small rake')

Updating a Row in a Table

  • UPDATE GardenTools
  • SET price = 25.99
  • WHERE id = 202

Deleting a Row in a Table

  • DELETE FROM GardenTools WHERE id = 202

Keep Learning SQL

by taking a

Webucator SQL class

https://www.webucator.com/database-training/sql-training.cfm

Live Online Training

The schedule below shows the next two upcoming classes for each course. For more class dates click on the course title.

CourseDatePriceRegister
Introduction to SQL TrainingDec 14 - Dec 15, 2017$790.00Register
Introduction to SQL TrainingJan 04 - Jan 05, 2018$790.00Register
Introduction to SQL Training Using SQL ServerDec 14 - Dec 15, 2017$790.00Register
Introduction to SQL Training Using SQL ServerJan 04 - Jan 05, 2018$790.00Register
Introduction to SQL Training Using OracleDec 14 - Dec 15, 2017$790.00Register
Introduction to SQL Training Using OracleJan 04 - Jan 05, 2018$790.00Register
Introduction to SQL Training using MySQLDec 14 - Dec 15, 2017$790.00Register
Introduction to SQL Training using MySQLJan 04 - Jan 05, 2018$790.00Register
Advanced Oracle SQL QueriesJan 17 - Jan 19, 2018$1,275.00Register
Advanced Oracle SQL QueriesJan 29 - Jan 31, 2018$1,275.00Register
Advanced MySQL QueriesFeb 02 - Feb 02, 2018$425.00Register
Advanced MySQL QueriesMar 02 - Mar 02, 2018$425.00Register
SQL Database Definition Language (DDL) TrainingFeb 02 - Feb 02, 2018$395.00Register
SQL Database Definition Language (DDL) TrainingMar 02 - Mar 02, 2018$395.00Register

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

90,938

Students who have taken Live Online Training

16,067

Organizations who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

9.54

Students rated our SQL trainers 9.54 out of 10 based on 295 reviews

This was an excellent course!!

Awilda Goron, DentaQuest
Boston MA

Was a little intimidated at the idea of learning a new computer language from scratch. However, within 15 minutes of beginning the course, I was definitely put at ease... now I'm a bilingual programmer!

Rickey Green, Lincoln Property Company
Dallas TX

This was my first course with Webucator, and it was phenomenal! Both the instructor and the support staff were great. They take care of you all the way through - from getting your machine set up to take the course, all the way through to the final lab session.

Phil Blunk, Ivie
Bentonville AR

This was a great introductory SQL course.

Geoffrey Howard, Match.com
Dallas TX

Contact Us or call 1-877-932-8228

Where We Have Trained
We've provided Database training all over North America!


  • Juneau, AK
  • Birmingham, AL
  • Eufaula, AL
  • Conway, AR
  • Cottonwood, AZ
  • Phoenix, AZ
  • Scottsdale, AZ
  • Tempe, AZ
  • Tucson, AZ
  • Burnaby, BC
  • Vancouver, BC
  • Aliso Viejo, CA
  • Bakersfield, CA
  • Brea, CA
  • Carlsbad, CA
  • Chino, CA
  • Concord, CA
  • Duarte, CA
  • Emeryville, CA
  • Folsom, CA
  • Fremont, CA
  • Fresno, CA
  • Loma Linda, CA
  • Los Angeles, CA
  • Novato, CA
  • Pasadena, CA
  • Poway, CA
  • Sacramento , CA
  • San Bernardino, CA
  • San Diego, CA
  • San Francisco, CA
  • San Jose, CA
  • San Leandro, CA
  • Santa Clara, CA
  • Santa Clarita, CA
  • Santa Monica, CA
  • Scotts Valley, CA
  • South San Francisco, CA
  • Thousand Oaks, CA
  • Tulare, CA
  • Ventura, CA
  • Centennial, CO
  • Colorado Springs, CO
  • Denver, CO
  • Englewood, CO
  • Golden, CO
  • Longmont, CO
  • Danbury, CT
  • Hartford, CT
  • Wash DC, DC
  • Washington, DC
  • Bradenton, FL
  • Doral, FL
  • Hollywood, FL
  • Jacksonville, FL
  • Lakeland, FL
  • Ocala, FL
  • Pensacola, FL
  • Plantation, FL
  • St. Petersburg, FL
  • Tallahassee, FL
  • Wildwood, FL
  • Alpharetta, GA
  • Atlanta, GA
  • Duluth, GA
  • Kings Bay, GA
  • Madison, GA
  • Marietta, GA
  • Norcross, GA
  • Roswell, GA
  • Thomasville, GA
  • Addison, IL
  • Batavia, IL
  • Burr Ridge, IL
  • Chicago, IL
  • Downers Grove, IL
  • Hoffman Estates, IL
  • Lombard, IL
  • McHenry, IL
  • Mokena, IL
  • Naperville, IL
  • North Chicago, IL
  • Northbrook, IL
  • Riverwoods, IL
  • Rosemont, IL
  • South Chicago, IL
  • Springfield, IL
  • Vernnon Hills, IL
  • Vernon Hills, IL
  • Waukegan, IL
  • Carmel, IN
  • East Chicago, IN
  • Evansville, IN
  • Hammond, IN
  • Indianapolis, IN
  • Elwood, KS
  • Covington, KY
  • Lexington, KY
  • Louisville, KY
  • Bossier City, LA
  • Harahan, LA
  • New Orleans, LA
  • Shreveport, LA
  • Acton, MA
  • Billerica, MA
  • Boston, MA
  • Bridgewater, MA
  • Brookline, MA
  • Cambridge, MA
  • Concord, MA
  • Dedham, MA
  • FOXBORO, MA
  • Framingham, MA
  • Jamaica Plain, MA
  • Maynard, MA
  • Newton, MA
  • Peabody, MA
  • Quincy, MA
  • Worcester, MA
  • Aberdeen, MD
  • Baltimore, MD
  • Fort Detrick, MD
  • Monkton, MD
  • Owings Mills, MD
  • North Anson, ME
  • Ada, MI
  • Ann Arbor, MI
  • East Lansing, MI
  • FarmingtonHillsMi, MI
  • Flint, MI
  • Kalamazoo, MI
  • Lansing, MI
  • Livonia, MI
  • Macomb, MI
  • St Joseph, MI
  • Kansas City, MO
  • St. Louis, MO
  • Lumberton, NC
  • Raleigh, NC
  • Research Triangle Park, NC
  • Winston-Salem, NC
  • Bismarck, ND
  • Offutt AFB, NE
  • Offutt Air Force Base, NE
  • Omaha, NE
  • Annandale, NJ
  • Bridgewater, NJ
  • Cranford, NJ
  • Eatontown, NJ
  • Hackensack, NJ
  • Morris Plains, NJ
  • New Brunswick, NJ
  • Princeton, NJ
  • Secaucus, NJ
  • Woodbury, NJ
  • Rio Rancho, NM
  • Las Vegas, NV
  • Nellis AFB, NV
  • Albany, NY
  • Baldwinsville, NY
  • Brooklyn, NY
  • East Syracuse, NY
  • Kingston, NY
  • Long Island City, NY
  • New York, NY
  • Pittsford, NY
  • Rochester, NY
  • Syracuse, NY
  • Troy, NY
  • White Plains, NY
  • Canton, OH
  • Cleveland, OH
  • Columbus, OH
  • Kettering, OH
  • Piketon, OH
  • Norman, OK
  • Oklahoma City, OK
  • Tulsa, OK
  • Burlington, ON
  • North York, ON
  • Ottawa, ON
  • Toronto, ON
  • Albany, OR
  • Hillsboro, OR
  • Lake Oswego, OR
  • Portland, OR
  • Bala Cynwyd, PA
  • Bensalem, PA
  • Camp Hill, PA
  • Dresher, PA
  • Lancaster, PA
  • Mechanicsburg, PA
  • Oaks, PA
  • Philadelphia, PA
  • Pittsburgh, PA
  • West Point, PA
  • Gatineau, QC
  • Lincoln, RI
  • Providence, RI
  • Rapid City, SD