Structured Query Language (SQL)

Course:  SQL
Duration:  3 Days
Level:  I
Course Summary

This course will provide students with SQL skills needed to build simple or complex interactive queries against data which is stored in DB2 (or similar) databases. The course includes an introduction to the structure and function of the DB2 product, and a comprehensive examination of the SQL language, including a progressive series of hands-on workshops to provide the student with experience in using the language.

« Hide The Details
Topics Covered In This Course


  • The origin and history of IBMOs relational products
  • Terminology pertinent to relational environments
  • Overview of DB2 system components
  • How data is physically stored in a relational DBMS
  • The logical organization of the database
  • How the system retrieves data from the database
  • Data relationships
  • SQL syntax rules
  • Using SPUFI (or QMF, ISPF) to build and execute interactive SQL queries


  • Understanding and using SQL data types
  • The use and implications of NULL values
  • Creating databases, tables, and other objects
  • Deleting databases, tables, and other objects
  • Understanding indexes
  • When and how to use an index
  • Advantages and disadvantages of index usage
  • Primary and foreign keys
  • Referential integrity
  • The optimizer, indexes, and the EXPLAIN statement


  • Syntax of SELECT statements
  • Tailoring a Select List to choose specific columns
  • Building expressions
  • Using the WHERE clause to choose specific rows
  • How to eliminate duplicate data
  • Coping with NULL values during data retrieval
  • Using DISTINCT, ANY, and ALL
  • Rules for logical comparison of data
  • Boolean comparison, using NOT, AND, and OR
  • Rules for arithmetic comparison of data
  • Using IN and NOT IN to build include lists
  • Using BETWEEN and NOT BETWEEN to define ranges
  • Pattern-matching and building search arguments, using LIKE, NOT LIKE, and wildcard values
  • Sorting output, using the ORDER BY clause
  • The EXISTS and NOT EXISTS predicates


  • Aggregate (Built-In) Functions, including AVG, MIN, MAX, COUNT (*), COUNT (DISTINCT), and SUM
  • Scalar Functions, including
    • Conversion between different data types
    • Date and time functions
    • Character string concatenation
  • GROUP BY and HAVING clauses
  • UNION and UNION ALL keywords
  • Joining tables
  • How to specify join criteria
  • Uses and rules for Sub-queries
  • Uses and rules for Views


  • The INSERT statement, including examination of statement parameters and referential integrity implications.
  • The UPDATE statement, including examination of statement parameters and referential integrity implications.
  • The DELETE statement, including examination of statement parameters and referential integrity implications.
  • The COMMIT statement and database recovery.
What You Can Expect

After taking this course the student should be able to utilize application programs to embed SQL statements within batch or on-line programs using DB2, SQL/DS, or similar SQL-based database management systems.

Who Should Take This Course

Anyone who will be using SQL to extract data from DB2, SQL/DS, or other relational database management system.

Recommended Prerequisites

The participants need no prior knowledge of the SQL language.

Training Style

This class is taught by lecture with hands-on workshops.

« Hide The Details
Related Courses
Code Course Title Duration Level
Advanced SQL (Structured Query Language)
3 Days

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]