Sams Teach Yourself MySQL in 10 Minutes By Chris Newman
Part 1: MySQL Foundations:
Lesson 1. Introducing MySQL:
Database Basics
MySQL Components
Lesson 2. Using MySQL:
The mysql Client
Executing SQL Statements
Creating the Sample Tables
Part 2: Getting Started with SQL:
Lesson 3. Retrieving Data :
The SELECT Statement
Lesson 4. Filtering and Sorting Data:
The WHERE Clause
The ORDER BY Clause
Lesson 5. Advanced Data Filtering:
Combining WHERE Clauses
Limiting the Number of Rows Returned
Lesson 6. Numeric Operators and Functions :
Numeric Operators
Numeric Functions
Conditional Functions
Lesson 7. String Operators and Functions:
Using Operators with Strings
String Functions
Lesson 8. Date Operators and Functions:
Date Operators
Date Functions
Lesson 9. Summarizing Data:
Aggregate Functions
Grouping Data
Filtering Summary Data
Part 3: Advance SQL:
Lesson 10. Using Subqueries:
Understanding Subqueries
Lesson 11. Joining Tables:
Understanding Joins
Lesson 12. Creating Advanced Joins:
The JOIN Keyword
Inner Joins
Joining Multiple Tables
Cross Joins
Self-Joins
Natural Joins
Outer Joins
Lesson 13. Combining Queries :
Understanding Combined Queries
Other Compound Operations
Using Temporary Tables
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
Lesson 15. Working with Data :
The INSERT Statement
The DELETE Statement
The UPDATE Statement
The REPLACE Statement
Loading Data from a File
Why Use Transactions?
Transactions in MySQL
Autocommit Mode
Rolling Back a Transaction
Lesson 16. Designing Your Database:
Relationships
Normalization
Naming Tables and Columns
Data Types
CHAR and VARCHAR
Lesson 17. Keys and Indexes :
Understanding Keys and Indexes
Using Indexes in MySQL
Lesson 18. Managing User Access :
Understanding MySQL Authentication
User Management
Using Wildcards
Part 5: New Features in MySQL 5.0 :
Lesson 19. Views :
Understanding Views
Lesson 20. Stored Routines:
Understanding Stored Routines
Lesson 21. Triggers:
Understanding Triggers
Using Triggers
Part 6: Interfacing with MySQL:
Lesson 22. Using ODBC:
Understanding ODBC
Connecting to MyODBC
Lesson 23. Using MySQL with C:
The C Language API
Lesson 24. Using MySQL with PHP :
Using the mysql API
Using the mysqli API
Lesson 25. Using MySQL with Perl:
The Perl DBI
Using the MySQL DBD.Download