Description

MariaDB 11 Essentials provides a concise guide to MariaDB, covering fundamental concepts, advanced techniques, and best practices.

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

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

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

What You’ll Learn:

✅ Install and configure MariaDB on Windows and Linux.

✅ Use MariaDB client tools and graphical interfaces like MySQL Workbench and phpMyAdmin.

✅ Design efficient database schemas and relationships.

✅ Manage databases using the Structured Query Language (SQL).

✅ Optimize database performance using indexing and query optimization techniques.

✅ Automate repetitive database tasks using triggers and scheduled events.

✅ Secure MariaDB databases by managing user privileges and access controls.

This book explains each topic in detail and includes practical examples that provide hands-on experience. The chapters also contain quick-reference summaries highlighting key points for easy review.

By the end of this book, you will have the confidence to build and manage MariaDB databases.

ISBN: 978-1-965764-16-9
Format: PDF (ePub available on request)
Page count: 270
Page Size: 7.5in x 9.25in
Publication date: April 9, 2025