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
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