DB2 for LUW (Linux, UNIX, Windows)

Course:  DB2UDBI
Duration:  2 Days
Level:  I
« Hide The Details
Topics Covered In This Course

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.


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.

What You Can Expect

The course provides a comprehensive introduction to IBM's DB2 database management system for LUW (Linux, UNIX, and Windows). The course includes practical exercises.

Who Should Take This Course

Anyone with a need to understand DB2 for LUW basics.

Recommended Prerequisites

A basic knowledge of the Linux, UNIX, or Windows operating systems.

« Hide The Details
Related Courses
Code Course Title Duration Level
4 Days
DB2 SQL Application Programming
5 Days
SQL Advanced Functionality (Cross Platform)
3 Days

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]