> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/mariadb-quickstart-guides.md).

# Quickstart Guides

{% columns %}
{% column %}
{% content-ref url="/pages/oGcwaGWRFir9VxHLbGnk" %}
[Installing MariaDB Server Guide](/docs/server/mariadb-quickstart-guides/installing-mariadb-server-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Official MariaDB Server install guide: Linux apt/dnf/yum commands, mariadb-secure-installation setup, systemctl status/start checks, Windows .msi installer.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/U5oB3Pknardb2qcV86vd" %}
[Adding & Changing Data Guide](/docs/server/mariadb-quickstart-guides/mariadb-adding-and-changing-data-guide-1.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This guide provides a walkthrough of the INSERT, UPDATE, and DELETE statements, demonstrating how to add, modify, and remove data in tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/gj7sIeftpbehUHRvYLDV" %}
[Essential Queries Guide](/docs/server/mariadb-quickstart-guides/mariadb-advanced-sql-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn how to perform essential SQL operations such as creating tables, inserting data, and using aggregate functions like MAX, MIN, and AVG.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/9NfSX1N8rJ7GRAlX0kaM" %}
[Basics Guide](/docs/server/mariadb-quickstart-guides/basics-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete MariaDB basics guide: connect with mariadb -u/-p/-h, CREATE DATABASE/USE, CREATE TABLE with AUTO\_INCREMENT, INSERT/SELECT/UPDATE/DELETE commands.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/HlkHx9DymC9iDzM4SLT1" %}
[Altering Tables Guide](/docs/server/mariadb-quickstart-guides/mariadb-alter-table-guide-1.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn how to modify existing table structures using the ALTER TABLE statement, including adding columns, changing types, and managing indexes.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/SPhl48v4hsm6T96ygKcG" %}
[Connecting to MariaDB Guide](/docs/server/mariadb-quickstart-guides/mariadb-connecting-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This guide details how to connect to a MariaDB server using the command-line client, covering options for host, user, password, and protocol.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/POxLyb6mdsssTGxNnEE0" %}
[Troubleshooting Connection Issues Guide](/docs/server/mariadb-quickstart-guides/mariadb-connection-troubleshooting-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Diagnose and fix common MariaDB Server connection problems, such as "Can't connect to local server" and access-denied errors, with step-by-step troubleshooting.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/W5DUN3ujn1sLIPyfXii8" %}
[Doing Time Guide](/docs/server/mariadb-quickstart-guides/mariadb-datetime-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Understand how to work with date and time values in MariaDB, including data types like DATETIME and TIMESTAMP, and useful temporal functions.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/QiHcFpDUpBze97XiiRqD" %}
[Importing Data Guide](/docs/server/mariadb-quickstart-guides/mariadb-importing-data-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn how to efficiently import data into MariaDB tables from external files using the LOAD DATA INFILE statement.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/kCv3M0HHXaRx9fjSPYFZ" %}
[Essentials of an Index Guide](/docs/server/mariadb-quickstart-guides/essentials-of-an-index-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This guide provides a conceptual overview of database indexes, explaining their purpose, different types, and when to use them for optimization.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Wmt45g0lcbIhNZN9rGSC" %}
[Getting Started with Indexes Guide](/docs/server/mariadb-quickstart-guides/mariadb-indexes-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Definitive MariaDB indexes guide: PRIMARY KEY, UNIQUE INDEX, INDEX, FULLTEXT types, CREATE/ALTER TABLE syntax, CREATE INDEX, SHOW INDEX, and EXPLAIN.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/BRHNBfBssVtfdyOTzCHv" %}
[Joining Tables with JOIN Clauses](/docs/server/mariadb-quickstart-guides/mariadb-join-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This guide introduces the different types of JOINs (INNER, LEFT, RIGHT, CROSS) and demonstrates how to combine data from multiple tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/rZWdKMRnZeLyRKWmlJRU" %}
[Advanced Joins](/docs/server/mariadb-quickstart-guides/more-advanced-joins.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore complex join scenarios. This guide covers filtering joined data with WHERE clauses, handling dates, and aggregating results from multiple tables for deeper analysis.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/9mgo6MElJhFPsC4ssYKu" %}
[Configuring MariaDB for Remote Client Access Guide](/docs/server/mariadb-quickstart-guides/mariadb-remote-connection-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Configure MariaDB Server to accept remote connections by setting bind-address, granting privileges for remote users, and opening the right firewall rules.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/9A5pJVllWc4BxzWluqTu" %}
[Getting Data Guide](/docs/server/mariadb-quickstart-guides/mariadb-selecting-data-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This guide explains the SELECT statement in detail, covering how to retrieve, filter, limit, and sort data from your MariaDB database.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/hijcdPj5OGoxZKRpQnHC" %}
[Basic SQL Statements Guide](/docs/server/mariadb-quickstart-guides/mariadb-sql-cheat-cheat-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
A quick reference for core SQL statements including DDL (CREATE, DROP), DML (INSERT, UPDATE, DELETE), and TCL (COMMIT, ROLLBACK) commands.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/KyaMpWXebm0TA4az3Nx0" %}
[Basic SQL Debugging Guide](/docs/server/mariadb-quickstart-guides/mariadb-sql-debugging-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This guide offers conventions and practical tips for designing SQL queries that are easier to read, understand, and debug.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/QKTLpqkiwYAXyZfbte6Z" %}
[MariaDB String Functions Guide](/docs/server/mariadb-quickstart-guides/mariadb-string-functions-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This guide goes through several built-in string functions in MariaDB, grouping them by similar features, and providing examples of how they might be used.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/EEyfyNdzfr8351E0FKsn" %}
[Restoring Data from Dump Files Guide](/docs/server/mariadb-quickstart-guides/mariadb-restore-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Restore MariaDB data from mariadb-dump backup files using the mariadb client, including how to selectively restore a single table.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/pHWJsAufS5tdQul8GqkW" %}
[Changing Times in MariaDB](/docs/server/mariadb-quickstart-guides/mariadb-time-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This guide explores MariaDB functions for performing calculations and modifications on date and time values, like DATE\_ADD and DATE\_SUB.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/6NK22x40sgn3SshRQiCR" %}
[System & Status Variables Guide](/docs/server/mariadb-quickstart-guides/system-and-status-variables-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This guide indicates where the various system and status variables of MariaDB Server are found.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/bELjbpBYmRjeG39v8p9W" %}
[Making Backups with mariadb-dump Guide](/docs/server/mariadb-quickstart-guides/mariadb-backup-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Create logical backups of MariaDB databases with the mariadb-dump utility, covering how to back up all databases, specific databases, or individual tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/F0FTO1SY0A0DdiDurTyX" %}
[A MariaDB Primer Guide](/docs/server/mariadb-quickstart-guides/mariadb-usage-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
A beginner-friendly primer on using the mariadb command-line client to log in, create databases, and execute basic SQL commands.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/AnghuCHHZ8Af6SN0Tc3j" %}
[Creating & Using Views Guide](/docs/server/mariadb-quickstart-guides/mariadb-views-guide.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Discover how to create and use views to simplify complex queries, restrict data access, and present a specific perspective of your data.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/mEDTlZKW1nrIJBgb44rK" %}
[Database Applications](/docs/server/mariadb-quickstart-guides/database-applications.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This section offers advice on writing and maintaining applications that use databases, covering schema design, code practices, and testing.
{% endcolumn %}
{% endcolumns %}