Melton/Simon: Understanding the New SQL

I SQL-92 Basics

• 1. Introduction to SQL-92. 3-14
• 2. Getting Started with SQL-92. 15-41
• 3. Basic Table Creation and Data Manipulation. 43-60
• 4. Basic Data Definition Language (DDL). 61-81
• 5. Values, Basic Functions, and Expressions. 83-112

II Advamced Features of SQL-92

• 6. Advanced Value Expressions: CASE, CAST, and Row Value Expressions. 115-124
• 7. Predicates. 125-147
• 8. Working With Multiple Tables: The Relational Operators. 149-174
• 9. Advanced SQL Query Expressions. 175-198
• 10. Constraints, Assertions, and Referential Integrity. 199-228

III SQL and Applications

• 11. Accessing SQL From the Real World. 231-258
• 12. Cursors. 259-271
• 13. Privileges, Users, and Security. 273-291
• 14. Transaction Management. 293-302
• 15. Connections and Remote Database Access. 303-309
• 16. Dynamic SQL. 311-345

IV The Finishing Touches

• 17. Diagnostics and Error Management. 349-360
• 18. Internationalization Aspects of SQL-92. 361-369
• 19. Information Schema. 371-385
• 20. A Look to the Future. 387-394

Appendices

• A. Designing SQL-92 Databases. 397-412
• B. A Complete SQL-92 Example. 413-440
• C. The SQL-92 Annexes: Differences, Implementation-Defined and Implementation-Dependednt Features, Deprecated Features, and Leveling. 441-463
• D. Relevant Standards Bodies. 465-468
• E. Status Codes. 469-472
• F. The SQL Standardization Process. 473-480
• G. The Complete SQL-92 Language. 481-527

Index