Beginning DB2 From Novice to Professional

IBM’s DB2 Express Edition is one of the most capable of the free database platforms available in today’s marketplace. In Beginning DB2, author Grant Allen gets you started using DB2 Express Edition for web sites, desktop applications, and more. The author covers the basics of DB2 for developers and database administrators, shows you how to manage data in both XML and relational form, and includes numerous code examples so that you are never in doubt as to how things work. In this book, you’ll find:

• A friendly introduction to DB2 Express Edition, an industrial–strength, relational database from IBM
• Dozens of examples so that you are never in doubt as to how things work
• Coverage of important language interfaces, such as from PHP, Ruby, C#, Python, and more

The book is aimed at developers who want a robust database to back their applications.

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.

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.