SQL Basics
What You'll Learn in SQL Basics
Course Length
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
- 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
Delivered by One of Our Trusted Partners
SQL Basics
Upcoming Classes
All Public classes are held onlinewith a live instructor
| Dates | Price | Qty |
|---|---|---|
| July 14-16, 2025 9:00 AM to 5:00 PM ET | $2,160.00 Online | |
| October 27-29, 2025 10:00 AM to 5:00 PM ET | $2,160.00 Online | |
| March 2-4, 2026 10:00 AM to 5:00 PM ET | $2,160.00 Online | |
| July 6-8, 2026 10:00 AM to 5:00 PM ET | $2,160.00 Online |
Have a Group?
Complete the form to receive a quote for private or customized training.
More people = GREATER savings
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
30 Days of After-Training Support
Get 30 days of live 24/7 after-training support via phone, email and online chat to help apply what you've learned
Certificate of Completion
Boost your credentials with a Certificate of Completion, confirming the skills you’ve acquired with us.
PDF Reference Guide
Want a summary of what you’ve learned? Save paper and use your PDF Reference Guide, accessible on any of your devices.
Certificate of Completion
Boost your credentials with a Certificate of Completion, confirming the skills you’ve acquired with us.