DB2 SQL Essentials

Currency:
V8 & V9

Audience:
Application Developers, Application Programmers, Production DBAs, Database Administrators and Capacity Planners.

Prerequisites:
Completion of our course DB2 UDB Fundamentals or equivalent knowledge.

Summary:
This course focuses on the scope and limits of basic SQL operations such as:

• DB2 SQL interface options (e.g., Command Line Processor, Command Center)
• 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.