Know DB2

Db2 for z/OS - Database Administration

From Start to Finish: Parts: 1, 2 and 3

An intense three-week hands-on class that takes the student through SQL, Utilities, Recovery, Database Administration, and System Administration for Db2 for z/OS.

Db2 for z/OS Database Administration From Start to Finish: Part 1

This customized hands-on SQL and Command workshop is designed to take the student through coding complex SQL statements, developing SQL performance tuning methods and using Db2 Commands.

Topics Covered:

Duration: 5 days, Hands-on labs

Audience: Anyone who will be coding complex joins and queries and is concerned with optimum performance; programmers, application designers, database administrators, system administrators.

Prerequisites: Working knowledge of basic SQL, TSO, and SPUFI, and optionally QMF or Data Studio.

Complete Outline: Db2 for z/OS Database Administration From Start to Finish: Part 1.

Db2 for z/OS Database Administration From Start to Finish: Part 2

This 5-day course provides the attendee with the skill set required to understand physical database designs, perform database implementations and to maintain DB2 for z/OS databases in an on-going production environment.

Topics Covered:

Duration: 5 days, Hands-on labs

Audience: Db2 Database Administrators, Data Administrators and Systems Administrators who will be designing, implementing and/or maintaining Db2 for z/OS.

Prerequisites: An understanding of the relational data model and SQL.

Complete Outline: Db2 for z/OS Database Administration From Start to Finish: Part 2.

Db2 for z/OS Database Administration From Start to Finish: Part 3

Db2 Database Administration Part 3 is an in-depth systems look at DB2 for z/OS course. In this course you are introduced to the Systems side of Db2, monitoring, performance issues, system backup and recovery, and planning the installation or migration of Db2. Attend this course prior to installing, or migrating to Db2.

Topics Covered:

Duration: 5-Day Lecture, Workshops, Labs

Audience: All personnel who will be working with Db2 for z/OS as DBA’s or System Administrators

Complete Outline: Db2 for z/OS Database Administration From Start to Finish: Part 3.


Please call our toll free number 1.866.224.4968 or email us at info@cbi4you.com if you have any questions or concerns.