DB2 SQL Essentials

Course Code: DWUSQE
Currency: V8 & V9
Duration: 2 days
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.
View full outline in PDF formatDetailed Outline

Course Schedule

  • 14-15 April
  • 12-13 May
  • 16-17 June
  • 14-15 July
  • 18-19 August
  • 15-16 September
  • 13-14 October

Price: £675+VAT
Venue: Gatwick

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