DB2 ADMINISTRATION (DB2 DBA)
COURSE CONTENT
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