IBM DB2 Books - Page 3

DB2 Fundamentals Certification for Dummies

Paul C. Zikopoulos, Jennifer Gibbs, Roman B. Melnyk

Amazon Price: $23.09 List Price: $34.99 Usually ships in 24 hours By: For Dummies Amazon Marketplace: 37 new & used starting at $1.64

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Certification Central -> Exams -> DB2
Subjects -> Computers & Internet -> Certification Central -> General
Subjects -> Computers & Internet -> Certification Central -> General AAS

Customer Reviews:
Total reviews: 12 Average rating: 4.5 of 5

Essential to my success on Exam 512 5 out of 5 stars.
6 of 6 people found this review helpful.

This book made passing Exam 512 fairly easy. Books & classes from IBM do not focus on passing the exams, but this book does. During 10 yrs. of UNIX sys. admin. I'd done almost no database work. I passed Exam 512 after 3 weeks of concentrated effort. Week 1 - 2 classes: DB2 UDB Family Fundamentals (2 days) & DB2 UDB SQL Workshop (2 days). Weeks 2 & 3 - Read "DB2 Fundamentals Certification for Dummies" cover to cover. I answered every end of chap. question, did every lab and took the practice exams on the CD. I'd never sat for a certification test and this book made me very comfortable with the process. I passed Exam 513 three weeks later using a 4 day class, DB2 UDB Admin. Workshop, and "All-In-One DB2 Admininistration Exam Guide" in the same fashion. I highly recommend this book for passing Exam 512. I would not recommend it as a reference for DBAs.

Editorial Review:

IBM Universal Database is experiencing tremendous share growth and certification in DB2 is quickly becoming an important hiring factor with many corporations turning to UDB for their database solutions. This book will guide you quickly through preparation for the DB 2 Fundamentals exam -- and start you on the path to DB2 certification!

Focused specifically on this exam, DB2 Fundamentals Certification For Dummies will help you prepare quickly and efficiently for the Fundamentals exam. This guide brings you extensive self-assessment opportunities -- including questions prepared by IBM insiders with access to the actual exam content. Plus, the book includes coverage of what to expect during the actual testing situation, and tips and hints on how to best prepare for the exam.

Advanced DBA Certification Guide and Reference for DB2(R) Universal Database v8 for Linux, UNIX, and Windows (IBM Press Series--Information Management)

Dwaine R. Snow, Thomas Xuan Phan

Amazon Price: $53.07 List Price: $65.99 Usually ships in 24 hours By: IBM Press Amazon Marketplace: 21 new & used starting at $27.95

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Certification Central -> Exams -> DB2
Subjects -> Computers & Internet -> Certification Central -> IBM
Subjects -> Computers & Internet -> Certification Central -> Linux

Customer Reviews:
Total reviews: 15 Average rating: 5.0 of 5

Excellent book 5 out of 5 stars.
3 of 3 people found this review helpful.

This is the book I was waiting for long on DB2UDB. This not only covers topics for certifications but also good (very good) reference material for all UDB DBAs on LUW platform.

Absolutely the best DB2 book! 5 out of 5 stars.
3 of 3 people found this review helpful.

I just found this book, and after reading it wish I had found this years ago. This is the most comprehensive book on DB2 that I have ever seen. This book has already saved me a lot of time. The performance chapter is great and helped me improve the performance of my DB2 server by over 30% in less than a week.

Editorial Review:

This book contains practice exams, plus detailed answers and explanations, covering every concept and technique for the advanced DBA Certification. Topics covered will include: advanced administration, high availability backup and recovery, performance tuning and scalability, networking and security, how to manage a large number of users and connections and large amounts of data, authentication, and encryption. People will need to pass the Fundamentals and DBA exams before they can take the Advanced DBA. IBM estimates that a large percentage of those who take the regular DBA exam will go on to seek Advanced DBA certification since the information covered with the Advanced DBA material will greatly improve their skills.

DB2: Concepts, Programming and Design (IBM McGraw-Hill Series)

Jay Ranade

List Price: $52.95 By: McGraw-Hill Companies Amazon Marketplace: 22 new & used starting at $4.47

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Specific Databases -> IBM DB2
Subjects -> Computers & Internet -> Databases -> General

Customer Reviews:
Total reviews: 2 Average rating: 5.0 of 5

Most user friendly 5 out of 5 stars.
0 of 4 people found this review helpful.

I feel that Mr. Ranade has done a great job by writing such a reader friendly book but i feel that a topic that needs a little bit more evaluation is the Field proc and the edit proc and how they can be applied on a table so that it facilitates the sorting of data according tothe user needs.

