Category: MariaDB
MariaDB Tutorial / Create a Product Table, Insert Data, and Query It
Build a complete product table, insert three records, and verify its definition and query results. Practice price and stock filters, understand rerun behavior, and reset only confirmed disposable tutorial data.
MariaDB Tutorial / Create a Database with CREATE DATABASE, USE, and utf8mb4
Create a practice database with explicit utf8mb4 settings and verify its definition. Understand connection-local database selection, collation comparisons, and why IF NOT EXISTS preserves existing defaults.
MariaDB Tutorial / Connect with the Command-Line Client and Run SQL Files
Connect to MariaDB with explicit TCP and UTF-8 settings, check account and query results, and execute a complete SQL file with SOURCE. Learn how to diagnose path, encoding, and partial-execution errors.
MariaDB Tutorial / Install MariaDB on Ubuntu and Start the Server
Install MariaDB on Ubuntu with APT, distinguish service activity from automatic startup, and understand socket authentication. Create a restricted TCP learning account and diagnose connection or service problems.
MariaDB Tutorial / Install MariaDB on Windows and Start the Server
Set up a local MariaDB server on Windows, verify its service and TCP connection, and create a database-scoped learning account. Follow practical checks for installation, port, path, and authentication problems.
MariaDB Tutorial / What MariaDB Is: Databases, SQL, and Its Relationship to MySQL
Understand the roles of the MariaDB server and client, the structure of relational data, and the purpose of SQL. Learn how MariaDB relates to MySQL and prepare for a small product-database exercise.