MySQL Crash Course by Rick Silva is a course in using MySQL for beginner and intermediate database developers.
The book is available at No Starch Press and in bookstores everywhere.
The book introduces you to the basics of MySQL development. MySQL development techniques are explained with an emphasis on using Structured Query Language (SQL). Learn to use and create MySQL databases, tables, functions, procedures, views, and triggers.
Introduction
Chapter 1 – Installing MySQL and Tools
Chapter 2 – Creating Databases and Tables
Chapter 3 – Introduction to SQL
Chapter 4 – MySQL Data Types
Chapter 5 – Joining Database Tables
Chapter 6 – Complex Joins with Multiple Tables
Chapter 7 – Comparing Values
Chapter 8 – Calling Built-In MySQL Functions
Chapter 9 – Inserting, Updating, and Deleting Data
Chapter 10 – Creating Views
Chapter 11 – Creating Functions and Procedures
Chapter 12 – Creating Triggers
Chapter 13 – Creating Events
Chapter 14 – Tips and Tricks
Chapter 15 – Calling MySQL from Programming Languages
Chapter 16 – Creating a Weather Database and Loading Data
Chapter 17 – Using Triggers to Track Changes to Voter Data
Chapter 18 – Using Views to Hide Salary Data
Afterword
Here you will find one SQL script for each chapter called chapter_X.sql (where X is the chapter number). The script contains:
- Any set up commands that need to be run before the examples and exercises.
- The example SQL statements used in each chapter of the book.
- Answers to the "Try It Yourself" exercises in each chapter of the book.
Copy and paste the commands you are interested in from the script and run them against your own database using your favorite MySQL graphical tool (like MySQL Workbench).
Happy MySQLing!
Rick Silva