IBM Introduction to DB2 for z/OS for Systems and Operations Personnel
- Código del Curso CV021G
- Duración 3 días
Otros Métodos de Impartición
Método de Impartición
Este curso está disponible en los siguientes formatos:
-
Cerrado
Cerrado
-
Clase de calendario
Aprendizaje tradicional en el aula
-
Aprendizaje Virtual
Aprendizaje virtual
Solicitar este curso en un formato de entrega diferente.
Temario
Parte superiorDB2 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.
Learning Journeys or Training Paths that reference this course:
- Db2 for z/OS - Role: Database Administrator
- Db2 for z/OS - Role: System Administrator
- DB2 for z/OS
Calendario
Parte superiorDirigido a
Parte superiorThis 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.
Objetivos del Curso
Parte superior- 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
Contenido
Parte superiorCONTENTS:
- z/OS Prequisite 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
Pre-requisitos
Parte superiorYou should have a working knowledge of
- z/OS, TSO, ISPF, and SDSF
- sequential, partitioned, and VSAM data sets
- and basic JCL
- /es-es/-/media/global-knowledge/merchandising/right-side-column/es/250x600--training-subscriptions_es.jpg https://www.globalknowledge.com/es-es/training/suscripciones/gk-polaris?utm_source=website&utm_medium=banner&utm_campaign=webbanner #000000
- #000000
- CV021G
- IBM Introduction to DB2 for z/OS for Systems and Operations Personnel
- Gestión & Desarrollo de la Base de Datos
- CV021G | IBM Introduction to DB2 for z/OS for Systems and Operations Personnel | Training Course | IBM.
- IBM
