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. Test Your Knowledge

  4. Chapter 4 Filtering

    1. Condition Evaluation

    2. Building a Condition

    3. Condition Types

    4. Null: That Four-Letter Word

    5. Test Your Knowledge

  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. Test Your Knowledge

  6. Chapter 6 Working with Sets

    1. Set Theory Primer

    2. Set Theory in Practice

    3. Set Operators

    4. Set Operation Rules

    5. Test Your Knowledge

  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. Test Your Knowledge

  8. Chapter 8 Grouping and Aggregates

    1. Grouping Concepts

    2. Aggregate Functions

    3. Generating Groups

    4. Group Filter Conditions

    5. Test Your Knowledge

  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. Test Your Knowledge

  10. Chapter 10 Joins Revisited

    1. Outer Joins

    2. Cross Joins

    3. Natural Joins

    4. Test Your Knowledge

  11. Chapter 11 Conditional Logic

    1. What Is Conditional Logic?

    2. The Case Expression

    3. Case Expression Examples

    4. Test Your Knowledge

  12. Chapter 12 Transactions

    1. Multiuser Databases

    2. What Is a Transaction?

    3. Test Your Knowledge

  13. Chapter 13 Indexes and Constraints

    1. Indexes

    2. Constraints

    3. Test Your Knowledge

  14. Chapter 14 Views

    1. What Are Views?

    2. Why Use Views?

    3. Updatable Views

    4. Test Your Knowledge

  15. Chapter 15 Metadata

    1. Data About Data

    2. Information_Schema

    3. Working with Metadata

    4. Test Your Knowledge

  1. Appendix ER Diagram for Example Database

  2. Appendix MySQL Extensions to the SQL Language

    1. Extensions to the select Statement

    2. Combination Insert/Update Statements

    3. Ordered Updates and Deletes

    4. Multitable Updates and Deletes

  3. Appendix Solutions to Exercises

    1. Chapter 3

    2. Chapter 4

    3. Chapter 5

    4. Chapter 6

    5. Chapter 7

    6. Chapter 8

    7. Chapter 9

    8. Chapter 10

    9. Chapter 11

    10. Chapter 12

    11. Chapter 13

    12. Chapter 14

    13. Chapter 15

  4. Colophon