SQL The Complete Reference

James R. Groff, Paul N. Weinberg

1076 pages, parution le 10/09/2002 (2^eme édition)

Ajouter à une liste

Indisponible

Résumé

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).

Contents

PART I: An Overview of SQL
Ch. 1: Introduction
Ch. 2: Quick Tour of SQL
Ch. 3. SQL in Perspective
Ch. 4. Relational Databases
PART II: Retrieving Data
Ch. 5. SQL Basics
Ch. 6. Simple Queries
Ch. 7. Multi-Table Queries
Ch. 8. Summary Queries
Ch. 9. Subqueries and Query Expressions
Part III: Updating Data
Ch. 10. Database Updates
Ch. 11. Data Integrity
Ch. 12. Transaction Processing
Part IV: Database Structure
Ch. 13. Creating a Database
Ch. 14. Views
Ch. 15. SQL Security
Ch. 16. The System Catalog
Part V: Programming with SQL
Ch. 17. Embedded SQL
Ch. 18: Dynamic SQL
Ch. 19: SQL APIS
Part VI: SQL Today and Tomorrow
Ch. 20. Database Processing and Stored Procedures
Ch. 21. SQL and Data Warehousing
Ch. 22. SQL Networking and Distributed Databases
Ch. 23. SQL and Objects
Ch. 24. The Future of SQL
Ch. 25. Database Updates and Installation: SQL Server 2000, Yukon, IBM DB2, MySQL & Sybase
Part VII: Appendices
A. The Sample Database
B. Database Vendor Profiles
C. Company and Product List
D. SQL Syntax Reference
E. SQL Call Level Interface
F. SQL Information Schema Standard
G. About the CD-ROM

L'auteur - James R. Groff

James R. Groff

is currently CEO of Times Ten Performance Software, developer of an ultra-high-performance main-memory SQL database for communications and Internet applications.

L'auteur - Paul N. Weinberg

Paul N. Weinberg

is Vice President of A2i, Inc., developer of a database-driven, cross media catalog publishing system that supports printed and electronic output from a single data source.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Mc Graw Hill
Auteur(s)	James R. Groff, Paul N. Weinberg
Parution	10/09/2002
Édition	2^eme édition
Nb. de pages	1076
Format	18,7 x 23,2
Couverture	Broché
Poids	1780g
Intérieur	Noir et Blanc
EAN13	9780072225594
ISBN13	978-0-07-222559-4