Database Design and SQL for DB2

Database Design and SQL for DB2 engages readers with a hands-on approach that provides start-to-finish coverage of database design and SQL, IBM's strategic language for the IBM i integrated database.

This book is designed for professional application developers and college-level students who want to become developers. This is also an ideal book for developers coming from other database platforms. For many developers, this book can serve in place of IBM's database-related manuals. All the essential SQL and related DB2 topics are covered from an introductory to an advanced level.

Each chapter includes comprehensive explanations and numerous examples. In addition, the companion website for this book provides further examples of embedded SQL as well as using client-side technologies such as jQuery, JSON, and AJAX with RPG Web applications.

You will find Database Design and SQL for DB2 immediately useful, whether you are just beginning to learn SQL or you are an experienced developer. And you will turn to this book time and time again for quick answers to the best way to design and implement database applications.

With Database Design and SQL for DB2, you will:

• Model and design databases using entity relationship (ER) diagrams
• Normalize database tables
• Implement physical database tables
• Define referential constraints-primary and unique key indexes-and check constraints to enforce data integrity
• Use simple and complex SQL statements on single and multiple tables
• Use the SELECT-UPDATE-INSERT-and DELETE statements
• Create database tables-views-and indexes
• Develop RPG Web applications that incorporate embedded SQL
• Incorporate jQuery-JSON-and AJAX into RPG Web applications