Learn Basic DB2 on Mainframe for Beginners

Understand the DDL and DML operations on DB2.
Rating: 4.1 out of 5 (365 ratings)
6,479 students
Learn Basic DB2 on Mainframe for Beginners
Rating: 4.1 out of 5 (365 ratings)
6,476 students
Students will be able to create tables and views. By the end of the course, students will be able to perform the basic the DDL and DML operations in DB2.

Requirements

  • You have a Mainframe connection or a Mainframe Id to practice DB2
  • You must know basic TSO/ISPF commands.
Description

Note:

This Course is NOT a DB2 DBA COURSE and is not related to Database administration. 

The Course provides the basic introduction to DB2 and trains on the DML operations on 

Mainframe. Most of the DDL operations on DB2 are carried out by DB2 DBA and this course 

gives a brief introduction of DDL operations which Mainframe Developer should be aware of.

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). Major DML operations are also covered. Please do not worry, if you do not know what is DDL and what is DML. This is covered in the course.

Which topics are covered in this Course?

  • This Course Covers all DML operations  for Mainframe Developers.
  • Students will get trained on how to create a table, view and index.
  • The Course teaches you - How to Insert records into table, update records, select the records from the table


Who this course is for:
  • Anyone who wants to learn DB2 on Mainframe can enroll for this course.
Course content
3 sections • 17 lectures • 1h 41m total length
  • Introduction to DB2
    02:23
  • Types of Operations in DB2
    05:06
  • Hierarchy of DB2
    05:17
  • Data Types in DB2
    07:25
  • Create a Table in DB2
    11:31
  • Create a View
    05:54
  • Alter a Table
    05:38
  • Drop a Table
    03:18
  • Insert Records in table
    13:01
  • Select record from Table - Part1
    09:06
  • Select record from Table - Part2
    07:31
  • Select Record From Table - Part3
    11:47
  • Select Record From Table - Part4
    02:50
  • Select Record From Table - Part5
    02:46
  • Update a Table
    04:23
  • Delete Records from table
    03:17
  • Bonus Lesson: Let us stay connected
    00:34

Instructor
Founder of a Training company. IT Consultant, Coach, Mentor
Sandeep Kumar
  • 4.8 Instructor Rating
  • 2,505 Reviews
  • 15,533 Students
  • 8 Courses

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

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

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 and much more)

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