DB2 school training courses in Columbia, SC (public, in-house or online)

This course deals with the complexity of accessing DB2 within IMS DB/DC programs. Developers from either the IMS or DB2 world learn how to best design, develop and debug applications. Labs enable the students with hands-on experience.
Designed For
This course is designed for either IMS or DB2 developers and DBA’s working in the IMS-DB2 environment.
Course Outline
Synchronization and Commit Processing
Coding for Improved Performance
PSB, Package and Plan Use
Scrolling/Pag...

Full archival course description>>

This course provides comprehensive coverage of DB2 physical objects from a database administrator’s and a system administrator’s perspective. A full range of administration topics are addressed including physical structures, packages, plans, access paths, DB2 Optimizer, monitoring and control, transaction locking, lock avoidance, stored procedures, distributed facilities, data sharing and recovery of system components.
Designed For
This course is intended for DB2 System Administrators and...

Full archival course description>>

This course provides comprehensive coverage of DB2 from a database administrator’s perspective. A full range of DBA topics are addressed including DB2 physical structure, DB2 data integrity constraints, implementation of DB2 objects, DB2 utilities, DB2 Service Aids, stored procedures, security and authorizations.
Designed For
This course is intended for new or inexperienced DB2 Database Administrators.
Course Outline
Introduction to DB2
DB2 Data Integrity Constraints
Impleme...

Full archival course description>>

This comprehensive course covers DB2 recovery and operational issues. It discusses normal and abnormal start-up and termination methods, the use of utilities and service aids to back up and restore user and system data, and other problem and operational issues. Hands-on lab exercises reinforce material covered during lecture.
Designed For
This course is designed for individuals involved in the day-to-day running and support of a DB2 subsystem, as well as those responsible for the recovery...

Full archival course description>>

This course is designed to review the concepts and components of DB2 for UNIX and Windows. DB2 commands and SQL will be used to focus on DB2 administration activities. The relationships between object components will be presented along with communication and security aspects. Design issues of referential Integrity, table check constraints, user defined data types and functions, triggers and large objects will be reviewed. Program design issues will be considered which effect concurrency, integri...

Full archival course description>>