MariaDB Tutorial

MariaDB Tutorial

This MariaDB tutorial has been designed for absolute beginners, self-learners and database professionals. In this MariaDB Tutorial, you will learn the MariaDB from very basic to advanced in a reasonable manner that you will follow.

This guide also might be useful for intermediate and advanced learners. Because after the beginners part finished we will discuss the MariaDB advanced topic such as MariaDB by examples, MariaDB application implementation, working with MySQL client, etc.

We will cover the most basic and advanced concepts/topics in this MariaDB tutorial. After completing this tutorial you will learn basic concepts like MariaDB possible features, installation on a different platform, connecting MariaDB server, creating the database, creating the table, inserting data, delete/modifying data, etc.

So What is MariaDB?

MariaDB is an open-source, community-based, relational database management system developed by the MySQL community. Like all other RDBMS (Relational Database Management System) MariaDB has all the features of the RDBMS.

Some most useful and most used features of MariaDB are given below:

  • MariaDB is a light-weight relational database management system.
  • It is cross-platform, almost all the popular OS can run the MariaDB server.
  • All the possible RDBMS features exist in the MariaDB server.
  • And all the features can be used by interpreting the SQL command.
  • Many popular programming language support MariaDB to integrate with them (e:g: PHP)
  • MariaDB is very easy to learn and use.
  • It is open-source and community-based application.
  • You can modify, integrate and extend the source code as your needs without any permissions.

By default, MariaDB supports PHP programming language. But you can use other programming languages by writing API or using existing API write by others. You will find many open-source API to integrate with your desired programming language.

What You Will Need to Get Started

Ideally Nothing! If you want to learn how MariaDB works, how to operate the data then you can learn MariaDB without having any prior programming language experience. In this case, you will learn the MariaDB syntax like creating a database, modifying database, features, etc.

But if you want to implement MariaDB with real-world application, then you should have some programming experience (e:g: PHP). To interact between MariaDB server and real-world application we have to use a client program (less experience required), or we have to write a small piece of program/script (called API).

In the subsequent chapters, we will learn all the procedures among with the basic MariaDB. Let’s get started.