Quick Overview
Job Description
Course Outline
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
Views
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
Skills
Similar jobs
Product Trainer/Tech Writer - Level 2 or 3 with Security Clearance
Northrop Grumman · Boulder, United States
4 hours ago$85.6k - $128.4k/yrCA Vision to COBOL Migration Consultant (Trainer)
Maintec Technologies Inc · United States
YesterdayProduct & Sales Enablement Trainer
ManhattanLife Insurance and Annuity Company · Houston, United States
YesterdaySales Trainer (Field Instructor) - Bilingual
Canon U.S.A., Inc. · Irving, United States
Yesterday$54.5k - $81.5k/yrAutomotive Technical Trainer/Instructor
Asbury Automotive Group · Roswell, United States
YesterdayProduct Management Trainer
Venusgeo · Fort Worth, United States
Yesterday