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

Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description

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.

Expected Duration (hours)
2.1

Lesson Objectives

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

discover the key concepts covered in this course

perform basic cross and inner joins using SELECT-FROM-WHERE queries

use the JOIN keyword to perform cross joins, inner joins, left outer joins, and right outer joins

recognize how default ON DELETE behavior of foreign key constraints in MariaDB works and perform a three-way join

override the default ON DELETE behavior of foreign key constraints in MariaDB tables to implement cascading delete

illustrate the basic usage of the DISTINCT and GROUP BY keywords

recognize different aggregate functions within GROUP BY queries and work with the HAVING clause to filter results of GROUP BY operations

Use the SOME, ALL and ANY keywords to link subqueries to outer queries

utilize generated columns in MariaDB

recognize what triggers are, implement an insert trigger, and observe its working mechanism

create and use an update trigger, which is executed after updates to a MariaDB table

invoke a stored procedure and pass in required arguments

start a transaction and execute statements within it, and either rollback or commit that transaction

summarize the key concepts covered in this course

Course Number:
it_dasqpmdj_03_enus

Expertise Level
Expert