Introduction to RDBMSs and the DB2 v11
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:
- 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
Introduction to DB2 Relational Databases and SQL
The Concepts of a Relational Database
The Role of the DBA
SQL Statement Introduction
The DB2 Server Alternatives
The Platforms That DB2 Run On
Storage Methods Used by DB2
DB2 for z/OS Implementation
The Unique Aspects of DB2 on z/OS
Unique Storage Requirements on z/OS
SQL Preparation in a z/OS Environment