Objectives
On successful completion of this course, attendees will
be able to:
- describe the relational concepts and theory, and the advantages of a RDBMS
- describe the components of the DB2 system, their function, and how they are controlled
- identify the objects used to store DB2 data and the relationships between them
- code the SQL statements needed to create and modify DB2 data objects, and control access to them
- code SQL statements to read and modify DB2 data and interrogate the DB2 catalog
- describe and fully utilise all the functions available with DB2
Interactive (DB2I)
- use online utilities to backup and restore data, and perform other data management tasks
- describe the use of stand-alone utilities and identify situations where they may be required.
Who Should Attend
All IT professionals who need to understand and work with the DB2 UDB for z/OS.
Prerequisites
A basic understanding of IT, with some exposure to database technology as a user. Whilst not essential, a knowledge of TSO/ISPF would be beneficial.
Duration
2 days
Fee
£825 (ex. VAT)
Course Code
DC |
|
Contents
DBMS overview
What is a database?; comparison of hierarchical, network & relational database management systems; a brief history of DB2.
This segment compares and contrasts the RDBMS with other database methodologies.
Relational theory & concepts
Relational theory; relational model; relational algebra; entity, referential and user-defined integrity.
This segment discusses the relational theory, and DB2’s adherence to it.
DB2 system and operations
DB2 address spaces; DB2 attachments; storage pools; logging methodology; basic operations; DB2 commands.
This segment introduces the main components of the DB2 system, and how they are controlled.
DB2 Interactive (DB2I)
DB2I panels; SPUFI; other functions.
This segment introduces DB2I and explains the various functions it provides.This segment introduces the main components of the DB2 system, and how they are controlled.
DB2 data objects
DB2 objects and the relationships between them; DB2 catalog & directory;
interrogating the DB2 catalog.
This segment describes the main components used in DB2 data storage, and explains the need for and use of the DB2 catalog and directory databases
Introduction to SQL
Data Definition Language; Data Manipulation Language; Data Control Language; basic SQL SELECT, INSERT, UPDATE & DELETE statements; COMMIT and ROLLBACK processing; DB2 optimizer.
This segment introduces SQL and gives examples of the most commonly used syntax
Managing DB2 data with utilities
On-line utilities; stand-alone utilities; invoking and controlling utilities.
This segment introduces the utility jobs provided with DB2 and demonstrates their use in managing DB2 data.
Hands-on exercises
Using DB2I to code and execute SQL; Interrogating the DB2 catalog; using utilities to back-up and recover DB2 data; issuing DB2 commands.
These exercises are designed to reinforce understanding of the topics covered.
|
