Beginning DB2

1. Front Matter

   Pages i-xxvi

   PDF

2. Getting Started

   1. Front Matter

      Pages 1-1

      PDF

   2. What Is DB2 and Where Can I Get It?

      Pages 3-9

   3. Installing DB2 for Linux and Windows

      Pages 11-35

3. Beginning Administration with DB2 Express Edition

   1. Front Matter

      Pages 37-37

      PDF

   2. DB2 Wizards: The Fast Path to Working with Your New Database

      Pages 39-61

   3. Controlling Your Environment with Db2 Control Center and Command-Line Tools

      Pages 63-85

4. Database Fundamentals with DB2 Express Edition

   1. Front Matter

      Pages 87-87

      PDF

   2. IBM Data Studio

      Pages 89-109

   3. SQL for DB2: Part 1

      Pages 111-126

   4. SQL for DB2: Part 2

      Pages 127-142

   5. Developing Functions and Stored Procedures in DB2

      Pages 143-161

   6. Controlling Access to DB2

      Pages 163-175

   7. Securing Data in DB2

      Pages 177-194

   8. Using XML with DB2

      Pages 195-214

   9. Indexes, Sequences, and Views

      Pages 215-237

5. Programming with DB2 Express Edition

   1. Front Matter

      Pages 239-239

      PDF

   2. PHP with DB2

      Pages 241-262

   3. DB2 on Rails

      Pages 263-277

   4. DB2 Development with Microsoft Visual Studio.NET

      Pages 279-299

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.

• .NET
• Access
• Interface
• Python
• database
• database administration
• performance
• relational database

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.

Policies and ethics