DB2 SQL Essentials

Course Code: DZOSQE
Duration: 3 days
Audience: Application Developers, Application Programmers, Production DBAs, Database Administrators and Capacity Planners.
Prerequisites: At least 6 months experience in an MVS environment.
Summary: This course focuses on the scope and limits of SQL operations such as:
  • Overview of Data Definition Language (DDL): Create/Alter/Drop DB2 objects
  • Data Manipulation Language (DML)
  • Predicates
  • NULL considerations
  • INNER JOINs
  • OUTER JOINs
  • UNIONs
  • CASE expressions
  • GROUP BY & HAVING
  • CAST operations
  • Subqueries (correlated & non-correlated)
  • Subselects
  • Column/scalar functions
Objectives: Upon completion of this lab-oriented course, the delegate should be competent to code SQL SELECT, INSERT, UPDATE and DELETE statements to manipulate relational data stored in one-or-more tables.
View full outline in PDF formatDetailed Outline

Course Schedule

Request a date for this course

Book Course

Course Outlines

Detailed course outlines are available in PDF format. Download Adobe's Acrobat Reader free from: www.adobe.com
Get Acrobat Reader

Training Topics

GENERAL

print  |  top of page