by JonathanCook (Author), RobertHarbus (Author), TetsuyaShirai (Author)
IBM DB2 is now the most-popular and fastest growing database in the world, with well over 1 million licensed users. With the release of version 7.1 of its database software, IBM is expected to further increase its lead over rivals Oracle and Microsoft in late 2000 and into 2001. This book is the most comprehensive reference to DB2 UDB, as well as the most complete study guide for DB2 certification. This book will cover DB2 certification for both the Windows and UNIX platforms.
Format: Paperback
Pages: 1014
Edition: 3
Publisher: IBM Press 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.
Published: 12 Nov 1999
ISBN 10: 0130867551
ISBN 13: 9780130867551
Book Overview:
Jonathon Cook and Tetsuya Shirai are software professionals at IBM's International Technical Support Organization, Austin, TX.