
SQL: The Complete Reference
McGraw-Hill Professional (Publisher)
Published on 16. May 1999
Book
Paperback/Softback
1008 pages
978-0-07-211845-2 (ISBN)
Description
Providing the conceptual framework and insight into relational database technology, this how-to guide includes comprehensive coverage of every SQL feature and topic as well as current enhancements and extensions.
More details
Language
English
Place of publication
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Illustrations
Illustrations
Dimensions
Height: 231 mm
Width: 188 mm
Thickness: 48 mm
Weight
1928 gr
ISBN-13
978-0-07-211845-2 (9780072118452)
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
Overview of SQL. Introduction--Update on New Market Developments. A Quick Tour of SQL. SQL in PerspectiveRelational Databases. Retrieving Data. SQL Basics--SQL 2/SQL 3, Database Comparisons. Simple Queries. Multi-Table Queries. (Joins) Summary Queries. Subqueries and Query Expressions. Updating Data.Database Updates--SQL2/SQL3. Data Integrity--Expanded Treatment of Triggers. Transaction Processing.Database Structure. Creating a Database.Views. SQL Security. The System Catalog.Programming with SQL.Embedded SQL. Dynamic SQL. SQL APIs.SQL Today and Tomorrow.Database Processing and Stored Procedures.SQL and Data Warehousing.SQL and Networking and Distributed Databases.SQL and Objects.The Future of SQL.Appendices.Future Directions. Distributed Database Management. The Future of SQL.