Understanding DB2: Learning Visually with Examples and over 2 million other books are available for Amazon Kindle . Learn more


or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Start reading Understanding DB2 on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Understanding DB2: Learning Visually with Examples (IBM Press) [Paperback]

Raul F. Chong , Xiaomei Wang , Michael Dang , Dwaine Snow
5.0 out of 5 stars  See all reviews (1 customer review)
RRP: £44.99
Price: £37.50 & FREE Delivery in the UK. Details
You Save: £7.49 (17%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it Thursday, 2 Oct.? Choose Express delivery at checkout. Details

Formats

Amazon Price New from Used from
Kindle Edition £35.62  
Hardcover --  
Paperback £37.50  

Book Description

12 Mar 2012 0133007049 978-0133007046 2
The Easy, Visual Way to Master IBM® DB2 for Linux®, UNIX®, and Windows®—Fully Updated for Version 9.5

IBM DB2 9 and DB2 9.5 provide breakthrough capabilities for providing Information on Demand, implementing Web services and Service Oriented Architecture, and streamlining information management. Understanding DB2: Learning Visually with Examples, Second Edition, is the easiest way to master the latest versions of DB2 and apply their full power to your business challenges.

Written by four IBM DB2 experts, this book introduces key concepts with dozens of examples drawn from the authors' experience working with DB2 in enterprise environments. Thoroughly updated for DB2 9.5, it covers new innovations ranging from manageability to performance and XML support to API integration. Each concept is presented with easy-to-understand screenshots, diagrams, charts, and tables.

This book is for everyone who works with DB2: database administrators, system administrators, developers, and consultants. With hundreds of well-designed review questions and answers, it will also help professionals prepare for the IBM DB2 Certification Exams 730, 731, or 736.

Coverage includes

  • Choosing the right version of DB2 for your needs
  • Installing and configuring DB2
  • Understanding the DB2 environment, instances, and databases
  • Establishing client and server connectivity
  • Working with database objects
  • Utilizing breakthrough pureXML™ technology, which provides for nativeXML support
  • Mastering administration, maintenance, performance optimization, troubleshooting, and recovery
  • Understanding improvements in the DB2 process, memory, and storage models
  • Implementing effective database security
  • Leveraging the power of SQL and XQuery

Product details

  • Paperback: 1056 pages
  • Publisher: IBM Press; 2 edition (12 Mar 2012)
  • Language: English
  • ISBN-10: 0133007049
  • ISBN-13: 978-0133007046
  • Product Dimensions: 23.2 x 17.9 x 5.1 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 1,712,772 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

From the Back Cover

The Easy, Visual Way to Master IBM® DB2 for Linux®, UNIX®, and Windows®—Fully Updated for Version 9.5

IBM DB2 9 and DB2 9.5 provide breakthrough capabilities for providing Information on Demand, implementing Web services and Service Oriented Architecture, and streamlining information management. Understanding DB2: Learning Visually with Examples, Second Edition, is the easiest way to master the latest versions of DB2 and apply their full power to your business challenges.

Written by four IBM DB2 experts, this book introduces key concepts with dozens of examples drawn from the authors' experience working with DB2 in enterprise environments. Thoroughly updated for DB2 9.5, it covers new innovations ranging from manageability to performance and XML support to API integration. Each concept is presented with easy-to-understand screenshots, diagrams, charts, and tables.

This book is for everyone who works with DB2: database administrators, system administrators, developers, and consultants. With hundreds of well-designed review questions and answers, it will also help professionals prepare for the IBM DB2 Certification Exams 730, 731, or 736.

Coverage includes

  • Choosing the right version of DB2 for your needs
  • Installing and configuring DB2
  • Understanding the DB2 environment, instances, and databases
  • Establishing client and server connectivity
  • Working with database objects
  • Utilizing breakthrough pureXML™ technology, which provides for nativeXML support
  • Mastering administration, maintenance, performance optimization, troubleshooting, and recovery
  • Understanding improvements in the DB2 process, memory, and storage models
  • Implementing effective database security
  • Leveraging the power of SQL and XQuery
--This text refers to an out of print or unavailable edition of this title.

About the Author

Raul F. Chong, DB2 on Campus Program Manager at the IBM Toronto Laboratory, is a DB2 Certified Solutions Expert in administration and application development with ten years of experience in DB2. He has helped customers resolve DB2 migration, performance, and design issues; developed new DB2 solutions; taught DB2 workshops; contributed to DB2 exam tutorials; and was the lead author of the first edition of Understanding DB2.

Xiaomei Wang, a technical consultant at the IBM Toronto Laboratory, has nine years of DB2 experience. She has handled critical DB2 customer and business partner situations worldwide.

Michael Dang, DB2 Technical Sales Specialist, specializes in solution design, database sizing, product licensing, and Balanced Warehouse configurations. He formerly served as a DB2 Support Analyst and spent seven years as a DB2 DBA.

Dwaine R. Snow, DB2 Senior Product Manager, has worked with DB2 for seventeen years. He is the coauthor of Advanced DBA Certification Guide and Reference for DB2 Universal Database for Linux, UNIX, and Windows, DB2 UDB for Windows, and the first edition of Understanding DB2.


What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
4 of 4 people found the following review helpful
By Amano
Format:Hardcover
I started in a new Operations role in a software company that used DB2 as their target database. I had previoulsy used MySQL on other applications but after a short while trying to figure out DB2 I knew that it would take more than online manuals to get a good understanding of the architecture of DB2. I didn't find many books on DB2 (as opposed to the hundred or so for Oracle) but fortunately 'Understanding DB2' is one of the best technical books I've bought.

The first couple of chapters take you through the basics of DB2 such as it's admin and monitoring tools, DB2 environment and even and introduction into database partitioning. The language used is very clear without being overly wordy and the diagrams provide good aids to understanding the structure of DB2.

I was a bit cautious about the 'Learning Visually with Examples' subtitle of the book as I didn't want almost a thousand pages of useless Windows screen shots with little explanation. However the authors have done a good job to ensure all diagrams and screenshots are appropriate. In fact there a less GUI screenshots than you might expect because a lot of DB2 is operated from the command line. It is good that most time was spent with the command line because a GUI are not always available (I work with DB2 on Unix and Windows) and while it's easy to understand the GUI after knowing the command line, the reverse is not true.

I especially liked the practical nature of the book, including the case studies at the end of each chapter which take you through possible real life examples of what you've just learnt. The questions also help to make sure you've understood the chapters.

It should be noted that this is not a book to teach you SQL.
Read more ›
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.6 out of 5 stars  29 reviews
13 of 13 people found the following review helpful
5.0 out of 5 stars Case studies, graphics, sample questions, and well-written 17 Mar 2005
By S. Visser - Published on Amazon.com
Format:Hardcover
I find it hard to believe that I am the first person to post a review of this book.

I spent quite a bit of time reviewing this book as I was about to be a guest speaker at a local college. Everything I read I found to be easy to understand and well-laid out. The best part for me is the case studies. Basically the authors go through an easy to understand scenario where they clearly demonstrate the concepts discussed in the chapter. There is a case study for each chapter, and 17 chapters.

I am still loosely involved with DB2 certifications and I was very happy to see that the authors included 20 sample questions for each chapter of the book. Writing good sample questions is difficult to do, but this author team has clearly put a lot of time and effort in to ensure that there are many questions that are useful whether you are just trying to validate your retention of the chapter or if you are trying to pass one of our exams. An appendix in the back of the book explains the answers to each question as well, but don't peek until you've tried to answer the questions on your own!

This book also has a diagram for everything. The cover says you'll be learning visually with examples, and that couldn't be more true. The CD also contains colour versions of the key diagrams so that you can print them and review them.

This book should be mandatory for anyone who is learning DB2 for the first time, but I also think that this book is useful as a reference book and a refresher for anyone who works with DB2.
8 of 8 people found the following review helpful
5.0 out of 5 stars A concise, visual exploration of DB2 6 July 2005
By mairhtin Ofeannag - Published on Amazon.com
Format:Hardcover
This book is really rather interesting. It appears to take off where the old Don Chamerlain books ended. Don has not given us one of his tomes in quite some time (version 5, I believe) and they have been sorely missed. This book takes up that honorable tradition.

DB2 is a complex and at times complicated set of software services, and needs some sort of gentle entrance guide. By not assuming that the reader is familiar with anything, and by explaining everything is a visual manner, the book assists first-timers and even those of us who are experienced to walk confidently through the excersises and learn the tasks of a DBA or new-found developer.

A must read for those who need to be "up and running" as quickly as possible!!
7 of 7 people found the following review helpful
5.0 out of 5 stars A great book for experienced DBAs who are new to DB2 UDB 5 Jun 2005
By Ted J. Wasserman - Published on Amazon.com
Format:Hardcover
If you have previous relational database experience, but are new to DB2, this book is for you. This book focuses on the administration tasks and features available in DB2.

The writing style of the book should appeal to those who like to learn using a lot of examples and diagrams (also included on the accompanying CD if you want to print them out in color). These complement the written material very well. All important DB2 administration concepts are explained in a straightforward and easy-to-understand manner. Most topics include at least one example to re-inforce important ideas.

Two other features of this book that I really liked are the short Case Studies and numerous Review Questions at the end of each chapter. The case studies are based on common real life scenarios and are meant to illustrate how the topics covered in the chapter can be applied in a real life setting. This is very helpful for seeing the material "in action". The review questions also help solidify the important concepts covered in the chapter can be used while studying for the DB2 certifications.

I would also recommend this book if you are planning to study for the DB2 Certifications. I would read this one first, to have all the fundamental concepts explained in a clear and illustrative manner. I would then consider obtaining one of the other certification guides to fill in all the nitty gritty details you might expect on a certification test.

Overall, I would highly recommend this book if you have some relational database background and are looking to gain a clear and fundamental understanding of DB2 administration topics.
5 of 5 people found the following review helpful
5.0 out of 5 stars Best guide for DB2 learners, designers and administrators 5 April 2005
By Manu Sud - Published on Amazon.com
Format:Hardcover
Finally, I am able to find a book that does teach me WHAT IS DB2? When I first saw the book, I was scared to see that I will need to read another set 900 pages. But when I started reading, I loved the clear instructions and step-by-step procedures. These helped me not only understand concepts but also test them. The name of this book says it all... Understanding DB2(R): Learning Visually with Examples. This book places heavy emphasis on writing code by using examples provided in throughout the book.

As an engineer, I like solving problems. And I was delighted to see the sample questions that helped me clear my DB2 certifications. I gave this book 5 stars because I commend the authors on a book that takes a hard/boring subject and makes it fairly readable. I also like their writing style and the code examples are great.

In conclusion, the book has good and usable information under its covers, and is a worthy read for novice as well as the experienced database designers and administrators.
4 of 4 people found the following review helpful
4.0 out of 5 stars Every thing you need to know about DB2 4 Oct 2005
By David Stout - Published on Amazon.com
Format:Hardcover
This book has everything you need to get you started using DB2 however I felt it lacked some understanding of the SQL language.

The book comes with a trial version of the DB2 database. This is handy for precious.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback