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
Call Us Today!            INDIA: +91 9618816600               USA: +12108587448              training@iconitinc.com