SQL The Complete Reference

by James R. Groff, Paul Weinberg, Andy Oppel

About the Book: SQL The Complete Reference SQL: The Complete Reference, Third Edition has been revised to cover the latest RDBMS software versions including Microsoft SQL Server 2008, Oracle Database 11g, DB2, and MySQL. There are also extensive changes throughout the book including a new chapter on the latest innovations in SQL-based data management, new coverage of Database APIs and OCI, new J2EE developments, new Application Server coverage, SQL security regulations, and much more. 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 Procedural SQL 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 Specialty Databases 27 The Future of SQL Part VII Appendixes A The Sample Database B DBMS Vendor Profiles C SQL Syntax Reference About the Authors: James R. Groff, Paul N. Weinberg James R. Groff is senior vice president of business strategy at Oracle Corporation. Paul N. Weinberg is senior vice president of NetWeaver MDM at SAP.

Genres: Programming, Reference

Paperback

First published March 1, 1999

Reviews

[Oleksandr · Rating 3 out of 5]

Pretty outdated

[Allisonperkel · Rating 4 out of 5]

Well written, very good overview of SQL

[John Bevan]

I registered a book at BookCrossing.com!
http://www.BookCrossing.com/journal/12020028

[Luke Darling · Rating 3 out of 5]

Definitely contains a lot of information. This book is good for entry to intermediate experience but not much more. The chapters are well organized and I like the railroad diagrams.