
Paths
Querying Data with SQL in MariaDB
MariaDB is an open-source, community-developed, and commercially supported fork of the popular MySQL relational database management system. This skill will teach you how to use... Read more
What You Will Learn:
- Managing and manipulating data with SQL
- Creating projections of data with SQL
- Defining simple MariaDB database objects, such as functions, with SQL
Pre-requisites
Relational database literacy
Beginner
Learn to use the SELECT statement, along with JOINs and WHERE clauses, to create organized projections of data stored in MariaDB.
Querying Data from MariaDB
59m
Description
Querying meaningful data is the primary task for any relational engine, and MariaDB is one of the most sophisticated relational databases in the RDBMS world. In this course, Querying Data from MariaDB, you’ll gain the ability to work with complex business logic using Data Query Language (DQL) in MariaDB. First, you'll learn how to retrieve specific column data from a table using the SELECT statement. Next, you’ll discover how to retrieve specific rows of data from a table using various keywords in the WHERE clause. Finally, you’ll explore how to use advanced search and pattern matching using the LIKE keyword. When you’re finished with this course, you’ll have the skills and knowledge of various elements of the data query language of MariaDB to bring meaningful results from your database. Software required: MariaDB
Table of contents
- Course Overview
- Understanding Data Query Language (DQL)
- Retrieve Specific Column Data from Table
- Retrieve Specific Row Data from Table
- Summary
Combining and Filtering Data with MariaDB
2h 36m
Description
MariaDB is one of the most sophisticated relational databases in the RDBMS world. It is critical that, in the relational database, multiple columns, fields, and tables work together to provide meaningful results for end users.
In this course, Combining and Filtering Data with MariaDB, you’ll gain the ability to work with complex business logic using various SQL and relational database features of MariaDB.
First, you’ll learn how to aggregate results with Group By.
Next, you’ll learn how to manipulate string and numeric column fields, as well as about Common Table Expressions, Union queries, and Join to combine various results into a single resultset.
Finally, you’ll explore how to work with windowing functions to return meaningful results from your database.
When you’re finished with this course, you’ll have the skills and knowledge of various SQL features of MariaDB to solve complex business problems.
Table of contents
- Course Overview
- Aggregating Results with GROUP BY
- Manipulating String and Numeric Column Fields
- Using Common Table Expressions for Efficiency
- Combining Data from Two or More Tables Using Joins
- Limiting Results with Windowing Functions
- Combining Results Set of Multiple SELECT with UNION
- Summary
Intermediate
Insert, update, and delete data from MariaDB.
MariaDB Data Manipulation Playbook
1h 34m
Description
To master any Relational Database Management System (RDBMS), it is important to learn the elements of data manipulation, and MariaDB is one of the most sophisticated relational databases in the RDBMS world. In this course, MariaDB Data Manipulation Playbook, you’ll gain the ability to work with complex business logic using the Data Manipulation Language (DML) of MariaDB. First, you’ll learn how to add new records into tables with the INSERT statement. Next, you’ll discover how to change existing records with the UPDATE statement. Finally, you’ll explore how to remove records with the DELETE and TRUNCATE statements. When you’re finished with this course, you’ll have the skills and knowledge of various elements of the data manipulation language of MariaDB to bring out meaningful results from your database. Software required: MariaDB
Table of contents
- Course Overview
- Understanding Data Manipulation Language (DML)
- Adding New Records into Tables with INSERT Statement
- Changing Existing Records with the UPDATE Statement
- Removing Records with Delete and Truncate Statement
- Summary
Advanced
Create MariaDB database objects, such as functions and stored procedures, to capture reusable query logic.
Capturing Logic with Stored Procedures in MariaDB
1h 8m
Description
Stored Procedures are very powerful for retrieving or updating data from tables, which is one of the most important routines for DBAs and developers when dealing with set-based operations.
In this course, Capturing Logic with Stored Procedures in MariaDB, you’ll gain the ability to work with complex business logic inside stored procedures.
First, you’ll learn how to create stored procedures.
Next, you’ll discover how to use various different parameters in stored procedures.
Finally, you’ll explore how to work with multiple stored procedures together and return various different information from the stored procedures.
When you’re finished with this course, you’ll have the skills and knowledge of stored procedures needed to work with complex business logic.
Software required: MariaDB
Table of contents
- Course Overview
- Getting Started with Stored Procedures
- Applying Parameters in Stored Procedures
- Returning Information from Stored Procedures
- Summary
MariaDB Functions Playbook
1h 41m
Description
To master any Relational Database Management System (RDBMS), it is important to learn elements of its data manipulations. In this course, MariaDB Functions Playbook, you’ll gain the ability to work with complex business logic using various built-in functions of MariaDB. First, you’ll learn how to work with information and date functions. Next, you’ll discover how to work with control flow functions and string functions. Finally, you’ll explore the aggregate and numeric scalar functions. When you’re finished with this course, you’ll have the skills and knowledge of various elements of the built-in functions of MariaDB to bring meaningful results for your business application. Software required: MariaDB
Table of contents
- Course Overview
- Understanding Information and Date Functions
- Implementing Control Flow Functions
- Working with String Functions
- Exploring Aggregate and Numeric Scalar Functions
- Summary