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 Types
Chapter 5: Joining Database Tables
Chapter 6: Complex Joins with Multiple Tables
Chapter 7: Comparing Values
Chapter 8: Calling Built-in MySQL Functions
Part III: Database Objects
Chapter 9: Inserting, Updating, and Deleting Data
Chapter 10: Creating Views and Materialized 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: 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
Appendix A: List of Built-in Functions
The chapters in red are included in this Early Access PDF.