DB2

Learn everything you need to know about this Relational Database Management System

Course Code : 1045

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

  • Data and databases
  • Database Management Systems (DBMS)
  • Information model and data model
  • Relational Data model and Relational Databases
  • Normalization
  • 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
  • Installation
  • Configuration
  • Database creation
  • Instance creation
  • Table space creation
  • Working with Buffer pool
  • Servers, instances and databases
  • Managing instances
  • Creating a DB2 database
  • Cataloging
  • Database (Data) Objects
  • SQL
  • Data definition language
  • Data manipulation language
  • JOINs
  • Data Control Language
  • Transaction Control Statements
  • Database transactions
  • Concurrency
  • Concurrency issues
  • Concurrency control
  • Isolation levels
  • Locking
  • Specifying Isolation levels
  • Authentication
  • Trusted context
  • Authorization
  • Authorities
  • Privileges
  • Label-based Access Control (LBAC)
  • ROLES
  • Overview of XML
  • Pure XML in DB2
  • XML Data movement in DB2
  • XQuery and SQL/XML
  • XML Indices in DB2
  • Application Development
  • Application Development Environment
  • Embedded SQL
  • Static SQL
  • Dynamic SQL
  • Routines
  • Types
  • Benefits
  • Usage
  • Tools for developing business
  • Triggers
View More

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.

Customer Reviews

Name
Email
Rating
Comments

No reviews yet