Mainframe Code DB2 on COBOL Programs for Absolute Beginners
What you’ll learn
Create and Execute COBOL DB2 Programs with Ease
Master the concepts of Cursor
Develop and Design their own tables using DDL operations on Mainframe
Students will be able to perform all DML operations like INSERT, UPDATE, DELETE and SELECT on table.
Maximize the knowledge on SQL operations
Students will be trained to create Indexes and Keys
Requirements
You must have a Mainframe id to practice DB2 on Mainframe
You should know the basics of TSO/ISPf, JCL and COBOL. If not, I recommend you to enroll for “Mainframe: The Complete TSO/ISPF Course from Beginner to Expert”, “Mainframe: The Complete JCL Course from Beginner to Expert” and “Mainframe: The Complete COBOL Course from Beginner to Expert” first and then enroll for this course.
Description
Note:——————————————————————————————————————————— This Course is NOT a DB2 DBA COURSE and is not related to Database Administration ——————————————————————————————————————————— Why should I Learn DB2 on Mainframe?Most of the projects on IBM Mainframe require DB2 Knowledge. Most of the Projects use COBOL DB2 Programs.If you know DB2, it adds value to your career and resume.Is this Course for DB2 DBA?No, this Course is for Developers who work on IBM Mainframe. This Course covers primary DDL operations from the developers’ point of view(not DBA’s), DML Operations, Keys, Index, and executing COBOL DB2 Programs.Does this course cover any CICS?Currently, this course does not cover any topic related to CICS. What makes this Course unique and a Best Seller?Well, the course has everything you need to get started with DB2 on COBOL. If you want to build a career in Mainframe, DB2 is a ‘MUST HAVE’ skill and this is the starting point of Mainframe.There’s no risk involved in taking this Course!This course comes with a 30-day money-back guarantee. I am sure that this is the best course on JCL and you can compare the content which is provided in this course against any DB2 Course I guarantee you that you will not get such good structured content anywhere. Still, if you are not completely satisfied with the course, please let us know and we will provide a refund without asking any questions.What if you are stuck?I personally answer all the questions which are asked here. If you are stuck anywhere, ask a question or you can message me directly and I will answer all your doubts.Are you getting updated content?Yes, I keep updating the content always to make sure, i provide all the information to my students.Which topics are covered in this Course? This Course Covers DB2 operations on COBOL programs for Mainframe Developers.Students will get trained on how to execute a COBOL DB2 Program.The concept of DB2 cursors is covered in detail.Major DDL and DML operations are illustrated with lots of examples.The concept of Keys and Indexes are covered with examples.Note:To understand the complete Mainframe, a professional must have DB2 skills on the Mainframe server. Most of the Mainframe projects will have DB2 in them.
Overview
Section 1: Introduction
Lecture 1 Introduction to DB2
Lecture 2 Important information about this Course
Lecture 3 About Mainframe id
Lecture 4 Types of SQL Operations in DB2
Lecture 5 Hierarchy of DB2
Lecture 6 Data Types in DB2
Section 2: DDL Operations
Lecture 7 Create a Table
Lecture 8 Create Views
Lecture 9 Alter Table
Lecture 10 Drop a Table
Section 3: DML Operations
Lecture 11 Insert records in Table
Lecture 12 Select Records from Table – Part 1
Lecture 13 Select Records from Table – Part 2
Lecture 14 Select Records from Table – Part 3
Lecture 15 Select Records from Table – Part 4
Lecture 16 Select Records from Table – Part 5
Lecture 17 Update a Table
Lecture 18 Delete Records from table
Section 4: Keys and Index
Lecture 19 Unique Key
Lecture 20 Unique Index
Lecture 21 Primary Key
Lecture 22 What is NULL, NOT NULL and DEFAULT
Lecture 23 Referential Integrity
Lecture 24 Lets code an example to understand Referential Integrity
Section 5: Code COBOL DB2 Program to Perform DB2 operations in COBOL
Lecture 25 Steps to Create COBOL DB2 Program – Part 1
Lecture 26 Steps to Create COBOL DB2 Program – Part 2
Lecture 27 Another JCL To Precompile, Compile & Link Edit
Lecture 28 JCLS used to execute the COBOL DB2 Program in this course
Lecture 29 Various Parameters used in Bind Process
Lecture 30 Structure of COBOL DB2 Programs
Lecture 31 Lets code a COBOL DB2 Program to perform DB2 operations
Lecture 32 Code Program 1 for DML operation
Lecture 33 Code Program 2 for DML operation
Lecture 34 Code Program 3 for DML operation – Part 1
Lecture 35 Code Program 3 for DML operation – Part 2
Section 6: Lets do a project on COBOL DB2 Program
Lecture 36 Description of the Project
Lecture 37 Prepare before coding COBOL DB2 Program
Lecture 38 Structure of the COBOL DB2 Program for the Project
Lecture 39 Execute the Program for the Project
Section 7: Handling an unknown missing value in COBOL DB2
Lecture 40 Lets understand what is unknown missing value in DB2
Lecture 41 Let us Code an Indicator to show the missing unknown value
Lecture 42 Let us master how to process the unknown value
Section 8: How to process multiple Records in DB2
Lecture 43 Problem analysis – How to process multiple records from a Table
Lecture 44 Let us process multiple records in the table through COBOL DB2 Program
Lecture 45 How to update the current record after the fetching of the records
Lecture 46 Bonus Lesson : Let us stay connected
Mainframe programmer who knows basics of TSO/ISPF, JCL and Cobol,Anyone who wants to learn DB2 on COBOL. This course is not for DB2 DBA but for Mainframe programmers.,The SQL commands learned using DB2 will work similarly on other tools like Oracle, MySql, Ms Sql server, postgresql, sqlite, etc. Of course, logic will be same but few exceptions can be there
Course Information:
Udemy | English | 5h 36m | 3.90 GB
Created by: Sandeep Kumar
You Can See More Courses in the Developer >> Greetings from CourseDown.com