DB2 ADMINISTRATION (DB2 DBA)
Duration : 20 DAYS (30 hours) [one & half hour per day]
Pre-requisite : should have the knowledge on SQL
Course material : only softcopy (in the form of pdf)
Software : DB2 9.7 Express-C, IBM Data Studio, Built-in Linux supported DB2 software
COURSE CONTENT
Part 1:- RELATIONAL DATA MODEL
Agenda
_ Data and Databases
_ Database Management Systems (DBMS)
_ Information Model & Data Model
_ Relational Data Model & Relational Databases
_ Normalization
Part 2:- DB2 FUNDAMENTALS AND IBM DATA STUDIO TOOL
Agenda
_Product Overview
Editions & Features
Licensing
_ Fundamentals
_ IBM Data Studio
_ DSAC
PART 3:- INSTALLATION AND CONFIGURATION (WORKING WITH WINDOWS OS)
Agenda
_Installation
_Configuration
Part 4:- WORKING WITH DATABASES AND DATABASE OBJECT IN DB2
Agenda
_ Servers, Instances, and Databases
_ Managing Instances
_ Creating a DB2 Database
_ Cataloging
_ Database (Data) Objects
Part 5:- INTRODUCTION TO SQL
Agenda
_ SQL
_ Data Definition Language
_ Data Manipulation Language
_ JOINs
_ Data Control Language
_ Transaction Control Statements
Part 6:- DATA CONCURRENCY
Agenda
_ Database Transactions
_ Concurrency
_ Concurrency Issues
_ Concurrency Control
Part 7:- DB2 SECURITY
Agenda
_ Authentication
_ Trusted Context
_ Authorization
_ Authorities
_ Privileges
_ Label-Based Access Control (LBAC)
_ROLES
Part 8:- DB2 BACKUP AND RECOVERY
Agenda
_Backup
_Recovery
Part 9:- DB2 PURE XML
Agenda
_ Overview of XML
_ PureXML in DB2
_ XML Data Movement in DB2
_ XQuery and SQL/XML
_ XML Indexes in DB2
_ Application Development
Part 10:- DB2 PROGRAMMING FUNDAMENTALS
Agenda
_ Application Development Environment
_ Embedded SQL
_ Static SQL
_ Dynamic SQL
_ Routines
_Triggers