Course# 1: Fundamentals of IBM DB2 for z/OS

 

Pre-req : Data Structures and Algorithms (CS 146 in SJSU)

 

       

Major topic covered:

Part I: Overview

        Chapter 1: Introduction to DB2

        Chapter 2: DB2 Concept

Part II: DB2 anatomy

        Chapter 3: System overview

        Chapter 4: System structures

        Chapter 5: Database services

        Chapter 6: DB2 environment

        Chapter 7: DB2 attachment facilities

Part III: Application development

        Chapter 10: SQL overview

        Chapter 11: DB2 interface

        Chapter 12: SQL journeys

        Chapter 13: Database implementation

        Chapter 14: Application implementation

Part IV: System administration

        Chapter 15: Concurrency control

        Chapter 16: Security

        Chapter 17: Logging and recovery

        Chapter 18: Startup and restart

        Chapter 19: Commands, utilities, and tools

Part V: Performance topics

        Chapter 20: System performance

        Chapter 21: Query performance

Outcome: Upon Completion of this course, you will be able to: