IBM DB2 ADMINISTRATION ONLINE TRAINING & CORPORATE TRAINING INCLUDING LIVE PROJECT , JOB AND INTERVIEW SUPPORT BY REALTIME WORKING EXPERTS


FOR FREE DEMO contact us :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 1+214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in

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


IBM DB2 COURSE CONTENT (we can customize the Course Agenda as per your requirements)



IBM DB2 Course Highlights (ALL CONCEPTS)


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



FOR More Details contact us :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 1+214-628-3894
Gtalk : raavi.sriraja@gmail.com

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