DB2 UDB V8.1 Certification Exam 703 Study Guide

DB2 UDB V8.1 Certification Exam 703 Study Guide

4.0 1
by Roger E. Sanders
     
 

  • 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

Overview


  • 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 forstoring, 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.

Product Details

ISBN-13:
9780131840492
Publisher:
MC Press, LLC
Publication date:
06/01/2004
Series:
IBM Press Series--Information Management
Edition description:
Study Guid
Pages:
352
Product dimensions:
6.00(w) x 8.90(h) x 0.90(d)

Meet 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

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

DB2 UDB V8.1 Certification Exam 703 Study Guide 4 out of 5 based on 0 ratings. 1 reviews.
Guest More than 1 year ago
This is one of the latest in a series of study guides that Sanders has put together for various dB2 certifications. As with his earlier books, a lot of its value is in the focus on what you need to know to pass an exam, in this case, the 703 exam. You will find an extensive question set at the end of each chapter, with answers later in the book. These question sets are indispensible for testing your knowledge understanding. But there is a second potential use of this book. It lets you concisely see various technical abilities of dB2. Useful if you are considering using dB2 or one of its competitors, like Oracle or Postgres or MySQL. For example, MySQL's most persuasive argument is that it is free. But it has limitations. No stored procedures [yet]. By contrast, Sanders describes these in dB2 in various chapters, and how they can reduce bandwidth in a client-server application, to cite only one instance. Another example of using this book to compare dB2 and MySQL might be the book's discussion of using foreign key constraints in dB2. Whereas currently in MySQL, foreign keys are not permitted. (Except in a very limited sense.) So with a little imagination, you can use this book as part of a competitive analysis of dB2. Perhaps not what Sanders or IBM fully intended. But the flexibility is useful.