SQL Programming with MariaDB: Using Joins Triggers & Stored Procedures

Joins triggers and stored procedures are useful tools to take advantage of when working with MariaDB. In this course youll begin by using several types of joins such as cross joins inner joins and outer joins to combine data from multiple tables.<<Next youll 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. Youll then use the HAVING clause as a way to filter the output of the GROUP BY clause.<<Youll move on to use the two types of generated columns – virtual and persistent computing them on-the-fly from a function expression.<<Finally youll use triggers to perform operations whenever a condition is satisfied and stored procedures for code re-use and parameterization.