MySQL 9 Essentials

by Neil Smyth

MySQL 9 Essentials is a concise guide to MySQL 9 database administration, covering fundamental concepts, techniques, and best practices. Each topic is explained in detail, with practical examples that provide hands-on experience. The book’s modular approach makes it both a learning guide and a practical reference resource. In addition, each chapter includes quick-reference summaries highlighting key points for easy review and online knowledge quizzes to help reinforce understanding.

This work was written and produced entirely by the author. We are proud to be distributing it.

The book begins with instructions on installing and securing MySQL on Windows, macOS, and Linux before introducing the fundamentals of relational database management systems. It then explores key MySQL features such as SQL programming, views, joins, stored routines, indexing for performance optimization, and automation with triggers and events.

In addition to covering MySQL’s command-line tools, several chapters introduce phpMyAdmin and MySQL Workbench, which provide user-friendly graphical interfaces for database management.

Each chapter includes quick-reference summaries highlighting key points for easy review and online knowledge quizzes to help reinforce understanding.

• Windows 11 x86 64-bit
• macOS 64-bit ARM or x86
• Linux x86 64-bit
• Minimum of 8GB of RAM

“Source code"https://www.payloadbooks.com/product/mysql9-prag/

Errata

Releases:

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.