SQL in a Nutshell, 2nd Edition |
By Kevin E. Kline |
|
Publisher | : O'Reilly |
Pub Date | : September 2004 |
ISBN | : 0-596-00481-8 |
Pages | : 710 |
| | |
| Copyright |
| | Preface |
| | | Why This Book? |
| | | Who Should Read This Book? |
| | | How This Book Is Organized |
| | | Conventions Used in This Book |
| | | How to Use This Book |
| | | How to Contact Us |
| | | Safari Enabled |
| | | Resources |
| | | Changes in the Second Edition |
| | | Acknowledgments |
| | Chapter 1. SQL History and Implementations |
| | | Section 1.1. The Relational Model and ANSI SQL |
| | | Section 1.2. History of the SQL Standard |
| | | Section 1.3. SQL Dialects |
| | Chapter 2. Foundational Concepts |
| | | Section 2.1. Database Platforms Described in This Book |
| | | Section 2.2. Categories of Syntax |
| | | Section 2.3. SQL2003 and Platform-Specific Datatypes |
| | | Section 2.4. Constraints |
| | Chapter 3. SQL Statement Command Reference |
| | | Section 3.1. How to Use This Chapter |
| | | Section 3.2. SQL Platform Support |
| | | Section 3.3. SQL Command Reference |
| | Chapter 4. SQL Functions |
| | | Section 4.1. Types of Functions |
| | | Section 4.2. ANSI SQL Aggregate Functions |
| | | Section 4.3. ANSI SQL Window Functions |
| | | Section 4.4. ANSI SQL Scalar Functions |
| | | Section 4.5. Platform-Specific Extensions |
| | Chapter 5. Database Programming |
| | | Section 5.1. Database Programming Overview |
| | | Section 5.2. Opening a Database Connection |
| | | Section 5.3. Closing a Database Connection |
| | | Section 5.4. Managing Transactions |
| | | Section 5.5. Executing Statements |
| | | Section 5.6. Retrieving Data |
| | | Section 5.7. Bound Parameters |
| | | Section 5.8. Error Handling |
| | | Section 5.9. Examples |
| | Appendix A. Sybase Adaptive Server |
| | | Section A.1. Sybase Adaptive Server Datatypes |
| | | Section A.2. Sybase Adaptive Server SQL Statements |
| | | Section A.3. Sybase Adaptive Server SQL Functions |
| | | Section A.4. Sybase Adaptive Server Keywords |
| | Appendix B. Shared and Platform-Specific Keywords |
| | Colophon |
| | Index |