Combining and Filtering Data with MariaDB

In this course, you'll explore and learn how you can combine and filter multiple areas of the relational database to build an efficient result for end users.
Course info
Level
Beginner
Updated
Nov 8, 2019
Duration
2h 36m
Table of contents
Description
Course info
Level
Beginner
Updated
Nov 8, 2019
Duration
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.

About the author
About the author

Pinal Dave is a Pluralsight Developer Evangelist.

More from the author
More courses by Pinal Dave
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Pinal Dave, and welcome to my course, Combining and Filtering Data with MariaDB. I'm a SQL permission expert at sqlauthority.com. MariaDB is the world's most widely used free and open source database. This course gives you a comprehensive view of major components of combining and filtering data with MariaDB. And this course requires no prior experience with MariaDB. Some of the major topics that we will cover include aggregating results with group by, manipulating string and numbering column fields using common table expressions for efficiency, combining data from two or more tables using joins, limiting results with windowing functions, combining result sets of multiple select with union. And finally, we will summarize all this in summary module. Many of the modules contains additional learning resources to strengthen your further learning. By the end of this course, you will have a solid foundation to get started with combining and filtering data with relational database, MariaDB. I hope you will join me on this journey to learn MariaDB with the Combining and Filtering Data with MariaDB course at Pluralsight.