Product Description

Marketshare for DB2 has been growing steadily over the past 5 years and with the recent release of DB2 Universal Database V8, the product has never had more momentum. Not only is the product used in every company on the Fortune 500, but it is becoming very popular in the small to medium sized businesses as well. Sams Teach Yourself DB2 Universal Database in 21 Days, Second Edition, focuses on performing tasks using the graphical interfaces and wizards that are provided with DB2 on the Windows platform. (DB2 also runs on z/OS, OS/400, AIX, Linux, HP-UX, and Sun Solaris.) Readers are guided through performing all the commonly used tasks to run DB2, including installing DB2, setting up DB2, creating databases and tables, populating the database with data, accessing the data, ensuring the database is tuned for performance. This book differs from the competition in that it provides examples and scenarios making it very easy for the reader to learn complicated tasks. It gives them everything they need for the commonly used tasks in a simple to understand manner. Quizzes and exercises strengthen the knowledge gained and ensure concepts are learned rather than memorized.

Product Details

• Amazon Sales Rank: #1190146 in Books
• Published on: 2003-08-30
• Original language: English
• Number of items: 1
• Binding: Paperback
• 624 pages

From the Back Cover

Marketshare for DB2 has been growing steadily over the past 5 years and with the recent release of DB2 Universal Database V8, the product has never had more momentum. Not only is the product used in every company on the Fortune 500, but it is becoming very popular in the small to medium sized businesses as well. Sams Teach Yourself DB2 Universal Database in 21 Days, Second Edition, focuses on performing tasks using the graphical interfaces and wizards that are provided with DB2 on the Windows platform. (DB2 also runs on z/OS, OS/400, AIX, Linux, HP-UX, and Sun Solaris.) Readers are guided through performing all the commonly used tasks to run DB2, including installing DB2, setting up DB2, creating databases and tables, populating the database with data, accessing the data, ensuring the database is tuned for performance. This book differs from the competition in that it provides examples and scenarios making it very easy for the reader to learn complicated tasks. It gives them everything they need for the commonly used tasks in a simple to understand manner. Quizzes and exercises strengthen the knowledge gained and ensure concepts are learned rather than memorized.

About the Author
Sams Teach Yourself DB2 Universal Database in 21 DaysSams Teach Yourself DB2 Universal Database in 21 Days About the Author Susan Visser has worked on the DB2 product for more than 12 years. First as a technical writer creating product documentation, then as a service consultant answering customer questions on the phone, and finally as the leader of the DB2 certification program creating certification exams to validate DB2 product skills. Five years ago, Susan wrote and published the first edition of Teach Yourself DB2 Universal Database in 21 Days. Since then she has helped other authors write and publish their books. In many cases, she has reviewed their books and provided guidance as to the style and topics to cover. As part of her job as certification lead, Susan speaks to many people who are trying to learn DB2 either for the first time or for a new release. She has gathered ideas from them to learn how people like to learn and the books they like to learn from. She also helps people get the skills they need to pass the certification exams and understand what is necessary both in terms of content and the different styles of learning. Bill Wong has spent the last 18 years working in various positions within IBM. Bill has worked with the DB2 product since its inception, working as a systems programmer, DBA, product planner, and as a technical sales specialist. Bill has also spent time teaching courses on database technology, strategic I/T planning, systems analysis and design, and decision theory. He is the author of many articles on DB2 technology and speaks frequently at technical conferences and customer sites around the world. Bill is currently the Program Director for Information Grid Solutions, and is responsible for helping customers understand IBM's latest directions in Grid computing, and how DB2 might fit into that environment. ) Copyright Pearson Education. All rights reserved.

Customer Reviews

A practical quick introduction
A very practical and focused book, that can quickly get you up and running with the basics of using dB2. There are two roles described here. One is that of the Database Administrator. You'd be the person to act as sysadmin of a dB2 database. Doing the install and later creating users with various privileges, and in general keeping an eye on things. Corresponds exactly to being sysadmin of a computer.

The second role is that of a dB2 user. Here, a user is really a programmer. She can be expected to design a database, and to then implement it in dB2.

One thing about the book is that it does not really emphasise a separation between the two roles in the overall narrative. Sure, some sections are exclusively for one role. But the overlap in knowledge is extensive. The book correctly requires you to know both roles, to be more effective in either. This is a key difference between dB2 and the general usage of a computer. For the latter, a sysadmin does not need to know the programming languages that a user-programmer has expertise in.

The discussion about SQL itself is pretty rudimentary. You get enough of the basics to be able to use these quickly in dB2, for simple applications. A pragmatic approach to SQL. Which is what the typical SAMS reader probably needs.

Very comprehensive but can be improved
It is a very good book to start learning DB2. However this book doesn't cover the client configuration issues on Unix platforms.

Wassim Saade

Oracle Certified DBA

Learning DB2
I found this book very helpful in learning DB2. Before reading, I knew the basics of SQL, but little or nothing about DB2. I did have to read another book to prepare for certification, but one thing this book gave me that the certification guide did not was hands on experience with DB2.