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
    To find out how to perform basic cross and inner joins using SELECT-FROM-WHERE queries, consult a SQL tutorial or reference. FREE ACCESS
  • Locked
    3.  Implementing Joins using the JOIN Keyword
    8m 34s
    In this video, learn how to use the JOIN keyword to perform cross joins, inner joins, left outer joins, and right outer joins. FREE ACCESS
  • Locked
    4.  Working with Default ON DELETE Behavior in MariaDB
    8m 45s
    Upon completion of this video, you will be able to recognize the default ON DELETE behavior of foreign key constraints in MariaDB and perform a three-way join. FREE ACCESS
  • Locked
    5.  Using ON DELETE CASCADE on FOREIGN KEY Constraints
    8m 10s
    Learn how to override the default ON DELETE behavior of foreign key constraints in MariaDB tables to implement cascading delete. FREE ACCESS
  • Locked
    6.  Using the GROUP BY Clause
    10m 45s
    Upon completion of this video, you will be able to illustrate the basic usage of the DISTINCT and GROUP BY keywords. FREE ACCESS
  • Locked
    7.  Working with the HAVING Clause
    10m 9s
    Upon completion of this video, you will be able to recognize different aggregate functions within GROUP BY queries and work with the HAVING clause to filter results of GROUP BY operations. FREE ACCESS
  • Locked
    8.  Using the SOME, ALL, and ANY Keywords
    8m 8s
    In this video, learn how to use the SOME, ALL and ANY keywords to link subqueries to outer queries. FREE ACCESS
  • Locked
    9.  Utilizing Generated Columns
    11m 48s
    In this video, you will learn how to use generated columns in MariaDB. FREE ACCESS
  • Locked
    10.  Creating Insert Triggers
    10m 14s
    After completing this video, you will be able to recognize what triggers are, implement an insert trigger, and observe how it works. FREE ACCESS
  • Locked
    11.  Using Update Triggers
    10m 56s
    In this video, you will create and use an update trigger, which is executed after updates to a MariaDB table. FREE ACCESS
  • Locked
    12.  Using Stored Procedures
    10m 32s
    In this video, learn how to invoke a stored procedure and pass in required arguments. FREE ACCESS
  • Locked
    13.  Working with Transactions
    11m 6s
    Learn how to start a transaction, execute statements within it, and either roll back or commit that transaction. FREE ACCESS
  • 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Querying MariaDB: Use SQL Operations,Data Extraction, and Custom Queries to Make your MariaDB Database Analytics more Accessible
Course Database Fundamentals: Database Administration Basics
Book Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Multiple SQL Tables
Course Objects & Retrieving Data
Course DDL, DML, & Constraints