DB2 Database Administration Online Training

DB2 Database Administration Online Training

DB2 Database Administration Online Training
DB2 Database Administration Online Training

DB2 Database Administration Online Training Course Content:

RELATIONAL DATA MODEL

  • Data and Databases
  • Database Management Systems (DBMS)
  • Information Model & Data Model
  • Relational Data Model & Relational Databases
  • Normalization

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

INSTALLATION AND CONFIGURATION (WORKING WITH WINDOWS OS)

  • Installation
  • Configuration
  • Database creation
  • Instance creation
  • Table space Creation
  • Working with Buffer pool

WORKING WITH DATABASES AND DATABASE OBJECT IN DB2

  • Servers, Instances, and Databases
  • Managing Instances
  • Creating a DB2 Database
  • Cataloging
  • Database (Data) Objects

INTRODUCTION TO SQL

  • SQL
  • Data Definition Language
  • Data Manipulation Language
  • JOINs
  • Data Control Language
  • Transaction Control Statements

DATA CONCURRENCY

  • Database Transactions
  • Concurrency
  • Concurrency Issues
  • Concurrency Control
  • Isolation Levels
  • Locking
  • Specifying Isolation Levels

DB2 SECURITY

  • Authentication
  • Trusted Context
  • Authorization
  • Authorities
  • Privileges
  • Label-Based Access Control (LBAC)
  • ROLES

DB2 BACKUP AND RECOVERY

  • Backup
  • Recovery

DB2 PURE XML

  • Overview of XML
  • PureXML in DB2
  • XML Data Movement in DB2
  • XQuery and SQL/XML
  • XML Indexes in DB2
  • Application Development

DB2 PROGRAMMING FUNDAMENTALS

  • Application Development Environment
  • Embedded SQL
  • Static SQL
  • Dynamic SQL
  • Routines
  • Types
  • Benefits
  • Usage
  • Tools for Developing Routines
  • Triggers

Drop your query

What my Client's Say?

 

  • Prabhu is an excellent instructor, very patient and thorough. I have tried another training class and EXPLORE IT far exceeds other trainers and their methods ~ Hassan Malik

  • An extremely helpful and informative course. Training materials were well organized and provided good case studies. Instructor was extremely professional and pleasant to learn from.~ Bhavani Sudarshnam

  • The training was clear and detailed. I like Parker's style of teaching as the recurrent training is a thorough review of the HR. Every opportunity for the student to ask questions was provided. ~ Yiting Chen

  • Jane Anderson conducted the class in a very professional manner. Examples were very relevant and I feel that I gained a lot from the updated materials this year.~ Somesh Taneja

  • Prem was a great instructor. Thanks Prem for making the training easy to understand. A lot of information was covered. He made the approach easy to follow.~ Komali Sambakula

  • She wants to make sure that her students walk away from her course with a good working knowledge. She is an excellent trainer and cares that all of her students learn the material.~ Kiran Jain

  • Krishna is very thorough and professional. He made the code very understandable. I was very impressed with his teaching methods and presentation of the regulations. EXPLORE IT is the best! ~ Rajesh Isukapalli

  • Mr. Chris Brown was very affirmative with the course, on time and fluent. This is my second recourse with him. I hope to take his course as long as I am shipping at my current job. ~ Awais Rahim