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 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
IN THIS COURSE
-
2m 49s
-
10m 8s
-
3. Implementing Joins using the JOIN Keyword8m 34s
-
4. Working with Default ON DELETE Behavior in MariaDB8m 45s
-
5. Using ON DELETE CASCADE on FOREIGN KEY Constraints8m 10s
-
6. Using the GROUP BY Clause10m 45s
-
7. Working with the HAVING Clause10m 9s
-
8. Using the SOME, ALL, and ANY Keywords8m 8s
-
9. Utilizing Generated Columns11m 48s
-
10. Creating Insert Triggers10m 14s
-
11. Using Update Triggers10m 56s
-
12. Using Stored Procedures10m 32s
-
13. Working with Transactions11m 6s
-
14. Course Summary2m 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.
