DB2 Universal Database v7.1 for UNIX, Linux, Windows and OS/2 Database Administration Certification Guide (4th Edition) - Softcover

George Baklarz; Bill Wong; Cook, Jonathan

Softcover

ISBN 10: 0130913669 ISBN 13: 9780130913661

Publisher: Prentice Hall, 2000

Synopsis

A guide and reference to the newest version of IBM's DB2 Universal Database. Suitable for those deploying or managing the new version, or preparing for certification, this 2.25-inch thick guide presents a detailed overview of the whole family of products, concepts, and terminology, as well as coverage of installation, configuration, networking, security, data integrity, optimization, and other topics. CD-ROM contains a trial version of DB2 UDB v7.1for Windows versions NT, 2000, 98, and 95, as well as a demo program DB2DEMO. Annotation c. Book News, Inc., Portland, OR (booknews.com)

About this title

Review

IBM's DB2 Universal Database has a large following of corporate users--which means information technology professionals eager to sell their services to such companies--who can profit by knowing how to set up and use DB2. The easiest way to pass sniff tests in the search for a DB2 administration job is to have your certification papers in hand. DB2 Universal Database v7.1: Database Administration Certification Guide is meant to help you pass two of IBM's three DB2 certification exams. Coverage is sufficiently wide-ranging and deep (this is a large book) that you can continue to use the book as a reference once you've passed the exams.

Baklarz and Wong--both members of IBM's DB2 team--document the subject fully, don't cover test-taking strategies, and avoid limiting themselves to subjects known to appear on the exams. Indeed, except for some sample questions in an appendix, you wouldn't know that this is an exam-prep book at all (which is good, because knowledge-gathering is the best exam preparation of all. The book explains DB2 with the proven technique of what and why, shows how to do it (and illustrates the process with listings and screen shots), and then recaps what went on in the process. It's an effective approach that DB2 administrators will like. --David Wall

Topics covered: The published scope of the DB2 Family Fundamentals exam and the DB2 for OS/2, Windows, Unix, and Linux Database Administration exam, including basic functionality and architecture, database objects, Structured Query Language (SQL), data maintenance, and backup. Though there's some mention of software development issues, this book doesn't cover the requirements of the DB2 Family Applications Development exam.

From the Back Cover

• Gain DB2 Universal Database Certification!
• Includes demonstration program covering new product features
• Preparation for v7.1 Fundamentals and Database Administration Certification Exams
• Contains many useful tips, techniques and guidelines for DB2 administrators and developers
• The only comprehensive reference guide for DB2 UDB V7.1 certification
• CD-ROM contains trial version of DB2 UDB V7.1 for Windows NT, Windows 2000, and Windows 95/98
• Written by DB2 experts in IBM's Toronto Lab
• The #1 guide and reference for IBM's powerhouse DB2 UDB V7.1 database
• New DB2 UDB V7.1 features for all platforms: UNIX, Linux Windows, and OS/2!
• Complete coverage for database administrators and application developers!
• Sample test questions to assist in your preparation for IBM's new DB2 UDB V7.1 exams

IBM's DB2 Universal Database Version 7.1 for UNIX, Windows, and OS/2 delivers unprecedented power, scalability, e-business support, and much more! Now, there's a complete, authoritative guide to deploying, managing, and developing applications with DB2 UDB V7.1 — and preparing for IBM's updated DB2 UDB V7.1 certification exam!

This is IBM's definitive guide and reference for the newest, most powerful version of DB2 Universal Database ever: Version 7.1. DB2 Universal Database v7.1 for UNIX, Linux, Windows, and OS/2 Database Administration Certification Guide, Fourth Edition delivers end-to-end coverage for every DB2 UDB developer and administrator, on every platform: Windows, UNIX, or OS/2 — including the most complete IBM DB2 UDB certification review you can find.

IBM DB2 experts present a detailed overview of the DB2 UDB family of products, key DB2 concepts, and terminology, plus in-depth coverage of installation, configuration, networking, security, data integrity, optimization, and more. Coverage includes:

• DB2 administration: populating tables with import and load utilities, monitoring, logging, maintenance, and tuning
• Security: Controlling data access through authentication, assigned authorities, user/group privileges, and more
• Database backup and recovery, step-by-step
• DB2 SQL, in depth: database objects, Data Definition Language (DDL), Data Manipulation Language (DML), triggers, outer joins, OLAP SQL, table hierarchies, concurrency, and embedded SQL

Whether you're deploying DB2 UDB V7.1, managing DB2 UDB V7.1, preparing for DB2 UDB V7.1 certification, or all three, The DB2 Universal Database v7.1 for UNIX, Linux, Windows, and OS/2 Database Administration Certification Guide, Fourth Edition will be your single most valuable resource.

About the CD

The CD contains a trial version of DB2 UDB v7.1 for Windows NT, Windows 2000, and Windows 95/98. The CD also includes the demo program DB2DEMO, which enables you to demonstrate and use various SQL features of DB2.

Edition details

• Publisher: Prentice Hall
• Publication date: 2000
• ISBN 10: 0130913669
• ISBN 13: 9780130913661
• Binding: Paperback
• Language: English
• Number of pages: 790