*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.
Customer Reviews:
Avg. Customer Rating: 4.0 / 5.0
Another Excellent Certification Exam Study Guide:
If you studying for the Family Application Development Exam (703) certification exam, you will find the book to be quite helpful. I wish I had this book when I was studying 703 certification exam. Many of us concentrate on only one or two of the methods of communicating with DB2 in our programs. The book does a good job of explaining embedded SQL programming, CLI/ODBC programming and Java programming. It is difficult to remember all the information about all of these and the book gives a great review... more info
NOT a good book:
I am pretty sure even exam 706 (of which I did not review the objectives) will not ask for ALL the parameters for the dbm? It's unweidy to paste a total of 12 pages on the dbm cfg parameters. Was it necessary or to thicken the book? It's a certification book - please focus on the certification objectives ONLY.
Use for competitive analysis of dB2:
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... more info
You must do the problems:
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... more info
