Detailed Course Outline
Preface
- • Course Overview
- • Intended Audience
- • Course Objectives
- • Prerequisites
Unit 1 - Db2 Relational database concepts
- • Relational Database design
- • Data access
- • Interacting with Db2
- • Catalog and directory
Unit 2 - SQL and SPUFI
- • SQL SELECT statement review
- • SQL INSERT, UPDATE, DELETE review
- • SQL COMMIT and ROLLBACK review
- • Joining tables
- • Executing SQL using SPUFI
Unit 3 - Db2 objects (Storage groups, databases, and table spaces)
- • Object concepts
- • Storage Groups
- • Databases
- • Table Spaces
Unit 4 - Db2 Objects (Tables, indexes, and views)
- • Tables
- o Aliases
- • Table constraints
- o Primary key
- o Foreign key
- o Check
- o Referential integrity
- • Indexes
- • Views
- • Qualified names
- • Implicit object creation
Unit 5 - Utilities
- • Utility Categories
- • Load Utility
- • Check Data Utility
- • Unload Utility
- • Runstats Utility
- • Reorg Utility
Unit 6 - Commands and program preparation
- • Db2 Command Structure
- • Display Command
- • Archiving Logs
- • Stop and Start Commands
- • Executing Commands
- • Program Preparation
Unit 7 - The Db2 system
- • System Parameters (zParms)
- • Address Spaces
- • System Databases
- • Buffer Pools
- • Logging
- • Integrity
- • Security
Unit 8 - Db2 Shutdown, startup, and recovery
- • Start and Stop Commands
- • Db2 Shutdown Process
- • Db2 Startup Phases
- • System Recovery
- • Object Recovery
- • Copy Utility
- • Recover Utility
Appendix A - Demonstration solutions