Mainframe DB2 Developer Course 1

In the comprehensive Mainframe DB2 developer curriculum, the initial segment focuses on fundamental concepts. This includes an introduction to DB2, exploration of DB2 objects and components, as well as an in-depth study of datatypes within the DB2 environment. Students will gain practical experience in executing SQL commands using both QMF and SPUFI interfaces, covering essential operations such as CREATE TABLE, INSERT, UPDATE, DELETE, SELECT commands, Join concepts, Sub queries. The subsequent course delves into the integration of DB2 functionalities within COBOL programs, providing learners with hands-on training in implementing DB2 features in COBOL applications.

Topics covered:

• Introduction to DB2

• Understanding DB2 Objects

• Exploring DB2 Components

• Studying Datatypes in DB2

• Executing SQL Commands in QMF

• Executing SQL Commands in SPUFI

• Learning CREATE TABLE Command

• Mastering INSERT Command

• Understanding UPDATE Command

• Implementing DELETE Command

• Executing SELECT Command

• Create table with Primary key

• Create table with Composite key

• Create table with referential integrity

• Discussed on few SQL commands like -105, -206,-204,-180,-181, -540 and etc.

• Joins in DB2

  • Inner join

  • Left outer join

  • Right outer join

  • Full outer join

• Sub-queries

The topics outlined above are thoroughly explored on the Mainframe server to facilitate better comprehension and practical knowledge acquisition. Through both Course 1 and Course 2, students will engage in hands-on learning experiences that reinforce their understanding of DB2 concepts and their application within the Mainframe environment.