This course will cover DB2 Physical Storage, Data Definition, Application Programming Considerations, Load Related Utilities, Performance Issues, Referential Integrity Implications, DB2 Catalog, Security end Auditing, and the Backup and Recover Processes. Application programmers may find this course to be an excellent tool to sharpen their DB2 skills helping them to bridge the traditional gap between programmers and database administrators.
Project managers, team leaders, data analysts, database administrators, systems administrators and systems programmers who will be working with DB2.
Some experience with MVS and TSO is assumed as well as introductory level
knowledge of DB2
Course Objectives:Install the DB2 product and related attachments
Alter the install parameters with DSNZPARM overrides
Describe DB2 storage management techniques
Implement a DB2 database and it's performance considerations.
Manage the system objects
Manage the DB2 life-cycle
Perform a DB2 design review for proper working set and performance estimates
Implement DB2 security control
Describe the DB2 effect on standards and procedures
Upon completion of this course, student should be able to:
Key Topics:Introduction to relational database systems
Using SQL for data definition
Using SQL for basic data retrieval
Using SQL for advanced data retrieval
Using SQL for data modification
Last modified: 29-Jun-2016