Logo

DB2DBA

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

          • Architecture
          • Users              
          • Instances
          • DB2 Client
          • Storage
          • Table spaces
          •  Buffer pools
          • Security
          • SQL and XQuery

_ IBM Data Studio
_ DSAC
PART 3:- INSTALLATION AND CONFIGURATION (WORKING WITH WINDOWS OS)
                                Agenda                        
_Installation
                                    _Configuration

  • Database creation
  • Instance creation
  • Table space Creation
  • Working with Buffer pool                                         

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

  • Isolation Levels
  • Locking
  • Specifying Isolation Levels

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

  • Types
  • Benefits                      
  • Usage
  • Tools for Developing Routines

                                    _Triggers