SQL Complete Manual: Second Edition

Author: Grove
Publisher:
Publish Date: 2003-07-01
Features: Databases are a crucial supporting technology in the culture of computer networks and the cornerstone for applying human historical experience on computer networks. Today, computer networks are becoming increasingly widespread, and the concept of databases is gaining more understanding. The establishment, application, and maintenance of databases have always been the focus of industry professionals. SQL is the standard computer language for communication in relational database management systems and is currently evolving towards an object-oriented direction. This book provides a comprehensive discussion on the use and development of SQL technology. The book is divided into six parts, where Part 2 to Part 5 respectively introduce the history of SQL and changes in SQL standards, how to use SQL to retrieve and update data, how to construct database structures, and how to implement data security solutions, and describe how to use embedded SQL in the ANSI standard. Additionally, it thoroughly discusses the application of SQL in data warehouses, distributed databases, and new object-oriented technologies. Part 6 is dedicated to introducing the present state and future development of SQL. The appendices of the book not only provide a detailed description of sample databases but also introduce major international database providers along with their brief history and the characteristics of mainstream products. The accompanying CD-ROM includes trial versions of three major database products for hands-on practice. This book is suitable for a wide range of readers, including database users, data processing experts, programmers, and database administrators, as well as students studying databases and SQL programming who are seeking a primary reference book.