Learn MariaDB : A Beginner to Advanced Guide

Master MariaDB from beginner to advanced topics by learning installation, syntax, connections, and operations like creating databases and tables, inserting and updating records, and using aggregate functions and joins.

Explore what MariaDB is as an open source relational database management system, including how tables, primary keys, and foreign keys establish relationships and ensure referential integrity.

Discover MariaDB features such as high performance storage engines and cross-platform support across multiple operating systems. Explore language compatibility, GPL or BSD licensing, and version history like 5.1.

Learn how to select, create, use, and drop databases in MariaDB, and verify deletion using management studio.

Learn how to create a table in MariaDB, specify a primary key, and define columns with appropriate data types.

Learn how the drop table statement removes a table from a MariaDB database, its unrecoverable consequences, and use Management Studio to drop a table.

Learn how to insert records into a table using insert statements in MariaDB, and verify results with select queries on the students table, including fields like name, address, admission date.

Use a select statement to limit records from a table and retrieve name and address from students, ordered by student_id in descending, then limit 1 to 4 in ascending order.

Learn how to update data in MariaDB by modifying existing fields, changing values like student names and birthdays, and reflecting these updates in records.

Learn how to delete data in MariaDB by removing records from the students table, then verify deletions with a select query to confirm removed records.

Explore how the truncate statement deletes all records in the same statement without a where clause, and understand that the deleted records cannot be ordered back.

Master the where clause in MariaDB by filtering the students table using conditions on student id and student name, including operators like greater than and greater than or equal to.

Explore the like clause in MariaDB, using pattern matching with wildcards in select statements to find data, including names starting with specific letters and single-character matches.

Explore the order by clause to sort results in ascending or descending order. Retrieve student name and student id from the students table and view the ordered output.

Use the distinct clause to return unique student names from the students table, removing duplicates. Explore applying distinct with multiple expressions to get unique combinations of student name and address.

Learn to use the from clause in MariaDB to fetch data from the students table, retrieve all rows, select specific columns, and order results.

Explore the MariaDB COUNT() function, learning how it counts expressions and rows, and how to count distinct student names to prevent duplicates in queries.

Learn how to use the min() function to retrieve the minimum value of an expression, and apply an order by clause in a MariaDB select query.

Explore the max function in MariaDB to obtain the maximum value of an expression. See how max differs from a single expression and apply it to examples like 500.

Master the avg() function to compute the average salary across all students and apply a 50 percent increase to that average in MariaDB.

Master inner join concepts and the left and right join types to combine data from students and employees in MariaDB using select queries.

Explore how a left outer join retrieves all student records and matches with employees where available.

Explore right outer join in MariaDB, using an on condition to combine students with employees and view student names, addresses, and employee salaries.

Learn how the union operator combines multiple select statements in MariaDB, selecting student names from students and employee names from employees, handling duplicates.

Explore the union all operator in MariaDB and compare it with the union operator, learning how to combine multiple selects like student names and employee names while managing duplicates.

Explore the intersect operator in MariaDB by comparing student names and employee names to find common names and observe cases with no matches.

Learn how to create a function in MariaDB, defining a stored program to compute and update values, and experiment with function naming and usage.

Learn how to create and drop stored procedures in MariaDB, compare procedures with functions, and manage procedure names through practical examples.

Explore the conditions statement in MariaDB, using not, not like, starts with, and between to filter select results for students and staff.

Learn how the MariaDB comparison operator evaluates equality to filter data, enabling you to select results and understand how comparisons shape outcomes.

Learn how VirtualBox enables virtualization on your existing computer, allowing you to run multiple operating systems like Windows and Linux simultaneously.

Download a CentOS ISO image by going to the link, then click the first link, and watch the download start.

Learn how to set up a virtual machine in VirtualBox, enable virtualization, and attach a CentOS ISO image to the optical drive, configuring storage options.

Boot the machine and run the setup wizard, guiding storage selection, naming the computer, and creating a password as the operating system installs and reboots.

Install MariaDB on CentOS using yum, configure the system, and complete a secure setup by removing anonymous users and limiting remote login.

Set up a MariaDB Galera cluster across three servers by installing required packages, configuring services, and validating the clustered status.