iBase Training

Official Website

IBM DB2 DBA Online Training Course Content by Corporate Trainers

 

 

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 : info@ibasetraining.com

Phone/WhatsApp : +91-8106721223

USA Number : +1-650-993-1007

Gtalk : ibasetraining@gmail.com

 

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

 

 

Student Registration

Name

Email Id

Country Code

Mobile No

Course Name

City