DB2 ADMINISTRATION (DB2 DBA)

Pre-requisite : should have the knowledge on SQL
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