Pub. Date:
Sams Teach Yourself DB2 Universal Database in 21 Days / Edition 2

Sams Teach Yourself DB2 Universal Database in 21 Days / Edition 2

by Susan Visser, Bill Wong


Current price is , Original price is $49.99. You
Select a Purchase Option (REV)
  • purchase options


Sams Teach Yourself DB2 Universal Database in 21 Days / Edition 2

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

ISBN-13: 9780672325823
Publisher: Sams
Publication date: 08/30/2003
Series: Sams Teach Yourself Series
Edition description: REV
Pages: 600
Product dimensions: 7.40(w) x 9.20(h) x 1.50(d)

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 forInformation 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.

Table of Contents


Week 1
    Day 1 What DB2 Can Do For You
      2 Exploring the Capabilities of DB2 Universal Database
      3 Installing and Configuring DB2 Server
      4 Getting Started
      5 Setting up DB2 Instances and Server Communications
      6 Installing and Configuring DB2 Clients
      Ensuring Data Security
Week 2
    Day 8 Designing the CDLIB Database
      9 Creating Databases and Tables
      10 Creating Table Spaces
      11 Accessing the Data
      12 SQL Concepts
      13 Advanced SQL
      Design Considerations
Week 3
    Day 15 Using System Administration Tools
      16 Recovery Concepts
      17 Moving Data
      18 Replicating Data
      19 Database Monitoring Tools
      20 Tuning DB2 Universal Database Performance
      Diagnosing Problems

    A Getting Certified
    B Answers to Quizzes

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews