MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. This book will teach you all you need to know to be immediately productive with the latest version of MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible.
Learn How To
Retrieve and Sort Data
Filter Data Using Comparisons, Regular Expressions, Full Text Search, and Much More
Join Relational Data
Create and Alter Tables
Insert, Update, and Delete Data
Leverage the Power of Stored Procedures and Triggers
Use Views and Cursors
Manage Transactional Processing
Create User Accounts and Manage Security via Access Control