Audience
Anyone with a need to understand DB2 for LUW basics. The course is delivered up to DB2 9.7
Prerequisites
A basic knowledge of the Linux, UNIX, or Windows operating systems.
Duration
2 days. Hands on.
Course Objectives
The course provides a comprehensive introduction to IBM's DB2 database management system for LUW (Linux, UNIX, and Windows). The course includes practical exercises.
Course Content
Relational Database Concepts
- The Relational Model.
- Data Structure Rules.
- Relationships.
- The Relational Operators.
- Integrity Rules.
- DB2 and the Relational Model.
DB2 Features
- What is DB2?
- What is SQL?
- Command Line Processor.
- Command Center and Control Center.
- Data Studio.
- DB2 Packaging.
DB2 Objects
- Tables.
- Databases.
- Tablespaces.
- Built-In and Distinct Data Types.
- Indexes.
- Free Space.
- Large Objects.
- The DB2 Catalog.
Program and User Interface
- The SQL language.
- Dynamic and Static SQL.
- Data Definition.
- Data Manipulation.
- Select.
- The DB2 Optimizer.
- Constants.
- Views and Aliases.
- Embedded SQL.
- Host Variables and Cursors.
- Nulls.
- Special Registers.
- Operational Environment.
- Instances and Databases.
- Connections.
- End User Access.
- DB2 Utilities.
Security
Reading Data
- Select.
- Selection Criteria.
- Arithmetic.
- Built-In Functions.
- Group By.
- Select Distinct.
Updating Data
- Adding Rows.
- Deleting Rows.
- Updating Rows.
- Concurrency.
- Unit of Work.
- Locking.
- Commit and Rollback.