1. Relational Database Management System Concepts
2. Data Objects
3. System Objects
4. Structured Query Language (SQL)

1. Categories Of SQL
2. Retrieving Data with DDL/DML/DCL
3. Working with Tables and Modifying Data
4. Working with Tables and Modifying Data
5. Joins & Sub queries
6. Unions

1. Basic of Coding SQL in an Application program
2. Generating Declarations for Tables using DCLGEN
3. Embedding SQL statements in Host Languages
4. Program preparation
5. Plan/package/Bind parameters
6. Singleton Select

1. Embedding SQL statements in Host Languages
2. Singleton Select
3. Using insert/update/delete using Singleton select
4. Using Null indicator in Application
5. Bind parameters
6. Importance of levels

1. Coding Dynamic SQL in Application Programs
2. Lock implementation
3. Implementing cursor techniques in Application
4. For fetching more rows

1. Triggers
2. Performance tuning
3. Using Explain function to improve performance
4. Stored Procedures
5. Other Utilities
6. To Understand the DB2 related Utilities and Miscellaneous

Review of DB2