DB2

Enquire, Join and get training by Well Experienced & Certified tutors
for your professional IT Course.

Get in Touch

+91 988 099 7819

cvptechnolab@gmail.com

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. IBM Data Studio

INSTALLATION AND CONFIGURATION (WORKING WITH WINDOWS/LINUX OS)

1. Installation
2. Configuration
23. 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

Training Schedule

CLASS TIME(IST) START DATE END DATE DURATION DAY ENROLL
WEEKEND 6:30 AM-9:00 AM 29-Apr-2017 30-May-2017 1 MONTH SAT & SUN
WEEKEND 5:00 PM-8:30 PM 29-Apr-2017 30-May-2017 1 MONTH SAT & SUN
REGULAR 5:30 PM-6:30 PM 01-May-2017 30-May-2017 1 MONTH MON – FRI
Live online class
In class questions
Review session
Practice assignments

100% practical oriented sessions
Experienced certified faculty
Resume & Interview guidance
Hands-on projects execution

Mode of Training ?

We conducting the course via live and interactive sessions. This enables you to ask questions and engage in discussions at any point during the class.

What tools do I need to attend the training sessions?

Laptop/Desktop/ipad with Internet and no need of any software and hardware to do the practices.

We will give you live lab setup documentation

What is covered under the 24/7 Support ?

We also have a dedicated team that provides on demand assistance through our community forum. What’s more, you will have lifetime access to the community forum, even after completion of your course with us.

We will also provide the updated documents,Interview question and access to our online practices exam portal

What if we missed the session ?

We will allow to the next batch, also we will provide the backup sessions and will share the recorded session