Curriculum
- 1 Section
- 9 Lessons
- 24 Hours
Expand all sectionsCollapse all sections
- Topics9
- 1.1Preface Course Overview Intended Audience Course Objectives Prerequisites
- 1.2Unit 1 – Db2 Relational database concepts Relational Database design Data access Interacting with Db2 Catalog and directory
- 1.3Unit 2 – SQL and SPUFI SQL SELECT statement review SQL INSERT, UPDATE, DELETE review SQL COMMIT and ROLLBACK review Joining tables Executing SQL using SPUFI
- 1.4Unit 3 – Db2 objects (Storage groups, databases, and table spaces) Object concepts Storage Groups Databases Table Spaces
- 1.5Unit 4 – Db2 Objects Tables Indexes Views
- 1.6Unit 5 – Utilities Utility Categories Load Utility Check Data Utility Unload Utility Runstats Utility Reorg Utility
- 1.7Unit 6 – Commands and program preparation Db2 Command Structure Display Command Archiving Logs Stop and Start Commands Executing Commands Program Preparation
- 1.8Unit 7 – The Db2 system System Parameters (zParms) Address Spaces System Databases Buffer Pools Logging Integrity Security
- 1.9Unit 8 – Db2 Shutdown, startup, and recovery Start and Stop Commands Db2 Shutdown Process Db2 Startup Phases System Recovery Object Recovery Copy Utility Recover Utility
Unit 1 – Db2 Relational database concepts Relational Database design Data access Interacting with Db2 Catalog and directory
Next