IBM DB2 Administration

TIBM DB2 is a family of database server products developed by IBM. These products all support the relational model, but in recent years some products have been extended to support object-relational features and non-relational structures, in particular XML.

DB2 can be administered from either the command-line or a GUI. The command-line interface requires more knowledge of the product but can be more easily scripted and automated. The GUI is a multi-platform Java client that contains a variety of wizards suitable for novice users. DB2 supports both SQL and XQuery. DB2 has native implementation of XML data storage, where XML data is stored as XML (not as relational data or CLOB data) for faster access using XQuery.

DB2 has APIs for REXX, PL/I, COBOL, RPG, FORTRAN, C++, C, Delphi, .NET CLI, Java, Python, Perl, PHP, Ruby, and many other programming languages. DB2 also supports integration into the Eclipse and Visual Studio integrated development environments.

RELATIONAL DATA MODEL :
    1.Data and Databases
    2.Database Management Systems (DBMS)
    3.Information Model & Data Model
    4.Relational Data Model & Relational Databases
    5.Normalization

DB2 FUNDAMENTALS AND IBM DATA STUDIO TOOL
    1.Product Overview
    2.Editions & Features
    3.Licensing
    4.Fundamentals
    5.Architecture
    6.Users
    7.Instances
    8.DB2 Client
    9.Storage
    10.Table spaces
    11.Buffer pools
    12.Security
    13.SQL and XQuery
    14.IBM Data Studio
    15.DSAC

INSTALLATION AND CONFIGURATION (WORKING WITH WINDOWS OS)
    1.Installation
    2.Configuration
    3.Database creation
    4.Instance creation
    5.Table space Creation
    6.Working with Buffer pool

WORKING WITH DATABASES AND DATABASE OBJECT IN DB2
    1.Servers, Instances, and Databases
    2.Managing Instances
    3.Creating a DB2 Database
    4.Cataloging
    5.Database (Data) Objects

INTRODUCTION TO SQL
    1.SQL
    2.Data Definition Language
    3.Data Manipulation Language
    4.JOINs
    5.Data Control Language
    6.Transaction Control Statements

DATA CONCURRENCY
    1.Database Transactions
    2.Concurrency
    3.Concurrency Issues
    4.Concurrency Control
    5.Isolation Levels
    6.Locking
    7.Specifying Isolation Levels

DB2 SECURITY
    1.Authentication
    2.Trusted Context
    3.Authorization
    4.Authorities
    5.Privileges
    6.Label-Based Access Control (LBAC)
    7.ROLES

DB2 BACKUP AND RECOVERY
    1.Backup
    2.Recovery

DB2 PURE XML
    1.Overview of XML
    2.PureXML in DB2
    3.XML Data Movement in DB2
    4.XQuery and SQL/XML
    5.XML Indexes in DB2
    6.Application Development

DB2 PROGRAMMING FUNDAMENTALS
    1.Application Development Environment
    2.Embedded SQL
    3.Static SQL
    4.Dynamic SQL
    5.Routines
    6.Types
    7.Benefits
    8.Usage
    9.Tools for Developing Routines
    10.Triggers