Sams Teach Yourself MySQL in 10 Minutes - page 1
- Sams Teach Yourself MySQL in 10 Minutes
- Sams Teach Yourself MySQL in 10 Minutes
- Table of Contents
- Copyright
- About the Author
- Introduction
- Part 1: MySQL Foundations
- Lesson 1. Introducing MySQL
- Database Basics
- MySQL Components
- Summary
- Lesson 2. Using MySQL
- The mysql Client
- Executing SQL Statements
- Creating the Sample Tables
- Summary
- Part 2: Getting Started with SQL
- Lesson 3. Retrieving Data
- The SELECT Statement
- Summary
- Lesson 4. Filtering and Sorting Data
- The WHERE Clause
- The ORDER BY Clause
- Summary
- Lesson 5. Advanced Data Filtering
- Combining WHERE Clauses
- Limiting the Number of Rows Returned
- Summary
- Lesson 6. Numeric Operators and Functions
- Numeric Operators
- Numeric Functions
- Conditional Functions
- Summary
- Lesson 7. String Operators and Functions
- Using Operators with Strings
- String Functions
- Summary
- Lesson 8. Date Operators and Functions
- Date Operators
- Date Functions
- Summary
- Lesson 9. Summarizing Data
- Aggregate Functions
- Grouping Data
- Filtering Summary Data
- Summary
- Part 3: Advance SQL
- Lesson 10. Using Subqueries
- Understanding Subqueries
- Summary
- Lesson 11. Joining Tables
- Understanding Joins
- Summary
- Lesson 12. Creating Advanced Joins
- The JOIN Keyword
- Inner Joins
- Joining Multiple Tables
- Cross Joins
- Self-Joins
- Natural Joins
- Outer Joins
- Summary
- Lesson 13. Combining Queries
- Understanding Combined Queries
- Other Compound Operations
- Using Temporary Tables
- Summary
- Part 4: Creating a New Database
- Lesson 14. Creating and Modifying Tables
- Creating a New Database
- Character Sets and Collations
- Altering a Database
- Dropping a Database
- Managing Tables
- Temporary Tables
- Using a Query to Create a Table
- Storage Engines
- Altering Tables
- Dropping Tables
- Summary
