SQL Training

  4.7 out of 5 based on 1268 Ratings

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

Introduction to SQL Training

- $790.00

If you need to get up to speed creating SQL reports quickly, this is the right SQL course for you. The class can be taught using SQL Server, Oracle, or MySQL. In addition to report writers, web designers learning to create database-driven websites will also benefit from this type of SQL training.

Next Live Class:

Introduction to SQL Training Using SQL Server

- $790.00

If you're just getting started writing reports or creating websites using SQL Server, this is the right SQL course for you. You will learn the fundamentals of SQL queries shared by all major databases as well as some of the ways SQL Server's variant of SQL differs from other databases. For a deeper dive into Transact-SQL, consider our 3-day Apache Maven Quickstart Training.

Next Live Class:

Introduction to SQL Training Using Oracle

- $790.00

If you're organization uses Oracle and you or your team have been tasked with creating or editing SQL reports, then this is the right SQL course for you. You will learn the fundamentals of SQL queries shared by all major databases as well as some of the ways Oracle's variant of SQL differs from other databases.

Next Live Class:

Introduction to SQL Training using MySQL

- $790.00

If your organization uses MySQL for report writing as a backend to a database and it will be your job to write SQL queries, then this is the right SQL course for you. You will learn the fundamentals of SQL queries shared by all major databases as well as some of the ways MySQL's variant of SQL differs from other databases.

Next Live Class:

Advanced Oracle SQL Queries

- $1,275.00

If you or your team have already learned the fundamentals of SQL and now need to up your skills to make more complex SQL queries against an Oracle database, then this is the right course for you. We review some of the more complex multi-table queries and then get into Oracle-specific SQL functions and processing.

Next Live Class:

Advanced MySQL Queries

- $425.00

If you or your team have already learned the fundamentals of SQL and now need to take your MySQL skills to the next level, this MySQL course will help you do that quickly. You'll learn to use conditional processing to calculate multiple levels of subtotals using ROLLUP, to take advantage of many different SQL functions, and to explore MySQL schemas so you can get a better understanding of how your data is structured.

Next Live Class:

DB2 SQL Training

In this DB2 SQL Training training class, students will learn the DB2 SQL starting at the most basic level and going to the most advanced level. This course includes many examples.

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

What people say about our training

I was completely starting from scratch when learning SQL. Great, patient instructor.
Alex Mathew
GuideStone Financial Resources
I felt a little intimidated going into the course but in short order was very comfortable with learning the applications of the program.
Maxine Winder
Alberta Health Services
This class increased my overall understanding of SQL a tremendous amount.
William Blackburn
Edgewood Chemical Biological Center
Webucator is a great tool for introducing yourself to Technical Training. Instead of learning on the fly at a job, or on your own, the classes Webucator offers and the level of training is worth the time and money!
April Dickson
IEHP

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

61,268

Students who have taken Instructor-led Training

11,739

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.40

Students rated our SQL trainers 9.40 out of 10 based on 1,268 reviews

Contact Us or call 1-877-932-8228