
- English
- ePUB (mobile friendly)
- Available on iOS & Android
About this book
MariaDB 11 Essentials provides a concise guide to MariaDB, one of the most highly regarded database management systems in use today. It covers 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.
The essentials of relational database management are covered, including table design, SQL queries, joins, and transaction handling.
Beyond the fundamentals, this book covers advanced MariaDB features, such as indexing for performance optimization, automation with triggers and events, and creating and restoring database backups.
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.
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 design, build, and manage MariaDB databases.
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
Table of contents
- 1. Start Here
- 2. The Basics of Databases
- 3. Installing and Launching MariaDB on Linux
- 4. Installing and Launching MariaDB Server on Windows
- 5. The MariaDB Client
- 6. MariaDB Users, Privileges, and Security
- 7. Creating Databases and Tables
- 8. Inserting Data into Database Tables
- 9. Updating and Managing MariaDB Tables
- 10. Updating and Deleting Table Data
- 11. Retrieving Data from MariaDB Databases
- 12. Filtering Result Sets with the WHERE Clause
- 13. Filtering Results with Logical Operators
- 14. Wildcard and Regular Expression Matching
- 15. Understanding Joins and Unions
- 16. An Introduction to MariaDB Views
- 17. Understanding MariaDB Indexes
- 18. MariaDB Stored Routines
- 19. Working with Control Flow
- 20. Error Handling in MariaDB
- 21. An Introduction to MariaDB Virtual Columns
- 22. Automation with MariaDB Triggers
- 23. Scheduling Tasks with MariaDB Events
- 24. Configuring MariaDB using the my.cnf File
- 25. An Introduction to mariadb-admin
- 26. Backing up and Restoring Databases
- 27. Installing MySQL Workbench
- 28. MySQL Workbench Administration
- 29. MySQL Workbench Queries and Models
- 30. Database Administration with phpMyAdmin
- 31. A Guided Tour of phpMyAdmin
- Index