Sams Teach Yourself SQL™ in 10 Minutes, Third Edition

Contents

Introduction

1. Understanding SQL

Database Basics

What Is SQL?

Try It Yourself

Summary

2. Retrieving Data

The SELECT Statement

Retrieving Individual Columns

Retrieving Multiple Columns

Retrieving All Columns

Summary

3. Sorting Retrieved Data

Sorting Data

Sorting by Multiple Columns

Sorting by Column Position

Specifying Sort Direction

Summary

4. Filtering Data

Using the WHERE Clause

The WHERE Clause Operators

Summary

5. Advanced Data Filtering

Combining WHERE Clauses

Using the IN Operator

Using the NOT Operator

Summary

6. Using Wildcard Filtering

Using the LIKE Operator

Tips for Using Wildcards

Summary

7. Creating Calculated Fields

Understanding Calculated Fields

Concatenating Fields

Performing Mathematical Calculations

Summary

8. Using ...