Skip to main content

You are here

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.

Sams Teach Yourself MySQL in 10 Minutes

Rating 4/5

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

Book: 

Premium Drupal Themes by Adaptivethemes