Courses

DB2 ADMINISTRATION

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

 

live Chat