DB2 UDB for z/OS Version 8 SQL and Applications

This course is an in-depth look at the many new and enhanced SQL and Application features of DB2 UDB for z/OS Version 8. IBM calls DB2 Universal Database (UDB) for z/OS Version 8, "The biggest release in DB2 history and represents a major reengineering of the product." Over half of the development time in V8 was spent on SQL. In this course you are introduced to these new features and we also provide you with details on how to utilize the features through examples. Attend this course to obtain the knowledge required to select and implement the new features that best fit your environment.  The course covers new and changed functionality in Version 8 for z/OS.
A detailed look at this course...

 

DB2 UDB for z/OS Version 8 Transition

This course is an in-depth look at the many new and enhanced features of DB2 UDB for z/OS Version 8.   IBM calls DB2 Universal Database (UDB) for z/OS Version 8, "The biggest release in DB2 history and represents a major reengineering of the product." In this course you are introduced to the new features of Version 8 and we also provide you with details on how to utilize the features through examples. Attend this course prior to migrating to Version 8 to obtain the knowledge required to select and implement the new features that best fit your environment.
A detailed look at this course...

 

DB2 UDB for z/OS and OS/390 Version 7 Utility Transition

This course is an in-depth look at the many new and enhanced features of DB2 UDB for z/OS and OS/390 Version 7 utilities. Attend this course prior to implementing Version 7 utilities to obtain the knowledge required to build and implement optimally performing utilities that best fit your environment. The course covers new and changed functionality of the DB2 utilities
A detailed look at this course...

 

DB2 UDB Version 7 for z/OS & OS/390 Utility Implementation

This course is an in-depth look at the DB2 UDB for z/OS and OS/390 utilities. Attend this course if you have limited or no prior knowledge of the DB2 utilities in order to obtain the knowledge required to build and implement optimally performing utilities that best fit your environment.
A detailed look at this course...
 

DB2 Logical to Physical Design Transition

This course is intended for all personnel involved in the Logical to Physical design implementation of Relational Database systems. The course reviews the Database Design Life Cycle as it pertains to any RDBMs and incorporates specifics as to the physical implementation of your design in DB2.
A detailed look at this course...
 

DB2 UDB for z/OS and OS/390  Version 7 Transition

This course is an in-depth look at the many new and enhanced features of DB2 UDB for z/OS and OS/390 Version 7. Not only are you introduced to the features but we also provide you with details on how to utilize the features and provide an extensive set of examples. Attend this course prior to migrating to Version 7 to obtain the knowledge required to build your migration plan and to select and implement the new features that best fit your environment. The course covers new and changed functionality, migration planning and fallback. The course is modularized; it is recommended that application personnel attend the first day and database and systems personnel attend all 2.5 days.
A detailed look at this course ..
 

DB2 UDB for z/OS and OS/390 V5 to V7 Transition

Please call for a class outline. We customize this class for each client based on the customers needs. The number of class days varies with the selected topics. 866.CBI.4YOU
 

DB2 UDB for z/OS and OS/390 Version 6 Transition Overview

This 1 day course is intended for experienced Systems Administrators, Data Base Administrators and Lead Application designers who will be participating in the Migration and/or implementation of DB2 UDB for z/OS and OS/390 Version 6. The course introduces the attendee to the many new and enhanced features of DB2 UDB for z/OS and OS/390 Version 6 and details migration considerations.
A detailed look at this course ..
 

DB2 for OS/390 Version 6 Transition

This 3 day course introduces the attendee to the many new and enhanced features of DB2 UDB for z/OS and OS/390 Version 6 as well as presenting information about migration and fallback.   A detailed look at this course ..
 

DB2 UDB for z/OS and OS/390 Data Sharing Recovery/Restart

This 2.5 day course will help you understand how recovery works in a data sharing environment and develop the procedures you should have in place to recover from errors or unexpected conditions. A detailed look at this course ..
 

DB2 UDB for z/OS and OS/390 Data Sharing

This 2.5 day course introduces the attendee to the components and features of DB2 UDB for z/OS and OS/390 Data Sharing as well as how to plan for the implementation of a Data Sharing Group. The major issues of naming conventions, data migration, performance, locking, communications and coupling facility requirements are included. A detailed look at this course ..
 

DB2 UDB Stored Procedures

This 3 day course presents the coding and administration requirements to implement, develop and test cross platform Stored Procedures for the DB2 UDB Environment. The first half of the course concentrates on developing DB2 UDB for z/OS and OS/390 COBOL stored procedures. The remainder of the course addresses SQL procedures in a distributed environment. A detailed look at this course ..
 

