Relational databases have become the mainstream of database systems. Currently widely used database software is based on the relational model. The full name of SQL is Structured Query Language (Structured Query Language), which is the most commonly used language in relational databases. SQL can manage not only the data in the database but also the relational database itself. SQL databases can also be accessed directly through interactive client applications. This book starts with the basic knowledge of SQL and combines popular database software (SQL Server and Oracle) to describe all aspects of data operation and system management.
Features of this book: Comprehensive content, clear structure, and easy querying. This book follows the elements of SQL statements and explains the SQL language in the order of data definition, data query, data manipulation, data control, transaction control, and programmed SQL. It is comprehensive in content.
In this book, most SQL statements are explained using the sequential structure of "grammar, description, examples, example code, and running results" to facilitate readers' learning and quick reference.
Rich in examples and closely integrated with practical applications, this book includes a total of 317 large and small examples (see code directory), allowing readers to master the usage while learning the principles of SQL language.
This book also takes into account the implementation of SQL statements in various database products. For statements that have little difference between SQL Server and Oracle, this book only introduces their implementation process in SQL Server with examples. For statements that are quite different between SQL Server and Oracle, this book introduces their implementation in SQL Server with examples. and implemented in Oracle.
Expand
