Database Design and SQL for DB2
by James CooperView All Available Formats & Editions
ISBN-10: 1583473572
ISBN-13: 9781583473573
Pub. Date: 04/24/2013
Publisher: Mc Press
Thorough and updated coverage of database design and SQL for DB2 are the focus of this guide for the relational database-management system used on IBM i computer systems. Suitable for classroom instruction or self-study, this book explains the most widely used database language and the way that language is implemented on a variety of computer platforms. Topics
Overview
Thorough and updated coverage of database design and SQL for DB2 are the focus of this guide for the relational database-management system used on IBM i computer systems. Suitable for classroom instruction or self-study, this book explains the most widely used database language and the way that language is implemented on a variety of computer platforms. Topics covered include database concepts, SQL inquiries, web applications, and database security, and the material is reinforced by numerous illustrations, examples, and exercises.
Product Details
- ISBN-13:
- 9781583473573
- Publisher:
- Mc Press
- Publication date:
- 04/24/2013
- Pages:
- 504
- Product dimensions:
- 8.08(w) x 9.98(h) x 1.01(d)
Table of Contents
Contents
Introduction,Chapter 1: Database Concepts,
Chapter 2: Conceptual Design Using ER Diagrams,
Chapter 3: Normalization,
Chapter 4: Physical Database Design: Creating Tables,
Chapter 5: Database Constraints,
Chapter 6: Single-Table Queries,
Chapter 7: Updating Tables,
Chapter 8: Multiple-Table Queries,
Chapter 9: Subqueries,
Chapter 10: Views and Indexes,
Chapter 11: Embedded SQL,
Chapter 12: SQL Cursors,
Chapter 13: The Create SQL Program Command,
Chapter 14: Stored Procedures,
Chapter 15: Triggers,
Chapter 16: Additional SQL Topics,
Chapter 17: Database Security and the GRANT and REVOKE Statements,
Index,
Customer Reviews
Average Review: