IBM DB2 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 Bbackup 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