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: Linux/UNIX/Windows Introduction Training

DB2 UDB: Linux/UNIX/Windows Introduction Training

Course#: WA2280

This course introduces and explains all aspects of relational technology as implemented by DB2 UDB for Linux, UNIX and/or MS Windows. The course is designed for applications programmers, designers, analysts and DBAs who have used DB2 in a mainframe environment. The presentation combines formal tuition with practical workshop sessions.

Objectives

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

  • use Command Center, Control Center, or other SQL execution environment (e.g. WinSQL) to code SQL statements
  • use the System Catlaog
  • understand and control the locking strategy used by DB2 to maintain data integrity
  • describe the different development environments available
  • explain the use and implementation of the Development Center
  • list the different types of indexes and the use of Index Advisor
  • use Visual Explain
  • use and understand the Health Center to describe the development and execution of Utilities
  • explain the use of Journals
  • describe the Replication Center
  • explain the use of the Task Center
  • use the Event Analyzer
  • describe the Indoubt Transaction Manager
  • use the Memory Visualizer
  • describe the Configuration Assistant.

Audience

IT personnel who are exposed to, or required to write and perform activities associated with application development and implementation in a DB2 UDB Linux, UNIX, and/or Windows environment.

Prerequisites

Those attending the course should be familiar with computing environments.

Duration

2 days

Outline of WA2280 DB2 UDB: Linux/UNIX/Windows Introduction Training

1. Introduction to DB2 under Linux/UNIX/Windows

  • Versions
  • system architecture.

2. Terms/Terminology

  • Database, Buffer Pool, Instance, Tablespace
  • Tables
  • Views
  • View Merge
  • Materialization
  • Columns
  • Nulls
  • Referential Integrity
  • Alias
  • Attributes.

3. DDL via CONNECT Commands or the Control Center

4. The Locking Strategy

  • Principles and implementation.

5. Indexing

  • The different types of index available, Index Advisor, creation, Visual Explain, and Muti Dimentional Clustering.

6. Stored Procedures and UDFs

  • Development using the Development Center
  • SPL
  • execution.

7. DB2 Utilities

  • REORG, RUNSTATS, BACKUP, RESTORE, LOAD,IMPORT and EXPORT.

8. Other Options

  • Journals, Replication Center, Task Center, Event Analyzer, Health Center, Indoubt Transaction Manager, Memory Visualizer, and Configuaration 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.