Chapter 4. SQL in a Nutshell

Introduction

In this chapter, we use examples to build up a picture of the capabilities of the SQL database language. Most SQL statements are discussed briefly. The details and all the features are described in other chapters. The intention of this chapter is to give you a feeling of what SQL looks like and what this book covers.

In the first sections, we also explain how to create the sample database. Be sure to execute the statements from these sections because almost all examples and exercises in the rest of this book are based upon this database.

Portability

Not all the statements and features described in this chapter are supported by all the SQL products. Especially in the first sections, we include some SQL statements ...

Get Introduction to SQL: Mastering the Relational Database Language, Fourth Edition/20th Anniversary Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.