SQL in a Nutshell, 2nd Edition [Electronic resources]

• Table of Contents

• Index

• Reviews

• Reader Reviews

• Errata

• Academic

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