Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > DB2 > DB2 UDB Family: Introduction & Fundamentals Training

DB2 UDB Family: Introduction & Fundamentals Training

Course#: WA2278

This course introduces and explains the fundamental principles of the DB2 UDB family of products. The course focuses on the relational theory and concepts, and how DB2 adheres to them. It also introduces the basic concepts of DB2 data storage, SQL, DB2 utilities, and the use of DB2 Interactive (DB2I) and the relevant centres.

Objectives

On successful completion of this course attendees will be able to:

  • describe the relational theory and concepts
  • list the objects used to store DB2 data
  • understand the use of Structured Query Language
  • describe the functions available with DB2 Interactive (DB2I)
  • list the utility jobs available for DB2.

Audience

All IT professionals who need to understand the full range of the DB2 UDB family of products.

Prerequisites

A basic understanding of IT, with some exposure to database technology as a user.

Duration

2 days

Outline of WA2278 DB2 UDB Family: Introduction & Fundamentals Training

1. DBMS Overview

  • A database is...
  • DB2 is...
  • Hierarchical database structure
  • Network database structure
  • Relational database structure
  • Table structure
  • DB2 family & versions.

2. Relational Theory & Concepts

  • E F Codd
  • The relational model
  • Structure: tables, rules for columns and rows, keys, Primary and Foreign keys
  • Manipulation: relational algebra, project, Restrict, join, UNION
  • Domain and user-defined Integrity
  • Entity and Referential Integrity
  • Referential Integrity: INSERT, UPDATE, DELETE.

3. DB2 Data & System Overview

  • DB2 objects
  • the DB2 database
  • Tablespace and Instance
  • Tablespace formats
  • Table
  • SYNONYM & ALIAS
  • View
  • Index
  • Index structure
  • Storage group
  • User defined datasets
  • Schema
  • Trigger
  • DB2 catalog & directory
  • DB2 address spaces
  • DB2 attachments
  • Buffer Pools & Hiperpools
  • DB2 logging.

4. Structured Query Language Overview

  • Structured Query Language
  • Data Definition Language commands & examples
  • Data Control Language commands & examples
  • Data Manipulation Language commands
  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • COMMIT / ROLLBACK
  • DB2 Optimizer.

5. DB2 Interactive (DB2I) and Command Center Overview

  • DB2I primary option menu
  • Panels: SPUFI defaults
  • Precompile
  • Option 5 - BIND / REBIND / FREE
  • Option 6 - RUN
  • Option 7 - DB2 commands
  • Option 8 - DB2 Utilities
  • Invoking DB2 Utilities.

6. DB2 Utilities Overview

  • Controlling Utilities
  • Backup & Recovery Utilities
  • Integrity & consistency utilities
  • General utilities
  • Stand-alone utilities.

7. The Centers

  • Development Center
  • Replication Center: Introduction, Create the capture control tables, Register a source table, Create the apply control tables
  • Task Center: Introduction, Creating a task
  • Event Analyzer
  • Health Center: How it works, Type of alert/action/indicators, Using, Configure, Recommendation Adviser
  • Indoubt Transaction Manager
  • Memory Visualizer
  • Configuration Assistant.
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.