IBM Db2 Administration Online Course

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
• Pure-XML 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