MySQL 9 Essentials

ebook Deploying and Managing MySQL 9 Databases

By Smyth

cover image of MySQL 9 Essentials

Sign up to save your library

With an OverDrive account, you can save your favorite libraries for at-a-glance information about availability. Find out more about OverDrive accounts.

   Not today

Find this title in Libby, the library reading app by OverDrive.

Download Libby on the App Store Download Libby on Google Play

Search for a digital library with this title

Title found at these libraries:

Loading...

MySQL 9 Essentials is a concise guide to MySQL 9 database management, covering fundamental concepts, techniques, and best practices.

The book begins by installing and configuring MySQL on Windows, macOS, and Linux before outlining the fundamentals of relational database management systems.

Beyond the fundamentals, this book covers advanced MySQL features such as views, indexing for performance optimization, automation with triggers and events, and database modeling with MySQL Workbench.

In addition to covering the command-line tools provided with MySQL, several chapters introduce the phpMyAdmin and MySQL Workbench tools, which offer user-friendly graphical interfaces for database management.

The book explains each topic in detail and includes practical examples that provide hands-on experience. Each chapter also contains a quick-reference summary highlighting key points for easy review and access to an online knowledge test quiz to assess and reinforce your understanding.

In addition, this book features in-depth chapters, 28 online quizzes, and access to downloadable project code, ensuring you gain both theoretical knowledge and hands-on experience.

​​​​​​​By the end of this book, you will have the confidence to build, manage, and optimize MySQL databases effectively, equipping you with the skills necessary to handle real-world database challenges.

MySQL 9 Essentials