Detailed Course Outline
CONTENTS :
- Introduction
- TSO/E and ISPF
- Data Sets
- JCL and SDSF
- DB2 Relational Database Concepts
- Structured Query Language (SQL) and SPUFI
- DB2 Objects
- The DB2 System
- DB2 Commands and Program Preparation
- DB2 Utilities
- DB2 Shutdown, Startup, and Recovery
- Course Summary
AGENDA :
Day 1
- (00:30) Welcome
- (01:00) Unit 1: Introduction
- (01:30) Unit 2: TSO/E and ISPF
- (01:00) Exercise 1: TSO and ISPF
- (00:15) Exercise 1 Review
- (01:00) Unit 3: Data Sets (Data Sets and Sequential Data Sets)
- (01:00) Exercise 2: Sequential Data Sets
- (00:15) Exercise 2 Review
Day 2
- (01:00) Unit 3: Data Sets (Partitioned Data Sets)
- (01:00) Exercise 3: Partitioned Data Sets
- (00:15) Exercise 3 Review
- (00:45) Unit 3: Data Sets (VSAM Data Sets)
- (00:30) Exercise 4: VSAM Data Sets
- (00:15) Exercise 4 Review
- (01:30) Unit 4: JCL and SDSF
- (01:30) Exercise 5: JCL and SDSF
- (00:15) Exercise 5 Review
Day 3
- (01:15) Unit 5: DB2 Relational Database Concepts
- (01:15) Unit 6: Structured Query Language (SQL) and SPUFI
- (00:45) Exercise 6: SQL and SPUFI
- (00:15) Exercise 6 Review
- (01:30) Unit 7: DB2 Objects (Databases and Table Spaces)
- (00:45) Exercise 7: Databases and Table Spaces
- (00:15) Exercise 7 Review
- (01:30) Unit 7: DB2 Objects (Tables, Indexes, and Views)
- (00:45) Exercise 8: Tables, Indexes, and Views
- (00:15) Exercise 8 Review
Day 4
- (01:00) Unit 7: DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements)
- (00:30) Exercise 9: Qualified Names, Implicit Object Creation, and SQL Statements
- (00:15) Exercise 9 Review
- (01:30) Unit 8: The DB2 System
- (00:45) Exercise 10: The DB2 System
- (00:15) Exercise 10 Review
- (02:00) Unit 9: DB2 Commands and Program Preparation
- (00:45) Exercise 11: DB2 Commands
- (00:15) Exercise 11 Review
Day 5
- (02:00) Unit 10: DB2 Utilities
- (01:00) Exercise 12: DB2 Utilities
- (00:15) Exercise 12 Review
- (01:15) Unit 11: DB2 Shutdown, Startup, and Recovery
- (00:45) Exercise 13: DB2 Recovery
- (00:15) Exercise 13 Review
- (00:30) Unit 12: Course Summary