Skip to content

Latest commit

 

History

History
57 lines (23 loc) · 2.18 KB

MariaDB Tutorial.md

File metadata and controls

57 lines (23 loc) · 2.18 KB

原文地址:https://www.mariadbtutorial.com/

MariaDB Tutorial

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.

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.

This MariaDB basics section helps you learn how to query data from tables, manage databases and tables.

In this tutorial, you will learn about MariaDB views and their advantages including simplicity, consistency, and security.

In this tutorial, you will learn about MariaDB triggers and the main differences between triggers and stored procedures.

This section teaches you about MariaDB indexes including creating new indexes, removing existing indexes, and listing all indexes in the database.

This section introduces you to the most commonly used MariaDB aggregate functions including avg(), count(), max(), min(), and sum().