IBM DB2 Universal Database Certification gives you a powerful advantage in the marketplace for expertise on the world's #1 enterprise database platform. Passing IBM DB2 Universal Database V8.1 Family Fundamentals Exam 700 earn you the IBM Certified Database Associate certification and is the prerequisite for all intermediate and follow-on certifications.

In this book,Roger E. Sanders-one of the world's leading DB2 Universal Database experts and an active parti***nt in IBM's DB2 Universal Database exam development process-covers everything you need to know to pass DB2 Universal Database V8.1 Exam 700. Sanders covers every exam objective, beginning with a review of the DB2 family of tools and products, as well as fundamental database concepts such as SQL and data consistency.

This comprehensive study guide walks you step-by-step through deployment planning; database security; SQL; DB2 database object creation and management; database con currency; and much more.Every chapter contains an extensive set of practice questions closely modeled on the actual exam, along with carefully explained answers. Coverage includes:

• Creating and deploying DB2 Universal Database databases

• Database objects and IBM's tools for creating, accessing, and mani***ting them

• Protecting data: controlling access with authentication, authorities, and privileges

• Options and alternatives for accessing DB2 data

• Using SQL to work with data objects such as tables, views, and indexes

• Concurrency: maintaining data integrity and consistency in single-and multi-user environments

Whatever DB2 certification you're planning to pursue, DB2 Exam 700 is the foundation-and DB2 Universal Database V8.1 Certification Exam 700 Study Guide is the solution.