Loader
whatsapp

TRAINING

Enroll Now ibm-db2-training

Online Training

Corporate Training

ON Demand

IBM DB2 Training  

DB2 training is designed to store, analyze and retrieve the data efficiency. DB2 is a product from IBM.  DB is stands for Database. DB2 is the extensions with the help of object oriented features and non relational structures with XML. It is a relational Database management system.

Outline

DB2 11 for z/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of:

  • TSO/E and ISPF
  • Data sets
  • DB2 Objects
  • Structured Query Language
  • DB2 Commands
  • JCL and SDSF
  • DB2 Utilities
  • DB2 Logging
  • DB2 Program Preparation

Audience

This beginning DB2 basic course is for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment.

Prerequisites

There are no formal prerequisites for this course.

Course Objectives
  • Describe several services provided in a z/OS environment
  • Explain workloads in the batch environment
  • Explain workloads in the online environment
  • Describe job roles in a z/OS environment
  • Log On to TSO/E
  • Navigate TSO/E and ISPF
  • Use TSO commands
  • Setup and utilize JCL (Job Control Language)
  • Utilize SDSF
  • Describe the different types of data sets in a z/OS environment
  • Allocate data sets and list data set information and content
  • Create and modify data set content
  • Give an overview of the DB2 9 environment
  • Describe and utilize DB2 Objects
  • Describe and utilize several DB2 Utilities
  • Describe the DB2I (DB2 Interactive Facility) environment
  • Use SPUFI (SQL Processing Using File Input) to compose and execute SQL
  • Setup and execute DB2 Commands
  • Understand DB2 Logging
  • Describe DB2 program preparation process
  • Understand DB2 startup and shutdown
  • Understand and utilize DB2 recovery strategies
Key topics

CONTENTS

  • Introduction
  • TSO/E and ISPF
  • Data Sets
  • JCL and SDSF
  • DB2 Relational Database Concepts
  • Structured Query Language (SQL) and SPUFI
  • DB2 Objects
  • The DB2 System
  • DB2 Commands and Program Preparation
  • DB2 Utilities
  • DB2 Shutdown, Startup, and Recovery
  • Course Summary

AGENDA :

Day 1
  • Welcome
  • Introduction
  • TSO/E and ISPF
    1. TSO and ISPF
    2. Review
  • Data Sets (Data Sets and Sequential Data Sets)
    1. Sequential Data Sets
    2. Review
Day 2
  • Data Sets (Partitioned Data Sets)
    1. Partitioned Data Sets
    2. Review
  • Data Sets (VSAM Data Sets)
    1. VSAM Data Sets
    2. Review
  • JCL and SDSF
    1. JCL and SDSF
    2. Review
Day 3
  • DB2 Relational Database Concepts
  • Structured Query Language (SQL) and SPUFI
    1. SQL and SPUFI
    2. Review
  • DB2 Objects (Databases and Table Spaces)
    1. Databases and Table Spaces
    2. Review
  • DB2 Objects (Tables, Indexes, and Views)
    1. Tables, Indexes, and Views
    2. Review
Day 4
  • DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements)
    1. Qualified Names, Implicit Object Creation, and SQL Statements
    2. Review
  • The DB2 System
    1. The DB2 System
    2. Review
  • DB2 Commands and Program Preparation
    1. DB2 Commands
    2. Review
Day 5
  • DB2 Utilities
    1. DB2 Utilities
    2. Review
  • DB2 Shutdown, Startup, and Recovery
    1. DB2 Recovery
    2. Review

United Global Soft Key Features

Expert Instructors

Practical Implementation

Real- time Case Studies

Certification Guidance

Resume Preparation

Placement Assistance

Copyright 2018 © www.unitedglobalsoft.com . All right reserved | Sitemap | Privacy Policy | Terms Of Services