MariaDB Tutorials: Learn MariaDB Step by Step

New to MariaDB? Start here

Read these in order. Each one builds on the one before it.

1. How to install MariaDBInstall MariaDB and log in for the first time.
2. How to Create Database in MariaDBCreate your first database.
3. MariaDB Create Database and User (With GRANT and Login Test)Add a user and grant it access.
4. How to Create Table in MariaDBCreate a table with keys and data types.
5. MariaDB Select Statement- Detailed GuideRead and filter your data.
6. MariaDB Join with ExamplesCombine data from related tables.

The basics5

What it is, what it's good for, and the questions people ask before they commit to it.

• How to use Maria DB
• Maria DB GUI
• MariaDB Reserved Words – Helpful Tutorial
• What is MariaDB Database
• What is MariaDB Used For

Install, connect and tools9

Install it, connect to it, and get your tools working.

• How to Access MariaDB in Linux
• How To Check MariaDB Version [Several Ways]
• How To Ping Maria DB Server Port From Ubuntu
• How to Start MariaDB in CentOS 7
• How to uninstall MariaDB
• MariaDB Enable Remote Access
• MariaDB Max Connections – Helpful Guide
• MariaDB Migration Tool
• How to install MariaDB

Databases, tables and columns24

Create and change databases, tables, columns, keys, indexes and views.

• How to Add Column in MariaDB [5 Examples]
• How to Change Column in MariaDB
• How to create a database from an SQL file in MariaDB
• How To Create Views In MariaDB
• How to Delete a Database in MariaDB
• How to Drop Column from MariaDB Table
• How to Drop Constraint in MariaDB
• How to List Databases in MariaDB
• How to Select a Database in MariaDB
• How to Show Tables in MariaDB
• MariaDB Add Column With Default Value
• MariaDB Alter Table If Exists
• MariaDB Check Constraint + Examples
• MariaDB Create Sequence + Examples
• MariaDB Drop Table
• MariaDB Foreign Key + Examples
• MariaDB Primary Key
• MariaDB Rename Column + Examples
• MariaDB Rename Table
• MariaDB Rename View [Complete tutorial]
• MariaDB Temporary Table: Create, From Select, Index and Drop
• MariaDB Unique Key
• How to Create Database in MariaDB
• How to Create Table in MariaDB

Data types6

Pick the right data type for every column.

• MariaDB AUTO_INCREMENT + Examples
• MariaDB ENUM – Helpful Guide
• MariaDB Set Auto Increment Value
• MariaDB Show Column Data Type
• MariaDB TINYINT
• MariaDB varchar

SELECT queries, filtering and grouping22

Read data with SELECT, filter it, sort it and summarize it.

• How to use MariaDB Not Equal Operator
• MariaDB Between
• MariaDB Check If Rows Exists [With 11 real examples]
• MariaDB Comment – How to use
• MariaDB GROUP BY [With 9 useful example]
• MariaDB If Null + Examples
• MariaDB If statement in Select
• MariaDB Insert If Not Exists
• MariaDB ISNULL + Examples
• MariaDB LIMIT + Examples
• MariaDB Median – Complete Tutorial
• MariaDB Order By
• MariaDB Order By Decreasing [17 Amazing Examples]
• MariaDB Queries – Detailed Guide
• MariaDB query example
• MariaDB Row_Number Tutorial
• MariaDB See If Table Exists
• MariaDB Select Into + Examples
• MariaDB Select Unique [With 21 Amazing Examples]
• MariaDB Select Where Not Empty
• MariaDB Union Operator
• MariaDB Select Statement- Detailed Guide

Joins3

Combine rows from two or more tables.

• MariaDB Full Outer Join – How to implement
• MariaDB Left Join – Helpful Guide
• MariaDB Join with Examples

Insert, update and delete8

Add, change and remove rows safely.

• Add Data To Table MariaDB
• How to truncate table in MariaDB + Examples
• MariaDB Delete Row + Examples
• MariaDB Insert Into
• MariaDB Insert Into Select [With 13 Best Examples]
• MariaDB Insert Multiple Rows [Complete Guide]
• MariaDB on Duplicate Key Update
• MariaDB Update Statement with Examples

Strings, numbers and conversions6

Work with text and numbers, and convert between types.

• MariaDB Cast with Examples
• MariaDB Check Empty String
• MariaDB Check String Length [13 helpful examples]
• MariaDB LIKE Operator [7 Examples]
• MariaDB Regexp + Examples
• MariaDB Substring [11 Examples]

Dates and times8

Format, compare and calculate dates and times.

• MariaDB Date + Examples
• MariaDB Date Add Days [With 21 Useful Examples]
• MariaDB Date Allow Null [17 Useful Examples]
• MariaDB Date Greater Than – Detailed Guide
• MariaDB Date_Format
• MariaDB DateTime Tutorial + Examples
• MariaDB Str_To_Date [10 Amazing Examples]
• MariaDB Timestamp + Examples

Functions7

Built-in functions and the ones you write yourself.

• How to Create Function in MariaDB
• MariaDB COUNT Function [10 Examples]
• MariaDB DATEDIFF Function
• MariaDB Greatest Function – Useful Guide
• MariaDB JSON Functions: Reference Table and Examples
• MariaDB Window functions
• Replace Function in MariaDB [9 Examples]

Stored procedures, variables and control flow6

Stored procedures, variables, IF/CASE logic, loops, error handling and transactions.

• MariaDB Case Statement
• MariaDB create procedure – Complete Tutorial
• MariaDB IF Tutorial
• MariaDB Set Variable – Complete Guide
• MariaDB Transaction – Helpful Guide
• MariaDB Variables

Triggers1

Run code automatically when rows are inserted, updated or deleted.

• How to Create Trigger in MariaDB

Users, logins and permissions6

Create users, reset passwords and grant the right permissions.

• Grant All Privileges MariaDB
• How to Grant User Access to a MariaDB Database
• How to Show Users in MariaDB
• MariaDB Remove User
• MariaDB Reset Root Password
• MariaDB Create Database and User (With GRANT and Login Test)

Backup, import/export and administration7

Back up, restore, import, export, migrate and monitor.

• How to load files into MariaDB
• MariaDB Backup Database
• MariaDB EXPLAIN
• MariaDB import CSV
• MariaDB Index: Create, Show, Rename and Drop (With EXPLAIN)
• MariaDB Logs – Helpful Guide
• MariaDB Sharding

Errors and fixes4

The exact error message, what causes it and the steps that fix it.

• Cannot Delete Or Update A Parent Row
• Column count doesn’t match value count at row 1
• MariaDB ERROR 1064
• Setup Wizard Ended Prematurely

Comparisons8

Side-by-side comparisons to help you choose.

• MariaDB Difference Between Two Dates
• MariaDB vs MongoDB
• MariaDB vs MySQL
• MariaDB Vs MySQL Vs PostgreSQL
• MariaDB vs Oracle
• MariaDB vs Postgres
• MariaDB Vs SQL Server – Detailed Comparison
• MariaDB Vs SQLite

Other database tutorials

Looking for everything, newest first? See the full tutorial list.