YL&A

EDUCATION

YL&A provides the best in DB2 & SQL education. Our instructors are among the most respected experts in the DB2 database market and are available for international courses. Classes are available privately or publicly through DB2 User Groups. All courses are tailored to meet the specific needs of any organization, including hands-on workshops where applicable.

For pricing and availability, contact us at info@ylassoc.com.

COURSE LIST

DB2 9 for z/OS

DB2 9 for z/OS Transition Class
DB2 9 for z/OS Certification Class
DB2 V8 and 9 Application Challenges and Solutions Class

DB2 for z/OS Version 8

DB2 for z/OS Version 8 DBA Certification
DB2 for z/OS Version 8 Transition: An Intense Look at What's New

SQL and Applications

DB2 V8 and 9 Application Challenges and Solutions Class
DB2 for z/OS Intermediate and Advanced SQL and Performance
Advanced and Complex SQL
SQL and DB2 for Z/OS Database Performance Analysis and Techniques (New)
DB2 for z/OS Backup and Recovery; Options and Performance
Advance Application Program Techniques
DB2 Application Programming
Introduction to Basic SQL Design & Coding
DB2 Stored Procedures: Programming and Administration
Stored Procedures, Triggers & User-defined Functions
Backup, Recovery & Restore
Introduction to Relational Design, SQL, and DB2

Performance

DB2 z/OS Version 7 & 8 Impacts on Performance
SQL and DB2 for Z/OS Database Performance Analysis and Techniques (New)
Table and Index Design for High Performance
Buffer Pool and Subsystem Design for Performance & Tuning
DB2 High Performance Design & Tuning

Data Sharing

Data Sharing Complete
Data Sharing Recovery
Data Sharing Performance and Tuning
Data Sharing Implementation

Database Design

Logical Database Design for Relational Databases
Data Warehouse Design and Performance

IBM is a registered trademark of International Business Machines Incorporated
DB2 is a registered trademark of International Business Machines Incorporated