Opleidingen

Opleiding: Introduction to DB2 for zOS for Systems and Operations Personnel [TDS_CV021G]

OVERVIEW

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

- DB2 Objects
- Structured Query Language
- DB2 Commands
- DB2 Utilities
- DB2 Logging
- DB2 Program Preparation

The course materials cover DB2 11 for z/OS.

Virtueel en Klassikaal™

Virtueel en Klassikaal™ is een eenvoudig leerconcept en biedt een flexibele oplossing voor het volgen van een klassikale training. Met Virtueel en Klassikaal™ kunt u zelf beslissen of u een klassikale training virtueel (vanuit huis of kantoor )of fysiek op locatie wilt volgen. De keuze is aan u! Cursisten die virtueel deelnemen aan de training ontvangen voor aanvang van de training alle benodigde informatie om de training te kunnen volgen.

OBJECTIVES

After this course participants should be able to:

  • 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 course is for beginning DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment.

CERTIFICATION

None

NEXT STEP

None

CONTENT

Course Content

  • z/OS Prerequisite Review
  • 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:15) Welcome
  • (00:30) Unit 1: z/OS Prerequisite Review
  • (00:10) Exercise 1: Connecting to z/OS and Creating Data Sets
  • (00:05) Exercise 1 Review
  • (01:15) Unit 2: DB2 Relational Database Concepts
  • (01:15) Unit 3: Structured Query Language (SQL) and SPUFI
  • (00:45) Exercise 2: SQL and SPUFI
  • (00:15) Exercise 2 Review
  • (01:30) Unit 4: DB2 Objects (Databases and Table Spaces)
  • (00:45) Exercise 3: Databases and Table Spaces
  • (00:15) Exercise 3 Review
  • (01:30) Unit 4: DB2 Objects (Tables, Indexes, and Views)

Day 2

  • (00:45) Exercise 4: Tables, Indexes, and Views
  • (00:15) Exercise 4 Review
  • (01:00) Unit 4: DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements)
  • (00:30) Exercise 5: Qualified Names, Implicit Object Creation, and SQL Statements
  • (00:15) Exercise 5 Review
  • (01:30) Unit 5: The DB2 System
  • (00:45) Exercise 6: The DB2 System
  • (00:15) Exercise 6 Review
  • (02:00) Unit 6: DB2 Commands and Program Preparation

Day 3

  • (00:45) Exercise 7: DB2 Commands
  • (00:15) Exercise 7 Review
  • (02:00) Unit 7: DB2 Utilities
  • (01:00) Exercise 8: DB2 Utilities
  • (00:15) Exercise 8 Review
  • (01:15) Unit 8: DB2 Shutdown, Startup, and Recovery
  • (00:45) Exercise 9: DB2 Recovery
  • (00:15) Exercise 9 Review
  • (00:30) Unit 9: Course Summary
Meer...
€2.550
ex. BTW
Aangeboden door
Global Knowledge Network Netherlands B.V.
Onderwerp
IBM Db2
Database ontwerp / design
Niveau
Looptijd
3 dagen
Taal
nl
Type product
cursus
Lesvorm
Klassikaal
Aantal deelnemers
Max: 16
Tijdstip
Overdag
Tijden en locaties
TDS UK Virtual Training English
ma 9 nov. 2026
TDS UK Virtual Training English
ma 15 feb. 2027
TDS UK Virtual Training English
ma 17 mei 2027
Keurmerken aanbieder
Cedeo
CRKBO en BTW-vrijstelling
VOI
EXIN
ISO register
Microsoft Learning Partner
VMWare Partner
Oracle Education Partner
AgilePM - Agile Project Management (APMG)
ASL