Mainframe: Code DB2 on COBOL Programs for Absolute Beginners
4.2 (338 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,870 students enrolled

Mainframe: Code DB2 on COBOL Programs for Absolute Beginners

Master the DDL and DML operations on DB2. Code multiple COBOL DB2 Programs. Master the concept of Cursors on DB2
4.2 (333 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,870 students enrolled
Created by Sandeep Kumar
Last updated 5/2020
English
English [Auto-generated]
Current price: $121.99 Original price: $174.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5.5 hours on-demand video
  • 4 articles
  • 7 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Course content
Expand all 45 lectures 05:36:03
+ Introduction
5 lectures 22:31
Important information about this Course
02:20
Hierarchy of DB2
05:17
Data Types in DB2
07:25
+ DDL Operations
4 lectures 26:21
Create Views
05:54
Alter Table
05:38
Drop a Table
03:18
+ DML Operations
8 lectures 54:41
Insert records in Table
13:01
Select Records from Table - Part 1
09:06
Select Records from Table - Part 2
07:31
Select Records from Table - Part 3
11:47
Select Records from Table - Part 4
02:50
Select Records from Table - Part 5
02:46
Update a Table
04:23
Delete Records from table
03:17
+ Keys and Index
6 lectures 53:00
Unique Key
05:51
Unique Index
06:40
Primary Key
10:35
What is NULL, NOT NULL and DEFAULT
10:28
Referential Integrity
04:32
Lets code an example to understand Referential Integrity
14:54
+ Code COBOL DB2 Program to Perform DB2 operations in COBOL
11 lectures 01:25:53
Steps to Create COBOL DB2 Program - Part 1
11:44
Steps to Create COBOL DB2 Program - Part 2
12:14
Another JCL To Precompile, Compile & Link Edit
00:17
JCLS used to execute the COBOL DB2 Program in this course
03:25
Various Parameters used in Bind Process
04:45
Structure of COBOL DB2 Programs
05:57
Lets code a COBOL DB2 Program to perform DB2 operations
14:02
Code Program 1 for DML operation
05:06
Code Program 2 for DML operation
08:18
Code Program 3 for DML operation - Part 1
05:04
Code Program 3 for DML operation - Part 2
15:01
+ Lets do a project on COBOL DB2 Program
4 lectures 33:32
Description of the Project
04:59
Prepare before coding COBOL DB2 Program
07:32
Structure of the COBOL DB2 Program for the Project
12:48
Execute the Program for the Project
08:13
+ Handling an unknown missing value in COBOL DB2
3 lectures 29:07
Lets understand what is unknown missing value in DB2
04:43
Let us Code an Indicator to show the missing unknown value
11:12
Let us master how to process the unknown value
13:12
+ How to process multiple Records in DB2
4 lectures 30:56
Problem analysis - How to process multiple records from a Table
07:12
Let us process multiple records in the table through COBOL DB2 Program
14:59
How to update the current record after the fetching of the records
08:15
Bonus Lesson : Let us stay connected
00:30
Requirements
  • You must have a Mainframe id to practice DB2 on Mainframe
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 requires DB2 Knowledge.
  • Most of the Projects uses 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 major DDL operations from developers point of view(not DBA's Point of view), DML Operations, Keys, Index and executing COBOL DB2 Programs.

Does this course covers any CICS?

At this moment, this course does not cover any topic related to CICS. 

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 are covered in detail.
  • Major DDL and DML operations are illustrated with lots of examples.
  • The concept of Keys and Indexes are covered with examples.
Who this course is for:
  • You must know basic TSO/ISPF commands. Basic knowledge on COBOL is required.