SQL Programming with MariaDB: Using Joins, Triggers, & Stored Procedures
MariaDB 10.5
| Expert
- 14 videos | 2h 4m 26s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this courseperform basic cross and inner joins using SELECT-FROM-WHERE queriesuse the JOIN keyword to perform cross joins, inner joins, left outer joins, and right outer joinsrecognize how default ON DELETE behavior of foreign key constraints in MariaDB works and perform a three-way joinoverride the default ON DELETE behavior of foreign key constraints in MariaDB tables to implement cascading deleteillustrate the basic usage of the DISTINCT and GROUP BY keywordsrecognize 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 queriesutilize generated columns in MariaDBrecognize what triggers are, implement an insert trigger, and observe its working mechanismcreate and use an update trigger, which is executed after updates to a MariaDB tableinvoke a stored procedure and pass in required argumentsstart a transaction and execute statements within it, and either rollback or commit that transactionsummarize the key concepts covered in this course
IN THIS COURSE
-
2m 49s
-
10m 8s
-
8m 34s
-
8m 45s
-
8m 10s
-
10m 45s
-
10m 9s
-
8m 8s
-
11m 48s
-
10m 14s
-
10m 56s
-
10m 32s
-
11m 6s
-
2m 23s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.