mainframe db2

• Course Overview
• Course Content
• Customer Reviews

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. Understand the DB2 Environment Learn about relational database concepts how to physically implement a logical database design using DDL, Learn about data studio and its installation Learn Db2 servers,clients and drivers

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

---

---

---

...more