mainframe db2

Course Overview

Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on mainframe db2 which gives you the opportunity to interact with a mainframe db2 instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content

Basics of SQL - the Relational Language

SQL Queries

Comparison operators and multiple conditions

Null data characteristics and selecting null data

IN, BETWEEN, LIKE and negation in WHERE clauses

ORDER BY and SELECT DISTINCT clauses

Using calculated values in a SELECT and WHERE clause

GROUP BY and HAVING clauses

Column functions

Scalar functions

Joins

UNION and UNION ALL

Sub select

Using arithmetic with time and date data

INSERT, DELETE and UPDATE statements

Creation of View, Synonym and Alias

DB2 for z/OS overview of the application program environment

DB2 OBJECTS (create TABLE, SYNONYM, VIEW)

Program Preparation

CURSOR processing

DB2 OBJECTS (Referential Integrity, INDEXES)

Dynamic SQL

STORED PROCEDURES concepts

DB2 for z/OS Security for application programmers

DB2 for z/OS Performance for the application programmer

DB2 APPLICATION PROGRAMMING

Customer Reviews

Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.

-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional.
I am quite satisfied with the course.