MySQL Crash Course

by Rick Silva

December 2022, 304 pp.

ISBN-13:

9781718503007

This complete guide to all things MySQL takes you from the absolute basics of creating a table to the complexities of managing an entire database. You'll learn to build efficient databases through interesting examples, exercises, and three hands-on projects through which you'll create databases for weather, voter, and salary data.

The book leads beginners like you through all of MySQL’s intricacies, without the technical jargon. It’s designed to help you build confidence in creating simple databases and tables before learning more advanced concepts, including how to update and delete data, work with multiple tables, and avoid common mishaps. By the end of the book, you'll be a database management pro, who knows how to carry out comprehensive data projects with ease!

Author Bio

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, NC 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.

Table of contents

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.