DB2 Universal Database V7 Administration

On this course you will learn to administer DB2 version 7 on all Intel and Unix platforms

 

Objectives:

 		 On completion of the course you will be able to:
  • Install DB2 on the platform of your choice
  • Choose a security strategy relevant to your organisation
  • Define all necessary database objects
  • Perform administration tasks such as Backup, Recovery and Reorganisation
  • Employ Perormance and Tuning skills

Subjects covered:
  • Getting started with DB2 UDB
  • Making connections
  • Controlling access to the data
  • Database objects
  • Manipulating database objects
  • Advanged SQL
  • Concurrency
  • Data storage management
  • Maintaining data
  • Database Recovery
  • Monitoring & Tuning

Participants:

 Programmers, database administrators and those responsible for DB2 UDB installation and support.

Prerequisites:

 Some knowledge of relational database concepts, and experience with SQL is necessary, together with experience of a Windows system.

Remarks:

 The course prepares you to sit the following IBM Certification exams.
  • 512 DB2 UDB V7.1 Fundamentals
  • 513 DB2 UDB V7.1 Database Administration
The course material includes the book ‘DB2 Universal Database v7.1 Certification Guide’, including a DB2 UDB 60 day trial version for Win.95/98/NT/2000 or OS/2

Teaching method:

 Classical, with practical exercises on a Windows PC

Course duration:

 4 days.

Cost:

 1500,- EUR excl. tax

Register for course: