MySQL Crash Course

by Rick Silva

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

PDF

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