SQL Programming with MariaDB: Using Joins, Triggers, & Stored Procedures

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. Joins, triggers, and stored procedures are useful tools to take advantage of when working with MariaDB. In this course, you'll begin by using several types of joins, such as cross joins, inner joins, and outer joins, to combine data from multiple tables.Next, you'll use aggregate functions, such as SUM, MIN, MAX, AVERAGE, and COUNT, with the GROUP BY clause to group data in rows based on a specified column. You'll then use the HAVING clause as a way to filter the output of the GROUP BY clause.You'll move on to use the two types of generated columns - virtual and persistent, computing them on-the-fly from a function expression.Finally, you'll use triggers to perform operations whenever a condition is satisfied and stored procedures for code re-use and parameterization.