Table of Contents |
| SQL Bible |
| Preface |
| 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 |
| Part VII - Appendix |
| 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 |
| List of Figures |
| List of Tables |
| List of Code Examples |
| List of Sidebars |
| CD Content |