- 4 hours
The Introduction to RDBMSs and DB2 course describes from a Database Administrator's (DBA) viewpoint how DB2 is used and the types of DB2-related tasks that the DBA performs. The course also looks at DB2's system configuration requirements and how it is implemented in a z/OS environment.
Programmers, DBAs, operations analysts, business analysts, and any other personnel requiring a systems introduction to RDBMs and DB2.
General knowledge of information technology concepts, the z/OS environment, and programming.
After completing this course, the student will be able to describe:
- How a DB2 relational database is structured
- The environments into which DB2 can be installed
- How DB2 data is accessed
- How DB2 is configured and accessed in a z/OS environment
The Concepts of a Relational Database
The Role of the DBA
SQL Statement Introduction
The Platforms That DB2 Runs On
Storage Methods Used by DB2
The Unique Aspects of DB2 on z/OS
Unique Storage Requirements on z/OS
SQL Preparation in a z/OS Environment