DB2 Universal Database V6.1 for Unix, Windows and OS/2 Certification Guide (IBM DB2 Certification Guide Series) - Softcover

Cook, Jonathan; Harbus, Robert; Shirai, Tetsuya

Softcover

ISBN 10: 0130867551 ISBN 13: 9780130867551

Publisher: IBM Press, 1999

Synopsis

PLEASE PROVIDE COURSE INFORMATION

PLEASE PROVIDE

About this title

From the Back Cover

8675E-6

• The #1 guide and reference for IBM's powerhouse DB2 UDB V6.1 database
• New DB2 UDB V6.1 features for all platforms: UNIX, 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 V6.1 certification exams

IBM's DB2 Universal Database Version 6.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 V6.1 - and preparing for IBM's updated DB2 V6.1 certification exams!

This is IBM's definitive guide and reference for the newest, most powerful version of DB2 Universal Database ever: Version 6.1. DB2 Universal Database Version 6.1 for UNIX, Windows and OS/2 Certification Guide, Third Edition delivers end-to-end coverage for every DB2 developer and administrator, on every platform: Windows, UNIX, or OS/2 - including the most systematic IBM DB2 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, application development, 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
• Database access techniques using ODBC, JDBC, and ADO

Whether you're deploying DB2 UDB V6.1, managing DB2 UDB V6.1, preparing for DB2 UDB V6.1 certification, or all three, DB2 Universal Database Version 6.1 for UNIX, Windows, and OS/2 Certification Guide, Third Edition will be your single most valuable resource.

Synopsis

This is IBM's definitive guide to the newest version of DB2 Universal Database. It contains end-to-end coverage for every DB2 developer and administrator -- and for anyone who wants to achieve IBM DB2 certification. Start with a detailed overview of the DB2 family of products, key DB2 concepts, and terminology. Next, walk through installing DB2, setting up DB2 clients (including ODBC support); and controlling data access through authentication, assigned authorities, and user/group privileges. Understand DB2 SQL in depth, including database objects, the Data Definition Language (DDL), triggers, outer joins, OLAP SQL, table hierarchies, and concurrency. Master DB2 administration, including the optimal physical placement of data; populating DB2 tables with IBM's import and load utilities; monitoring, maintenance and tuning; logging; and database recovery. Finally, master the basics of DB2 application development. Review each programming method and interface provided by DB2; master embedded SQL; even learn the basics of CLI, ODBC, JDBC, and ADO.

Edition details

• Publisher: IBM Press
• Publication date: 1999
• ISBN 10: 0130867551
• ISBN 13: 9780130867551
• Binding: Paperback
• Language: English
• Edition number: 3
• Number of pages: 1014