Training: SQL Programming with MariaDB

• MariaDB is a popular tool for SQL programming. To use it, you

• must first know how to install it on your machine and set it up for
• your needs. In this course, you'll learn how to install MariaDB for
• macOS and MS Windows. You'll then run MariaDB from a command line
• interface (CLI) and create a new custom user for MariaDB from the
• CLI -an essential step for running MariaDB from a client such as
• DBeaver, as connecting as root is not considered a best practice.
• Next, you'll work with DBeaver and recognize how it is a handy user
• interface to interact with a MariaDB server. Finally, you'll run a
• few basic MariaDB commands and queries from DBeaver.

• To query data with SQL, you need to know which queries and

• keywords to use for which operations. In this course, you'll learn
• to query data using the classic SQL syntax construct, the
• SELECT-FROM-WHERE query, and how keywords, such as LIKE, can be
• used to filter data based on a condition and using wildcards.
• You'll learn how to carry out different aspects of inserting,
• updating, and deleting data - such operations, along with querying,
• are collectively known as CRUD operations, an acronym for
• Create-Read-Update-Delete. Finally, you'll learn how to take
• advantage of another important aspect of relational database usage
• - the ability to impose constraints upon data. You'll work with
• UNIQUE, NOT NULL, and FOREIGN KEY constraints.

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.