IBM DB2 DBA LIVE ONLINE TRAINING BY REALTIME PROFESSIONALS

IBM® DB2 is one of the powerful RDBMS software help to achieve high voluminous (128 TB) data and accommodates special CLOB, BLOB data types. DB2® is compatible with various operating systems and federates with different types of databases. DB2 is one of the leading Web-based databases.


FOR FREE DEMO contact :

Email : raj@apex-online-it-training.com

Phone/WhatsApp : +91-(850) 012-2107

USA Number : 214-628-3894

Gtalk : raavi.sriraja@gmail.com

Blog: http://apex-it-online-trainings.blogspot.in


IBM DB2 DBA Interview Questions and Answers, Recorded Video Sessions, Materials, Interviews,Assignments Will be provided

IBM DB2 ADMINISTRATION COURSE OUTLINE

(the course content can be modified as per your requirements):


Part 1:- RELATIONAL DATA MODEL

· 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

· 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)

· Installation

· Configuration

· Database creation

· Instance creation

· Table space Creation

· Working with Buffer pool

Part 4:- WORKING WITH DATABASES AND DATABASE OBJECT IN DB2

· Servers, Instances, and Databases

· Managing Instances

· Creating a DB2 Database

· Cataloging

· Database (Data) Objects

·

Part 5:- INTRODUCTION TO SQL

· SQL

· Data Definition Language

· Data Manipulation Language

· JOINs

· Data Control Language

· Transaction Control Statements

·

Part 6:- DATA CONCURRENCY

· Database Transactions

· Concurrency

· Concurrency Issues

· Concurrency Control

· Isolation Levels

· Locking

· Specifying Isolation Levels

Part 7:- DB2 SECURITY

· Authentication

· Trusted Context

· Authorization

· Authorities

· Privileges

· Label-Based Access Control (LBAC)

ROLES

Part 8:- DB2 BACKUP AND RECOVERY

· Backup

· Recovery

Part 9:- DB2 PURE XML

· 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

· Application Development Environment

· Embedded SQL

· Static SQL

· Dynamic SQL

· Routines

· Types

· Benefits

· Usage

· Tools for Developing Routines

· Triggers