Contact Us info@learnquest.com
Up to 30% off Virtual Classes Through May 31! Use promo code Virtual30 when registering.
??WelcomeName??

BROWSE CATALOG

??WelcomeName??
    Training
|
    Solutions
|
    Company
|
    Offers
| |
Contact Us 877-206-0106 |
LearnQuest is the top Global Training Provider for some of the world's biggest brands.

Login

Please enter your Username and Password

New User? Register Here >

Request Information

Please Complete this form and Click Submit

By submitting this form, I agree to LearnQuest's Terms and Conditions

photo

Thank you for your interest in LearnQuest.

Your request is being processed and LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.

photo

Thank you for your interest in Private Training.

We look forward to helping you develop the perfect training solution to help you meet your company's goals.

For immediate assistance, speak with one of our representatives using the chat module below. Otherwise, LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.

photo

Thank you for your interest in LearnQuest!

Now, you will be able to stay up-to-date on our latest course offerings, promotions, and training discounts. Watch your inbox for upcoming special offers.

Categories IBM Db2 Essentials

z/OS and DB2 Basics for DB2 for z/OS DBA Beginners

IBM Business Partner

Course #: CV041G
Duration: 40 Hours
Price: 4,185.00 USD
Prices reflect a 20% discount for IBM employees
 GSA Public Price: ??gsa-public-price??
GSA Private/Onsite Price: ??gsa-private-price??
For GSA pricing, go to GSA Advantage! Delivery Formats
Material: LearnGreen (pdf)

IBM Certification Badge IBM
Certified
IT Management, Business

Delivery Formats

 

Classroom Schedule

Virtual Schedule Virtual Training Facts

Close

Guaranteed To Run
Location Distance
Delivered By
Language
Date
Price
Unfilter
Date
Price
Loc

Language
GTR
Washington DC (21 mi)
LearnQuest
English
8-Jun to 12-Jun
9AM - 5PM
4,185.00 USD
ENROLL
8-Jun to 12-Jun
4,185.00 USD
Washington DC
LearnQuest
Enroll
English
Philadelphia PA (140 mi)
LearnQuest
English
8-Jun to 12-Jun
9:00 ETAM - 5:00 ETPM
4,185.00 USD
ENROLL
8-Jun to 12-Jun
4,185.00 USD
Philadelphia PA
LearnQuest
Enroll
English

Not seeing what you want? Contact us

View our Global Training Schedule

Not seeing what you want? Contact us

View our Global Training Schedule

Classroom Schedule

Virtual Schedule

Close

 

There are no virtual classes on the schedule in your country. There are no public classes currently scheduled in your country.
View our global class schedule
This course is available in private, mentoring or e-learning options.

Complete this form, and a Training Advisor will be in touch with you shortly to address your training needs.

 

By submitting this form, I agree to LearnQuest's Terms and Conditions

View our Global Training Schedule

??elearning-section??

Request Private Training

Delivery Formats

Close

Tell us a little about yourself:

By submitting this form, I agree to LearnQuest's Terms and Conditions

All Courses Backed by the LearnQuest 100% Satisfaction Guarantee

Course Description

IBM Certification Badge

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

The course materials cover DB2 11 for z/OS.



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

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.

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

  • (00:30) Welcome
  • (01:00) Unit 1: Introduction
  • (01:30) Unit 2: TSO/E and ISPF
  • (01:00) Exercise 1: TSO and ISPF
  • (00:15) Exercise 1 Review
  • (01:00) Unit 3: Data Sets (Data Sets and Sequential Data Sets)
  • (01:00) Exercise 2: Sequential Data Sets
  • (00:15) Exercise 2 Review

Day 2

  • (01:00) Unit 3: Data Sets (Partitioned Data Sets)
  • (01:00) Exercise 3: Partitioned Data Sets
  • (00:15) Exercise 3 Review
  • (00:45) Unit 3: Data Sets (VSAM Data Sets)
  • (00:30) Exercise 4: VSAM Data Sets
  • (00:15) Exercise 4 Review
  • (01:30) Unit 4: JCL and SDSF
  • (01:30) Exercise 5: JCL and SDSF
  • (00:15) Exercise 5 Review

Day 3

  • (01:15) Unit 5: DB2 Relational Database Concepts
  • (01:15) Unit 6: Structured Query Language (SQL) and SPUFI
  • (00:45) Exercise 6: SQL and SPUFI
  • (00:15) Exercise 6 Review
  • (01:30) Unit 7: DB2 Objects (Databases and Table Spaces)
  • (00:45) Exercise 7: Databases and Table Spaces
  • (00:15) Exercise 7 Review
  • (01:30) Unit 7: DB2 Objects (Tables, Indexes, and Views)
  • (00:45) Exercise 8: Tables, Indexes, and Views
  • (00:15) Exercise 8 Review

Day 4

  • (01:00) Unit 7: DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements)
  • (00:30) Exercise 9: Qualified Names, Implicit Object Creation, and SQL Statements
  • (00:15) Exercise 9 Review
  • (01:30) Unit 8: The DB2 System
  • (00:45) Exercise 10: The DB2 System
  • (00:15) Exercise 10 Review
  • (02:00) Unit 9: DB2 Commands and Program Preparation
  • (00:45) Exercise 11: DB2 Commands
  • (00:15) Exercise 11 Review

Day 5

  • (02:00) Unit 10: DB2 Utilities
  • (01:00) Exercise 12: DB2 Utilities
  • (00:15) Exercise 12 Review
  • (01:15) Unit 11: DB2 Shutdown, Startup, and Recovery
  • (00:45) Exercise 13: DB2 Recovery
  • (00:15) Exercise 13 Review
  • (00:30) Unit 12: Course Summary

Badges

When you complete the Instructor-Led version of this course, you will be eligible to earn an IBM Training Badge that can be displayed on your website, business cards and social media channels to demonstrate your mastery of the skills you learned here.
IBM Certification Badge
 

Reviews

We Guarantee You'll be Satisfied

At LearnQuest, our goal is always the same: to provide the highest quality training and service to each and every customer.

If you’re not satisfied for any reason, simply contact one of our Training Advisors for assistance with your concerns.

Enrollment Options

Select the Training Provider you would like to use

Already have an account?

Enroll with LearnQuest >

Enroll with Our Partner >

You will be leaving the LearnQuest Website

*If using Apple Training Credits or LearnPass, you must enroll with LearnQuest

Stay up-to-date with LearnQuest training opportunities and events

Contact Us

Toll Free 877-206-0106
 Telephone 610-206-0101
 Email info@learnquest.com

Follow Us

Training

Solutions

Company

©LearnQuest, Inc. | Terms of Service | Knowledge Base | Country: United States
heres the new schedule
This website uses third-party profiling cookies to provide services in line with the preferences you reveal while browsing the Website. By continuing to browse this Website, you consent to the use of these cookies. If you wish to object such processing, please read the instructions described in our Privacy Policy.