DB2 SQL Essentials

Course Code: DBISQE
Duration: 2 days
Audience: Application Developers, Application Programmers, System Administrators and Capacity Planners.
Prerequisites: Completion of our course DB2 Concepts & Facilities or equivalent knowledge.
Summary: This course focuses on the scope and limits of basic SQL operations such as:
  • DB2 SQL interface options (e.g., iSeries Navigator)
  • 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
  • Special registers
  • Introduction to embedded SQL
Objectives: Upon completion of this lab-oriented course, the delegate should be competant 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