 | Level: Introductory George Baklarz (baklarz@yahoo.com), DB2 Technical Pre-Sales Support, IBM
18 Jul 2006 This tutorial will take you through the various steps required to manage some of the objects within DB2®. It includes overview information for indexes, constraints, referential integrity, and views. This is the third in a series of seven tutorials that you can use to help prepare for the DB2 9 for Linux®, UNIX®, and Windows™ Database Administration Certification (Exam 731). Objectives - Create DB2 tasks using the GUI tools
- Create and manage indexes
- Create constraints on tables
- Create views on tables
- Exam the contents of the system catalog tables
- Enforce data uniqueness
Prerequisites
To take the DB2 9 DBA exam, you must have already passed the DB2 9 Fundamentals exam 730.
If it's available, we recommend that you take the DB2 Fundamentals tutorial series before starting this series. If the Fundamentals series is not yet available, it's fine to do this DBA series first.
System requirements
You do not need a copy of DB2 to complete this tutorial. However, you will get more out of the tutorial if you download the free trial version of IBM DB2 9 to work along with this tutorial.
Duration
Less than one hours
Formats html, pdf
| | | |
