MySQL Crash Course
Programming
Book Details
Book Title
MySQL Crash Course: A Hands-on Introduction to Database Development
Author
Rick Silva
Publisher
No Starch Press
Publication Date
2023
ISBN
9781718503007
Number of Pages
352
Language
English
Format
File Size
3.11MB
Subject
Databases
Table of Contents
- Contents
- PRAISE FOR MySQL Crash Course
- Title Page
- Copyright
- Dedication
- About the Author
- Acknowledgments
- Introduction
- About This Book
- Who Is This Book For?
- SQL in MySQL vs. SQL in Other Database Systems
- Using the Online Resources
- 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. 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