DB2 is the number two database server next to Oracle and is a highly underpublished area. Written by two members of IBM's DB2 team, this title provides an inside and first look at this version. It should appeal to both administrators and developers as it provides comprehensive coverage.
Reihe
Sprache
Verlagsort
Verlagsgruppe
McGraw-Hill Education - Europe
Zielgruppe
Für höhere Schule und Studium
Für Beruf und Forschung
Illustrationen
Maße
Höhe: 235 mm
Breite: 183 mm
Gewicht
ISBN-13
978-0-07-213344-8 (9780072133448)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
Paul C. Zikopoulos (Toronto, Canada) is a Database Specialist with the DB2 Sales Support team at IBM. He has written numerous magazine articles and books about DB2. Most recently, he co-authored the books A DBA's Guide to Databases on Linux (Syngress Media) and DB2 for Dummies (IDG Books). Zikopoulos is a DB2 Certified Advanced Technical Expert (DRDA and Cluster/EEE) and a DB2 Certified Solutions Expert (Business Intelligence and Database Administration). Roman B. Melnyk, PhD (Toronto, Canada) is a Senior Member of the DB2 Information Development team at IBM, specialising in database administration and DB2 utilities. During more than six years at IBM, Melnyk has written numerous DB2 books and other related materials. Melnyk recently co-authored DB2 for Dummies (IDG Books).
Introduction Part I - Relational Database Concepts Database Design Database Objects Introducing Structured Query Language (SQL) Part II - Getting Started with DB2 Installing DB2 Migrating Databases Connecting Clients to Servers Controlling Data Access Understanding Instances Managing Data Storage Creating Databases Working with Tables Part III - Maintaining Data Moving Data Replicating Data Recovering Data Part IV - Performance Database Monitoring Configuration Tuning Problem Determination Part V - SQL Basic SQL Advanced SQL Part VI - Distributed Databases New features in 7.2 that will require outlining on beta Part VII - Business Intelligence Federated Systems Data Warehousing OLAP Part VIII - Administration GUI Tools (To be outlined on release of the GUI for 7.2) Part IX - Application Development Introduction to Application Development Embedded SQL Administrative Application Programming Interface (API) Call Level Interface (CLI) and ODBC Java Support Introduction to Stored Procedures and the Stored Procedure Builder Part X - Availability The Pillars of Availability Setting up FailOver Support on DB2 Advanced Topics of Availability Part XI - Reference SQL Keywords Special Registers Catalog Views System Commands CLP Commands Data Structures