文档介绍：Sams Teach Yourself SQL in 21 Days, Fourth Edition
By Ryan K. Stephens, Ronald R. Plew
ISBN: 0-672-32451-2
Pages: 864
Table of
•
Contents
• Index
Copyright
What's New in the Latest Edition
About the Authors
Contributing Authors
Acknowledgments
We Want to Hear from You!
Introduction
Who Should Read This Book?
Overview
Conventions Used in This Book
Using MySQL for Hands-on Exercises
Week 1. At a Glance
Day 1. Getting Started with SQL
A Brief History of SQL
A Brief History of Databases
Today's Database Landscape
A Cross-Product Language
An Overview of SQL
Popular SQL Implementations
Open Database Connectivity
Embedding SQL in Application Programming
Summary
Q&A
Workshop
Day 2. Introducing the Query
Exploring SQL's Background
Learning Basic Query Syntax
The Building Blocks of Data Retrieval: SELECT and FROM
Applying Query Concepts
Writing Your First Query
Selecting Distinct Values
Summary
Q&A
Workshop
Day 3. Expressions, Conditions, and Operators
Working with Query Expressions
Placing Conditions on Queries
Learning How to Use Operators
Summary
Q&A
Workshop
Day 4. Molding Data with Built-in Functions
Using Aggregate Functions to Summarize Data
Using Functions to Format Date and Time Values
Using Functions for Arithmetic Operations
Using Functions to Modify the Appearance of Character Values
Conversion Functions
Miscellaneous Functions
Supplemental Examples of MySQL Character Functions
Supplemental Examples of MySQL Date Functions
Summary
Q&A
Workshop
Day 5. Clauses in SQL Queries
Specifying Criteria with the WHERE Clause
Order from Chaos: The ORDER BY Clause
The GROUP BY Clause
The HAVING Clause
Combining Clauses
Summary
Q&A
Workshop
Day 6. Joining Tables
Joining Multiple Tables in a Single SELECT Statement
Joining Tables Based on Equality
Joining Tables Based on Nonequality
OUTER JOINs Versus INNER JOINs
Joining a Table to