From the July IBM Press Books Newsletter
*****************************************************************FREE eBOOK + "BUY 2 GET 1 FREE" OFFER ON SOA AND WEBSPHERE BOOKS*****************************************************************We have several special offers to celebrate the publication of anumber of important new SOA and WebSphere IBM Press books:
* Download a FREE eBook, the Summer SOA and WebSphere Sampler.Check out important content from six new and classic SOA andWebSphere titles. Topics covered include: SOA project planning, amethodology for service modeling and design, MDM as an SOA enabler,business integration architecture and patterns, and more. Downloadthis FREE eBook to read about these important topics.
* Place an order on ibmpressbooks.com for two (2) IBM Pressbooks –- one of the six featured SOA and WebSphere books plus anyother IBM Press book –- and you'll receive a FREE copy of "The NewLanguage of Business: SOA and Web 2.0" by Sandy Carter. Don't wait;this offer is only available while supplies last.
* Get a 35% discount on six new and best-selling SOA and WebSpherebooks, plus free ground shipping in the US.
* Listen to two audio podcast series from expert SOA authors whoexplain concepts from their books: Robert Laird, co-author of thejust-published "Executing SOA: A Practical Guide for the Service-Oriented Architect" has a 3-part podcast series, as does SandyCarter, author of "The New Language of Business: SOA and Web 2.0."
Visit ibmpressbooks.com/SOAspecial to learn details aboutthe special offer, and listen to the audio podcasts.
Here are the other IBM Press titles that you may wish to consider as part of this offer:
Enterprise Master Data Management: An SOA Approach to Managing Core Information By Allen Dreibelbis, Eberhard Hechler, Ivan Milman, Martin Oberhofer, Paul Van Run, Dan Wolfson.Take your career to the next level by understanding how and why master data management can improve your business.
Understanding DB2(R): Learning Visually with Examples (2nd Edition) By Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow.With 20 5-star reviews, how can you go wrong with this book? Whether you've never used DB2 before or whether you're just trying to get up to speed with the latest features, this book is the one for you.
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) By George Baklarz, Paul C. Zikopoulos.This is the essential book that should be on everyone's bookshelf!
Understanding DB2 9 Security By Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry Chan.Improving the security of your environment is definitely something you should consider.
PS. Happy Independence Day to all my American friends!![Read More]
Keep on Learning
svisser1 2700018UK9 3,355 Views
svisser1 2700018UK9 3,348 Views
pureXML™ – “The two most beautiful words in the English language" when it comes to storing and handling XML data.
The pureXML capabilities unique to IBM DB2 software allow you to store your XML data natively in a database table, providing seamless integration of XML and relational data and allowing you to use both SQL and XQuery to query your XML data. What does this mean? Performance improvements, productivity improvements, and cost savings, just like those being realized by other businesses like yours.
OK... sure, this is product information. But check out these videos:
The Pitch Part 1The Pitch Part 2The Pitch Part 3
Do you like watching videos for this kind of thing? Take a look at the large number of videos that are now available on ChannelDB2.com and YouTube.com.
See also Kate's Blog and PlanetDB2.
PS... I need to remember to bring my headphones into work so I don't disturb all those around me by watching / listening to these videos![Read More]
Today's DB2 Magazine Email Newsletter had a pointer to this great reading list for developers:
In addition to these articles, I suggest the following books:
DB2 SQL PL: Essential Guide for DB2 UDB on Linux, UNIX, Windows, i5/OS, and z/OS, Second Edition
by Zamil Janmohamed, Clara Liu, Drew Bradstock, Raul Chong, Michael Gao, Fraser McArthur, Paul Yip
DB2 SQL PL, Second Edition shows developers how to take advantage of every facet of the SQL PL language and development environment. The authors offer up-to-the-minute coverage, best practices, and tips for building basic SQL procedures, writing flow-of-control statements, creating cursors, handling conditions, and much more. Along the way, they illuminate advanced features ranging from stored procedures and triggers to user-defined functions.
The only book to combine practical SQL PL tutorials and a detailed syntax reference, DB2 SQL PL, Second Edition draws on the authors' unparalleled expertise with SQL PL in real business environments.
DB2 Express: Easy Application Development and Administration
by Paul Yip, Kit Man Cheung, Jason Gartner, Clara Liu, Stephen O'Connell
Read the book, "DB2 Express: Easy Application Development and Administration" to learn how to leverage the latest and greatest features in DB2 V8.2 that will help you build, tune, deploy, and troubleshoot your VB.NET or JDBC application.
IBM DB2 UDB Express Edition Version 8.2 delivers everything small- to medium-sized businesses need to accelerate time-to-value and dramatically reduce TCO in their database applications. Like DB2 Express itself, this book cuts out the complexity. You'll find step-by-step guidance using the graphical tools in DB2 Express, and expert tips on database application development and administration, including: application design, development with both Visual Basic .NET and Java security, deployment, performance tuning, day-to-day administration, and more.
Once you are skilled as a database application programmer, verify your skills by taking the AD cert exam 703 (http://www-03.ibm.com/certify/certs/dbapudv81.shtml). You may wish to check out one of the following cert guides created to help prepare you for this exam.
DB2 UDB V8.1 Certification Test 703 Study Guide
By Roger Sanders
DB2 Universal Database v8.1 Application Development Certification Guide, Second Edition
by Steve Sanyal, David Martineau, Kevin Gashyna, Mike Kyprianou
Details on newsletter:
DB2 Magazine Email Newsletter
Volume 6, Issue 9
For the first time in the history of the DB2 certification program, we created an upgrade exam to help those certified as a DBA for Version 7 quickly recertify as a DBA for Version 8. Exam 706, the DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration Upgrade Exam, has 30 questions that are related to DB2 UDB Version 8 ONLY.
The DB2 Version 7 Certification Exams were wildly popular, so the idea was that we could help all those people recertify very easily with a half priced exam, but it didn't work out that way at all!
Our DB2 Version 8 Certification Exams have now exceeded the popularity of the Version 7 exams, but only a very small fraction of people took the upgrade exam route. I wonder why?
To compare the exams:
# Questions: 70
Time limit: 90 min
Tasks covered: All DBA tasks
# Questions: 30
Time limit: 45 min
Tasks covered: Only V8 content
Personally I would prefer to take Exam 706 as there are fewer questions, but perhaps people feel that Exam 706 is much more difficult than Exam 701? Surprisingly the over all pass rate is the same for both exams, so it seems to me that the difficulty level is equivalent.
If you are still certified as a DBA at the V7 level only, consider upgrading to V8 by taking Exam 706 and then let me know what you think. We're wondering if we should go through the effort of creating another upgrade exam for the next release.
If you would like some tips as to which book you should use to prepare for Exam 706, I would suggest one of the following:
DB2 UDB V8.1 Certification Exams 701 and 706 Study Guide
by Roger Sanders
DB2 Universal Database V8 for Linux, UNIX, and Windows Database Administration Certification Guide (5th Edition)
by George Baklarz and Bill Wong
DB2 Version 8: The Official Guide
by Paul Zikopoulos, George Baklarz, Roman Melnyk, Dirk deRoos
IBM Press Program Manager[Read More]
svisser1 2700018UK9 3,328 Views
Willie Favero gave an excellent summary of the best speakers at IDUG NA last week, but I don't remember seeing the complete list.... Melanie Stopfer who is on my extended team, was one of the top 10 speakers! Congratulations!
During the conference closing session on Thursday, May 10, IDUG announced the best-rated presentations from the conference. Listed in alphabetical order, the top 10 DB2 technical session presenters for this event, based on evaluations received from attendees, were:
• Bonnie Baker, Bonnie Baker Corporation • Leon Katsnelson, IBM • Bob Lyle, IBM • Dale McInnis, IBM • Roger Miller, IBM / Chris Munson, IBM • Bryan Paulsen, John Deere Corporation • Terry Purcell, IBM • Suresh Sane, DST Systems, Inc. • Bryan Smith, IBM • Melanie Stopfer, IBM
Congratulations to all the speakers!
PS..... I underlined the people who I've had the pleasure to work directly with over the past few years.
When in University, we were given a list of books that we were required to buy and a schedule of when our classes were. We bought the books, went to classes, and were asked to read the book in preparation for the classes.... is this how professional education is handled as well?
It seems to me that professional education is handled or expected to be different. Most of the classes I've attended since graduating from University, the instructor gives a list of suggested books, but typically none are listed as required and fewer yet are handed out in the class to be used in conjunction with the classroom education.
Personally I think that different people learn in different ways. Some people need an instructor to tell them the important points in the lectures and direct them to the labs, exercises and additional reading. There are others who prefer to read a book on their own time, try the examples in the book and learn by doing.
In the case of classroom education, I think that if a student was given a complementary book to take back to the office, he or she would be able to reinforce what was learned in class and would have a reference book for learning about topics that may not have been covered in class.
I'm mentioning this because I recently arranged for a couple of IBM's classes to hand out a book to students who take the class. Here are the details:
*Free book Offer* CF120 * DB2 SQL Workshop * 2 Days * $1,050
Learn about SQL and how it applies to the entire DB2 UDB Family. This course is appropriate for individuals working in a z/OS, VM/VSE, Linus, UNIX, or Windows environment. Complete extensive hands-on exercises to develop your skills to use the SQL you learn. Perform these exercises either by using the DB2 UDB for Linux, UNIX, or Windows product in a Windows environment or by using the DB2 UDB for z/OS product through a Time Sharing Option (TSO) interface to a z/OS system. This course has been updated to V8.
Get your free copy of "Understanding DB2" while supplies last for classes during February, March and April.
*Free book Offer* U5732 * DB2 Family Introduction Mini-Curriculum * 4 Days * $1,945
Learn the functions and components of IBM DB2 UDB, a relational database manager, which may be installed on a variety of operating systems including z/OS, AIX, Linux, HP-UX, Sun, and Windows operating systems. Discuss the DB2 UDB products and services. Focus on the services DB2 UDB provides and how they work. Learn about SQL and how it applies to the entire DB2 UDB Family. Seven labs are included to address using DB2 UDB for z/OS Version 8 and DB2 UDB for Linux, UNIX and Windows Version 8.
Get your free copy of "Understanding DB2" while supplies last for classes during February, March and April.
If you get a chance, tell me what you think of this idea... would you like to see more IBM and non-IBM classes include a free book with the student materials? In certain cases, should a book be sent to the student in advance as a prerequisite? What do you think?
Roger Sanders' latest book DB2 9 Fundamentals Certification Study Guide continues to sell extremely well... and has received 6 customer reviews on amazon.com.... all rated 5 stars! What are people saying? Click the link above to see all the customer reviews (or to add your own if you own the book :)
The ITSO sends out lists of the most popular IBM Redbooks each month, in terms of the number of downloads. The list covers all IBM Redbooks, across all product areas. This past month, there were 2 DB2 book in the top 10 list:
* DB2 9 for z/OS Technical Overview* Up and Running with DB2 for Linux
Congratulations to all authors!
The featured title for January is the DB2 Express: Easy Development and Administration.
Stay tuned for more news about DB2 Express, the product. Here is a website that will be updated with the news later this month:
For our book of the month, we've been able to get an electronic coupon and free shipping for buyers in the US:
Save 35% on Apache Derby -- Off to the Races and preview a sample chapter! Visit http://ibmpressbooks.com/title/0131855255 and enter case-sensitive coupon code CLOUDSCAPE at Step #3 during checkout to redeem.
While you're on the IBM Press site, sign up for the newsletter to keep on top of all the new releases (I will typically only tell you about the data ones) and become a member to qualify for a 30% discount on all IBM Press books.
svisser1 2700018UK9 3,243 Views
Here's another book that was just recommended to me:
Querying XMLXQuery, XPath, and SQL/XML in context (The Morgan Kaufmann Series in Data Management Systems)by Jim Melton, Stephen Buxton
Foreword by Don Chamberlin
Although the book was written BEFORE the release of DB2 9, it is an excellent product-indepentant book that can help you learn how to query the XML you wish to store in a database.
From the Back CoverThere is no more authoritative pair of authors on Querying XML than Jim Melton and Stephen Buxton. Best of all, as readers of Jim's other books know, his informal writing style will teach you what you need to know about this complex subject without giving you a headache. If you need a comprehensive and accessible overview of Querying XML, this is the book you have been waiting for.-from the foreword by Don Chamberlin, IBM Fellow, Almaden Research Center
Enjoy! Susan[Read More]