MySQL 9 Essentials
By Neil Smyth
Language: English
Category: Ebook - Computer/Internet
Categories: Computer/Internet
Uploader: vinko
Uploaded At: 2025-03-31 13:24:30
Payload Media, February 22, 2025
Description
MySQL 9 Essentials is a concise guide to mastering MySQL database administration, whether you’re a beginner or an experienced developer looking to sharpen your skills.
This book delivers a clear, practical approach to MySQL’s core concepts, best practices, and advanced features—giving you the tools to build, optimize, and manage databases.
You’ll start with step-by-step instructions to install and configure MySQL on Windows, macOS, and Linux, before diving into the foundations of relational database management. From there, you’ll explore essential MySQL features, including views, joins, stored routines, indexing for performance tuning, and automation with triggers and scheduled events.
Beyond the command line, MySQL 9 Essentials introduces user-friendly tools like phpMyAdmin and MySQL Workbench, making database management more accessible.
What You’ll Learn:
✅ Install and configure MySQL across different operating systems
✅ Work with MySQL’s command-line client and powerful graphical interfaces
✅ Design efficient, well-structured databases
✅ Write and execute SQL queries to manage and retrieve data
✅ Boost database performance with indexing and query optimization
✅ Automate repetitive tasks using triggers and scheduled events
✅ Secure your databases by managing user permissions and access controls
Each chapter contains detailed explanations, hands-on examples, and quick-reference summaries, ensuring you can apply what you’ve learned in real-world scenarios. Plus, online knowledge quizzes help reinforce key concepts along the way.
About the Author
Neil Smyth has more than 25 years of experience in the IT industry, including software development, project management, and marketing. He has a Bachelor of Science degree in Information Technology and holds several certifications, including A+, Security+, Network+, Project+, Java Associate, and Microsoft Certified Professional. Neil is also a CIW Database Design Specialist.
Neil is the co-founder and CEO of Payload Media, Inc., a technical content publishing company. He is also an author who has written several programming and system administration books under the “Essentials” range. Notable titles include Android Studio Development Essentials, Jetpack Compose Essentials, iOS App Development Essentials, and Ubuntu Essentials.
ISBN: 9781965764107
Publisher: Payload Media (February 22, 2025)
Print length: 424 pages
Number of pages (Paperback): 270