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

MariaDB 10.5
  • 14 Videos | 2h 10m 26s
  • Includes Assessment
  • Earns a Badge
Likes 1 Likes 1
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

  • Playable
    1. 
    Course Overview
    2m 49s
    UP NEXT
  • Playable
    2. 
    Understanding Joins
    10m 8s
  • Locked
    3. 
    Implementing Joins using the JOIN Keyword
    8m 34s
  • Locked
    4. 
    Working with Default ON DELETE Behavior in MariaDB
    8m 45s
  • Locked
    5. 
    Using ON DELETE CASCADE on FOREIGN KEY Constraints
    8m 10s
  • Locked
    6. 
    Using the GROUP BY Clause
    10m 45s
  • Locked
    7. 
    Working with the HAVING Clause
    10m 9s
  • Locked
    8. 
    Using the SOME, ALL, and ANY Keywords
    8m 8s
  • Locked
    9. 
    Utilizing Generated Columns
    11m 48s
  • Locked
    10. 
    Creating Insert Triggers
    10m 14s
  • Locked
    11. 
    Using Update Triggers
    10m 56s
  • Locked
    12. 
    Using Stored Procedures
    10m 32s
  • Locked
    13. 
    Working with Transactions
    11m 6s
  • Locked
    14. 
    Course Summary
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 22 Likes 22  
Likes 40 Likes 40