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 belowOverview
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)
Table of Contents
Introduction | 1 | |
Week 1 | At a Glance | 5 |
Day 1 | What DB2 Can Do for You | 7 |
Day 2 | Exploring the Capabilities of DB2 Universal Database | 31 |
Day 3 | Installing and Configuring DB2 Server | 67 |
Day 4 | Getting Started | 95 |
Day 5 | Setting Up DB2 Instances and Server Communications | 117 |
Day 6 | Installing and Configuring DB2 Clients | 143 |
Day 7 | Ensuring Data Security | 171 |
Week 2 | At a Glance | 191 |
Day 8 | Designing the CDLIB Database | 193 |
Day 9 | Creating Databases and Tables | 211 |
Day 10 | Creating Table Spaces | 229 |
Day 11 | Accessing the Data | 249 |
Day 12 | SQL Concepts | 269 |
Day 13 | Advanced SQL | 297 |
Day 14 | Design Considerations | 321 |
Week 3 | At a Glance | 335 |
Day 15 | Using System Administration Tools | 337 |
Day 16 | Recovery Concepts | 363 |
Day 17 | Moving Data | 391 |
Day 18 | Replicating Data | 421 |
Day 19 | Database Monitoring Tools | 451 |
Day 20 | Tuning DB2 Universal Database Performance | 477 |
Day 21 | Diagnosing Problems | 507 |
App. A: Getting Certified | 525 | |
App. B: Answers to Quiz Questions | 533 | |
Index | 551 |
Customer Reviews
Average Review: