DB2 DBA Administration Course Content:

RELATIONAL DATA MODEL

_ Data and Databases
_ Database Management Systems (DBMS)
_ Information Model & Data Model
_ Relational Data Model & Relational Databases
_ Normalization

DB2 FUNDAMENTALS AND IBM DATA STUDIO TOOL

_Product Overview
_ Fundamentals
_ IBM Data Studio
_ DSAC

INSTALLATION AND CONFIGURATION (WORKING WITH WINDOWS OS)

_Installation
_Configuration

WORKING WITH DATABASES AND DATABASE OBJECT IN DB2

_ Servers, Instances, and Databases
_ Managing Instances
_ Creating a DB2 Database
_ Cataloging
_ Database (Data) Objects

INTRODUCTION TO SQL

_ SQL
_ Data Definition Language
_ Data Manipulation Language
_ JOINs
_ Data Control Language
_ Transaction Control Statements

DATA CONCURRENCY

_ Database Transactions
_ Concurrency
_ Concurrency Issues
_ Concurrency Control
Isolation Levels
Locking
Specifying Isolation Levels



DB2 SECURITY

_ Authentication
_ Trusted Context
_ Authorization
_ Authorities
_ Privileges
_ Label-Based Access Control (LBAC)
_ROLES

DB2 BACKUP AND RECOVERY

_Backup
_Recovery

DB2 PURE XML

_ Overview of XML
_ PureXML in DB2
_ XML Data Movement in DB2
_ XQuery and SQL/XML
_ XML Indexes in DB2
_ Application Development

DB2 PROGRAMMING FUNDAMENTALS

_ Application Development Environment
_ Embedded SQL
_ Static SQL
_ Dynamic SQL
_ Routines
_Triggers