DB2 for z/OS and OS/390 - System Overview & Performance Basics

This 1 day seminar is intended for Systems Programmers, Systems Administrators and Technical Database Administrators. The seminar describes the layout and content of the various DB2 subsystem data and system structures, what facilities are supplied to manage the DB2 environment and how DB2 relates to the MVS environment. A detailed look at this course ..
 

DB2 UDB for UNIX and Intel SQL and Application Coding

This 5 day hands-on course provides the student with an introduction to DB2 UDB, how to write and execute interactive SQL, how to write and execute static SQL programs using cursor techniques, how to use the EXPLAIN facility and will provide SQL performance and tuning tips. A detailed look at this course ..
 

DRDA and DB2 Connect - Putting the Pieces of the Puzzle Together

This 1 day seminar is intended for all personnel working with DB2 who require an introduction to DRDA and DB2 Connect. You will build a planning checklist to implement DRDA connectivity using DB2 Connect and TCP/IP. (Addresses z/OS and OS/390 plus Windows platforms).
 A detailed look at this course ..
 

Introduction to DB2 for z/OS and OS/390 and SQL Coding

This 3 day hands-on workshop trains the DB2 for z/OS and OS/390 Query user and application developer to code simple and complex SELECT and data modification statements. In addition, this course provides an informative overview of the DB2 for z/OS and OS/390 environment and basic SQL performance tuning techniques  A detailed look at this course ..
 

DB2 and Linux: An Introduction

This 1 day class deals with deploying DB2 UDB Enterprise Edition Version 7.1 for Linux.  Linux offers users stability, value and functionality. Combine this with the most trusted database for e-business, DB2, and you have a winning combination!  Come and learn how to implement Red Hat and DB2 in your workplace. A detailed look at this course ..

DB2 UDB for z/OS and OS/390 SQL and Application Coding

This 5 day hands-on course takes the student from an introduction to DB2, through learning SQL, working with SQL interactively and writing static SQL programs. By working with the EXPLAIN statement you will become familiar with tuning techniques used in DB2 UDB.
 A detailed look at this course ..
 

Using DB2 Utilities to Load and Unload Tables

This 1 day hands-on workshop trains the DB2 for z/OS and OS/390 application developer how to use DB2 utilities to perform table unloads and reloads.  A detailed look at this course ..
 

Data Warehousing: An Introduction

This 2 day course provides the students with practical techniques for designing and building a data warehouse.
  A detailed look at this course ..
 

DB2 UDB for z/OS and OS/390 Advanced SQL Coding & Performance Tuning

This hands-on workshop trains the DB2 for z/OS and OS/390 Query user and application developer to code complex SQL statements to achieve optimum performance.
A detailed look at this course ..
 

DB2 UDB for z/OS and OS/390 Data Base Administration

This 4.5 day course provides the attendee with the skill set required to conduct a physical database design, perform database implementations and to maintain DB2 for z/OS and OS/390 databases in an ongoing production environment. Note: Updated to cover DB2 UDB for z/OS and OS/390 Version 6 features.
A detailed look at this course ..
 

DB2 DBAs - From z/OS and OS/390 to Cross Platform

This 3 day presentation is intended for the DB2 for z/OS and OS/390 DBA who now faces the task of managing and administering cross-platform databases. During this session we discuss the differences between the various platforms and the DB2 database managers. Emphasis is placed on the administrative responsibilities, the physical differences in the environments, database structures and operational and recovery procedures. Leverage your existing knowledge and explore the differences, not the commonality, between the environments and the database objects.
A detailed look at this course ..
 

Relational Concepts and DB2

This 2 day hands-on class is an introduction to DB2 SQL coding for end-users, programmers, designers, and data base administrators.
A detailed look at this course ...
 

Implementing Triggers, UDTs, UDFs and Constraint Rules

This 1-day session presents the design, coding and administration requirements to implement, develop and test data integrity and business rules for the DB2 UDB for z/OS and OS/390 Environment using the most current version 6 enhancements. With the addition of Triggers, User Defined Distinct (Data) Types and User Defined Functions the degree of integrity support within the DBMS has greatly increased. These enhancements, when properly implemented, can result in faster application development and easier maintenance by moving certain parts of the application logic into DB2. Join us as we explore automating and controlling when events occur through the use of Triggers, enhancing integrity through UDTs/UDFs and putting your DBMS to work to support your overall business rules.
A detailed look at this course ...