# Quickstart Guides - [Installing MariaDB Server Guide](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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](https://mariadb.com/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. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://mariadb.com/docs/server/mariadb-quickstart-guides.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.