SQL: The Complete Reference, Second Edition
2nd Edition
Published on 16. August 2002
Book
Paperback/Softback
1080 pages
978-0-07-222559-4 (ISBN)
Description
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).
More details
Series
Edition
2nd edition
Language
English
Place of publication
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Illustrations
200 illustrations
Dimensions
Height: 231 mm
Width: 185 mm
Thickness: 57 mm
Weight
1742 gr
ISBN-13
978-0-07-222559-4 (9780072225594)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide
Paul N. Weinberg and James R. Groff are the authors of Using SQL, the book on which this guide is based. They were also the cofounders of Network Innovations Corporation, developers of SQL-based network software. Groff speaks and writes on SQL and UNIX topics. Weinberg is currently a developer at Apple Computer Corporation.
Paul N. Weinberg and James R. Groff are the authors of Using SQL, the book on which this guide is based. They were also the cofounders of Network Innovations Corporation, developers of SQL-based network software. Groff speaks and writes on SQL and UNIX topics. Weinberg is currently a developer at Apple Computer Corporation.
Content
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