DB2 UNIVERSAL DATABASE

DB2 UNIVERSAL DATABASE

This online course aim to provide students undertaking this program with the strategies, skills and knowledge to successfully use all aspects of this program with the added benefit of inbuilt testing throughout the course if required. For all but a few courses students can apply for a results based certificate, ONLINE, at the completion of their course. It is necessary to complete all modules for a true result. It is not necessary to have the program installed on your computer to undertake the training.
It allows you to take the training and then decide if you wish to purchase this or another program. Please ask for a particular version if not stated. A list of modules covered in this course is available, if required, by making a request via email or phone.

Learn how to perform database administration tasks such as creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements with DB2 UDB for Linux.

+ PLANNING AND SECURING A DB2 UDB DATABASE - [209548_ENG]
+ ACCESSING DATA AND MANIPULATING DB2 UDB DATABASE OBJECTS - [209551_ENG]
+ MANIPULATING DATA WITH DB2 UDB - [209552_ENG]
+ MAINTAINING DB2 UDB DATA CONSISTENCY - [209553_ENG]

Learn how to perform database administration tasks such as creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements with DB2 UDB for Linux, UNIX, and Windows. Use an AIX operating system during hands-on labs.

Course Materials

The course materials address DB2 UDB for Linux, UNIX, and Windows Version 8.2.

Hands-On Labs

Nine labs are included to address DB2 UDB for Linux, UNIX, and Windows.

Certification

Prepare for IBM Certification Test 701: DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration

This is an intermediate course for database administrators and other technical individuals, who plan, implement, and maintain DB2 UDB for Linux, UNIX and Windows databases.


Skills Taught

--------------------------------------------------------------------------------

List and describe the components of DB2 UDB
Implement DB2 security
Perform basic administration of a DB2 database system
Define a basic DB2 recovery strategy and perform the tasks necessary to support the strategy
Describe the application development process with respect to DB2 considerations


Course outline

--------------------------------------------------------------------------------

Overview of DB2 UDB

list the DB2 family of products
identify the DB2 UDB products
describe the functions of DB2 components
compare DB2 packaging options and product requirements
list DB2 supported configurations
Getting started with DB2 UDB Graphical User Interface (GUI)

list the GUI tools in DB2 UDB
explore the various ways to access the GUI tools
use different methods to execute a command or statement in DB2 UDB
Creating databases and data placement

create DB2 databases
identify default objects that are created when a database is created
identify how table spaces may be defined to store different types of data
describe the two types of table space management
identify when each type of table space management should be used
create System Managed Storage (SMS) table spaces
create Database Managed Storage (DMS) table spaces
Create objects

describe DB2 object hierarchy
create database objects: tables, indexes, views, aliases, schemas
alter tables and add check constraints, triggers, and referential integrity
describe Large Objects (LOB)
Moving data

describe and use the export and import utilities
describe and use the load utility
describe the functionality of the DB2 replication component
Recovery

state the three types of recovery support
explain the principles DB2 uses for its recovery/restart functions
describe the capabilities and functional requirements of DB2 logging
use the utilities to back up and recover user data and DB2’s catalog
recover data to a prior point in time
state general considerations regarding disaster recovery
prepare and implement standard recovery procedures for data recovery
Monitoring and problem determination

use error logs
identify the different monitor types
identify how to obtain a db2trc
describe the function of EXPLAIN and use this facility to assist basic analysis
identify additional commands for listing application information
Concurrency

list objects that may be locked by the database manager
discuss available lock modes and their compatibility
influence locking strategies used by the database manager
Application alternatives

prepare applications that access DB2 data for execution
use PRECOMPILE and BIND options that are appropriate for specific application requirements
describe the application alternatives available to access DB2 data or request other DB2 functions
list the benefits, and possible disadvantages, of the various interfaces
Application performance

list reasons for REBIND of application programs and execute this command
define the concept of single dimensional clustering, and determine the proper cluster sequence, if any, for DB2 tables
use RUNSTATS, REORGCHK, and REORG to enhance application performance
identify configuration parameters that impact performance of applications
Security

use DB2 access control mechanisms to implement security within the database
use group IDs to create a control hierarchy
describe privileges within a database
describe privileges required for binding and executing a package
describe the difference between explicit privileges and implicit privileges
describe the different DB2 authorization levels
Daily Agenda

Day 1

Welcome
Overview of DB2 Universal Database
Getting Started with DB2 UDB GUIs
Lab (DB2 Customization)
Creating Databases and Data Placement
Lab (Creating Databases/Tablespaces)
Day 2

Lab (Creating Databases/Tablespaces) (Continued)
Create Objects
Lab (Create Objects)
Moving Data
Lab (Moving Data)
Day 3

Lab (Moving Data) (Cont)
Recovery
Lab (Recovery)
Monitoring and Problem Determination
Concurrency
Lab (Investigating DB2 Locking)
Application Alternatives
Day 4

Lab (Preparing Applications for Execution)
Application Performance
Lab (Application Performance Tools)
Security
Lab (Securing the DB2 Environment)

Pages:- 1 2 3 4
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>