AUDIENCE:   Anyone with a need to understand DB2 for LUW basics. The course is delivered up to DB2 9. PREREQUISITES:   A basic knowledge of the Linux, UNIX, or Windows operating systems. DURATION:   2 days. Hands on. 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. - 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. IC06/01