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