Profile

e-Catalog

Contact

Search

Cart

IBM DB2 Universal Database 5.0: Database Objects and Data Manipulation

Course Status:	In Development	Courseware Features
Course Language:	English
Course Duration:	4 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

Audience

Application developers involved in creating applications on DB2 databases

Prerequisites

A basic understanding of relational databases and SQL; completion of previous courses in the IBM DB2 Universal Database 5.0 curriculum

Course Aim

To describe DB2 naming conventions and methods of data manipulation

Learning Objectives

Understand DB2 naming conventions. Understand the authorities required to access data in an application. Create and use packages. Define and manipulate database objects and data using SQL. Understand the creation and use of large objects in applications.

Topics Covered

Defining objects - Naming conventions - Table definition - View definition - Index definition Data access and manipulation - Data access - Joins and subqueries - Sorting and grouping - Packages - Common table expressions Advanced data manipulation - Column and scalar functions - Changing data - Accessing the system catalog - Large objects