MySQL Crash Course

Rick Silva is a software developer with decades of database experience. Silva has worked at Harvard Business School, Zipcar, and various financial services companies. A Boston native and a Boston College alum, he now lives in the Raleigh, North Carolina area with his wife Patti and his dog Dixie. When he's not joining database tables, he's playing banjo at a local bluegrass jam.

Acknowledgments
Introduction
PART I: GETTING STARTED
Chapter 1: Installing MySQL and Tools
Chapter 2: Creating Databases and Tables
PART II: SELECTING DATA FROM A MYSQL DATABASE
Chapter 3: Introduction to SQL
Chapter 4: MySQL Data TypesC
hapter 5: Joining Database Tables
Chapter 6: Performing Complex Joins with Multiple Tables
Chapter 7: Comparing Values
Chapter 8: Calling Built-in MySQL Functions
Chapter 9: Inserting, Updating, and Deleting Data
PART III: DATABASE OBJECTS
Chapter 10: Creating Views
Chapter 11: Creating Functions and Procedures
Chapter 12: Creating Triggers
Chapter 13: Creating Events
PART IV: ADVANCED TOPICS
Chapter 14: Tips and Tricks
Chapter 15: Calling MySQL from Programming Languages
PART V: PROJECTS
Chapter 16: Building a Weather Database
Chapter 17: Tracking Changes to Voter Data with Triggers
Chapter 18: Protecting Salary Data with Views
Afterword
Index