Search for Training

mainframe db2

Have Queries? Ask us +91 72592 22234

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

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

What is the sum of 2 + 8? (security question)

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234

Subscribe to our weekly newsletter