DB2 11 for z/OS Concepts and Facilities

Why take this course?

After completing this course, you will be able to
  • describe the major characteristics of the Relational Model.
  • recognize the basic components of the DB2 11 product, and its major operating platforms.
  • understand referential integrity.
  • understand basic Structured Query Language programs.
  • understand how DB2 affects the application development environment and process.
You will also
  • become familiar with fundamental DB2 objects.
  • learn more about DB2's security mechanism.
This introductory course explores IBM's strategic, relational database product, providing a comprehensive overview of DB2. Topics range from an introduction to relational database concepts to an overview of the Structured Query Language (SQL). We'll also give you a brief review of the DB2 application development environment.Information Technology staff at any level who need a basic introduction to DB2.

Who should attend?

Anyone who uses DB2-based applications in their day-to-day work will also benefit from this seminar.

Any prerequisites?
No database experience is necessary, although you should be familiar with basic data processing concepts.

Dates and Fees

1 Day   ? - $ 737 (CAD)  ? Up to 4 - $ 2,367 Up to 8 - $ 3,787    ? Plus - Please Contact Us
Mon Sep 27, 2021
Mon Oct 18, 2021
Mon Jan 24, 2022
Mon Feb 21, 2022
Contact us to arrange your preferred location and date

What Topics are covered

Relational Database Concepts
  • The Relational Model
  • Structure
  • Keys
  • Integrity
  • Manipulation
  • Data Models
  • Mapping business data
  • Entity types
  • Relationships
  • Attributes
DB2 Components and Features
  • DB2 Objects
  • Database
  • Storage Group
  • Tablespace
  • Table
  • Column
  • Index
  • Indexspace
  • View
  • Synonym
  • Alias
  • Object Dependency
  • Column datatypes
  • Primary key
  • Foreign key
  • Referential integrity
The z/OS DB2 Environment
  • DB2 environment
  • The DB2 subsytem
  • DB2 attachments
  • DB2 connections
  • DB2 access
  • Application development tools
  • The DB2 catalog
  • Using the catalog
  • Catalog tables
  • Security
Introduction to SQL
  • What is SQL?
  • The base language
  • Executing an SQL statement
  • Simple SELECT statement
  • SPUFI Demo