Querying Data with SQL in MariaDB

Paths

Querying Data with SQL in MariaDB

Author: Pinal Dave

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

Related topics

Relational databases (PostgreSQL SQL Server OracleDB) Business Intelligence Platforms like Tableau Power BI Database use in web development

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

by Pinal Dave

Nov 7, 2019 / 59m

59m

Start Course
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
  1. Course Overview
  2. Understanding Data Query Language (DQL)
  3. Retrieve Specific Column Data from Table
  4. Retrieve Specific Row Data from Table
  5. Summary

Combining and Filtering Data with MariaDB

by Pinal Dave

Nov 8, 2019 / 2h 36m

2h 36m

Start Course
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
  1. Course Overview
  2. Aggregating Results with GROUP BY
  3. Manipulating String and Numeric Column Fields
  4. Using Common Table Expressions for Efficiency
  5. Combining Data from Two or More Tables Using Joins
  6. Limiting Results with Windowing Functions
  7. Combining Results Set of Multiple SELECT with UNION
  8. Summary

Intermediate

Insert, update, and delete data from MariaDB.

MariaDB Data Manipulation Playbook

by Pinal Dave

Nov 12, 2019 / 1h 34m

1h 34m

Start Course
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
  1. Course Overview
  2. Understanding Data Manipulation Language (DML)
  3. Adding New Records into Tables with INSERT Statement
  4. Changing Existing Records with the UPDATE Statement
  5. Removing Records with Delete and Truncate Statement
  6. Summary

Advanced

Create MariaDB database objects, such as functions and stored procedures, to capture reusable query logic.

Capturing Logic with Stored Procedures in MariaDB

by Pinal Dave

Nov 8, 2019 / 1h 8m

1h 8m

Start Course
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
  1. Course Overview
  2. Getting Started with Stored Procedures
  3. Applying Parameters in Stored Procedures
  4. Returning Information from Stored Procedures
  5. Summary

MariaDB Functions Playbook

by Pinal Dave

Nov 13, 2019 / 1h 41m

1h 41m

Start Course
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
  1. Course Overview
  2. Understanding Information and Date Functions
  3. Implementing Control Flow Functions
  4. Working with String Functions
  5. Exploring Aggregate and Numeric Scalar Functions
  6. Summary
Offer Code *
Email * First name * Last name *
Company
Title
Phone
Country *

* Required field

Opt in for the latest promotions and events. You may unsubscribe at any time. Privacy Policy

By providing my phone number to Pluralsight and toggling this feature on, I agree and acknowledge that Pluralsight may use that number to contact me for marketing purposes, including using autodialed or pre-recorded calls and text messages. I understand that consent is not required as a condition of purchase from Pluralsight.

By activating this benefit, you agree to abide by Pluralsight's terms of use and privacy policy.

I agree, activate benefit