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
Website : http://www.apex-online-it-trainings.com/
Blog: http://apex-it-online-trainings..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