Practical SQL

CONTENTS IN DETAIL

FOREWORD by Sarah Frostenson

ACKNOWLEDGMENTS

INTRODUCTION

What Is SQL?

Why Use SQL?

About This Book

Using the Book’s Code Examples

Using PostgreSQL

Installing PostgreSQL

Working with pgAdmin

Alternatives to pgAdmin

Wrapping Up

1CREATING YOUR FIRST DATABASE AND TABLE

Creating a Database

Executing SQL in pgAdmin

Connecting to the Analysis Database

Creating a Table

The CREATE TABLE Statement

Making the teachers Table

Inserting Rows into a Table

The INSERT Statement

Viewing the Data

When Code Goes Bad

Formatting SQL for Readability

Wrapping Up

Try It Yourself

2BEGINNING DATA EXPLORATION WITH SELECT

Basic SELECT Syntax

Querying a Subset of Columns

Using DISTINCT to Find Unique Values

Sorting Data with ORDER BY

Filtering Rows with ...