SQL: The Complete Reference, Second Edition / Edition 2

SQL: The Complete Reference, Second Edition / Edition 2

by James R. Groff, Paul N. Weinberg, Michael Mueller, Paul N. Weinberg
     
 

ISBN-10: 0072225599

ISBN-13: 9780072225594

Pub. Date: 08/28/2002

Publisher: McGraw-Hill Companies, The

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,

Overview

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

Product Details

ISBN-13:
9780072225594
Publisher:
McGraw-Hill Companies, The
Publication date:
08/28/2002
Series:
Osborne Complete Reference Series
Edition description:
REV
Pages:
1080
Product dimensions:
7.40(w) x 9.20(h) x 2.17(d)

Table of 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

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >