Sams Teach Yourself MySQL in 10 Minutes

This primer book has practically all the content necessary in order to be fluent in MySQL and SQL in general at a medium to advance level knowledge. The examples are short and easy to understand. (After all the author’s goal was for each chapter to take 10 minutes to read). The chapters are perfectly structured, as you progress throughout the book, the chapters beautifully build up on top of content that you’ve already read (and hopefully learned). This book will teach you how to use MySQL, it doesn’t go into administration or any advance database optimization features of this fantastic relational database management system.

Published in 2006, so it obviously it has some information that is not quite up to date, but overall I think 90% of the content covered in this book is still perfectly valid. The only chapters that I didn’t bothered reading were the ones of using MySQL with different programming languages. This book is a perfect complementary MySQL and SQL reference book. The only drawback is the small outdated content, which hopefully in the near feature will have an updated version published.

Rating 4/5

Sams Teach Yourself MySQL in 10 Minutes

• Chapter 1: Introducing MySQL
• Chapter 2: Using MySQL
• Chapter 3: Retrieving Data
• Chapter 4: Filtering and Sorting Data
• Chapter 5: Advanced Data Filtering
• Chapter 6: Numeric Operators and Functions
• Chapter 7: String Operators and Functions
• Chapter 8: Date Operators an Functions
• Chapter 9: Summarizing Data
• Chapter 10: Using Subqueries
• Chapter 11: Joining Tables
• Chapter 12: Creating Advanced Joins
• Chapter 13: Combining Queries
• Chapter 14: Creating and Modifying Tables
• Chapter 15: Working with Data
• Chapter 16: Designing Your Database
• Chapter 17: Keys and Indexes
• Chapter 18: Managing User Access
• Chapter 19: Views
• Chapter 20: Stored Routines
• Chapter 21: Triggers
• Chapter 22: Using ODBC
• Chapter 23: Using MySQL with C
• Chapter 24: Using MySQL with PHP
• Chapter 25: Using MySQL with Perl

Tags: [ mysql ]

---