Editorial Review:

DB2, announced in 1983, has quickly replaced IMS as IBM's premier database product. This book covers key DB2 concepts from the perspective of DB2 Version 2, the most recent release of DB2, and provides a sample database that can be created on DB2 systems. Covered here are new topics such as: DB2 and IBM's Systems Applications Architecture; OS/2 EE and CSD; DDBMS (Distributed Data Management); IBM's implementation of DDBMS in OS/2 and DB2. Other key DB2 topics that are discussed here include: relational data model (including referential integrity); SQL and DB2 utilities; query processing and QMF; catalog and directory; application processing and CICS transaction management; security and authorization; flow of SQL, explain and performance; connection protocols and threads; data integrity, locking and concurrency; and logical database design.

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

Roger E. Sanders

Amazon Price: $31.45 List Price: $34.95 Usually ships in 24 hours By: Mc Press Amazon Marketplace: 20 new & used starting at $24.49

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Certification Central -> Exams -> DB2
Subjects -> Computers & Internet -> Certification Central -> Linux
Subjects -> Computers & Internet -> Certification Central -> General

Customer Reviews:
Total reviews: 1 Average rating: 5.0 of 5

Editorial Review:

In DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade 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 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 Certification Upgrade exam (Exam 736) provides validation that you have mastered DB2 9. Passing this exam also earns you the IBM Certified Database Administrator or Advanced Database Administrator certification.

This concentrated guide includes an extensive set of practice questions in each chapter 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.

With the DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade Certification Study Guide, you will:

• Gain the knowledge necessary to pass the DB2 9 for LUW DBA Upgrade Certification exam (Exam 736)

• Discover the changes to DB2 9 that you’ll need to know in order to be successful when taking the exam

• Receive an explanation of every topic included on the test…by someone involved in the creation of the actual exam

• Find 60 practice questions based on the actual exam’s format and approach, along with comprehensive answers to the test questions to help you gain understanding

DB2(R) Universal Database V8.1 Certification Exam 700 Study Guide

Roger E. Sanders

Amazon Price: $40.85 List Price: $59.99 Usually ships in 24 hours By: IBM Press Amazon Marketplace: 37 new & used starting at $5.99

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Certification Central -> Exams -> DB2
Subjects -> Computers & Internet -> Certification Central -> General
Subjects -> Computers & Internet -> Certification Central -> General AAS

Customer Reviews:
Total reviews: 16 Average rating: 4.5 of 5

Great book 5 out of 5 stars.
0 of 0 people found this review helpful.

Even for people that thinks that knows everything about DB2, this book is important because it delves into the main subjects that will appear in the exam, but also is useful to give you an overview about what you know, and what you have the opportunity to enhance your skills using other sources.

Editorial Review:

This book covers the first "Fundamentals" exam (test 700 (previously test 516)) an individual needs to pass in order to become DB2 UDB Version 8.1 certified. Written by a DB2 UDB Certified author who worked directly with the DB2 UDB Version 8.1 Certification Exam development team and reviewed by the IBM Data Management Certification Program Manager, each book is guaranteed to provide the reader with all of the information needed to pass the V8.1 Certification test 700. Exam-like questions and answers are provided at the end of each chapter and information explaining why each answer provided is correct accompanies every answer given. This is a must-have for any DBA taking the first certification exam.

DB2(R) Universal Database V8.1 Certification Exam 703 Study Guide (IBM Press Series--Information Management)

Roger E. Sanders

Amazon Price: $36.49 List Price: $49.99 In stock soon. Order now to get in line. First come, first served. By: IBM Press Amazon Marketplace: 13 new & used starting at $7.65

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Certification Central -> Exams -> DB2
Subjects -> Computers & Internet -> Certification Central -> IBM
Subjects -> Computers & Internet -> Certification Central -> General

Customer Reviews:
Total reviews: 5 Average rating: 4.0 of 5

Editorial Review:

*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.

Advanced Topics in DB2

Blaine Lucyk

List Price: $56.95 By: Addison-Wesley Pub (Sd) Amazon Marketplace: 16 new & used starting at $8.81

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Computer Science -> Software Engineering -> Information Systems
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Specific Databases -> IBM DB2

Database Design and Programming for DB2/400

Paul Conte

List Price: $75.00 By: 29th Street Press Amazon Marketplace: 15 new & used starting at $17.55

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Computer Science -> Modeling & Simulation
Subjects -> Computers & Internet -> Databases -> Database Design
Subjects -> Computers & Internet -> Databases -> Database Management Systems

