MariaDB is an open-source relational database management system (RDBMS), a highly compatible drop-in replacement of MySQL.
MariaDB was developed as a software fork of MySQL in 2009 in response to Oracle’s acquisition of MySQL. MariaDB intends to remain free, open-source software under the GNU General Public License.
The MariaDB tutorial website provides you with practical knowledge and skills to master MariaDB quickly. To get the best out of the tutorials, you should be familiar with RDBMS concepts. However, it is not required.
What you’ll learn
- Interact with MariaDB including selecting, inserting, updating, and deleting data.
- Utilize views to simplify the query and improve the security.
- Leverage triggers to automate some database tasks.
- Use indexes to improve the query performance.
- Use stored procedures and functions to wrap the business logic in the database layer.
Getting Started with MariaDB
This section helps you get started with MariaDB by providing you with the easy-to-follow steps of installing and connecting to the MariaDB server.
MariaDB Basics
This MariaDB basics section helps you learn how to query data from tables, manage databases and tables.
MariaDB Views
In this tutorial, you will learn about MariaDB views and their advantages including simplicity, consistency, and security.
MariaDB Triggers
In this tutorial, you will learn about MariaDB triggers and the main differences between triggers and stored procedures.
MariaDB Indexes
This section teaches you about MariaDB indexes including creating new indexes, removing existing indexes, and listing all indexes in the database.
MariaDB Aggregate Functions
This section introduces you to the most commonly used MariaDB aggregate functions including avg(), count(), max(), min(), and sum().