By Alexis Leon & Mathews Leon, Tata McGraw-Hill, 1999

Structured Query Language (SQL) is an essential skill for every software professional involved in designing, developing, or maintaining applications that rely on databases. It is equally indispensable for users of major Relational Database Management Systems such as DB2, Oracle, Sybase, MS‑SQL Server, and MS‑Access. With the rapid growth of the RDBMS industry, a solid working knowledge of SQL has become a fundamental requirement for all IT professionals.

This book provides a clear, comprehensive, and authoritative explanation of the official SQL standard. SQL has been adopted internationally by ISO, ANSI, FIPS, and numerous other bodies, and forms the foundation of hundreds of database products. As such, SQL remains one of the most important technologies in the database world.

Focusing on the SQL:1992 standard—commonly known as SQL/92 or SQL2—this book covers the major enhancements introduced in this version. While commercial database systems often implement their own dialects, this book concentrates on the official standard, making it relevant to anyone interested in SQL’s core principles, usage, and implementation.

Designed both as a reference and a tutorial, the book includes formal definitions, practical examples, and numerous exercises. It assumes no prior knowledge: readers are introduced to fundamental concepts such as data, database management, relational models, and data modeling before progressing to SQL itself. A strong grounding in these basics ensures effective understanding and application of SQL.

The book is organized into sections covering:

• Introduction to Database Concepts
• Introduction to SQL
• Data Definition
• Data Manipulation
• Data Control
• Advanced SQL Topics
• Performance Tuning

A dedicated Command/Quick Reference section provides an alphabetical listing of SQL commands with syntax and concise explanations, cross‑referenced to detailed chapters. A glossary of SQL and database terminology enables quick look‑ups, while a Frequently Asked Questions (FAQ) section helps readers test and reinforce their understanding.

The book is accompanied by a companion floppy disk containing objective‑type questions—multiple choice, true/false, and fill‑in‑the‑blank. Readers can take randomized tests, practice chapter‑wise, choose timed or untimed modes, and review their performance to identify areas for improvement.

Self‑contained and accessible, this book is ideal for anyone who wants to learn SQL—beginners, students, programmers, database administrators, and seasoned professionals alike. It serves as a reference guide, a course textbook, a refresher, and a practical tool for interview preparation. With its extensive examples, exercises, FAQs, and companion quiz software, this book is an invaluable resource for anyone seeking to master SQL and succeed in the database field.