SQL Basics



Course Length: 3 Days

Learning Objectives:
By the end of this training, you’ll be able to:
  • 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.

Prerequisites :
There are no prerequisites for this course.

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 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
  • SELECT ORDER BY Clause
  • 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

This Course Comes With

PDF Manual

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



Delivered by One of Our Trusted Partners
Basics
Date(s) Price Qty
January 9-11, 2023 10am to 5pm EST $2,160.00 (CAD)*  
May 1-3, 2023 10am to 5pm EST $2,160.00 (CAD)*  

* 13% HST will be applied on checkout


Online registration closes two business days before the start of the class.
Questions?
Do you have questions about this course? Would you like a class sooner or on a different date? Are you interested in scheduling a private group class? Please submit the simple form below and we will respond promptly.
Private Training for GroupsIf you are training 8+ people, a private training session may be more cost-effective. Click to contact us today and learn more.
Register for this class here
Learn more about each course here
Contact us for more information here