MySQL Crash Course - page 1
- MySQL Crash Course
- MySQL Crash Course
- Table of Contents
- Copyright
- About the Author
- Acknowledgments
- We Want to Hear from You
- Introduction
- Who Is This Book For?
- Companion Website
- Conventions Used in This Book
- Chapter 1. Understanding SQL
- Database Basics
- What Is SQL?
- Try It Yourself
- Summary
- Chapter 2. Introducing MySQL
- What Is MySQL?
- MySQL Tools
- Summary
- Chapter 3. Working with MySQL
- Making the Connection
- Selecting a Database
- Learning About Databases and Tables
- Summary
- Chapter 4. Retrieving Data
- The SELECT Statement
- Retrieving Individual Columns
- Retrieving Multiple Columns
- Retrieving All Columns
- Retrieving Distinct Rows
- Limiting Results
- Using Fully Qualified Table Names
- Summary
- Chapter 5. Sorting Retrieved Data
- Sorting Data
- Sorting by Multiple Columns
- Specifying Sort Direction
- Summary
- Chapter 6. Filtering Data
- Using the WHERE Clause
- The WHERE Clause Operators
- Summary
- Chapter 7. Advanced Data Filtering
- Combining WHERE Clauses
- Using the IN Operator
- Using the NOT Operator
- Summary
- Chapter 8. Using Wildcard Filtering
- Using the LIKE Operator
- Tips for Using Wildcards
- Summary
- Chapter 9. Searching Using Regular Expressions
- Understanding Regular Expressions
- Using MySQL Regular Expressions
- Summary
- Chapter 10. Creating Calculated Fields
- Understanding Calculated Fields
- Concatenating Fields
- Performing Mathematical Calculations
- Summary
- Chapter 11. Using Data Manipulation Functions
- Understanding Functions
- Using Functions
- Summary
- Chapter 12. Summarizing Data
- Using Aggregate Functions
- Aggregates on Distinct Values
- Combining Aggregate Functions
- Summary
- Chapter 13. Grouping Data
- Understanding Data Grouping
- Creating Groups
- Filtering Groups
- Grouping and Sorting
- SELECT Clause Ordering
- Summary
- Chapter 14. Working with Subqueries
- Understanding Subqueries
- Filtering by Subquery
