Courses

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

live Chat