MariaDB Tutorial

MariaDB is a popular open-source relational database management system (RDBMS) developed as a community-driven fork of MySQL. It is widely used to store, manage and retrieve structured data for web applications, enterprise software and cloud-based systems.

• Fully compatible with MySQL while offering additional features and performance improvements.
• Supports SQL for creating databases, managing tables and manipulating data.
• Provides advanced capabilities such as multiple storage engines, replication, high availability and security.
• Used by developers, database administrators and organizations to build scalable and reliable applications.

Getting Started

Learn the fundamentals of MariaDB, including installation, configuration and the core concepts required before working with databases.

• Introduction
• Installation
• Connect to MariaDB
• MariaDB vs MySQL
• Data Types
• Declaring Variable

Database Management

This section covers the creation and management of databases, including creating, selecting, modifying and deleting databases.

• Create
• Select
• Alter
• Drop

Table Management

Learn how to create and manage tables, which are the primary structures used to organize and store data in MariaDB.

• Create
• Show
• Alter
• Drop
• Truncate

Data Management

Understand how to insert, update and delete records while managing data efficiently within MariaDB tables.

• Create & Manipulate Data
• Insert Data
• Update Data
• Delete Data

Querying Data

Retrieve, filter, sort and organize data using MariaDB queries to extract meaningful information from your databases.

• SELECT Statement
• WHERE Clause
• ORDER BY Clause
• GROUP BY Clause
• HAVING Clause
• DISTINCT Clause
• LIKE Clause
• Regular Expressions
• NULL Values

Operators

MariaDB operators help perform comparisons, combine query results and build conditions for filtering and manipulating data.

• Comparison
• IN
• IS NULL
• Union
• Union All
• Intersect

Functions

MariaDB provides a variety of built-in functions for processing strings, dates, numbers and performing aggregate calculations.

• Introduction
• String
• Date
• Count
• Max, Min & Mod
• Average
• Quote

Working with Multiple Tables

Learn how to establish relationships between tables and retrieve related data efficiently using keys, joins and views.

• Joins
• Views
• Primary Key
• Foreign Keys

Indexes

Indexes improve query performance by speeding up data retrieval and optimizing searches on large tables.

• Create
• Show
• Drop
• Unique

Advanced Features

Explore advanced MariaDB capabilities for database programming, user management and writing complex SQL queries.

• Procedures
• Triggers
• Create User
• Common Table Expressions (CTEs)