Teach Yourself DB2 Universal Database in 21 Days

Susan Visser and Bill Wong
Ausust 2003

© 2003 International Business Machines Corporation. All rights reserved.

Teach Yourself DB2 Universal Database in 21 Days provides you with a practical, hands-on approach to learn how to use DB2 Universal Database quickly. Scenarios and step-by-step examples are provided to help you build your skill in an easy to understand manner. The book focuses on the most commonly used tasks so you can get started using DB2 immediately, in a real way. You are taught how to use the DB2 graphical interfaces and wizards on the Windows platform.

This is the perfect book for you if you are learning about databases for the first time or if you are changing careers from another database product or platform.

The scenario presented in the book is to create a library database to store your CD collection. All steps required to create your CD library are provided, including:

• Installing, configuring, and setting up DB2
• Designing a database, including normalizing data and choosing a primary key
• Using wizards to create the database, tables, and relationships between the tables
• Adding data to the tables using SQL or by loading or importing from other sources
• Accessing your data using SQL, Java, or your own applications
• Setting up security to protect your data
• Automating tasks such as creating monthly reports
• Scheduling tasks to run at specified times
• Backing up and restoring data
• Exporting data to other sources such as spreadsheets
• Replicating data to other databases
• Tuning performance parameters
• Solving problems

Also provided with the book is a trial version of DB2 UDB V8. You will have 180 days to use this version of DB2 to gain critical hands-on knowledge of the product.

About the authors

Susan Visser has worked on the DB2 product for more than 12 years. 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 taught 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 Program Director, 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.

Feedback for the authors

Do you have feedback for the authors? They are interested in your comments.

Downloads

Description	File type	File size	Download method
Table of contents	PDF	104 KB	HTTP
Sample chapter	PDF	1243 KB	HTTP