Beginning DB2 (eBook)

From Novice to Professional

Grant Allen (Autor)

eBook Download: PDF

2008 | 1st ed.
XXVI, 515 Seiten
Apress (Verlag)
978-1-4302-0548-7 (ISBN)

Infos

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.

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.

Inhalt

Contents at a Glance 5
Contents 7
About the Author 19
About the Technical Reviewer 20
Acknowledgments 21
Introduction 22
Getting Started 24
What Is DB2 and Where Can I Get It? 25
Installing DB2 for Linux and Windows 32
Beginning Administration with DB2 Express Edition 57
DB2 Wizards: The Fast Path to Working with Your New Database 58
Controlling Your Environment with DB2 Control Center and Command-Line Tools 81
Database Fundamentals with DB2 Express Edition 104
IBM Data Studio 105
SQL for DB2: Part 1 126
SQL for DB2: Part 2 142
Developing Functions and Stored Procedures in DB2 158
Controlling Access to DB2 177
Securing Data in DB2 190
Using XML with DB2 208
Indexes, Sequences, and Views 228
Programming with DB2 Express Edition 251
PHP with DB2 252
DB2 on Rails 274
DB2 Development with Microsoft Visual Studio.NET 289
Developing Java Applications with DB2 310
Exploring More DB2 Development Options 332
Ongoing Database Administration with DB2 344
Database Creation and Configuration 345
DB2 Backup and Recovery 366
Sharing Your DB2 Environment 391
Moving Data in Bulk with DB2 413
Working with Design 433
Moving Up to More Advanced DB2 447
Monitoring and Tuning DB2 Performance 465
Index 496

Produkt-Details

• Erscheint lt. Verlag: 20.11.2008
• Zusatzinfo: 544 p.
• Verlagsort: Berkeley
• Sprache: englisch
• Themenwelt: Informatik ► Datenbanken ► DB2
• Schlagworte: ACCESS • Database • database administration • Interface • .NET • Performance • Python • Relational Database
• ISBN-10: 1-4302-0548-2 / 1430205482
• ISBN-13: 978-1-4302-0548-7 / 9781430205487