I am very delighted to announce that I have just published five video courses on the Pluralsight about Learning MariaDB. I am indeed very delighted to share my suggestion about MariaDB Learning Path.
MariaDB Learning Path
- Course 1: Querying Data from MariaDB
- Course 2: Capturing Logic with Stored Procedures in MariaDB
- Course 3: MariaDB Data Manipulation Playbook
- Course 4: Combining and Filtering Data with MariaDB
- Course 5: MariaDB Functions Playbook
Course 1: Querying Data from MariaDB
Short description:
In this course, you’ll focus on developing the skills needed to work with complex business logic using Data Query Language (DQL) in MariaDB.
Long description:
Querying meaningful data is the primary task for any relational engine, and MariaDB is one of the most sophisticated relational databases in the RDBMS world. In this course, Querying Data from MariaDB, you’ll gain the ability to work with complex business logic using Data Query Language (DQL) in MariaDB. First, you’ll learn how to retrieve specific column data from a table using the SELECT statement. Next, you’ll discover how to retrieve specific rows of data from a table using various keywords in the WHERE clause. Finally, you’ll explore how to use advanced search and pattern matching using the LIKE keyword. When you’re finished with this course, you’ll have the skills and knowledge of various elements of the data query language of MariaDB to bring meaningful results from your database.
Course 2: Capturing Logic with Stored Procedures in MariaDB
Short description:
In this course, you’ll get started with Maria DB stored procedures, look into complex business logic inside stored procedures, and learn how to efficiently shape data per business requirements.
Long description:
Stored Procedures are very powerful for retrieving or updating data from tables, which is one of the most important routines for DBAs and developers when dealing with set-based operations. In this course, Capturing Logic with Stored Procedures in MariaDB, you’ll gain the ability to work with complex business logic inside stored procedures. First, you’ll learn how to create stored procedures. Next, you’ll discover how to use various different parameters in stored procedures. Finally, you’ll explore how to work with multiple stored procedures together and return various different information from the stored procedures.  When you’re finished with this course, you’ll have the skills and knowledge of stored procedures needed to work with complex business logic.
Course 3: MariaDB Data Manipulation Playbook
Short description:
This course will focus on the ability to work with complex business logic using the Data Manipulation Language (DML) of MariaDB, and some of its critical operations.
Long description:
To master any Relational Database Management System (RDBMS), it is important to learn the elements of data manipulation, and MariaDB is one of the most sophisticated relational databases in the RDBMS world. In this course, MariaDB Data Manipulation Playbook, you’ll gain the ability to work with complex business logic using the Data Manipulation Language (DML) of MariaDB. First, you’ll learn how to add new records into tables with the INSERT statement. Next, you’ll discover how to change existing records with the UPDATE statement. Finally, you’ll explore how to remove records with the DELETE and TRUNCATE statements. When you’re finished with this course, you’ll have the skills and knowledge of various elements of the data manipulation language of MariaDB to bring out meaningful results from your database.
Course 4: Combining and Filtering Data with MariaDB
Short description:
In this course, you’ll explore and learn how you can combine and filter multiple areas of the relational database to build an efficient result for end-users.
Long description:
MariaDB is one of the most sophisticated relational databases in the RDBMS world. It is critical that, in the relational database, multiple columns, fields, and tables work together to provide meaningful results for end-users. In this course, Combining and Filtering Data with MariaDB, you’ll gain the ability to work with complex business logic using various SQL and relational database features of MariaDB. First, you’ll learn how to aggregate results with Group By. Next, you’ll learn how to manipulate string and numeric column fields, as well as about Common Table Expressions, Union queries, and Join to combine various results into a single resultset. Finally, you’ll explore how to work with windowing functions to return meaningful results from your database. When you’re finished with this course, you’ll have the skills and knowledge of various SQL features of MariaDB to solve complex business problems.
Course 5: MariaDB Functions Playbook
Short description:
In this course, you’ll learn about Data Manipulation Language (DML) and some of its critical operations, and gain the ability to work with complex business logic using various built-in functions of MariaDB.
Long description:
To master any Relational Database Management System (RDBMS), it is important to learn elements of its data manipulations. In this course, MariaDB Functions Playbook, you’ll gain the ability to work with complex business logic using various built-in functions of MariaDB. First, you’ll learn how to work with information and date functions. Next, you’ll discover how to work with control flow functions and string functions. Finally, you’ll explore the aggregate and numeric scalar functions. When you’re finished with this course, you’ll have the skills and knowledge of various elements of the built-in functions of MariaDB to bring meaningful results for your business application.
I hope you find this MariaDB Learning Path helpful. If you have a Pluralsight subscription, you can watch it for free. If you do not have a Pluralsight subscription, you can still watch the course for FREE by signing up for a trial account.
Reference:Â Pinal Dave (https://blog.sqlauthority.com)
