DB2 Online Training


DB2 DBA Administration Online Training

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
      Editions & Features
      Licensing       
_ Fundamentals
   Architecture
   Users             
   Instances
   DB2 Client
   Storage
   Table spaces
    Buffer pools
   Security
   SQL and XQuery
_ IBM Data Studio
_ DSAC

INSTALLATION AND CONFIGURATION (WORKING WITH WINDOWS OS)
                    
_Installation
_Configuration
    Database creation
    Instance creation
    Table space Creation
    Working with Buffer pool                                        

 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
   Types
   Benefits                     
   Usage
   Tools for Developing Routines
_Triggers