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
     
 

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

See more details below

Overview

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.

Read More

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)

Related Subjects

Table of Contents

Introduction1
Week 1At a Glance5
Day 1What DB2 Can Do for You7
Day 2Exploring the Capabilities of DB2 Universal Database31
Day 3Installing and Configuring DB2 Server67
Day 4Getting Started95
Day 5Setting Up DB2 Instances and Server Communications117
Day 6Installing and Configuring DB2 Clients143
Day 7Ensuring Data Security171
Week 2At a Glance191
Day 8Designing the CDLIB Database193
Day 9Creating Databases and Tables211
Day 10Creating Table Spaces229
Day 11Accessing the Data249
Day 12SQL Concepts269
Day 13Advanced SQL297
Day 14Design Considerations321
Week 3At a Glance335
Day 15Using System Administration Tools337
Day 16Recovery Concepts363
Day 17Moving Data391
Day 18Replicating Data421
Day 19Database Monitoring Tools451
Day 20Tuning DB2 Universal Database Performance477
Day 21Diagnosing Problems507
App. A: Getting Certified525
App. B: Answers to Quiz Questions533
Index551

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >