Beginning DB2

Grant Allen has worked in the IT field for over 20 years, as a CTO, enterprise architect, and database administrator. Grant's roles have covered private enterprise, academia and the government sector around the world, specialising in global-scale systems design, development, and performance. He is a frequent speaker at industry and academic conferences, on topics ranging from data mining to compliance, and technologies such as databases (DB2, Oracle, SQL Server, MySQL), content management, collaboration, disruptive innovation, and mobile ecosystems like Android. His first Android application was a task list to remind him to finish all his other unfinished Android projects. Grant works for Google, and in his spare time is completing a Ph.D on building innovative high-technology environments. Grant is the author of Beginning DB2, and lead author of Oracle SQL Recipes and The Definitive Guide to SQLite.

Getting Started.- What Is DB2 and Where Can I Get It?.- Installing DB2 for Linux and Windows.- Beginning Administration with DB2 Express Edition.- DB2 Wizards: The Fast Path to Working with Your New Database.- Controlling Your Environment with Db2 Control Center and Command-Line Tools.- Database Fundamentals with DB2 Express Edition.- IBM Data Studio.- SQL for DB2: Part 1.- SQL for DB2: Part 2.- Developing Functions and Stored Procedures in DB2.- Controlling Access to DB2.- Securing Data in DB2.- Using XML with DB2.- Indexes, Sequences, and Views.- Programming with DB2 Express Edition.- PHP with DB2.- DB2 on Rails.- DB2 Development with Microsoft Visual Studio.NET.- Developing Java Applications with DB2.- Exploring More DB2 Development Options.- Ongoing Database Administration with DB2.- Database Creation and Configuration.- DB2 Backup and Recovery.- Sharing Your DB2 Environment.- Moving Data in Bulk with DB2.- Working with Design.- Moving Up to More Advanced DB2.- Monitoring and Tuning DB2 Performance.