Manipulating Data with DB2 UDB

Overview/Description
To execute queries using SQL

Target Audience
Anyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certification

Prerequisites
A knowledge of fundamental database concepts, database creation and procedures, daily administration tasks, and basic SQL

Expected Duration
160 Minutes

Objectives:

Manipulating Data with DB2 UDB

  • use the basic SELECT statement in a given scenario.
  • use advanced SELECT statement features in a given scenario.
  • use the INSERT, UPDATE, and DELETE statements in a given scenario.
  • use the SELECT, INSERT, UPDATE, and DELETE statements in a given scenario.
  • apply an inner join, an outer join, and a union in a given scenario.
  • apply table joins and unions in a given scenario.
  • manage cursors, transactions, and stored procedures in a given scenario.
  • manage transactions and stored procedures in a given scenario.


    • Course Number: 209552_eng