We gave another 200 exams on our third day. This brings the total number of exams given this week to over 600! We've been giving free exams to the attendees of this conference for more that 7 years now, so the attendees look forward to this offer.
Our exams normally cost $150 per try, so many conference attendees use this savings as a way to justify their conference fees. There are attendees who have taken and PASSED more than 5 exams this week. That is a significant savings for their companies, just in terms of the exam fees.
Also because our free testing is an annual event, people are coming prepared. I find that our first day pass rate for exams is extremely high largely due to the fact that people are preparing to take the exams before they come. We also run pre-conference exam crammer courses on the Sunday before the exams begin and I find that these people usually do well on the exams. This year we had Susan Lawson, Roger Sanders, and Bob Snell teach the crammer courses and those who attended them found them to be very useful.
The passing rate seems to fall as the week progresses though. I think this is due to the fact that people have passed the exams that they really wanted to pass and begin trying exams that they aren't fully prepared for. This is fine since each exam can be taken twice while at the conference and the score reports help people pin point the areas where they need to do more studying.
I had a few people comment that they aren't fans of certification exams because they know others who have passed an exam simply by reading a book. Although I'm sure it happens that a person passes an exam by reading a book, I find that our exams are experience-based and tend to be very difficult to pass simply by reading a book. In fact I have found that there are people who have worked on DB2 products for years but their focus is so narrow that they need to broaden their understanding of the product by reading books or taking classes before they are able to pass the exam.
The class we ran for the CM exam seems to have been successful. We had 40 people attend a three hour session after the conference ended for the day. Most of these people came to take Exam 443 as it was a very busy day for us!
The bookstore closed at the end of yesterday with not a single z/OS book remaining! Perhaps this means that the adoption rate for DB2 z/OS V8 is increasing! Susan Lawson's certification guide, Craig Mullins' Developer Guide, and Susan Sloan's Official Guide were the three top sellers at the conference. All three titles sold out of the copies the publisher brought to the conference and many orders were placed for books to be shipped directly to the reader.
That's it for today. Only half a day left at CMTC and a day and a half at the Information Management Technical Conference.
Keep on Learning
Can you believe it? March ends next Monday. Is it just me or was this the fastest moving first quarter ever!
Don't miss out on these special book prices that are offered by publishers MC Press and Pearson Education (IBM Press titles). The prices for the books at MC Press end March 31. I can't find details for when the IBM Press sale ends, but vaguely remember a March date as well. I'll confirm. But in the meantime, here are the details:
Save 37% on the purchase of DB2 9 for Developers by Philip K. Gunning. See also my blog entry about this book and sale.or go directly to the publisher's page.
While looking at the entry for Phil's book, I came across MC Press's Scratch and Dent Sale. Although there aren't any DB2 books listed in this sale, the prices are very good for Java, WebSphere, Elipse, and Rational titles.
See my blog entry about the Pearson Education sale of 35% off selected titles or go directly to the offer.
Books that are part of the IBM Press offer include:
* DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep, 6th Edition* Understanding DB2®: Learning Visually with Examples, 2nd Edition* Understanding DB2 9 Security* DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows™, i5/OS™, and z/OS®, 2nd Edition* Introduction to IMS™, An: Your Complete Guide to IBM's Information Management System* Mining the Talk: Unlocking the Business Value in Unstructured Information* Implementing ITIL Configuration Management* Practical Guide to Trusted Computing, A* Mainframe Basics for Security Professionals: Getting Started with RACF* Developing Quality Technical Information: A Handbook for Writers and Editors, 2nd Edition
svisser1 2700018UK9 3,538 Views
Leon's blog post just made me aware of this Consumability Survey for Information Management products.
The Consumability Survey was designed to gain insight into your business priorities and experiences with IBM software. It will take approximately 30 minutes to complete and must be completed in one session. The survey allows you to provide your input based on your experience and priorities for 31 product characteristics. You are then given the opportunity to prioritize those areas that matter most according to the demands of your business. When answering the survey, please be as specific as possible so that we can take appropriate actions to improve the product. At the survey Web site, please enter the optional invitation code: IMSOFTWARE.
You may wonder, what is consumability? The term is used to describe the difference between a product that works and one that makes your work easier, such as:
* How easily you were able to find the product that matched your business needs* How quickly you installed and configured the product to your environment* How well the product fulfilled its function within your organization* How efficiently the product suited your organization's usage on a daily basis* How easily you were able to derive business value from the product on a long-term basis
By taking the participating in our Consumability Survey, you're helping IBM focus on improving our software in ways that make the difference to your success.
See instructions in Leon's blog post if you want to provide feedback for DB2 Express-C.
Your opinion is very important to us, so thanks in advance for taking the survey.
svisser1 2700018UK9 3,537 Views
Here's another very long list for you.... this one lists all of the tutorials that were created on dWorks in the past year. Tutorials are very popular learning resources and they now cover most of our product areas. Check them out, or pass this information onto someone who you think would benefit from finding these learning materials.
Data Servers Cross Product The ultimate mashup, Part 6: Give the user control DB2 9 Fundamentals exam 730 prep, Part 1 DB2 9 Fundamentals exam 730 prep, Part 2 DB2 9 Fundamentals exam 730 prep, Part 3 DB2 9 Fundamentals exam 730 prep, Part 4 DB2 9 Fundamentals exam 730 prep, Part 5 DB2 9 Fundamentals exam 730 prep, Part 6 DB2 9 Fundamentals exam 730 prep, Part 7DB2 XML evaluation guide DB2 EveryplaceBuild end-to-end DB2 Everyplace mobile applications
DB2 for LUWDB2 9 table partitioningHello World, Part 7: DB2 for Linux, UNIX, and WindowsDevelop proof-of-concept .NET applications, Part 5: Create and consume Web services Kick-start takes you to the movies, Part 2 DB2 9 self-tuning memory management Shrink your database using DB2 9 row compressionDB2 Developer Workbench, Part 3: Developer Workbench and XMLThe ultimate mashup, Part 5: Change out Web servicesInformation on Demand Global Conference Web 2.0 Personal PlannerKick-start your J2EE apps using DB2 9 with pureXML and WebSphereSet up an SQL realm with DB2 Express-C, and WebSphere DB2 Developer Workbench and stored proceduresCreate XML-based stored procedures using the DB2 Developer WorkbenchSQL and XQuery tutorial for IBM DB2, Part 7: XML and XQuerySQL and XQuery tutorial for IBM DB2, Part 5: Data comparison SQL and XQuery tutorial for IBM DB2, Part 6: Data definition language and data control language The ultimate mashup, Part 1: Use and combine Web servicesDevelop a personal movie database app based on PHP and DB2 Create an XML-based Java application using DB2 9SQL & XQuery tutorial for IBM DB2, Part 4: Data analysisDB2 Developer Workbench concepts and basic tasksSQL & XQuery tutorial for IBM DB2, Part 3: Joins and unionsWire your application to DB2 pureXML data (Part 4)SQL & XQuery tutorial for IBM DB2, Part 1: Introduction to Aroma and SQLSQL & XQuery tutorial for IBM DB2, Part 2: Basic queriesDocument-level security using DB2 9 pureXML and LBAC DB2 9 DBA certification exam 731 prep, Part 1 DB2 9 DBA certification exam 731 prep, Part 2 DB2 9 DBA exam 731 prep, Part 3 DB2 9 DBA exam 731 prep, Part 4 DB2 9 DBA exam 731 prep, Part 5 DB2 9 DBA exam 731 prep, Part 6 DB2 9 DBA exam 731 prep, Part 7 Develop proof-of-concept .NET applications, Part 2 Develop proof-of-concept .NET applications, Part 3 Tutorial: DB2 label-based access control, a practical guide, Part 2: A step-by-step guide to protect sensitive data using LBAC Create database objects in DB2 Viper using .NET Integrate DB2 Express-C in apps with ActiveGrid LAMP StudioTutorial: Build Web services using IBM Database Add-ins for Visual Studio 2005: Highlights of the refreshDevelop DB2 applications using persistence-based frameworksDB2 and Rational: Working together, Part 2 Tutorial: Develop and test SQLJ programs for DB2 using Rational Application Developer Developing DB2 UDB User Defined Functions with .NET
DB2 for z/OSCreate z/OS procedures with Database Add-Ins for Visual Studio 2005
IMSIntegrate an IMS transaction into a Business Process Execution Language process
Classics/4GL/EGLCut out the Middle-Man: Use Informix Dynamic Server with J/Foundation to host a Java application service
CloudscapeApache Derby resources from the Web services perspective, Part 2: Producing and consuming WS-Notifications with DerbyApache Derby resources from the Web services perspectiveGet a head start with JDBC 4.0 using Apache Derby
U2A Hitchhiker's Guide to the UniVerse, Part 4: File and performance implicationsA Hitchhiker's guide to the UniVerse, Part 3Travels with Mark: A Hitchhiker's Guide to the UniVerse, Part 2: Sizing hashed files in UniVerse
Content ManagerContent Manager V8.3 Certification Exam TutorialsSearch legacy data sources
Document ManagerGet started with DB2 Document Manager, Part 2DB2 Document Manager: Build a simple client application (Tutorial)
OmniFind Discovery ServerStore selected OmniFind analysis results to a relational database
OmniFind Enterprise EditionSemantic search in IBM OmniFind Enterprise Edition, Part 2
DataStageIntegrated access to application data
Information IntegratorFederation Configuration Wizard
MDM-WebSphere Product CenterWebSphere Product Center - First steps
svisser1 2700018UK9 3,524 Views
Valerie Skinner interviewed me for her blog and posted the interview today!
Check it out!
Most of the publishing of technical books about DB2 originates in the United States, but not all. I know of a few books there were published in the Netherlands, Japan, India and Denmark. Only one of these books that I know of has been translated to English and sold world-wide, but if someone knows of any other books, please comment.
het SQL leerboek
Once a book is published in English, we try to make it available in as many English-speaking countries as possible, but occasionally there are problems with this. Many countries have very strict import rules that require much of the creation to take place in their country before it can be sold. This is the case for India, but if we have an Indian company print and bind the book for their country, the cost of the book will be much more affordable for local readers.
For a book to be truly useful, a translation into the local language is often required. This is tougher to accomplish since it requires extra handling of the book so extra costs are realized. The translators need to be paid and the local publisher needs to incur manufacturing costs to publish the translated book. As a result, publishers will only consider translating books if there is a substantial opportunity for sales.
We have many successful titles that have been translated into the following languages:
* Simplified Chinese
Another thing we are trying to do to help our international audience is to set up online bookstores that sell books in local currencies with reduced shipping costs. We currently have this set up in Canada, Europe, Russia, and India.
In Canada, you can purchase IBM Press books at a 30% discount directly from Pearson Canada, in Canadian dollars, at:
In Europe, you can purchase IBM Press books at a 30% discount directly from Pearson at:
Books are priced in Euros and they are currently having a special where several titles are available at a 40% discount. Order now as this offer ends at the end of August!
In India, there are several books reprinted in English and available at low prices in local currency. The official way to find and order the books is to contact Pearson India at:
Pearson Education India
482 F.I.E. PARPARGANJ
Delhi, India 110 092
Phone: 91 11 22146067-70
Fax: 91 11 22146071
That's what we've been able to arrange directly through the publisher, but search in your local countries to see if you can find online bookstores that sell the books. I doubt that you'll find any books at the bookstores, but you may wish to request a DB2 book as that will help encourage bookstores that there is a sizable market for these books.
Let me know if you have questions or want details on anything in this posting.
PS: Bookmark our international page to keep on top of the DB2 titles that are available world-wide:
I just read an article about Microsoft revamping their certification program for the next version of SQL Server. It seems that they are making the exams more closely tied to job roles and are making three distinct paths: one for administrators, one for developers and one for business intelligence. They are also creating shorter and simpler paths to certification... hmmmm seems to me that this is exactly what DB2 has been offering to people since DB2 Version 2 when Grant Hutchison originally launched the certification program. Here's the article:
A few years ago when I was running the DB2 Certification program, I did a competitive analysis of our program compared to Oracle's program. At the time, they required 5 exams to earn a DBA certification and we required only two exams. A year after our very successful V7 certification exams, I redid the competitive analysis and noticed that Oracle had changed their program to look exactly like DB2's program.
IBM should be flattered that two of our largest competitors have made such an effort to copy our programs!
I know that I'm pretty biased as I was one of the builders of the DB2 program, but take a look at this excellent article written by independent consultant Howard Fosdick.
Today's assessment question is also from Section 1: Database objects and Programming Methods (13%). Specifically, it tests this objective:
* Your ability to identify the more common privileges used when developing or running DB2 UDB applications.
The FINANCE application contains static SQL and issues the following statements:
SELECT name,id FROM prod.employee
UPDATE prod.dept SET dept=dept+1
INSERT INTO prod.dept VALUES(:id,:name)
Assuming a user can connect to the database, which of the following privileges must be granted to the user so that the FINANCE application can be run by that user?
A. UPDATE privilege on table DEPT
B. RUN privilege on tables EMPLOYEE and DEPT
C. EXECUTE privilege for the FINANCE application
D. CONTROL privilege on tables EMPLOYEE and DEPT
Where to find the answer:
1) Chapter 2 of Roger Sanders book: DB2(R) Universal Database V8.1 Certification Exam 703 Study Guide
2) Tutorial: http://www.ibm.com/software/data/education/selfstudy.html#2.
3) Product document: search on rivilegesand look up the following privileges: update, run, execute and control.
Susan Visser[Read More]
Invest in Your Skills and Learn about new functionality, VERY QUICKLY!
Buy one or more of the best selling DB2 UDB Version 8 books from IBM Press:
DB2 Universal Database V8.1 for Linux, UNIX, and Windows Database Administration Certification Guide, 5/e
by George Baklarz and Bill Wong
DB2 Version 8: The Official Guide
by Paul Zikopoulos, Roman Melnyk, Dirk DeRoos, George Baklarz
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
Upgrade your certification, very quickly: If you are currently certified as an IBM Certified Solutions Expert - DB2 UDB V7.1 Database Administration for Linux, UNIX, Windows and OS/2, you qualify to take the upgrade exam: Test 706: DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration Upgrade. If you have the V7 pre-requisite certification and you pass Exam 706, you will qualify as an IBM Certified Database Administrator - DB2 Universal Database V8.1 for Linux, UNIX and Windows. Exam 706 has 30 questions and is focused on the changes from DB2 UDB V7.1 and DB2 UDB V8.1 - http://www.ibm.com/certify/tests/obj706.shtml.
For further details on migrating, see a tech note written by DB2 support experts:
I'm getting ready to go to the Tech Conference in Orlando next week. Make sure you look for me at the free certification lab. We're hoping to give more than 900 exams next week!
Susan Visser[Read More]
Yesterday Ambuj Goyal, the new General Manager for Information Management came to visit the employees of the Toronto Lab. Although I met Ambuj in Orlando and have attended some of his webcasts, this was the first time I heard him speak to a group.
Most of the talk was in regards to Information as a Service and what it means to our customers and what it means to those of us working on DB2.
Here is an external site that links to radio broadcasts, brochures, and webcasts, and more resources if you would like to do some research:
The definition on this website is:
Ensuring that information is available on demand calls for a new information strategy. Information On Demand transforms captive data into openly available information as a new service layer throughout the enterprise.
When I think of "on demand", I think of two recent changes in the certification area that were significant:
1) We used to use a test delivery software that required an administrator to enter demographic data for the test candidate and to run a program that would make the chosen test available for that candidate. When we were giving tests at a conference, the program ran very slowly and we were sometimes required to ask the candidate to come back the next day to take their exam. Occasionally an error was made and the candidate would show up only to find that the wrong exam was made available. This caused us to make the change, re-run the program, and of course, make the test candidate wait! Painful.
Now we use a test delivery software that I call "Exams on Demand". We log into a secure internet server, the candidate enters their own demographic information (less chance of typos) and then the proctor types in a secret code to start the exam of choice. If the wrong exam is selected, no worries... the proctor just enters another code and the right exam appears. Using this system has allowed us to give more than 1000 exams to candidates at a conference in 4 days. With the previous software, we could maybe give 500 exams and there was much grief, as you can imagine.
2) Certification certificates used to be snail-mailed to candidates who passed all the required exams. If you lived in the United States, you could get your certificate within 2 weeks, assuming that the address that was entered into the system when you registered for the exam was entered correctly! For some people in other countries, China, India, and even Canada! some certificates were taking 8-12 weeks to arrive in the hands of the candidate! Who knows why.... but we changed our model to deliver electronic certificates. Now, within a week of passing the exam and meeting the requirements to earn a certificate, we send you an email telling you the website where you can download a pdf version of your certificate. Once you get it, you can print it locally. If you don't want to print it immediately, you can always go back to the website to re-access it, any time you want.
These are not the examples that Ambuj is making to executives that he meets, but for those of us involved in the certification testing area, these are real improvements in the ability to access information when needed.
If you've taken an exam, but haven't received your certificate yet, log into our new "Member Site" internet application for certification candidates. At the Member Site, you can update your own contact information, including email, postal address and company name, as well as:
* View your certifications and successful exams
* Check the fulfillment status of your certifications
* Request softcopy or hardcopy certificates
* Request merges of multiple testing IDs
* Download the IBM Certification marks (logos)
To register for the site, visit: https://www.ibm.com/certify/members
svisser1 2700018UK9 3,473 Views
This is my third blog entry about the Hot skills, cool Chumby IBM Training promotion that is taking place right now. After each entry, the web master thanks me for all the referrals, as it seems that people are reading my entries and are following the links! Thanks to all of you!
Here are the details for the promotion:
With this promotion you will learn new skills with world-class IBM instructors, AND you can also get a Chumby device (value $179.95 USD) to take home at the end of the class!
So... what is a Chumby?The chumby is a compact device that displays useful and entertaining information from the web: news, photos, music, weather, celebrity gossip, webcams, sports scores — using your wireless internet connection. Always on, it shows — nonstop — what's online that matters to you. I highly recommend you view the Chumby demo. Click the What the heck is a chumby button.
The Chumby sounds cool... but how does it work?Just plug it in, connect to your wireless network, and use your computer to choose a playlist of "widgets" (the bite-sized applications that run on a chumby). And if, say, you want to see news, the surf report, and traffic in the morning, and animations, web cams and eBay auctions at night, you can group widgets in "channels." Watch constantly updated info, or use interactive widgets that take advantage of its touchscreen or motion sensor. You can even share widgets and send ecards to other people's chumbys.
With over 700 widgets across 30 different categories such as weather, social networks, photos, sports, news, entertainment, videos and much more, you'll find lots of stuff you'll love.
Which courses are eligible?Check out ibm.com/services/learning/ites.wss/us/en?pageType=page&c=L576830G48338Q94 for a list of the eligible classroom and instructor-led online courses.
If you are lucky enough to get a Chumby... let me know what you think of it.
certmag.com just published the following article:
Database Administrators: Multitasking for Advancement
January 2006 - by Cari Mclean
Two of my workmates were quoted in the article.
Sue Myers, program director of information management skills at IBM.
Being proactive and agile in today's marketplace is essential to staying ahead of the technology curve. "We are on a cusp of a change in terms of how information is collected and how it is used," Sue Myers said. "So the opportunity for a DBA's future career growth is to step into that leadership position and to drive the strategic direction of where the data is goingn applications and the overall business environment."
Susan Dykman, information management certification program manager for IBM.
"Today, certifications for DBAs are the foundation required, and they are the proof of entry. We have done extensive looks into how employers value certification, and we have found if someone is hiring and the only difference between applicants is that applicant A has a certification and applicant B does not, the employer is going to pick applicant A," said Susan Dykman.
Read the entire article to get an idea as to how DB2 certifications can help you progress in your career as a DBA.
Many children are scheduled to go back to school after labor day, so with all the 'back to school' sales, and the approaching fall season (new clothes required?), many people feel that September is the best month to make significant changes in their lives. One article I read this weekend stated that September is the season of change, especially for women and that 'September Resolutions' are becoming as common as 'New Year's Resolutions'.
If you are feeling the need to make some changes, consider upgrading your skills. The DB2 Version 8 Certification Exams are very popular, so if you are down level or haven't yet earned a certification; consider adding it to your skill's plan.
Here's what I'd suggest:
For everyone selling, using, developing, consulting, or learning about relational databases, I suggest Exam 700 DB2 UDB Version 8 Family Fundamentals. Even if you are using Oracle, MS SQL Server, IDS, Cloudscape, or MySQL, you should consider this exam. This exam covers the basics such as planning, security, concurrency, and SQL usage. For study materials, see http://www.ibm.com/certify/tests/edu700.shtml.
If you are working as a DBA, supporting DB2 in any way, or developing DB2, you should take Exam 701 DB2 UDB Version 8 for UNIX, Linux, and Windows Database Administration or Exam 702 DB2 UDB z/OS Version 8 Database Administration. Both of these exams require a lot of knowledge, but if you work as a DBA, you already have 80% of the knowledge that you need to pass the exam. For study materials, see http://www.ibm.com/certify/tests/edu701.shtml or http://www.ibm.com/certify/tests/edu702.shtml.
If you were able to pass Exam 701 fairly easily, you should try Exam 704 DB2 UDB Version 8 for UNIX, Linux, and Windows Advanced Database Administration. Passing this exam will show others that you are a LEADER and have a deep skill level in the database area. For study materials, see http://www.ibm.com/certify/tests/edu704.shtml.
For programmers of any kind, consider taking Exam 703 DB2 UDB Version 8 Family Application Development. This exam covers the basics about program to a database in embedded SQL, Java, CLI and ODBC. You don have to be in expert in all programming areas, but you should be very strong in at least one area. I find that students working on computer science degrees are able to pass this exam with minimal work. For study materials, see http://www.ibm.com/certify/tests/edu703.shtml.
If you prefer the business side of things rather than technical, consider taking Exam 705 Business Intelligence Solutions. This exam isn very technical but it covers the concepts that you need to master to create solutions in your environment. For study materials, see http://www.ibm.com/certify/tests/edu705.shtml.
If you're working in WebSphere, Tivoli, Java, Lotus, Content Management or Rational, see http://www.ibm.com/certify to find the exams that fit your needs.
CertMag's 2005 Salary Survey: Monitoring Your Net Worth
Overall, certified professionals this year enjoyed an average 16.4 percent pay increase from 2004, up significantly from last year's reported increase of 14.1 percent. The global survey clearly showed the value of qualified IT experts, with 23.4 percent of the respondents earning 25 percent or more in salary than they did in 2004.
CertMag editors surveyed 35,167 IT professionals in 170 countries around the globe. With 95.4 percent of those professionals holding technical certificationshe average respondent has 3.29 certifications. CertMag's 2005 Salary Survey was conducted over a six-week period from Aug. 19 to Oct. 3, 2005.
CertMag's 2005 Salary Survey asked respondents to evaluate and rank the training and study methods they used, as well as the quality of their primary certification's program. The survey showed, like previous surveys have, that on-the-job training, self-study books and practice exams are used and considered valuable among respondents. Seventy-three percent of respondents found on-the-job training very valuable or extremely valuable. Self-study books were ranked the second-most-valued preparation material by respondents at 71.1 percent, and practice exams were valued at 70.6 percent.
The highest-paid IT professionals in the survey this year live in Switzerland, with an average salary of $83,420, followed by those in Denmark and the United States, with $70,590 and $68,890, respectively. The United Kingdom, whose IT professionals were the fourth highest-paid in 2004, fell to the seventh position, while Japanese IT workers jumped from 10th place to fifth, with a surprising $14,300 increase in average IT salary.
Read it online, at http://www.certmag.com/articles//anmviewer.asp?a=1524&z=224.[Read More]
svisser1 2700018UK9 3,442 Views
One more week till the middle of August! A special time in my life as it is my son's birthday :) But work wise, it is the last week for the Early Bird Pricing for the IBM Information On Demand 2008 taking place the last week of October in Las Vegas. Register now to save some money!
If you can't make it to that conference, consider CASCON 2008 taking place in Toronto the same week as IOD is taking place in Vegas.
Another event that is coming up is DB2 Aktuell 2008. This event takes place September 23 and 24 in Potsdam, Germany. The site is in German so I can't read it... but the sessions will be 50% English and 50% German.
Enjoy the summer while it is still here :)
svisser1 2700018UK9 3,422 Views
Have you seen the web banners for the new Certify and Save Promotion? The banner shows a cute piggy bank... which to me stands out because it is unlike most other web banners... on IBM sites at least.
What is Certify and Save?
From April 1, 2008 to June 30, 2008 you will receive a $75 discount on select DB2 9 certification exams when you purchase a qualifying DB2 9 Certification Study Guide. Simply purchase a qualifying guide from any US Bookstore between April 1, 2008 and June 30, 2008, and you are eligible to receive a Professional Certification voucher valid for 50% off the cost of an eligible exam at Thompson Prometric Testing Centers.
What are the qualifying books?
Only my most favourite books... the MC Press series of study guides that were written by Roger Sanders, Susan Lawson, and Dan Luksetich:
* DB2 9 Fundamentals Certification Study Guide by Roger Sanders* DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide by Roger Sanders* DB2 9 for z/OS Database Administration: Certification Study Guide by Susan Lawson and Dan Luksetich
All three books were written by well-respected DB2 experts / authors / speakers / exam developers. These books are focused on helping you learn what you need to know for the exams, so there is no better resource available for prepping for the exams. Each book contains sample questions that are directly related to the objectives of the exams. No where else can you find these questions along with the answers, and reasons for the answers.
Back to the promo... if you purchase the Fundamentals book by Roger Sanders, you'll qualify for a discount voucher for Exam 730; purchase the DBA book by Roger Sanders and you'll qualify for a discount voucher for Exam 731; and finally, purchase the DBA book by Susan Lawson & Dan Luksetich and you'll qualify for a discount voucher for Exam 732.
If you're interested in this offer... I'm sure you have plenty of questions. Here is a PDF with all the details for the Certify and Save Promotion. Kate and Emily also recorded a podcast to deliver all the details.
Again... follow the pig... and you'll find the savings.
PS... for those of you attending the IDUG conference during the offering period, you'll be happy to hear that I plan to be there handing out discount vouchers to those who buy the qualifying books.
If you've taken a class through IBM, you may already feel like you "know" these people. If you haven't taken a class yet, let me introduce you to:
* Jeff Bohm - Data Management Technical Education Specialist
* Shirley Brost - Senior Technical Learning Specialist
* Joan Dunn - Senior Education Specialist
* Melanie Stopfer - Consulting Learning Specialist and Developer
* John Zucchero - Education Learning Specialist
Take a class with one of these instructors and believe me... your depth of knowledge will surely deepen.
If you would like to increase your skills via IBM training classes, you'll be interested to know that the latest eCatalog is now available:
* view 26 IT curriculum areas
* get fast access to training paths and courses
* find detailed course descriptions, schedules and locations.
* hyperlink to curriculum home pages, up-to-date class schedules and offers that save money on training.
The three-book set of certification study guides written by Roger Sanders have been bundled together for a special price on informit.com and ibmpressbooks.com:
Are you preparing for DB2 certification? Improve your readiness with this collection of books. Author Roger Sanders is a DB2 expert who was involved in the development of these exams so you'll get sample questions straight from the source! Each book covers all the material you need to pass version 8 certification exams 700, 701, 703, and 706.
Included in the bundle are the following three books:
* DB2 Universal Database V8.1 Certification Exam 700 Study Guide
* DB2 Universal Database V8.1 Certification Exams 701 and 706 Study Guide
* DB2 Universal Database V8.1 Certification Exam 703 Study Guide
Author Roger Sanders was a member of the DB2 Version 8 Exam Development team, so he was an ideal person to write these study guides. Also, if you ever read one of Roger's books, you'll know first hand how good he is at explaining complex topics.
Besides being the only set of books that focus directly on what you need to know to do well on the exams, these books contain hundreds of assessment questions to help you gauge your readiness to take the real exams.
svisser1 2700018UK9 3,364 Views
For a limited time... possible till the end of March only... save 37% on the purchase of DB2 9 for Developers by Philip K. Gunning. From this site, download chapter 4 The Path to DB2 9 XML Capabilities to check out Phil's writing style and the content on XML.
See also the amazon site for this book to see the six 5-star reader reviews for this book.
For details on all of the books that are available for DB2 9.5, see ibm.com/software/data/education/bookstore/.
svisser1 2700018UK9 3,352 Views
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]
svisser1 2700018UK9 3,344 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,321 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,237 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]