tailieunhanh - SQL: The Complete Reference by James R. Groff and Paul N. Weinberg

SQL: The Complete Reference provides an in-depth discussion of SQL fundamentals, modern SQL products, and SQL's role in trends such as data warehousing, "thin-client" architectures, and Internet-based e-commerce. This book is your one-stop resource for all you need to know about SQL. It will help you: Learn the key concepts and latest developments in relational database technology. Master the industry-standard SQL language for managing database information. Understand the differences among all the leading brands of DBMS systems | SBORNEfr SQL The Complete Reference by James R. Groff and Paul N. Weinberg ISBN 0072118458 Osborne McGraw-Hill 1999 994 pages An encyclopedic reference guide to the SQL database language for both technical and non-technical readers. -Table of Contents Colleague Comments -Back Cover Synopsis by Dean Andrews What is SQL and where did it come from How do the SQL tools vary across database applications from different vendors How will SQL change in the future You ll find the answers to all these questions and many more in SQL The Complete Reference. Much more than just a listing of SQL commands and their parameters this encyclopedic reference guide explains the concepts and constructs of SQL programming such that non-technical readers will understand them and technical readers won t be bored. Table of Contents SQL - The Complete Reference - 4 Preface - 6 Part I An Overview of SQL Chapter 1 - Introduction - 8 Chapter 2 - A Quick Tour of SQL - 15 Chapter 3 - SQL In Perspective - 22 Chapter 4 - Relational Databases - 38 Part II Retrieving Data Chapter 5 - SQL Basics - 51 Chapter 6 - Simple Queries - 69 Chapter 7 - Multi-Table Queries Joins - 101 Chapter 8 - Summary Queries - 136 Chapter 9 - Subqueries and Query Expressions - 158 Part III Updating Data Chapter 10 - Database Updates - 196 Chapter 11 - Data Integrity - 211 Chapter 12 - Transaction Processing - 236 Part IV Database Structure Chapter 13 - Creating a Database - 256 Chapter 14 - Views - 290 Chapter 15 - SQL Security - 304 - 2 - Chapter 16 - The System Catalog - 321 Part V Programming with SQL Chapter 17 - Embedded SQL - 344 Chapter 18 - Dynamic SQL - 387 Chapter 19 - SQL APIs - 430 Part VI SQL Today and Tomorrow Chapter 20 - Database Processing and Stored Procedures - 435 Chapter 21 - SQL and Data Warehousing - 535 Chapter 22 - SQL Networking and Distributed Databases - 546 Chapter 23 - SQL and Objects - 575 Chapter 24 - The Future of SQL - 602 Part VII Appendices Appendix A - The Sample Database - 612 Appendix