Sams Teach Yourself MySQL

Table of contents

1. Copyright
2. About the Author
3. Introduction
4. MySQL Foundations
   1. Introducing MySQL
      1. Database Basics
      2. MySQL Components
      3. Summary
   2. Using MySQL
      1. The mysql Client
      2. Executing SQL Statements
      3. Creating the Sample Tables
      4. Summary
5. Getting Started with SQL
   1. Retrieving Data
      1. The SELECT Statement
      2. Summary
   2. Filtering and Sorting Data
      1. The WHERE Clause
      2. The ORDER BY Clause
      3. Summary
   3. Advanced Data Filtering
      1. Combining WHERE Clauses
      2. Limiting the Number of Rows Returned
      3. Summary
   4. Numeric Operators and Functions
      1. Numeric Operators
      2. Numeric Functions
      3. Conditional Functions
      4. Summary
   5. String Operators and Functions
      1. Using Operators with Strings
      2. String Functions
      3. Summary
   6. Date Operators and Functions
      1. Date Operators
      2. Date Functions
      3. Summary
   7. Summarizing Data
      1. Aggregate Functions
      2. Grouping Data
      3. Filtering Summary Data
      4. Summary
6. Advance SQL
   1. Using Subqueries
      1. Understanding Subqueries
      2. Summary
   2. Joining Tables
      1. Understanding Joins
      2. Summary
   3. Creating Advanced Joins
      1. The JOIN Keyword
      2. Inner Joins
      3. Joining Multiple Tables
      4. Cross Joins
      5. Self-Joins
      6. Natural Joins
      7. Outer Joins
      8. Summary
   4. Combining Queries
      1. Understanding Combined Queries
      2. Other Compound Operations
      3. Using Temporary Tables
      4. Summary
7. Creating a New Database
   1. Creating and Modifying Tables
      1. Creating a New Database
      2. Character Sets and Collations
      3. Altering a Database
      4. Dropping a Database
      5. Managing Tables
      6. Temporary Tables
      7. Using a Query to Create a Table
      8. Storage Engines
      9. Altering Tables
      10. Dropping Tables
      11. Summary
   2. Working with Data
      1. The INSERT Statement
      2. The DELETE Statement
      3. The UPDATE Statement
      4. The REPLACE Statement
      5. Loading Data from a File
      6. Why Use Transactions?
      7. Transactions in MySQL
      8. Autocommit Mode
      9. Rolling Back a Transaction
      10. Summary
   3. Designing Your Database
      1. Relationships
      2. Normalization
      3. Naming Tables and Columns
      4. Data Types
      5. CHAR and VARCHAR
      6. Summary
   4. Keys and Indexes
      1. Understanding Keys and Indexes
      2. Using Indexes in MySQL
      3. Summary
   5. Managing User Access
      1. Understanding MySQL Authentication
      2. User Management
      3. Using Wildcards
      4. Summary
8. New Features in MySQL 5.0
   1. Views
      1. Understanding Views
      2. Summary
   2. Stored Routines
      1. Understanding Stored Routines
      2. Summary
   3. Triggers
      1. Understanding Triggers
      2. Summary
9. Interfacing with MySQL
   1. Using ODBC
      1. Understanding ODBC
      2. Connecting to MyODBC
      3. Summary
   2. Using MySQL with C
      1. The C Language API
      2. Summary
   3. Using MySQL with PHP
      1. Using the mysql API
      2. Using the mysqli API
      3. Summary
   4. Using MySQL with Perl
      1. The Perl DBI
      2. Using the MySQL DBD
      3. Summary
10. Appendix
    1. Installing MySQL
       1. Obtaining MySQL
       2. Linux/UNIX Installation
       3. Windows Installation
    2. Sample Table Scripts
11. Index