MariaDB Beginner Tutorial: Create Tables, Insert Data, and Run Basic SQL Commands

Learn how to use MariaDB from scratch with this hands-on tutorial. In just a few minutes, you'll log in to MariaDB, create a database and table, insert and delete rows, and run basic SQL queries. Perfect for beginners looking to get started with SQL, MySQL, or MariaDB for data analysis or backend development.

What you'll learn:
✅ How to log into MariaDB
✅ How to create a database and tables
✅ How to insert, select, and delete data
✅ Basic SQL commands and syntax
✅ Dropping tables and databases

🔔 Subscribe for more SQL and database tutorials.

Keywords:
MariaDB tutorial, beginner SQL, how to create a database, create table SQL, insert into MariaDB, delete row MariaDB, SQL for data analysis, MariaDB vs MySQL, MariaDB SQL basics, Linux SQL MariaDB setup
00:00 - Intro & MariaDB login command
00:07 - Login as root using sudo
00:13 - Enter password and access MariaDB
00:34 - Create your first database (assignments)
00:55 - Use the new database
01:08 - Create table ‘students’ with ID, name, and age
01:39 - Set ID as AUTO_INCREMENT and PRIMARY KEY
01:58 - Add name (VARCHAR) and age (INT) with NOT NULL
02:30 - Insert a row: name = "John", age = 22
03:11 - View data with SELECT * FROM students
03:25 - Delete row WHERE name = 'John'
03:57 - Confirm deletion (empty set)
04:05 - Drop table ‘students’
04:12 - Drop database ‘assignments’
04:22 - Exit MariaDB (quit)

Видео MariaDB Beginner Tutorial: Create Tables, Insert Data, and Run Basic SQL Commands канала Matteo Aurelio's Board