Bibliographic record and links to related information available from the Library of Congress catalog
Information from electronic data provided by the publisher. May be incomplete or contain other coding.
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. End-User License Agreement.