Are you overwhelmed by the amount of technical information that is available for DB2? I don't blame you if you are! IBM produces many different types of training resources to suit individual preferences for learning.
The DB2 Skills Kit from developerWorks is a good place to begin your quest to learn more about DB2. Skill kits are FREE and make it easy to learn introductory concepts and usage procedures with demonstrations, step-by-step tutorials, technical articles, webcasts, podcasts, and presentations. No need to search for information: The DB2 Skills Kit has what you need in one kit: how to install, configure, and administer IBM® DB2®.
Increase your knowledge and skills whether you are a database administrator or application developer. This kit is aimed at IT professionals that have a basic understanding of database principles and design that are looking for “just in time DB2 skills.” Topics covered include: Overview, installation, configuration, database creation, and administration.
For detailed information on how to download the kit, see these step-by-step instructions.
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
Matching: readfirst X
I found this article about Athabasca University in Alberta that uses the concept of interactive virtual learning environments in some of their classes: Alberta university takes academic cue from video games.
From the article:Young people have long been able to hone physical skills through realistic video games, and the university wants to approach academics the same way, says Rory McGreal, the university's associate vice-president of research.
Hours spent hunched over a computer perfecting how to shoot a gun or explore a virtual environment could also be spent learning how the body works or understanding the universe.
“We're trying to harness the power of games and how we can use them to promote learning,” Mr. McGreal said Wednesday.
Personally I've witnessed the popularity of games with young people and I've also experienced the use of gaming to teach people to learn DB2. I was part of the pilot program that created the first "DB2 Detective Game" and loved seeing the students "get" the power of SQL while playing the game.
If you or someone you know needs to learn DB2... or if you like to volunteer to teach high school students, you need to check out the DB2 games:
IBM DB2 Detective Game
Getting started with DB2 9 and SQL can be easy with this new interactive game. Using an crime investigation theme, this introductory level game teaches relational database concepts and shows how technology can be applied to solving real-life problems.
IBM DB2 Business Game
Put your DB2 and SQL skills to the test with this intermediate level game! Jump into a “run your own business” scenario, where your company’s future depends on a key report needed to secure funds for a critical upgrade. Play the game and you may be ready to transfer your skills into action!
Knowing SQL is a pretty important skill to have if you work with databases. This just in, a book for those just beginning to learn SQL: Simply SQL by Rudy Limeback.
I don't have a copy of the book yet, so I don't have personal experience with it yet. Here is the description from the book:
Learning SQL has never been easier. Packed with full color examples, this practical hands-on guide provides an easy to read step-by-step introduction to learning all about SQL - from syntax to security. Simply SQL is the perfect crash course for beginners.
Packed with full-color examples, Simply SQL is a step-by-step introduction to learning SQL. You'll discover how easy it is to use SQL to interact with best-practice, robust databases. Rather than bore you with theory, it focuses on the practical use of SQL with common databases and uses plenty of diagrams, easy-to-read text, and examples to help make learning SQL easy and fun.
Rudy Limeback is an independent consultant with over 20 years of SQL experience using DB2, SQL Server, Access, Oracle, and MySQL. He has written numerous articles on SQL for major online IT sites like TechTarget. Rudy is also a Web developer, one of the original evolt.org admins, with his own Web site since 1996. You can find more information at r937.com. Rudy lives in Toronto, Canada, where the weather allows you to play frisbee golf all year long.
For a list of other SQL books, see these blog entries.
Thanks to Farzana Anwar from DB2 Information Development for this incredible list of sites that you might want to visit or bookmark.
DB2 for Linux, Unix, and Windows (Product Web site)This IBM DB2 product Web site contains information about the latest release and new features, links to important related Web sites, announcements about the release and more. This is a good starting point for information about DB2 for LUW.
DB2 for Linux, Unix, and Windows Editions (Product Web site)This product Web site provides information about IBM DB2 product editions. It contains information about the various editions of DB2 that are available. This Web site highlights the key features available with each edition and compares them in a tabular format. If you are not sure what edition of DB2 is appropriate for your needs this is a good starting point and reference.
DB2 for Linux, UNIX, and Windows Features and Benefits (Product Web site, Video with Sal Vella)This product Web site provides information about value-added features. It describes the value added features that are available to extend the core features available with a DB2 edition. Value added features are generally used to address specific business problems that might not be of general use to all customers. The value added features can be purchased separately and enabled with a separate license key.
Overview of DB2 9.5 by Chief Architect Tim Vincent (Podcast, mp3 file)This podcast which can be listened to or downloaded from the Voice of the DB2 Community Web site provides an overview of new DB2 9.5 features.
Introducing DB2 9: DB2 Unveiled (Article by Rav Ahuja)This article contains a comprehensive overview of new features available in DB2 9.1 with a focus on how you can use the features to help lower business costs and improve business data management. It links to several related articles that describe specific features in more detail. The content also applies to DB2 9.5 and DB2 9.7 data servers.
Compare the Distributed DB2 9 Data Servers (Article by Paul Zikopoulos)This article compares the various DB2 9.1 data server products. The content also applies to DB2 9.5 and DB2 9.7 data servers.
Which edition of DB2 9 is right for you? (Article by Paul Zikopoulos)This article describes and compares the product specifications, licensing considerations, and specific features and capabilities of each edition of DB2 9.1. The content is generally also appropriate for DB2 9.5 and DB2 9.7.
DB2 Version 9 Product and Packaging Information (Technote)This technote explains the DB2 product packaging options that are available. It contains links to packaging information for DB2 data servers, clients, and add-on features.
IBM DB2 9 New Features (Book)IBM DB2 9 New Features is an easy-to-read book that includes illustrations and examples. The content applies to both DB2 9.1 and DB2 9.5 data servers, however new features in DB2 9.5 are not described in this book.
There were many more links in the document that Farzana sent to me... and I'll share the links with you over the next few days.
If you or someone you know is looking to learn DB2, I recommend these two books:
Beginning DB2: From Novice to Professional (Expert's Voice) by Grant Allen
Understanding DB2(R): Learning Visually with Examples (2nd Edition) by Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow
Both of these books are excellent choices if you are trained on a competitive database and wish to quickly transfer your skills to DB2.
If you are a DBA and only want to buy a single book to have as a reference, here's what I suggest:
DB2 for Linux, UNIX, and Windows
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)
Written by long time DB2 experts and DB2 evangelists, George Baklarz and Paul Zikopoulos, this book is the reference and guide that you will use over and over as you do your job!
DB2 for z/OS
DB2 Developer's Guide (5th Edition) by long time DB2 expert and consultant, Craig Mullins. This book keeps on selling and selling... so it may be that everyone who works on DB2 for z/OS already owns a copy! If you don't, you should!
Informix Dynamic Server
Administering Informix Dynamic Server: Building the Foundation by long time IDS expert Carlton Doe. At this point, this is the ONLY up to date IDS book that is available! Buy it because it WILL update you on all the changes in the product, but also, the more books that sell, the more likely it is that we'll have more IDS books published!
If you do not find that these books fill your needs... don't worry... we have many others! See our IBM IM Bookstore and the channelDB2.com DB2inBooks discussion group.
Yesterday I was a last minute attendee / booth girl for the BMODUG event that was taking place down the road from my office. I met up with many people I already knew (Tim Johnson, Yvonne Kulker, Joe Borges, Susan Lawson and Melanie Stopfer), but also met quite a few new people. I strongly encouraged the new people to take a look at my blog, so I'll do a short recap today.
At the booth, I was handing out DB2 Gaming DVDs. For those who were not able to get a copy here is the site ibm.com/software/data/education/games.html where you can learn more about the games and also where you can download what you need to play or share the games. Happy Gaming!
I also had a few copies of a DVD that was created last year that contained a bunch of IBM Redbooks. Although it is nice to have a DVD with all this content, it is best to get the IBM Redbooks from the website as you can be sure that the content is most current.
Pearson Education Canada supplied the postcards that provided a Canadian website for you to purchase IBM Press books. The offer is for a 35% discount. Books that you might want to consider from this site are: IBM Press in Canada.
Understanding DB2(R): Learning Visually with Examples (2nd Edition) The book is the best way to learn (or relearn) DB2 for Linux, Unix and Windows. The book is filled with case studies, study questions, and well-written details on everything you'll need to know. Some competitively trained people who have read this book have told me that this is exactly what they needed to take the fear out of switching to DB2!
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep, 6th Edition This is the one book that all DBAs should have on their bookshelf. This book was written by George Baklarz and Paul Zikopoulos, two very well-known DB2 experts who know how to write a good book! The book is the best guide and reference that you can own and will surely be one of the most used books on your bookshelf.
Enterprise Master Data Management: An SOA Approach to Managing Core Information I mentioned this book to a few people yesterday. This is beyond a database topic... but is really insightful as to how data can be managed effectively throughout an industry... I read the book in draft form about a year ago and am surprised with the amount that I've been able to retain. I highly recommend this book if you are looking for a place to go beyond data.
I helped a few people with some certification questions that I have... and since today is testing day, I hope everyone does well on their exams! The best places on the web to go to are:
1) To help you decide where to start, see the certification roadmaps: ibm.com/software/data/education/cert-roadmaps.html.
2) For a breakdown of the exam objectives and the recommended study materials, see ibm.com/software/data/education/certprep.html
Many people were interested in the information I was giving about the ILO classes that are now available. ILO = instructor-led online and means that you sit at your desk at home or work and take part in an actual class via your computer (headphones and mic absolutely essential). You interact with the instructor and the other classmates as you would if you were sitting in a class with them, but you do it without needing to travel! There are 70 different ILO classes now available, some are short and take place in the evening, but others are full day classes. For all information, see: Instructor-Led Online Training. See also a recent blog entry that I wrote.
And finally, community! You are all community, so consider joining one of the groups on ChannelDB2.com:
DB2 in Books
I've listed every published book in this discussion group and I encourage you to use this as a way to reach the authors or to find related information such as events that the authors are taking part in, podcasts or webinars that are related to the book topic, and so on....
DB2 for Linux, UNIX, Windows
This is a place where you can find information about anything related to DB2 for LUW. Feel free to add discussions for areas that are not yet created. I've created a few discussions that you might find useful, including information about the latest ILO courses or current promotions that are being offered.
DB2 for z/OS
Same as the one above, only content is specific to the z platform.
I just started this group to be a collection of the many things that are happening at the IOD conference. With so much information being sent on a daily basis in regards to the conference, isn't it nice to have one spot that collects that information? And better yet, this is a place where you can share your thoughts on events that are taking place at the conference.
What do you think? Worth checking out? I hope so. When you're a member, make me a friend! A girl can never have too many friends!
Get your copy today! Currently at a VERY low price on amazon:
Administering Informix Dynamic Server: Building the Foundation
Amazon says that it "usually ships in 1-4 months"... but I received my copy today... so if you order.. yours should arrive quickly as well.
What is this book about? First of all, this is the first book about Informix to publish in 8 years! That certainly is something to celebrate! Yes... Informix IDS is alive and well!
Second, Carlton Doe is an amazing person to work with and dedicated beyond belief. You can be sure that the content in the book is superb!
Third, this is the Foundation book... and we'd like to publish one that covers more advanced topics... and this is where we NEED you! The publisher is watching closely to the success of this one... and if it does well, will consider more titles.
Fourth, this really is an amazing price. Today the discount that I see is 37% off the list price. This discount may disappear quickly... and without warning.
Congratulations to Carlton and all the dedicated IDS people in the world. I really hope that we see many more books publish in the future :)
A new ILO course has just been added. This one is an SQL workshop that is spread over 4 half-days in two weeks. ILO courses are the IBM courses that you take without traveling by joining a remote instructor via your computer.
Here are some details:
SQL Workshop - Multi Week Instructor Led Online
On completion of this course, you should be able to:
* Code SQL statements to retrieve data from a DB2 or Informix table, including the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses* Code inner joins and non-correlated subqueries* Use SQL arithmetic operations* Use scalar and column functions* Use UNION and UNION ALL* INSERT, UPDATE and DELETE rows* Code simple CREATE TABLE and CREATE VIEW statements
The DB2 books that you may wish to have to complement this course are:
* Understanding DB2(R): Learning Visually with Examples (2nd Edition)* DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)
If you are interested in passing the DB2 9 Family Fundamentals certification exam (Test 730), you should notice that about 23% of the exam covers SQL knowledge. The book DB2 9 Fundamentals Certification Study Guide by Roger Sanders corresponds to the exam objectives and therefore covers the SQL that you need to pass the exam.
An interesting way to get a start on learning SQL is through the DB2 Games. Here are some details that I found on Kate Dawson's blog:
If you are a beginner, choose the IBM DB2 Detective GameIf you like watching crime investigation shows, this might just be the perfect game for you. Using a crime investigation theme, you will enforce your DB2 9 and SQL skills while learning relational database concepts and how they can be applied to real-life problems. I’ve played this game and highly recommend it.
If you have some existing DB2 skills, choose the IBM DB2 Business GameTry a “run your own business” scenario and put your DB2 and SQL skills to the test with the Business Game. Your company’s future depends on a key report needed to secure funds for a critical upgrade… can you put your DB2 skills into action and beat the game? Play now and find out.
Whenever I ask people who are SQL experts, they tell me that they rely heavily on these books:
* Graeme Birchall's DB2 SQL Cookbook* The SQL Reference for Cross-Platform Development* Product Docs for DB2 LUW* Product Docs for DB2 z/OS
When at conferences, I've noticed that the following books are popular:* Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition* SQL Demystified* SQL: The Complete Reference, Second Edition* SQL In A Nutshell, 2nd Edition* SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL (2nd Edition)* SQL Pocket Guide
In writing this blog I realize how many resources are available for SQL. Clearly that means that it is a very important topic.... and one that you can continue to improve in.
I just realized that I haven't blogged about our certification program in some time. I dusted off a blog entry I did last year, updated it, and voila, here it is:
DB2 has six current certification exams that each lead to a different certification role. The most common certification is IBM Certified Database Administrator. Here are the exams that cover DB2 9 content:
* Exam 730 - DB2 9 Fundamentals * Exam 731 - DB2 9 DBA for Linux, Unix, and Windows* Exam 732 - DB2 9 DBA for z/OS* Exam 733 - DB2 9 Application Developer * Exam 734 - DB2 9 Advanced DBA for Linux UNIX and Windows* Exam 736 - DB2 9 Database Administrator for Linux UNIX and Windows Upgrade
Each exam has a time limit of 90 minutes, except the upgrade exam which has a time limit of 60 minutes. The number of questions and the cutscore for each exam varies. For example, exam 730 has 64 questions and you must score 59 percent or higher to pass it.
To become certified as a Database Administrator, you must pass both exams 730 and 731. Exam 730 covers basic DB2 concepts like SQL, installation, packaging, security, and concurrency. Exam 731 is much more detailed and focuses on the job tasks that a database administrator does in his or her daily job.
Certification Tips Common questions about certification go something like this: Do I have to get certified?, Is it worth anything?, and How do I get it? I've put together answers to these questions along with some other advice that I hope you find useful.
Do I need a DBA Certification to get a job as a DBA?
Not always as it depends on a number of factors. If you've worked as a DBA before or have a degree in an IT related field, and have experience using DB2, you may not need to get certified. I'd recommend it anyway, as regardless of what you already know, you'll learn something new during the process of earning a certification that may be tremendously valuable to you or your company If you have an older certification, upgrading to the most current level is an easy way to ensure that you stay on the top of your game.
If your employer requires you to be certified, or a job you are trying to get lists certification as a requirement, then for sure you'll need to earn the required certifications.
If you have little experience using DB2 or if you have a degree in a non-IT field and you're trying to break into the database arena, it's generally a good idea to get a few DB2 Certifications so employers take you a little more seriously. For self-study, also check out the free tutorials that IBM provides for most of the exams. The tutorials are broken into hour long segments of information based on the exam objectives. If have a great deal of experience, this may be all you need to prepare for the exam. To see the full set of exam prep tutorials that are available, see ibm.com/software/data/education/selfstudy.html.
Classroom education is an excellent way to learn, but may be difficult to justify for some people due to costs. If you find that you learn most effectively through classroom education, encourage your employer to pay for them. Don't forget to look into ILO training as this type of training gives you all the benefits of classroom education, but eliminates the travel costs. The best place to start to determine the classroom education that best fits your needs is with the training roadmaps: ibm.com/software/data/education/roadmaps.html.
Is there an easier way to get certified, that doesn't include studying?
Not many things of value don't require an effort. There are sites on the web that claim to have the actual certification exam for you to buy and memorize in order to pass the exam. These are created by a previous applicant who shares knowledge of the questions on a certification exam with a third party. There is no noble purpose of this information sharing. It is cheating, pure and simple. IBM has a non-disclosure agreement that they make every exam applicant agree to before they allow you to take the test. Any person who creates or gives out questions or answers from a certification exam is in violation of the NDA and if you get caught "dumping", you're likely to have your certs revoked, at a minimum! And, if you get caught using someone else's dump, you'll get your certs revoked and will never be able to get certified through IBM again.
Further more, there's the credibility issue of this information. Most dumps are littered with errors, spelling and otherwise. There are a lot of companies out there that sell brain dumps, but just because you pay for their version of sims / exams, doesn't make it legal. Be very careful of cheap exam sims because they tend to be brain dumps. If you have any questions about the validity of a company's product, ask other people in the DB2 Forums or go to IBM directly. As mentioned earlier, DB2 exams are experience based, so lots of practice using the product in as many areas as possible, may allow you to pass the exam without studying.
If I take the assessment exams repeatedly, will I eventually see all the questions on the certification exam?In the past, IBM offered free assessment exams to all candidates. It seems that several people were taking these exams multiple times in a possible attempt to memorize all of the questions. The bad news for these people is that the set of questions on the assessment exams is different than the set on the certification exams. Also, memorizing the questions and answers will not help you learn the material at all! I suggest that you take at least one assessment test to see how ready you are, but only AFTER you have read the exam objectives and had either experience or training. By the way, the assessment exams now cost $10 per take, so that will help you limit the number of assessment exams you decide to take. Here is the site that will get you to the assessment exams: ibm.com/software/data/education/cert/assessment.html.
Can I gain experience by reading DB2 Forums and Blogs?
Absolutely! There are several DBAs who firmly believe helping out on the various forums have helped us gain a deeper understanding of subjects that were on the exams. So, contribute to those forums. You're not only helping other people, you're helping yourself as well! Most likely you'll find members of the DB2 development team actively taking part in the forums as well.
Here are the sites that I recommend, at the least:Planet DB2 - a blog aggregator that combines DB2 blogs from around the world.IBM developerWorks - DB2 PortalIDUG – International DB2 User’s Group
Is it true that the DB2 Fundamentals Exam (700 or 730) caters to an LUW audience?
Not at all. The DB2 Fundamentals Exam contains only questions that are true for each and every platform! In fact, I've noticed that people whose primary area of experience is with DB2 for z/OS find this exam pretty easy.
Recommended Learning Path for Certification:
Here is the recommended path I suggest you take to prepare for a DB2 exam:
1) Choose the exam you want to take based on your job role. The DBA and AppDev certifications first require that you are certified as a Database Associate. To help you decide where to start, see the certification roadmaps: ibm.com/software/data/education/cert-roadmaps.html
2) Read through the exam objectives. Every question on the exam relates directly to one or more of the exam objectives. For a breakdown of the exam objectives and the recommended study materials, see ibm.com/software/data/education/certprep.html
3) If you are experienced with DB2 and feel that you are prepared to pass based on what you saw in the exam objectives, take an assessment exam. You'll get a report after taking the assessment exam that can help you pinpoint your weaknesses.
4) If you are NOT experienced with DB2, download a free version of DB2 Express-C and give it a try!
5) Decide on how you best want to increase your skills, and test your level of skill achieved by taking an assessment exam: ibm.com/software/data/education/cert/assessment.html.
a) Consider buying one of the Certification Study Guides to refresh and deepen your skills: ibm.com/software/data/education/bookstore/
b) Take a free tutorial: ibm.com/software/data/education/selfstudy.html.
c) Take an education class from IBM or one of its partners.
6) Feel ready? Book your test! Testing centers are located around the world. Find a location closest to your office or home: www.prometric.com/ibm. If this is your first time taking a certification exam, review the steps on this site: ibm.com/certify/process/t_proc.shtml
Which book is best?
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) by George Baklarz and Paul ZikopoulosWhat 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.
For exam prep, the best books are these:DB2 9 Fundamentals Certification Study Guide by Roger SandersDB2 9 Database Administration Certification Study Guide for Exam 731 by Roger Sanders DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 by Roger Sanders. You can find these books for sale at online book retails across the world.DB2 9 for z/OS Database Administration Certification Study Guide for Exam 732 by Susan Lawson and Dan Luksetich
You can find these books for sale at online book retails across the world.
PS: Check out Kate's blog entry with details about the upgrade exam: www.ibm.com/developerworks/blogs/page/katedawson[Read More]
Were you one of the very happy readers of the first edition of this book? If you check this book out on amazon.com... you'll see that the first edition of the book had 17 extremely positive reviews of the book. People liked the way the material was presented in a graphical, visual way... the case studies.... and the review questions. On top of that, the authors know there stuff and spend much of their working life talking to customers and helping them understand how to use the product and the benefits each feature is likely to bring.
From the publisher:
Understanding DB2, Second EditionBy Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow
IBM DB2 9 and DB2 9.5 provide breakthrough capabilities forproviding Information on Demand, implementing Web servicesand Service Oriented Architecture, and streamlininginformation management. Understanding DB2: Learning Visuallywith Examples, Second Edition, is the easiest way to masterthe latest versions of DB2 and apply their full power toyour business challenges.
Written by four IBM DB2 experts, this book introduces keyconcepts with dozens of examples drawn from the authors'experience working with DB2 in enterprise environments.Thoroughly updated for DB2 9.5, it covers new innovationsranging from manageability to performance and XML support toAPI integration. Each concept is presented witheasy-to-understand screenshots, diagrams, charts, andtables. This book is for everyone who works with DB2:database administrators, system administrators, developers,and consultants. With hundreds of well-designed reviewquestions and answers, it will also help professionalsprepare for the IBM DB2 Certification Exams 730, 731, or736.
Special Offer: Use the Coupon Code for this bookdescription to receive a 35% discount (coupon codes are casesensitive). Plus, FREE shipping in the US for every order.Coupon Code: CHONG0183
THANKS and CONGRATULATIONS to the author team! Another fantastic job![Read More]