Mainframe Db2 Developer Course 1

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

Homepage

https://www.udemy.com/course/mainframe-db2-developer-course-1/

Mainframe Db2 Developer Course 1 Fast Download
Mainframe Db2 Developer Course 1 Full Download