Install MariaDB: sudo apt install mariadb-server
Connect to MariaDB: sudo mysql
Show databases available: show databases;
Select ‘mysql’ database: use mysql;
Show tables in a database: show tables;
Retrieve everything: SELECT * FROM user;
Retrieve only some columns: SELECT host, user, password FROM user;
Creating table (named ‘user_review’): 
Inserting into a table:
INSERT INTO user_review (reviewer_name, star_rating, details) VALUE (‘Chris’, ‘4’, ‘A little bitter.’);
INSERT INTO user_review (reviewer_name, star_rating, details) VALUE (‘Linda’, ‘5’, ‘Essential for living.’);
List all rows and columns of a table: DESCRIBE user_review;