SQL: The Complete Reference, 2/e

The Most Comprehensive SQL Resource Available

Get in-depth details on all the powerful features and capabilities of SQL inside this one-stop guide. Featuring broad coverage of every aspect of this leading database language, this book provides you with an overview of SQL then shows you how to retrieve and update data, program with SQL, use stored procedures, and much more. Covering emerging standards and new related technologies including XML, Web services, EJB, J2EE, and JDBC, this book will help you gain the knowledge and essential skills you need to effectively work with SQL. Comprehensive, organized, and practical, this is the ultimate guide to understanding and using SQL.

• Master SQL basics and use simple, multi-table, and summary queries
  
• Understand key concepts and the latest developments in relational database technology
  
• Set up and manage SQL-based databases and write programs to access them
  
• Create and use the sample database to run the SQL query examples in the book
  
• Find out about Xpath, Xquery, and other XML-based database query standards
  
• Discover how J2EE-based applications relate to data management
  
• Use and program SQL databases with application servers to create powerful Web applications
  
• Preview the future of SQL--including MySQL and the impact of XML and Web Services
  

Contents            

   Part I: An Overview of SQL
    1: Introduction
    2: A Quick Tour of SQL
    3: SQL in Perspective
    4: Relational Databases

   Part II: Retrieving Data
    5: SQL Basics
    6: Simple Queries
    7: Multitable Queries (Joins)
    8: Summary Queries
    9: Subqueries and Query Expressions

   Part III: Updating Data
    10: Database Updates
    11: Data Integrity
    12: Transaction Processing

   Part IV: Database Structure
    13: Creating a Database
    14: Views
    15: SQL Security
    16: The System Catalog

   Part V: Programming with SQL
    17: Embedded SQL
    18: Dynamic SQL *
    19: SQL APIs

   Part VI: SQL Today and Tomorrow
    20: Database Processing and Stored Procedures
    21: SQL and Data Warehousing
    22: SQL and Application Servers
    23: SQL Networking and Distributed Databases
    24: SQL and Objects
    25: SQL and XML
    26: The Future of SQL

   Part VII: Appendixes
    A: The Sample Database
    B: Database Vendor Profiles
    C: SQL Syntax Reference
    D: SQL Call-Level Interface
    E: SQL Information Schema Standard
    F: CD-ROM Installation Guide