Mainframe Db2 Developer Course 1

DB2, DB2 on Z/OS

What you'll learn

Introduction to DB2

DB2 Objects

DB2 Components: SSAS,DBAS,DDF,SPAS,IRLM

Data types in DB2

Executing SQL commands thru QMF tool

Executing SQL commands thru SPUFI tool

Create table command, Primary key, Unique Index

INSERT,SELECT,UPDATE and Delete commands

SELECT Command: Where, Group By,Order By and Having,Like,Where , *

Joins in DB2

Subqueries in DB2

Requirements

Mainframe basics

Description

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 DB2Understanding DB2 ObjectsExploring DB2 ComponentsStudying Datatypes in DB2Executing SQL Commands in QMFExecuting SQL Commands in SPUFILearning CREATE TABLE CommandMastering INSERT CommandUnderstanding UPDATE CommandImplementing DELETE CommandExecuting SELECT CommandCreate table with Primary keyCreate table with Composite keyCreate table with referential integrityDiscussed on few SQL commands like -105, -206,-204,-180,-181, -540 and etc.Joins in DB2Inner joinLeft outer joinRight outer joinFull outer joinSub-queriesThe 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.

Overview

Section 1: Introduction to DB2, DB2 Objects, DB2 Components,Intro to QMF,SPUFI, Datatypes

Lecture 1 Introduction to DB2, Differences between Files and DB2

Lecture 2 What is Object in DB2 and Different types of DB2 Objects

Lecture 3 DB2 Architecture components: SSAS, DBAS, IRLM,SPAS,DDF

Lecture 4 Detailed discussion about DB2 Objects Storage, Database,TableSpace objects

Lecture 5 Datatypes in DB2

Lecture 6 Executing SQL commands in QMF

Lecture 7 Executing SQL commands in SPUFI, Creation of TABLE,UNIQUE Index

Lecture 8 INSER,SELECT,UPDATE,DELTETE commands execution in SPUFI

Lecture 9 Primay key and Unique index in DB2

Lecture 10 What is Composite key? and Demo on Composite key

Lecture 11 Demo on Referential Integrity

Section 2: Different options in SELECT command: Where, GROUP BY, HAVING,LIKE,AND,ORDER BY

Lecture 12 Select Command and Different options in SELECT command - Part 1 video

Lecture 13 Select Command and Different options in SELECT command - Part 2 video

Section 3: Joins in DB2

Lecture 14 Demo on Different types of joins

Section 4: Subqueries in DB2

Lecture 15 Subqueries in DB2

Beginners who are learning DB2 first time