loading

Mainframe: Code DB2 on COBOL Programs for Absolute Beginners

5,411 Enrolled Students

Course Features

Partner
Level
beginner
Start Date
Duration
1 year
Access
Full lifetime access
Certificate
Certificate of completion

Mainframe: Code DB2 on COBOL Programs for Absolute Beginners

5,411 Enrolled Students

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 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:

  • 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.

Instructors

About the instructor

Sandeep Kumar

My name is Sandeep Kumar. I have more than 12 years of experience on Mainframe and Technologies like Python, Java, PHP, Perl, Regular Expressions, JavaScript and much more. I have more than 12 years of experience as an Instructor.

I completed my Bachelor of Technology(B-Tech) in Computer Science and Master of Technology(M-Tech) in Software Application and Development from Vellore Institue of Technology(VIT).

Currently, i am the Founder of a Training company in India which provides online training on multiple IT and Non-IT related courses.

Before starting my career as an Instructor, I have worked for all types of projects like Development, Maintenance and Support projects. In my career, i have worked on Mainframe with Java, Mainframe with Perl(Regular Expressions), Mainframe with PHP, Mainframe with Unix, Python, PHP, and so on. I worked for multiple Fortune 500 companies of the world including  Fortune 1 company of the world which is a major retail giant in USA. When i was working for them, I  was part of the team which use to monitor more than 5000 stores across the world using Mainframe.

I used Mainframe in various sectors like Retail, Insurance, Banking and Share market. I have worked on many projects end to end. I am also an experienced person in Website Development as well.

I am an Expert on Mainframe(TSO/ISPF, JCL, VSAM, Cobol, DB2, CICS, IMS, PL1). Along with Mainframe, I am an IT consultant for Big Data, Cloud Computing, Complete Web Development(Java, PHP, Python, and much more)

I know 3 major language – English, French and Hindi. I have taught multiple students on French as well.

Reviews

Student feedback

0

Course Rating
5
0
4
0
3
0
2
0
1
0

Related Courses

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 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:

  • 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.