CETi - Distance-learning Title and Topics

Distance-learning - Db2: Database Administration

Home

distance-learning center

Professional Distance-learning

IT Training Services

MFRDB04

Db2: Database Administration

DURATION: 4 days

FEE: $1,980

PRIVATE GROUP FEE: $
Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

Programmer
Database Administrator
IT Professional

DATES:

CONTENT AND OBJECTIVES:

Db2 and the z/OS Environment
- The concepts and terminology of Db2 database administration.
- Instructor to provide examples.
Database Structures
- Examine the concepts and terminology of database structures.
- Instructor to provide examples.
Physical Database Design
- Design and implement a system using physical design.
- Develop a logical design of a system.
- Develop the appropriate DDL for creating objects which will include views and indexes.
Loading and Managing Db2 Databases
- Load tables in multiple ways.
- Load a table using a program and the Db2 LOAD utility.
Table and View design
- Design tables for performance and integrity.
- Redesign tables for partitioning, clustering, indexing, column layout, tablespace type, and page.
- Learn how to improve parallelism.
General Efficiency Techniques
- Become familiar with the options which are available for tuning a Db2 SQL query including: changing the query, redesigning the database, and changing the application program.
- Instructor presents examples and different scenarios: checking Db2 statistics, modifying sample SQL statements, and scenarios for changing table designs.
Factors Affecting Performance
- Examine the cost in terms of maintenance associated with indexes.
- Evaluate the benefits of a proposed index.
- How and when a proposed index brings significant relief to a query, then the index can be justified.
- Examine the trade-offs in query tuning and the impact of business decisions.
- Analyze an approach where tuning focuses on reducing query I/O.
- Recognize that a reduction in query I/O does not eliminate all of the I/O; some of the I/O is moved to index maintenance.
- Instructor presents examples and different scenarios: reducing unnecessary I/O with a new index, index-only processing, and index costs.
When to Tune
- Develop guidelines for determining when to tune and which components to tune.
- Instructor presents examples and different scenarios for monitoring Db2 and identifying issues relating to performance.
Recovery and Security
- Backup and restore a tablespace.
- Backup a series of tablespaces.
- Delete the tablespaces and then perform a restoration using logs and backups.


		Virtual Classroom		Blended Learning

↓


		Synchronous Instruction		Asynchronous Instruction

Effective February 27, 2012, the course dates listed on the CETi schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. CETi makes no representation regarding ownership in any of the software products that we train on.

CETi courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the CETi course and that the employer has a licensed version of the software.

Certain courses only should be taught by the source software company training company and open source purveyor.