Profile

e-Catalog

Contact

Search

Cart

IBM DB2 Universal Database 5.0: Database Creation, Access, and Manipulation

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

Audience

Database administrators and application developers who are responsible for database creation and who require an introduction to SQL

Prerequisites

Previous courses in the IBM DB2 Universal Database 5.0 curriculum and a basic understanding of relational databases

Course Aim

To describe database creation, data manipulation and validation in DB2

Learning Objectives

Create a DB2 database. Catalog a database. Interpret the system catalog and database directory. Define database objects and manipulate data using SQL. Understand the concept of a transaction or unit of work. Explain the use of constraints and triggers in data validation.

Topics Covered

Creating databases - Overview - Hands-on: Creating a database - The system catalog - Database directories - Database recovery logs Cataloging databases and nodes - Cataloging a local database - Cataloging a remote database - Cataloging a node Using SQL - Data Definition Language - Data Manipulation Language - Data Control Language - Transactions Data validation - Check constraints - Referential constraints - Triggers