DB2

Course Code: 1045

Overview
Schedule classes
What you'll learn
Outline
Prerequisites
Who should attend
Certification

Overview

DB2 is a relational database management system (RDBMS) that stores, processes, analyzes, and retrieves data efficiently. It also incorporates object-oriented features and non-relational structures with XML making it a robust database product.

Cognixia’s DB2 training course covers the DB2 ecosystem in detail, with a hands-on approach to learning. It explores the intricacies of the database systems through practical as well as theoretical insights on working and interacting with the DB2 software.

Schedule Classes

Looking for more sessions of this class?

Course Delivery

This course is available in the following formats:

Live Classroom
Duration: 13 days

Live Virtual Classroom
Duration: 13 days

What You'll learn

Introduction to Relational Data Models
DB2 fundamentals
The IBM data studio tool
Working with Windows OS
Overview of databases and database objects
Introduction to SQL
Data concurrency concepts
Db2 security, backup and recovery
Pure XML and programming fundamentals

Outline

Module 1: Relational Data Model

Data and databases
Database Management Systems (DBMS)
Information model and data model
Relational Data model and Relational Databases
Normalization

Module 2: DB2 Fundamentals and IBM Data Studio Tool

Product overview
Editions and features
Licensing
Fundamentals
Architecture
Users
Instances
DB2 client
Storage
Table spaces
Buffer pools
Security
SQL and XQuery
IBM Data Studio
DSAC I

Module 3: Installation and Configuration (Working with Windows OS)

Installation
Configuration
Database creation
Instance creation
Table space creation
Working with Buffer pool

Module 4: Working with Databases and Database Objects in DB2

Servers, instances and databases
Managing instances
Creating a DB2 database
Cataloging
Database (Data) Objects

Module 5: Introduction to SQL

SQL
Data definition language
Data manipulation language
JOINs
Data Control Language
Transaction Control Statements

Module 6: Data Concurrency

Database transactions
Concurrency
Concurrency issues
Concurrency control
Isolation levels
Locking
Specifying Isolation levels

Module 7: DB2 Security

Authentication
Trusted context
Authorization
Authorities
Privileges
Label-based Access Control (LBAC)
ROLES

Module 8: DB2 Backup and Recovery

Backup
Recovery

Module 9: DB2 Pure XML

Overview of XML
Pure XML in DB2
XML Data movement in DB2
XQuery and SQL/XML
XML Indices in DB2
Application Development

Module 10: DB2 Programming Fundamentals

Application Development Environment
Embedded SQL
Static SQL
Dynamic SQL
Routines
Types
Benefits
Usage
Tools for developing business
Triggers

Prerequisites

Having an understanding of operating systems and database concepts will be beneficial for participants, though not mandatory.

Who Should Attend

This DB2 course is highly recommended for current and aspiring –

Database Administrators
Project managers
Front office professionals
SAP Basis/SUP professionals
Data warehousing professionals
B2B integrators
ESB consultants
MDM Solution consultants

Interested in this course? Let’s connect!

Certification

Participants will be awarded with an exclusive certificate upon successful completion of the program. Every learner is evaluated based on their attendance in the sessions, their scores in the course assessments, projects, etc. The certificate is recognized by organizations all over the world and lends huge credibility to your resume.