Books & Videos

Table of Contents

  1. Chapter 1 A Little Background

    1. Introduction to Databases

    2. What Is SQL?

    3. What Is MySQL?

    4. What's in Store

  2. Chapter 2 Creating and Populating a Database

    1. Creating a MySQL Database

    2. Using the mysql Command-Line Tool

    3. MySQL Data Types

    4. Table Creation

    5. Populating and Modifying Tables

    6. When Good Statements Go Bad

    7. The Bank Schema

  3. Chapter 3 Query Primer

    1. Query Mechanics

    2. Query Clauses

    3. The select Clause

    4. The from Clause

    5. The where Clause

    6. The group by and having Clauses

    7. The order by Clause

    8. Exercises

  4. Chapter 4 Filtering

    1. Condition Evaluation

    2. Building a Condition

    3. Condition Types

    4. NULL: That Four-Letter Word

    5. Exercises

  5. Chapter 5 Querying Multiple Tables

    1. What Is a Join?

    2. Joining Three or More Tables

    3. Self-Joins

    4. Equi-Joins Versus Non-Equi-Joins

    5. Join Conditions Versus Filter Conditions

    6. Exercises

  6. Chapter 6 Working with Sets

    1. Set Theory Primer

    2. Set Theory in Practice

    3. Set Operators

    4. Set Operation Rules

    5. Exercises

  7. Chapter 7 Data Generation, Conversion, and Manipulation

    1. Working with String Data

    2. Working with Numeric Data

    3. Working with Temporal Data

    4. Conversion Functions

    5. Exercises

  8. Chapter 8 Grouping and Aggregates

    1. Grouping Concepts

    2. Aggregate Functions

    3. Generating Groups

    4. Group Filter Conditions

    5. Exercises

    6. 8-4 (Extra Credit)

  9. Chapter 9 Subqueries

    1. What Is a Subquery?

    2. Subquery Types

    3. Noncorrelated Subqueries

    4. Correlated Subqueries

    5. When to Use Subqueries

    6. Subquery Wrap-up

    7. Exercises

  10. Chapter 10 Joins Revisited

    1. Outer Joins

    2. Cross Joins

    3. Natural Joins

    4. Exercises

  11. Chapter 11 Conditional Logic

    1. What Is Conditional Logic?

    2. The Case Expression

    3. Case Expression Examples

    4. Exercises

  12. Chapter 12 Transactions

    1. Multiuser Databases

    2. What Is a Transaction?

  13. Chapter 13 Indexes and Constraints

    1. Indexes

    2. Constraints

  1. Appendix A ER Diagram for Example Database

  2. Appendix B MySQL Extensions to the SQL Language

    1. Select Extensions

    2. Combination Insert/Update Statements

    3. Ordered Updates and Deletes

    4. Multitable Updates and Deletes

  3. Appendix C Solutions to Exercises

    1. Chapter 3

    2. Chapter 4

    3. Chapter 5

    4. Chapter 6

    5. Chapter 7

    6. Chapter 8

    7. 8-4 (Extra Credit)

    8. Chapter 9

    9. Chapter 10

    10. Chapter 11

  4. Appendix D Further Resources

    1. Advanced SQL

    2. Database Programming

    3. Database Design

    4. Database Tuning

    5. Database Administration

    6. Report Generation

  5. Colophon