Computer Business International, Inc., is an on-site or virtual, hands-on instructor led
Db2 for z/OS education, training and consulting company
with over 30 years of Db2 experience.
5605 Riggin CT., Suite 200 Reno, NV 89502
Db2 12 for z/OS -
From Start to Finish: Part 1
Db2 Database Administration Part 1 is a customized hands-on SQL and Command workshop that is designed to take the student through coding complex SQL statements, developing SQL performance tuning methods and using Db2 Commands.
Db2 Concepts and Facilities Review
Complex Single Table SQL
Working with Multiple Tables
Performance Tuning & Explain
Tuning Embedded SQL
Working with DB2 Commands
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, SPUFI and optionally QMF.
Db2 12 for z/OS Database Administration
Part 1 Class Outline:
Db2 Concepts & Facilities Review
Db2 Environment- Subsystem Look
Products and Utilities Review
Data Structures – A Detail Look into Tables, Table spaces, and Indexes