Description
This course introduces and explains the fundamental principles of the Db2 for Linux, UNIX and Windows family of products. The course focuses on the relational theory and concepts, and how Db2 adheres to them. It also introduces the basic concepts of DB2 data storage, SQL, Db2 utilities, and the use of Db2 Interactive (Db2i) and the relevant centres.
Delegates will learn how to
- describe the relational theory and concepts
- list the objects used to store Db2 data
- understand the use of Structured Query Language
- describe the functions available with Db2 Interactive (Db2i)
- list the utility jobs available for Db2.
Audience
All IT professionals who need to understand the full range of the Db2 for LUW family of products.
Outline
Overview of DB2 for Linux, UNIX and Windows
Command Line Processor (CLP) and GUI Usage
The DB2 Environment
Creating Databases and Data Placement
Creating Database Objects
Moving Data
Backup and Recovery
Locks and Concurrency
Database Maintenance, Monitoring and Problem Determination
Security
Database Rebuild Support
DB2 Database and Table Space Relocation
Using Explain Tools
Using Indexes for Performance
Advanced Monitoring
Prerequisites
A basic understanding of IT, with some exposure to database technology as a user.