| |  | Copyright |
| | | IBM Press SeriesInformation Management |
| | | About Prentice Hall Professional Technical Reference |
| | | Foreword |
| | | Preface |
| | | | About This Book |
| | | | Conventions Used |
| | | | Acknowledgments |
| | | | About the Author |
| | | Part 1. DB2 UDB Certification |
| | | | Chapter 1. IBM DB2 Universal Database Certification |
| | | | DB2 Universal Database Certification Roles |
| | | | The Certification Process |
| | | Part 2. DB2 UDB Family Fundamentals |
| | | | Chapter 2. Planning |
| | | | The DB2 Universal Database Family |
| | | | DB2 Universal Database's Comprehensive Tool Set |
| | | | Practice Questions |
| | | | Answers |
| | | | Chapter 3. Security |
| | | | Controlling Database Access |
| | | | Authentication |
| | | | Authorities and Privileges |
| | | | Granting Authorities and Privileges |
| | | | Authorities and Privileges Needed to Perform Common Tasks |
| | | | Practice Questions |
| | | | Answers |
| | | | Chapter 4. Accessing DB2 UDB Data |
| | | | Servers, Instances, and Databases |
| | | | What Makes Up a DB2 UDB Database? |
| | | | Creating a DB2 UDB Database with the CREATE DATABASE Command |
| | | | Creating a DB2 UDB Database with the Create Database Wizard |
| | | | Deleting a DB2 UDB Database |
| | | | DB2 UDB's Directory Files |
| | | | Cataloging and Uncataloging a DB2 UDB Database |
| | | | Cataloging and Uncataloging a Node |
| | | | Cataloging and Uncataloging a DCS Database |
| | | | Cataloging Remote Databases with the Add Database Wizard |
| | | | Database Objects |
| | | | Practice Questions |
| | | | Answers |
| | | | Chapter 5. Working with DB2 UDB Data |
| | | | Structured Query Language (SQL) |
| | | | The SELECT Statement and Its Clauses |
| | | | Answers |
| | | | Chapter 6. Working with DB2 UDB Objects |
| | | | DB2 Universal Database's Data Types |
| | | | Understanding Constraints |
| | | | Creating Tables with the CREATE TABLE SQL Statement |
| | | | CREATE TABLE SQL Statement Examples |
| | | | Practice Questions |
| | | | Answers |
| | | | Chapter 7. Database Concurrency |
| | | | Understanding Data Consistency |
| | | | Isolation Levels |
| | | | Locking |
| | | | Practice Questions |
| | | | Answers |
| | | | Appendix A. DB2 UDB V8.1 Family Fundamentals Exam (Exam 700) Objectives |
| | | | Planning (15%) |
| | | | Security (9%) |
| | | | Accessing DB2 UDB Data (15%) |
| | | | Working with DB2 UDB Data (31%) |
| | | | Working with DB2 UDB Objects (19%) |
| | | | Data Concurrency (11%) |
