Great Canadian Training Company color logo

SQL Basics

What You'll Learn in SQL Basics

Course Length:

18 hours (3 days)

Learning Objectives

  • Have the ability to code queries involving simple to intermediate complexity
  • Understand the differences between the RDBMS
  • Gain a better understanding of relational concepts and terminology

Target Student

Programmers, Analysts, Database Administrators, End Users and IT Managers who are exposed to or are required to perform the activities associated with data stored in a relational database.

Course Outline

Come prepared to learn the Structured Query Language (SQL) across multiple database platforms in this fast-paced and hands-on course. The course begins with a discussion of relational concepts and terminology and quickly moves into a very practical discussion of data retrieval and manipulation using SQL. Each topic is reinforced with hands-on workshops. Examples and workshops are provided for multiple platforms such as Db2 for z/OS, Db2 for Linux, Unix & Windows, Oracle Database, Microsoft SQL Server, and PostgreSQL. Differences between the RDBMSs are highlighted throughout the material and especially in the SQL workshops. Students will leave with the ability to code queries involving simple to intermediate complexity.

Topics covered in this course:

  • SQL and Relational Databases Overview
  • SELECT Statements
  • SELECT WHERE Clause Operators
  • SQL Case Logic
  • SQL Built-in/Supplied Functions
  • SQL Aggregate Functions/Group By, Having Clauses
  • Insert, Update, Delete, Merge, Truncate Statements
  • Inner/Outer Joins
  • Basic Subqueries

SQL Basics

Upcoming Classes

All Public classes are held online
with a live instructor
Dates Price Qty
July 22-24, 2024
10:00 AM to 5:00 PM ET
$2,160.00 Online
October 7-9, 2024
10:00 AM to 5:00 PM ET
$2,160.00 Online
November 4-6, 2024
10:00 AM to 5:00 PM ET
$2,160.00 Online
* Applicable taxes will be applied on checkout

I want to talk to someone about private or customized training

Have questions about this course? See below or reach out to our training coordinators.

This course comes with

PDF Reference Guide

Take the Reference Guide anywhere and save the environment with an electronic copy of your training Reference Guide for use on any of your computers or devices