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

Courses Offered in Our Training Institute:

• IBM Lotus Notes Domino Server Administration

• IBM Lotus Notes Development

• IBM Web Sphere Application Server Administration

• IBM Web Sphere Process Server Administration

• IBM Web Sphere MQ Administration

• Oracle Apps R12 HRMS

• TIBCO, TIBCO I Process

• Oracle Apps R12 Finical

• Oracle Apps R12 Technical

• Oracle APPs SCM

• Oracle Apps HRMS

• Oracle FUSION  SOA ,  OSB

• OBIEE 11 g

• Oracle SQL, PL SQL

• Microsoft Dynamics CRM 4.0

• Webmethods

• Java

• Dotnet

• Siebel CRM , EAI, E-Scripting

• People Soft

• MicroStrategy

• Java & J2ee

• PHP

• Advanced Dotnet ( Wcf,Wpf,Linq,Ajax,)

• SharPoint

• Springs , Hibernate and Webservices

• Hyperion All Modules

• SAP  SD & SCM, BO

• Testing Tools – QTP, QC, Load Runner, selenium

www.futurepointtech.com

info@futurepointtech.com