SQL Bible

Here, in one definitive volume, is all the information you need to understand and use SQL and its implementations in accordance with the established SQL99 standard. Whether you want to learn database programming from scratch, you’d like to sharpen your SQL skills, or you need to know more about programming for a heterogeneous database environment, this book provides the complete menu. Tutorials and code examples in each chapter make it an indispensable reference for every level of expertise.

Inside, you’ll find complete coverage of SQL

• Understand the definition and characteristics of relational databases and SQL’s role within RDBMS
• Recognize vendor-specific implementation variations among Oracle, IBM DB2 UDB, and MS SQL Server
• Create and modify RDBMS objects like tables, views, indexes, synonyms, sequences, and schemas using Data Definition Language (DDL)
• Comprehend Data Manipulation Language (DML) from different vendors’ perspectives
• Master single-table select statements and multitable queries from the ground up</ LI>
• Explore in-depth SQL functions, operators, and data types for major RDBMS implementations
• Discover new SQL developments including XML, OLAP, Web services, and object-oriented features

Bonus CD-ROM includes:

• IBM DB2 Universal Database Personal Edition v 8.1 for Windows Operating Environments Evaluation copy
• Complete original database example files from the authors
• Complete book in PDF format

Table of Contents

Preface.

Acknowledgments.

PART I: SQL Basic Concepts and Principles.

  Chapter 1: SQL and Relational Database Management Systems (RDBMS).

  Chapter 2: Fundamental SQL Concepts and Principles.

  Chapter 3: SQL Data Types.

PART II: Creating and Modifying Database Objects.

  Chapter 4: Creating RDBMS Objects.

  Chapter 5: Altering and Destroying RDBMS Objects.

PART III: Data Manipulation and Transaction Control.

  Chapter 6: Data Manipulation Language (DML).

  Chapter 7: Sessions, Transactions, and Locks.

PART IV: Retrieving and Transforming Data.

  Chapter 8: Understanding SELECT Statement.

  Chapter 9: Multitable Queries.

  Chapter 10: SQL Functions.

  Chapter 11: SQL Operators.

PART V: Implementing Security Using System Catalogs.

  Chapter 12: SQL and RDBMS Security.

  Chapter 13: The System Catalog and INFORMATION_SCHEMA.

PART VI: Beyond SQL: Procedural Programming and Database Access Mechanisms.

  Chapter 14: Stored Procedures, Triggers, and User-Defined Functions.

  Chapter 15: Dynamic and Embedded SQL Overview.

  Chapter 16: SQL API.

  Chapter 17: New Developments: XML, OLAP, and Objects.

  Appendix A: What’s on the CD-ROM.

  Appendix B: The ACME Sample Database.

  Appendix C: Basics of Relational Database Design.

  Appendix D: Installing RDBMS Software.

  Appendix E: Accessing RDBMS.

  Appendix F: Installing the ACME Database.

  Appendix G: SQL Functions.

  Appendix H: SQL Syntax Reference.

  Appendix I: SQL-Reserved Keywords.

  Appendix J: SQL99 Major Features Compliance Across Different RDBMS.

  Appendix K: The Other RDBMS.

  Appendix L: A Brief Introduction to the Number Systems, Boolean Algebra, and Set Theory.

  Index