IBM DB2 ADMINISTRATION ONLINE TRAINING BY PRADHIKA TECHNLOGY IN INDIA

RELATIONAL DATA MODEL :

1.Data and Databases
2.Database Management Systems (DBMS)
3.Information Model & Data Model
4.Relational Data Model & Relational Databases
5.Normalization

DB2 FUNDAMENTALS AND IBM DATA STUDIO TOOL

1.Product Overview
2.Editions & Features
3.Licensing
4.Fundamentals
5.Architecture
6.Users
7.Instances
8.DB2 Client
9.Storage
10.Table spaces
11.Buffer pools
12.Security
13.SQL and XQuery
14.IBM Data Studio
15.DSAC

INSTALLATION AND CONFIGURATION (WORKING WITH WINDOWS OS)

1.Installation
2.Configuration
3.Database creation
4.Instance creation
5.Table space Creation
6.Working with Buffer pool

WORKING WITH DATABASES AND DATABASE OBJECT IN DB2

1.Servers, Instances, and Databases
2.Managing Instances
3.Creating a DB2 Database
4.Cataloging
5.Database (Data) Objects

INTRODUCTION TO SQL

1.SQL
2.Data Definition Language
3.Data Manipulation Language
4.JOINs
5.Data Control Language
6.Transaction Control Statements

DATA CONCURRENCY

1.Database Transactions
2.Concurrency
3.Concurrency Issues
4.Concurrency Control
5.Isolation Levels
6.Locking
7.Specifying Isolation Levels

DB2 SECURITY

1.Authentication
2.Trusted Context
3.Authorization
4.Authorities
5.Privileges
6.Label-Based Access Control (LBAC)
7.ROLES

DB2 BACKUP AND RECOVERY

1.Backup
2.Recovery

DB2 PURE XML

1.Overview of XML
2.PureXML in DB2
3.XML Data Movement in DB2
4.XQuery and SQL/XML
5.XML Indexes in DB2
6.Application Development

DB2 PROGRAMMING FUNDAMENTALS

1.Application Development Environment
2.Embedded SQL
3.Static SQL
4.Dynamic SQL
5.Routines
6.Types
7.Benefits
8.Usage
9.Tools for Developing Routines
10.Triggers

Our Courses

WebSphere
SAP
Oracle
Java
Microsoft
Tibco
PROFESSIONAL COURSES

Address

Rakesh Kumar

+91 9700330693

+1 234 200 0813

info@pradhikatechnology.com

pradhikatechnology@gmail.com