MySQL Crash Course

This title is out of date, and has been replaced byMySQL Crash Course (2nd Edition).

MySQL has become one of the most popular database management systems in the world. From small development projects to some of the best known and most prestigious sites on the Web, MySQL has proven itself to be a solid, reliable, fast, and trusted solution to all sorts of data storage needs.

This book is based on my best-selling Sams Teach Yourself SQL in 10 Minutes. That book has become one of the most used SQL tutorials in the world, with an emphasis on teaching what you really need to know, methodically, systematically, and simply. But as popular and as successful as that book it, it does have some limitations:

And that is where this book comes in. MySQL Crash Course builds on the proven tutorials and structure of Sams Teach Yourself SQL in Ten Minutes, without getting bogged down with anything but MySQL. Starting with simple data retrieval and working on to more complex topics including the use of joins, subqueries, regular expression and full text based searches, stored procedures, cursors, triggers, table constraints, and much more. You’ll learn what you need to know methodically, systematically, and simply – in 30 highly focused lessons designed to make you immediately and effortlessly productive.

Is this book right for you? This is a beginner-intermediate book, and is not intended for SQL or MySQL experts. This book is for you if:

If you want to invest minimal time (and cost) for a crash course on one of the most important DBMSs out there, then this book is indeed for you.

Note: This title covers MySQL 4.x and 5, and several chapters are only applicable to MySQL 5 and are noted as such in the text).