I was just informed that the McGraw-Hill book DB2 9 New Features is also available in India. One of the major selling points of this book, besides the fact that it lists all the newest features is it's coverage of XML. There is no other book on the market that has such thorough coverage of XML on DB2 9.
The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.
Keep on Learning
From archive: November 2007 X
Yesterday I received a comment on my blog entry asking when the book would be available in India. Here is my answer.
Most of our DB2 titles are published with either MC Press or Pearson Education. Pearson has a subsidiary in India and their site has an IBM Press page. I don't see any current books on the site yet, which is strange since the Security book was published in January this year. I've asked the publisher to let me know when the books will be ready in India and I'll pass the information along via my blog.
MC Press doesn't have a subsidiary, but they and other publishers tend to use local Indian publishers such as Schroff Publishing. I see that some of the books that I highly recommend are already on the site, including: DB2 9 Fundamentals Certification Study Guide, which you can purchase for Rs. 500.
I'll have more information about book availability in India and China very soon!
Finally the most essential DB2 book for DBAs has been updated for the latest release of DB2: DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition).
Congratulations to both George Baklarz and Paul Zikopoulos! As you may know, Bill Wong was George's co-author for the fourth and fifth editions to this book (as well as one of mine :). Bill had moved to a job in Tivoli, but is now back in DB2... which I'm quite happy about. Paul joined the team and I'm sure that this edition follows the tradition of the previous editions: well-written, easy to read, thorough, and essential!
What can you find in this book? Well, 1136 pages, for starters! As you can tell from the sheer size of the book is that you'll find much more than exam prep details! In fact, I would suggest that you continue to buy / read the Exam Study Guides by Roger Sanders to prepare for DB2 Certification Exams, but buy this book as your way to learn what you need to know, beyond the exams.
The sections of the book that I'd like to draw your attention to include:
1) Security. Although it doesn't cover the topic as thoroughly as Understanding DB2 9 Security does, it does include important security and resiliency enhancements, including advanced access control; fine-grained, label-based security; and the new security administrator role
2) SQL. There is an entire section of the book devoted to SQL. In my mind, there IS no other book you need for SQL beyond this one. Coverage includes pure XML, advanced SQL, and yes, even SQL for beginners. George is somewhat of an SQL expert and creates examples of all sorts to demonstrate a variety of SQL. But, George and Paul rarely rely solely on their own knowledge alone. They are well-connected with the entire development team and the book benefits from additions and reviews by the top experts in the area.
3) Autonomics. Want to make your environment more automatic? Learn about the operational improvements that can enhance your efficiency. Coverage includes self-tuning memory allocation, automated storage management, and storage optimization.
4) Partitioning. Perhaps an advanced topic, but important none-the-less. Learn about the new table-partitioning features that improve scalability and manageability.
5) Development. My dream would be to publish a book for this area alone, but since that isn't in the cards right now, read this book to learn about the powerful improvements for more agile and rapid development, including the new Eclipse-based Developer Workbench and simple SQL or XQuery access to all data.
I plan to work with both George and Paul to further feature unique aspects about their book, so stay tuned.
Interestingly, this book is not on special on amazon.com. I'm not sure why that is, but I'll keep watching to see if they put a sale on this book that matches their usual 37% discount. You may buy the book from the IBM Press websites at a discount:
United States - Use the coupon code DB2SAVE to get 35% off this and other books.Canada - 35% off all IBM Press titlesEMEA - 35% off all IBM Press titles.
IBMers may choose to purchase the book through an Internal Site.
Buy today and keep up to speed on the latest features.
The best book to buy right now for a beginner's look at DB2 is the Understanding DB2 book. The one that is available today is for V8.2, but it covers everything that you need to know about DB2 in a very easy to understand way. I like the way the authors added a mini case study at the end of each chapter to solidify the material covered in the chapter. There are also 5 or more study questions at the end of each chapter that can also help ensure that you've grasped the concepts.
The subtitle of the book is "Learning Visually with Examples" and the authors did a fine job of including many diagrams and screen captures throughout the book to make learning a bit more interesting. Check out the positive reader feedback that is posted on the amazon.com site linked above.
Also, I've had feedback from people who were trained on our databases or platforms (Oracle or DB2 for z/OS) and mentioned that they found it amazingly easy to transfer their skills to DB2 Linux, UNIX, Windows with the help of the book.
The newest version of this book comes out in the next month, Understanding DB2 Second Edition so you may want to wait till it is available, or you can buy the 8.2 version now at a reduced price. The best place for a European to buy this book is from Pearson Education EMEA Bookstore where this book is now available for £27.94; free shipping in Europe.
Another site worth checking is our IBM Information Management Bookstore where we have information about a deal where you can get 35% off all IBM Press books ordered before the end of December. Free shipping in the US.
If you're a book lover like me... then you have many bookshelves filled to the brim with books, many of which have been read, but many others waiting to be read. And then there is the inevitable purchase of more books every time you walk into a bookstore! But how can you choose which one is best for you?
If you are looking for technical books, you should try either Safari or Books 24x7 (or really, both!). These online book engines allow you to search across an entire collection of books helping you pinpoint the information that you need RIGHT NOW! If you like, you can simply just continue to search, as you do on Google, and then read the sections that come up. Or you may choose to read the entire book electronically. Your choice.
A few years ago I ran a pilot of Safari in the Toronto Lab. Some of the feedback I received then was that this tool helped them discover a book that they didn't know existed. The person then went to an online bookstore and purchased the printed version of the book. So, not only can you read the entire book online, but you can use these tools as a way to screen / filter the unbelievably large collection of tech books to find what is best for you.
Now is a great time.... as Safari is offering a 10-day free trial to use the tool. If you work for IBM, you should already know that you have a free subscription to Books 24x7. The internal link can be found on the page w3.ibm.com/learning.
So, what's the difference between these two tools? The primary difference is the selection of books. Safari is jointly owned by O'Reilly and Pearson, so you'll find all of their titles in Safari. Books 24x7 typically covers all other books from a variety of publishers. The good news for IBM Press books is that these titles can be found in both.
I hope that you're able to take advantage of these trial offers and that you find the book you need! See our IBM IM Bookstore for the books that I'd suggest.
The DB2 Chat with the Lab series continues. Listen to the DB2 experts, including Sal Vella, Drew Bradstock, Chris Eaton, Pat Bates, Paul Bird, Bill Minor, John Hornibrook, and Les King who develop breakthrough technology and get your questions answered.
Here are some of the topics that you can find:
* DB2 Warehouse 9.5 - What's New in the Platform for High Performance DB2 Analytics* Workload Management in Viper 2* Deep Dive into Deep Compression - a look into Compression in Viper and Viper 2* DB2 for LUW Security Enhancements: Making Database Security Management and Compliance Easier* Viper 2 Features and Open Beta Program* Webcast: Premiering DB2 Express-C: The Truly Free Database* Improved Query Optimization with Statistical Views* Beyond DB2 Viper - Technology Trends and Directions
New chats are added all the time, so keep watching for chats that you can take part in live.
I blogged about IBM DB2 Gaming last month, and when at the IDUG Athens conference last week, I handed out many DVDs that contain these games. I hope all those who received a DVD find it useful.
One of the suggestions I made to the attendees last week is that the games can be suitable for a teenaged audience. I was part of the pilot team and personally taught a classroom full of high-school students using the DB2 Detective Game. I was very pleased to see the awe in the students at the end of the session with comments like "oh, that's a database!" or "SQL is REALLY powerful". I hope you have similar experiences with either teenagers or new employees. Please let me know your experiences.
IBM DB2 Detective GameIBM DB2 Business Game
Congratulations to the authors for completing this book for DB2 Express-C 9.1: Getting Started with DB2 Express-C
Getting started with DB2 couldn't be easier. Read this book to:
* Find out what DB2 Express-C is all about * Understand DB2 architecture, tools, security * Learn how to administer DB2 databases * Write SQL, XQuery, stored procedures * Develop database applications for DB2 * Practice using hands-on exercises * Prepare for the DB2 on Campus exam
This book is ideal for developers, consultants, ISVs, DBAs, students, or anyone who wants to get started with DB2. While this books is focused on DB2 Express-C, the no-charge edition of DB2, the concepts and content are also very applicable to other DB2 editions on Linux, UNIX, and Windows.
Authors of the book include: Raul Chong, Rav Ahuja, and Ian Hakes.
Did you know that Viper 2 brings new capabilities to you as a developer, whether you're using SQL, XML, PHP, Ruby, .NET, or Java™?
As a developer it is difficult to stay on top of what is going on in the industry as technology is constantly changing. Learn how Viper 2 brings new productivity capabilities to you as a developer regardless of what programming environment you are in. In this webcast, you'll get all the details about what's new for developers in the latest release of IBM® DB2® for Linux®, UNIX®, and Windows®.
Grant and Chris will discuss trends in the industry that affect developers and describe what IBM Information Management is doing to help your development. You probably already know that DB2 Express-C is free for developers to develop, deploy and distribute. Now, Viper 2 provides a variety of means that help move your application from the development stage to deployment more rapidly.
New features will be covered in the following areas:
* The latest developer tools * Java development productivity * XML and XQuery * SQL * Database driver support * Web services creation and deployment
Date: November 7, 2007, 11am Eastern (10am Central, 8am Pacific)
* Grant Hutchison, Product Manager, IBM Data Server Clients and Tools * Chris Gruber, IBM >Developer Initiatives
Click here to register for this webcast: Webcast: What is new in Viper 2 for developers?[Read More]