Practical Reference Manual, Fourth Edition SQL Using SQL Various Versions

Author: [USA] Judith S. Bowman et al.
Publisher: Tsinghua University Press
Publication Date: 2002-04-01
Features: SQL is a relational database language used for defining, querying, modifying, and controlling data in relational databases. It is widely supported by relational database management system developers. This book introduces the basics of SQL, provides practical solutions with commercial application value, and explores the different SQL versions of renowned companies in the relational database field. The book includes extended platform SQL knowledge and various practical examples written based on SQL user feedback. The main content of the book includes: detailed introduction to commands for creating databases, tables, and indexes, as well as adding, modifying, and deleting data; retrieving specific data using the SELECT command; handling NULL values in relational databases; joining tables, including self-joins and outer joins; retrieving data from multiple tables using nested queries (subqueries); creating views (virtual tables) to achieve customized data access functions; and using SQL functions. This book is suitable for all users of relational database systems.