Who Should Read This Book?
SQL in a Nutshell, Third Edition, benefits several groups of users. It will be useful for programmers who require a concise and handy SQL reference tool; for developers who need to migrate from one SQL dialect to another; and for database administrators (DBAs) who need to both execute a myriad of SQL statements to keep their enterprise databases up and running, and create and manage objects such as tables, indexes, and views.
This book is a reference work, not a tutorial. The writing is not expository. For example, we won’t explain the concept of an elementary loop. Experienced developers already know such things—you want the meat. So we will explain, for example, the detailed workings of an ANSI standard cursor, how it works on each of the database platforms we cover, the special capabilities of cursors on each database platform, and the various pitfalls of cursors and how to get around them.
While we don’t intend for SQL in a Nutshell, Third Edition, to be a tutorial on SQL or a handbook for database design, we do provide some brief coverage of introductory topics, and we hope you’ll find that helpful. Chapter 1 and Chapter 2 provide a concise introduction to SQL, covering the general origins, essential structure, and basic operation of the language. If you’re new to SQL, these chapters will help you get started.