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

Who Is This Book For?

This book is a go-to resource for anyone new to SQL or just starting with MySQL and aiming to hit the ground running. It's tailored for those who:

• You are new to SQL.
• You are just getting started with MySQL and want to hit the ground running.
• You want to quickly learn how to get the most out of MySQL.
• You want to learn how to use MySQL in your own application development.
• You want to be productive quickly and easily using MySQL without having to call someone for help.

The book's focused, systematic approach to learning makes it perfect for quickly mastering MySQL, ideal for beginners and experienced SQL users alike.

Table of Contents

1 Understanding SQL

2 Introducing MySQL

3 Working with MySQL

4 Retrieving Data

5 Sorting Retrieved Data

6 Filtering Data

7 Advanced Data Filtering

8 Using Wildcard Filtering

9 Searching Using Regular Expressions

10 Creating Calculated Fields

11 Using Data Manipulation Functions

12 Summarizing Data

13 Grouping Data

14 Working with Subqueries

15 Joining Tables

16 Creating Advanced Joins

17 Combining Queries

18 Full-Text Searching

19 Inserting Data

20 Updating and Deleting Data

21 Creating and Manipulating Tables

22 Using Views

23 Working with Stored Procedures

24 Using Cursors

25 Using Triggers

26 Managing Transaction Processing

27 Globalization and Localization

28 Managing Security

29 Database Maintenance

30 Improving Performance

A: Getting Started with MySQL

B: The Example Tables

C: MySQL Statement Syntax

D: MySQL Datatypes

E: MySQL Reserved Words

About the Author

Ben Forta is Adobe's Senior Director of Education Initiatives and has more than three decades of experience in the computer industry―in product development, support, training, and product marketing. He is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (as well as spinoff titles like this one and versions on SQL Server T-SQL, Oracle PL/SQL, and MariaDB), Learning Regular Expressions, and Captain Code, which teaches Python to younger coders (and those young at heart), Java, Windows, and more. He has extensive experience in database design and development, has implemented databases for several highly successful commercial software programs and websites, and is a frequent lecturer and columnist on application development and Internet technologies. Ben lives in Oak Park, Michigan, with his wife, Dr. Marcy Forta, and their children. He welcomes your email at ben@forta.com and invites you to visit his website at http://forta.com.