Audience
Anyone with a need to understand the basics of DB2 for LUW.
Prerequisites
A basic knowledge of Linux, UNIX, or Windows operating systems is necessary for this course.
Duration
2 days. Hands on.
This course is available on site only. Please call for details.
Course Objectives
The course provides a comprehensive introduction to the SQL Query Language and 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.