Understanding DB2: Learning Visually with Examples Hardcover – 29 Dec 2007
There is a newer edition of this item:
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support?
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.
- 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
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.
Top customer reviews
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. While it has a chapter on SQL, this gives you an introduction to many of the commonly used commands. SQL is a big language and is best dealt in a book of it's own. But if you haven't used much SQL before, this book will give you enough to get by so I would rush out to buy a companion just yet.
To be honest, I can't really find a fault with this book. I've read about 2 thirds of it line by line and have used it when necessary to get me out of problems at work. I would recommend this book to beginners and intermediate DBAs. There are a number of references available from the IBM website, but only after gaining a good grounding of the nature of DB2 to these really make sense. And that is exactly what this book provides.
Most helpful customer reviews on Amazon.com
Makes us familiar with DB2 terminology gradually in simple terms with example usages without overloading us. Adding a foot note / in-line note mentioning counter parts of each tool/feature/concept in other popular RDBMS such as Oracle /MSSQL would have made this perfect for DBAs learning DB2 for the firsttime.
Nonetheless, this is a good book to start learning DB2.
I am reading this on Kindle, some diagrams are available in color for this book on IBM website. Wish Kindle version has those color diagrams instead of black & white.
It covers DB2 CC tools which is deprecated. You can found official community eBooks on 10 and IBM Data Studio online. It provided by IBM and community.
If you own iPad with Retina screen be prepared all pictures will look like crap. You can download hi-res from official site.
This book hits dead on!! Incredibly easy to read with examples and visuals that make understanding difficult concepts easy, but its encompasses every important concept in DB2 with plenty of detail. I love this book and recommend it to anyone looking for the DB2 book to buy. Of course there are times you will need to access DB2 Info Center when you need very specific detail, but this book will provide you on the right track and explain how you got there perfectly. Hats off to the authors of this one.
Look for similar items by category