# Quickstart Guides

- [Installing MariaDB Server Guide](/docs/server/mariadb-quickstart-guides/installing-mariadb-server-guide.md): Official MariaDB Server install guide: Linux apt/dnf/yum commands, mariadb-secure-installation setup, systemctl status/start checks, Windows .msi installer.
- [Adding & Changing Data Guide](/docs/server/mariadb-quickstart-guides/mariadb-adding-and-changing-data-guide-1.md): This guide provides a walkthrough of the INSERT, UPDATE, and DELETE statements, demonstrating how to add, modify, and remove data in tables.
- [Essential Queries Guide](/docs/server/mariadb-quickstart-guides/mariadb-advanced-sql-guide.md): Learn how to perform essential SQL operations such as creating tables, inserting data, and using aggregate functions like MAX, MIN, and AVG.
- [Basics Guide](/docs/server/mariadb-quickstart-guides/basics-guide.md): Complete MariaDB basics guide: connect with mariadb -u/-p/-h, CREATE DATABASE/USE, CREATE TABLE with AUTO\_INCREMENT, INSERT/SELECT/UPDATE/DELETE commands.
- [Altering Tables Guide](/docs/server/mariadb-quickstart-guides/mariadb-alter-table-guide-1.md): Learn how to modify existing table structures using the ALTER TABLE statement, including adding columns, changing types, and managing indexes.
- [Connecting to MariaDB Guide](/docs/server/mariadb-quickstart-guides/mariadb-connecting-guide.md): This guide details how to connect to a MariaDB server using the command-line client, covering options for host, user, password, and protocol.
- [Troubleshooting Connection Issues Guide](/docs/server/mariadb-quickstart-guides/mariadb-connection-troubleshooting-guide.md): Complete Troubleshooting Connection Issues Guide guide for MariaDB. Complete resource with setup instructions, configuration, usage examples, and best practices.
- [Doing Time Guide](/docs/server/mariadb-quickstart-guides/mariadb-datetime-guide.md): Understand how to work with date and time values in MariaDB, including data types like DATETIME and TIMESTAMP, and useful temporal functions.
- [Importing Data Guide](/docs/server/mariadb-quickstart-guides/mariadb-importing-data-guide.md): Learn how to efficiently import data into MariaDB tables from external files using the LOAD DATA INFILE statement.
- [Essentials of an Index Guide](/docs/server/mariadb-quickstart-guides/essentials-of-an-index-guide.md): This guide provides a conceptual overview of database indexes, explaining their purpose, different types, and when to use them for optimization.
- [Getting Started with Indexes Guide](/docs/server/mariadb-quickstart-guides/mariadb-indexes-guide.md): Definitive MariaDB indexes guide: PRIMARY KEY, UNIQUE INDEX, INDEX, FULLTEXT types, CREATE/ALTER TABLE syntax, CREATE INDEX, SHOW INDEX, and EXPLAIN.
- [Joining Tables with JOIN Clauses](/docs/server/mariadb-quickstart-guides/mariadb-join-guide.md): This guide introduces the different types of JOINs (INNER, LEFT, RIGHT, CROSS) and demonstrates how to combine data from multiple tables.
- [Advanced Joins](/docs/server/mariadb-quickstart-guides/more-advanced-joins.md): Explore complex join scenarios. This guide covers filtering joined data with WHERE clauses, handling dates, and aggregating results from multiple tables for deeper analysis.
- [Configuring MariaDB for Remote Client Access Guide](/docs/server/mariadb-quickstart-guides/mariadb-remote-connection-guide.md): Complete Configuring MariaDB for Remote Client Access Guide guide for MariaDB. Complete resource with setup instructions, configuration, usage examples, and.
- [Getting Data Guide](/docs/server/mariadb-quickstart-guides/mariadb-selecting-data-guide.md): This guide explains the SELECT statement in detail, covering how to retrieve, filter, limit, and sort data from your MariaDB database.
- [Basic SQL Statements Guide](/docs/server/mariadb-quickstart-guides/mariadb-sql-cheat-cheat-guide.md): A quick reference for core SQL statements including DDL (CREATE, DROP), DML (INSERT, UPDATE, DELETE), and TCL (COMMIT, ROLLBACK) commands.
- [Basic SQL Debugging Guide](/docs/server/mariadb-quickstart-guides/mariadb-sql-debugging-guide.md): This guide offers conventions and practical tips for designing SQL queries that are easier to read, understand, and debug.
- [MariaDB String Functions Guide](/docs/server/mariadb-quickstart-guides/mariadb-string-functions-guide.md): 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.
- [Restoring Data from Dump Files Guide](/docs/server/mariadb-quickstart-guides/mariadb-restore-guide.md): Complete Restoring Data from Dump Files Guide guide for MariaDB. Complete resource with setup instructions, configuration, usage examples, and best practices.
- [Changing Times in MariaDB](/docs/server/mariadb-quickstart-guides/mariadb-time-guide.md): This guide explores MariaDB functions for performing calculations and modifications on date and time values, like DATE\_ADD and DATE\_SUB.
- [System & Status Variables Guide](/docs/server/mariadb-quickstart-guides/system-and-status-variables-guide.md): This guide indicates where the various system and status variables of MariaDB Server are found.
- [Making Backups with mariadb-dump Guide](/docs/server/mariadb-quickstart-guides/mariadb-backup-guide.md): Complete MariaDB backup and recovery guide. Complete resource for backup methods, mariabackup usage, scheduling, and restoration for production use.
- [A MariaDB Primer Guide](/docs/server/mariadb-quickstart-guides/mariadb-usage-guide.md): A beginner-friendly primer on using the mariadb command-line client to log in, create databases, and execute basic SQL commands.
- [Creating & Using Views Guide](/docs/server/mariadb-quickstart-guides/mariadb-views-guide.md): Discover how to create and use views to simplify complex queries, restrict data access, and present a specific perspective of your data.
- [Database Applications](/docs/server/mariadb-quickstart-guides/database-applications.md): This section offers advice on writing and maintaining applications that use databases, covering schema design, code practices, and testing.
- [Introduction & Background](/docs/server/mariadb-quickstart-guides/database-applications/introduction-and-background.md): This section provides an introduction to developing database-backed applications with MariaDB, discussing maintenance, upgrades, and separation of concerns.
- [Database Design](/docs/server/mariadb-quickstart-guides/database-applications/database-design.md): Learn about best practices for database schema design, including naming conventions, choosing appropriate data types, and using views to abstract complexity.
- [Application Code](/docs/server/mariadb-quickstart-guides/database-applications/application-code.md): This guide covers application-side considerations, such as using ORMs, stored procedures, and writing robust SQL that handles schema changes gracefully.
- [Canary Testing](/docs/server/mariadb-quickstart-guides/database-applications/canary-testing.md): Explore strategies for safely testing schema and application changes using canary deployments, replication, and features like invisible columns.