Learn all you need to know about SQL with this one-stop resource. Updated to include information on Web services and XML, this complete guide also comes with a Windows 2000- and XP- compatible CD containing 4 databases (SQL Server 2000, IBM DB2 Version 7.2, Sybase, and mySQL).
Back Cover
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
art 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
