Learn Basic DB2 on Mainframe for Beginners

Understand the DDL and DML operations on DB2.
Learn Basic DB2 on Mainframe for Beginners
File Size :
1.12 GB
Total length :
1h 42m

Category

Instructor

Sandeep Kumar

Language

Last update

Ratings

4.4/5

Learn Basic DB2 on Mainframe for Beginners

What you’ll learn

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.

Learn Basic DB2 on Mainframe for Beginners

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

Overview

Section 1: Introduction

Lecture 1 Introduction to DB2

Lecture 2 Important update

Lecture 3 Types of Operations in DB2

Lecture 4 Hierarchy of DB2

Lecture 5 Data Types in DB2

Section 2: DDL operations on DB2

Lecture 6 Create a Table in DB2

Lecture 7 Create a View

Lecture 8 Alter a Table

Lecture 9 Drop a Table

Section 3: DML operations on DB2

Lecture 10 Insert Records in table

Lecture 11 Select record from Table – Part1

Lecture 12 Select record from Table – Part2

Lecture 13 Select Record From Table – Part3

Lecture 14 Select Record From Table – Part4

Lecture 15 Select Record From Table – Part5

Lecture 16 Update a Table

Lecture 17 Delete Records from table

Lecture 18 Bonus Lesson: Let us stay connected

Anyone who wants to learn DB2 on Mainframe can enroll for this course.

Course Information:

Udemy | English | 1h 42m | 1.12 GB
Created by: Sandeep Kumar

You Can See More Courses in the Developer >> Greetings from CourseDown.com

New Courses

Scroll to Top