Books & Videos

Table of Contents

  1. Chapter 1 SQL History and Implementations

    1. The Relational Model and ANSI SQL

    2. History of the SQL Standard

    3. SQL Dialects

  2. Chapter 2 Foundational Concepts

    1. Database Platforms Described in This Book

    2. Categories of Syntax

    3. SQL2003 and Platform-Specific Datatypes

    4. Constraints

  3. Chapter 3 SQL Statement Command Reference

    1. How to Use This Chapter

    2. SQL Platform Support

    3. SQL Command Reference

  4. Chapter 4 SQL Functions

    1. Types of Functions

    2. ANSI SQL Aggregate Functions

    3. ANSI SQL Window Functions

    4. ANSI SQL Scalar Functions

    5. Platform-Specific Extensions

  5. Chapter 5 Database Programming

    1. Database Programming Overview

    2. Opening a Database Connection

    3. Closing a Database Connection

    4. Managing Transactions

    5. Executing Statements

    6. Retrieving Data

    7. Bound Parameters

    8. Error Handling

    9. Examples

  1. Appendix A Sybase Adaptive Server

    1. Sybase Adaptive Server Datatypes

    2. Sybase Adaptive Server SQL Statements

    3. Sybase Adaptive Server SQL Functions

    4. Sybase Adaptive Server Keywords

  2. Appendix B Shared and Platform-Specific Keywords

  3. Colophon