Customer Reviews:
Total reviews: 4 Average rating: 5.0 of 5

Editorial Review:

Paul Conte, a leading DB2/400 authority with extensive application development experience, provides easy-to-follow instruction in the proper way to create efficient, flexible databases on the AS/400. His explanations and advice assure that you'll handle your design and coding challenges with confidence and professional-level techniques. This book provides complete coverage of both DDS, the traditional approach to defining DB2/400 files, and of SQL/400, the industry-standard database language that is IBM's strategic language for the future of DB2/400. With this text, you can be sure of handling not only existing application databases, but also developing new SQL/400 databases. These skills will put you in the forefront of AS/400 application developers. Database Design and Programming for DB2/400 also provides an excellent introduction to practical database design techniques. You get a solid introduction to the relational database model, which underlies the whole DB! 2/400 architecture and the SQL language. On that foundation, the book explains a step-by-step method of modeling an organization's database requirements and developing a design for the necessary database files. The text is designed for college-level courses and for independent study. Each chapter has numerous examples and exercises. The material is organized into four parts - DDS, database design, SQL, and advanced DB2/400 features - so you can focus on particular topics as needed. Appendices provide extensive reference material. You can use the book as your single DB2/400 resource, eliminating the need for many IBM manuals. You will find Database Design and Programming for DB2/400 immediately useful, whether you're just beginning to learn DB2/400 or you are an experienced developer. You will turn to this book time and time again for advice on the best way to design and program DB2/400 databases.

DB2(R) High Performance Design and Tuning

Richard A. Yevich, Susan Lawson

List Price: $54.99 By: Prentice Hall PTR Amazon Marketplace: 10 new & used starting at $12.40

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Relational Databases
Subjects -> Computers & Internet -> Databases -> Specific Databases -> IBM DB2

Customer Reviews:
Total reviews: 5 Average rating: 3.5 of 5

A book that tells you how to do it, not just how it works! 5 out of 5 stars.
23 of 28 people found this review helpful.

Enough can't be said about the usefulness of this book. Rather than explain how things work in DB2, it gives great advice on making DB2 applications perform. We changed a few things that we were a little wrong about, and significantly changed how memory was being allocated (BP, EDM, etc.), and reduced I/O and achieved measureably more transaction throughtput. And we have only started going though all the information, about 680 pages of it. The chapters on Data Sharing really answered some questions that we didn't understand -- great info. Just wish this book had been around earlier.

Editorial Review:

Now, there's a comprehensive core book on DB2, including coverage of the not-yet-released Version 7 of DB2: its key characteristics, and how to tune it for maximum performance. Written by world-renowned DB2 consultants Richard Yevich and Susan Lawson -- and endorsed by DB2 Chief Architect Roger Miller -- this book delivers the most thorough, real-world optimization information ever published, for both developers and administrators. Coverage includes: DB2 high-performance design for both OLTP and OLAP applications; practical techniques for improving the efficiency of SQL; working with the DB2 Optimizer; DB2 data sharing implementation and performance; triggers, stored procedures, UDFs, and other advanced DB2 programming techniques; and specific coverage of optimizing data warehouses and enterprise applications.

Business Intelligence for the Enterprise (IBM DB2 Certification Guides)

Mike Biere

Amazon Price: $40.49 List Price: $44.99 Usually ships in 24 hours By: IBM Press Amazon Marketplace: 27 new & used starting at $14.03

Buy at Amazon.com

Browse similar items by category:
Subjects -> Business & Investing -> Industries & Professions -> E-commerce -> General
Subjects -> Business & Investing -> Industries & Professions -> E-commerce -> General AAS
Subjects -> Business & Investing -> Industries & Professions -> MIS

Customer Reviews:
Total reviews: 5 Average rating: 4.0 of 5

Editorial Review:

The Business Intelligence space is one fraught with vendors, tools, and opinions of how best to implement BI solutions. This book addresses key areas of BI such as data structure and delivery, tools evaluation, and more. The subject areas are presented from the author's point of view and experiences. At the heart of the materials are points to ponder, food for thought, and significant errors to avoid. Business Intelligence is the conscious, methodical transformation of data from any and all data sources into new forms to provide information that is business driven and results oriented. It will often encompass a mixture of tools, databases, vendors in order to deliver an infrastructure that not only will deliver the initial solution, but it will incorporate the ability to change with the business and current marketplace. The purpose of investing in BI is to transform from an environment that is reactive to data to one that is proactive. A major goal of the solution will be to automate and integrate as many steps and functions as possible. Another goal is to provide data analytics that are as tool independent as possible.