Course Details

About the course

The DB2 Fundamentals class provides an introduction to the DB2 relational database system as implemented on z/OS. It introduces the major DB2 concepts, structures, functions and features and includes the following:

• Introduction to DB2

• DB2 Concepts

• DB2 System Overview

• DB2 System Structures

• DB2 Database Services

• DB2 Environment

• DB2 Attachment Facilities

• DB2 Workload Management

• Distributed Data Facility

• SQL Overview

• DB2 Interface

• SQL Journeys

• Database Implementation

• Application Implementation

• Concurrency Control

• DB2 Security

• DB2 Logging and Recovery

• Startup and Restart

• DB2 Commands, Utilities, and Tools

• System Performance

• Fundamental Query Optimization