DB2 in Books

Comment

Comment by bogdanjcnd on March 4, 2009 at 11:46pm

Thank you Susan for giving feedback about this book.Perhaps more people interested in dba duties or preparing to DBa certification exam could treat it as one of the main sources of knowledge about SQL. I anted also to share some new idea about SQL books I have recently read
One interesting is :
SQL and Relational Theory, 1st Edition

SQL and Relational Theory, 1st Edition
By: C.J. Date
Publisher: O'Reilly Media, Inc. which is available through Safari . It explains concept of SQL language
Author demonstrates how you can apply relational theory directly to use of SQL. For those who want to dip father in database theory this is strongly recommended source of knowledge.

Comment by Susan Visser on February 5, 2009 at 10:42am

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.

• Step through the basic SQL syntax
• Learn how to use best practices in database design
• Master advanced syntax like inner joins, groups, and subqueries
• Understand the SQL datatypes
• And much more...

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.

Comment by Susan Visser on February 2, 2009 at 2:26pm

New offer: Assess and Save:

Are you interested in getting certified, but finding money a bit tight? If yes, you'll love this new announcement:

With the Assess and Save Offer, candidates who purchase, take and PASS an Information Management Online Assessment Exam during the offering period (February 1, 2009 - April 30, 2009), will automatically receive a 50% off certification voucher good for the corresponding exam. That's $100 right back in your pocket!

IBM offers these online assessment exams for each Information Management Professional Certification. These "practice tests" enable you to test your readiness for a minimal fee of $10 USD, helping you to be successful on exam day.

Before you take the practice test, here are a few suggestions to help you pass:

Exam Preparation Documents

For exam objectives and cutscores for each exam, see the exam preparation documents.

Books

We now have an extensive collection of Certification Prep Guides, including

DB2 9 Fundamentals Certification Study Guide for Exam 730 by Roger Sanders

DB2 9 Database Administration Certification Study Guide for Exam 731 by Roger Sanders

DB2 9 for z/OS Database Administration Certification Study Guide for Exam 732 by Susan Lawson and Dan Luksetich

DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide for Exam 734 by Roger Sanders and Dwaine Snow

DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 by Roger Sanders

See also the DB2inBooks group on channeldb2.com.

Make sure you read all the details of this offer before proceeding: Assess and Save Offer.

Susan

Comment by Oswaldo F. Domejean on January 29, 2009 at 5:13pm

Hi Susan,
Thank you for taking a look at my book. Answering your question, I tested all the queries with DB2, and there is something else, the aspects I analysed in SQL correspond to the standar, the weaknesses are the same and in some cases still worse in other products. Thanks again.

Comment by Susan Visser on January 28, 2009 at 4:59pm

Thanks Oswaldo... I took a look at your book on lulu.com. Can you tell me if the book is product independent? It seems pretty generic from the TOC, but if you could tell me for sure, that would be helpful. Congratulations for publishing the book, by the way!

Comment by Oswaldo F. Domejean on January 18, 2009 at 12:04pm

Hi,

I invite you all to visit my website that has a book about the weaknesses SQL has on Database Processing. All the examples had been tested in DB2, but the situation is practically the same and in some cases still worse in other SQL DBMS. This publication explains aspects related to:

• Equivalent queries may produce different results.
• Aggregation operators like SUM, AVG, etc. doesn’t generate the correct calculation in certain cases.
• Query tables that have nulls may lead us to misinterpret results in a variety of cases.

It’s essential for us to be conscious about the weaknesses this language has in order to avoid them. I hope it’s useful:
The publication: http://stores.lulu.com/dbtips
A couple of weaknesses explained in my blog: http://dbtips.wordpress.com/
and its video clip in youtube.com: http://www.youtube.com/watch?v=FWrH5K6V6E0
Contact me: ofdomejean@gmail.com

Thanks for reading,

O. F. Domejean

Comment by Susan Visser on January 6, 2009 at 1:38pm

Thanks Luis! I'll make sure that there are links to your book.... as many people want Spanish versions!

Comment by Luis Reina on December 30, 2008 at 10:55am

Nice Group, congratulations! Here is another book, I have coauthored, to learn SQL and programming with DB2 LUW (though is in Spanish...)
http://www.paraninfo.es/servlet?txtsearchtitulo=&module_pk=10001&operation_pk=base_action_detail&obj_pk=8497320824&current_page=&txtautor=&txtsearchmercado_id=&txtisbn=&txttexto=&txttitulo=introduccion+al+SQL+para+usuarios&txtsearchtema_id=&txtsearchmateria_id=&txt_autor_id=

Comment by Cindy Saracco on September 22, 2008 at 2:41pm

That's a good Web site . . . . Some folks may also want to search the IBM Redbooks site (www.ibm.com/redbooks) for freely downloadable books on specific DB2 topics. (For example, if you go to the Redbooks web site and search on "db2 purexml," you'll find 3 books available for download.)

• ‹ Previous
• 1
• 2
• Next ›
• Page