|
 |
|
 |
 |
DB2(R) Universal Database V8.1 Certification Exam 703 Study Guide (IBM Press...
|
by Roger E. Sanders
Sales Rank: 870572
|
List Price: $49.99
$36.49
At Amazon
|
|
Paperback: 352 pages
Publisher: IBM Press; Stg edition May 25, 2004
Language: English
ISBN-10: 0131840495
ISBN-13: 978-0131840492
Product Dimensions:
9 x 5.9 x 0.8 inches
Shipping Weight: 1.4 pounds
Back Cover Copy
- The definitive DB2 UDB V8.1 Family Application Development (Exam 703) preparation guide--straight from IBM
- Covers database objects, SQL, embedded SQL, CLI/ODBC, JDBC, SQLJ, transactions, stored procedures, and user-defined datatypes and functions
- Reviews advanced programming concepts such as compound SQL, two-phase commit, and locking
- Contains extensive sample questions based on the actual exam's format and approach
- Includes authoritative coverage of the DB2 exam and certification process
- By Roger Sanders, best-selling DB2 certification author and active participant in IBM's exam development process
Recognition as an IBM DB2 Certified Application Developer demonstrates your exceptional expertise in developing for DB2 UDB 8.1, the world's #1 enterprise database platform. If you're an IBM Certified Database Associate, you can achieve certification by passing one exam: IBM DB2 UDB V8.1 Exam 703.
Straight from IBM, this is the only official Exam 703 self-study guide. Roger E. Sanders, the world-renowned DB2 expert who helped develop Exam 703, covers every objective you must master in order to pass.
Sanders walks step-by-step through basic data manipulation; core DB2 programming methods; SQL and embedded SQL; ODBC/CLI; Java and SQLJ; stored procedures; transactions, user-defined routines; 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: - In-depth explanations of database objects, privileges, and constraints
- SQL and DML statements for storing, manipulating, and retrieving data
- Embedding SQL in high-level programming language source code
- CLI/ODBC development, including conversion into executables
- JDBC objects and methods for developing Java database applications
- Using SQLJ to embed static SQL statements in Java applications
- Transactions, stored procedures, user-defined functions, and other advanced techniques
- Complete information on certification prerequisites and requirements
Whether you're currently preparing for Exam 703, or you simply want to deepen your skills as a DB2 developer, you'll find this book indispensable.
About The Author
ROGER E. SANDERS, database performance engineer with Network Appliance Inc., is author of several books about DB2, including DB2 UDB V8.1 Certification Exam 700 Study Guide, DB2 Universal Database SQL Developer's Guide and DB2 Administration All-in-One Exam Guide. He has worked with DB2 for well over a decade, and holds eight IBM DB2 certifications, including IBM Certified Advanced Technical Expert (DB2 for Clusters) and IBM Certified Solutions Expert. A regular contributor to DB2 Magazine, he has authored database tutorials for IBM's DeveloperWorks website and presented at three International DB2 User Group conferences.
Customer Reviews & Comments
This review is from: DB2(R) Universal Database V8.1 Certification Exams 701 and 706 Study Guide (IBM Press Series--Information Management) (Paperback)
In the world of large commercial databases, there are really only two choices: IBM's dB2 and Oracle. While MySQL and Postgres are increasingly try to break up this cosy duopoly, they are still small players. So as a professional DBA, or an aspiring one, dB2 is a good choice. Given this, IBM provides several levels of certification. Sanders here supplies the official study guide for the 701 and 706 exams. Thumbing through this book, you see lots of SQL commands. But a lot of the SQL appears to be syntax specific to managing dB2. A dB2 programmer/user can largely deal with generic SQL. But for you, that's not enough. The value of this book is heavily in the specifics of dB2 and how to optimise its performance. The questions and answers in each chapter are at least as important as the text. If you are at all serious, you MUST tackle these. Otherwise, you've just discarded half the value of the book. Of course, the actual questions in the exams will differ. But by being able to do the book's problems, it forces you to clarify your understanding. My own SQL background is mostly with MySQL. So most of this book is new to me. I tried a couple of chapters and their problem sets. Not bad. The problems are not trivial. But the volume of material in each chapter is succinct enough to be doable in a few hours.
|
DB2(R) Universal Database V8.1 Certification Exam 703 Study Guide (IBM Press...
List Price: $49.99
Available from Amazon
Price: $36.49
| |
|
|
|
|
