DB2 9 for Developers

DB2 9 is a major release including totally new features, most notably the tight integration of the new DB2 9 XML native data type into the DB2 9 data server. If you’re a DB2 developer or database administrator facing the task of implementing DB2 9, this book needs to be on your desk. In it, recognized DB2 guru and top consultant Philip K. Gunning shows how IBM has integrated native XML into the DB2 engine and gives developers and DBAs a detailed roadmap for implementing and exploiting the new XML capabilities.

First, Gunning recaps the basics of XML and explains why XML is so important in today’s business environment. Support for standard industry XML schemas is covered. Next, Gunning shows developers how to develop DB2 XML applications, describes the best way to design an XML database, and reveals the optimum way to tune the DB2 XML hybrid database. Because the book is written by an “in-the -trenches” consultant, readers will find it full of practical advice.

Also covered are practical details on the enhancements and features of the new release and the process for implementing them, along with in-depth examples and useful scripts. The new DB2 9 table partitioning and data compression are highlighted, and DB2 optimization of SQL and XML is discussed in detail. Gunning covers XML enhancements to DB2 utilities, such as LOAD and EXPORT, and provides recommendations. He’s even included performance considerations and tuning suggestions to help application developers and DBAs develop and maintain high-performance databases with DB2 9.

DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification Study Guide

In this book, Roger E. Sanders and Dwaine R. Snow—two of the world’s leading DB2 authors and active participants in the development of IBM’s DB2 certification exams—cover everything you need to know to pass the DB2 9 Advanced Database Administration for Linux, UNIX, and Windows exam (Exam 734). This exam is the final step needed to attain certification to be an IBM Certified Advanced Database Administrator - DB2 9 for Linux, UNIX, and Windows.

This comprehensive study guide explains all of the topics that are covered on the exam: database design, data partitioning and clustering, high availability, diagnostics, performance and scalability, database security and data encryption, connectivity and networking, and much more. Each chapter contains an extensive set of practice questions along with carefully explained answers.

Taking and passing the DB2 9 Advanced Database Administration for Linux,UNIX, and Windows exam (Exam 734) provides validation that you have extensive experience as a DBA and thorough knowledge of DB2 9. Certification proves you are capable of performing advanced database administration tasks—such as troubleshooting, performance tuning, and security management—that are highly sought by employers.

This book includes sample questions in each chapter plus a complete practice test that closely models the actual exam, along with an answer key that provides a full explanation of why the chosen answer is correct (and why the other answers are wrong). No other source gives a reader this much help in preparing for Exam 734.

DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Upgrade Exam Study Guide

In DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Upgrade Exam Study Guide, Roger E. Sanders—one of the world's leading DB2 authors and an active participant in the development of IBM's DB2 certification exams—covers everything a reader needs to know to pass the short—but notoriously challenging—DB2 9 for LUW DBA Certification Upgrade exam (Exam 736).

This specialized study guide steps you through all of the topics that are covered on the exam, including server management, data placement, XML concepts, activity analysis, high availability, database security, and much more. Everything new to DB2 9 that you will need to know in order to successfully pass the exam is covered in this book.

Taking and passing the DB2 9 for LUW DBA Upgrade Certification exam (Exam 736) provides validation that you have mastered DB2 9. Passing this exam also earns you the IBM Certified Database Administrator certification.

This concentrated guide includes an extensive set of practice questions in each chapter that closely model the actual exam, along with an answer key with a full description of why the answer is the correct one. No other source gives you this much help in passing the exam.

DB2 9 for Linux, UNIX, and Windows Database Administration Certification Study Guide

In DB2 9 for Linux, UNIX, and Windows Database Administration Certification Study Guide, Roger E. Sanders—one of the world’s leading DB2 authors and an active participant in the development of IBM’s DB2 certification exams—covers everything a reader needs to know to pass the DB2 9 UDB DBA Certification Test (731). This comprehensive study guide steps you through all of the topics that are covered on the test, including server management, data placement, database access, analyzing DB2 activity, DB2 utilities, high availability, security, and much more. Each chapter contains an extensive set of practice questions along with carefully explained answers.

Taking and passing the DB2 9 UDB DBA Certification Test (731) provides validation that you have mastered the next level of DB2 9. Passing this exam also earns you the IBM Certified Database Administrator certification.

The book includes a complete practice test of 150 questions that closely models the actual exam along with an answer key with a full description of why the answer is the correct one. No other source gives you this much help in passing the exam.

DB2 9 Fundamentals Certification Study Guide

In DB2 9 Fundamentals Certification Study Guide, Roger E. Sanders—one of the world’s leading DB2 authors and an active participant in the development of IBM’s DB2 certification exams—covers everything a reader needs to know to pass the DB2 9 Fundamentals certification exam (Exam 730). This comprehensive study guide steps you through all of the topics that are covered on the test: planning; database security; database objects; SQL, XQuery, and XML; tables, views, and indexes; database concurrency; and much more. Each chapter contains an extensive set of practice questions along with carefully explained answers.

Technical certification is becoming one of the most important trends in the IT industry today. Taking and passing the DB2 9 Fundamental certification exam (Exam 730) provides validation that you have mastered the basics of DB2 9. Passing this exam also earns you the IBM Certified Database Associate certification and is the prerequisite for all intermediate and follow-on DB2 certifications.

The book includes sample questions in each chapter plus a complete practice test of 150 questions that closely models the actual exam along with an answer key with a full description of why the answer is the correct one. No other source gives you this much help in preparing for the exam.

Whatever DB2 9 certification path you plan on pursuing, the DB2 9 Fundamentals certification exam is the first step, and this book is the best place to start.