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 Administration for Unix and Windows Training

DB2 UDB Administration for Unix and Windows Training

Course#: WA1294

This course is designed to review the concepts and components of DB2 for UNIX and Windows. DB2 commands and SQL will be used to focus on DB2 administration activities. The relationships between object components will be presented along with communication and security aspects. Design issues of referential Integrity, table check constraints, user defined data types and functions, triggers and large objects will be reviewed. Program design issues will be considered which effect concurrency, integrity and performance. DB2 administration functions and utilities will be reviewed and applied in workshops. Performance and tuning issues will be reviewed.

Objectives
  After completing this course the student should be able to:
  • Understand the basic concepts and facilities of DB2.
  • Create instances, databases and relational objects to support application development and user data access.
  • Use IMPORT, EXPORT and LOAD utilities to manipulate data.
  • Perform basic and advanced database and table space recovery
  • Understand the basic security features of DB2.
  • Understand and control the locking behaviour of DB2
  • Know how to support application development.
  • Know performance enhancing techniques for supporting applications.
Target Audience
  Database administrators
Prerequisites
 
  • Relevant Operating Systems experience (AIX or Windows).
  • Knowledge of relational database theory and SQL. Previous experience of using DB2 is recommended.
Duration
  Four days.

Outline of WA1294 DB2 UDB Administration for Unix and Windows Training

Day 1

  • The DB2 Family
  • Getting started with DB2 (INSTANCES)
  • Workshop
  • Creating databases and table spaces
  • Workshop

Day 2

  • Creating Tables and other objects
  • Workshop
  • TRIGGERS, UDT and UDF
  • Workshop
  • DB2 LOCKING
  • workshop
  • DB2 Privileges
  • workshop

Day 3

  • DB2 Data Management
  • Workshop
  • IMPORT/EXPORT/LOAD utilities
  • Workshop
  • Basic Database Recovery
  • Workshop

Day 4

  • Disaster Recovery for tables and table spaces
  • Workshop
  • Incremental backup and recovery techniques
  • workshop
  • Application development and Implementation
  • Workshop
  • Performance for applications
  • Workshop
  • Basic tuning techniques
  • Workshop
  • DB2 Configuration parameters
  • Workshop
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.