Combining and Filtering Data with MariaDB from Pluralsight

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.

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.

What's inside

Syllabus

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

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Focuses on teaching relational database features of MariaDB, which is a sophisticated and widely used relational database management system

Covers various SQL features and concepts, including aggregation, manipulation of string and numeric column fields, use of common table expressions, joins, windowing functions, and combining results of multiple SELECT statements with UNION

Suitable for learners who have a basic understanding of SQL and relational database concepts

Can help learners develop skills in working with complex business logic using SQL and MariaDB

May be particularly beneficial for those working with MariaDB in a professional setting

Does not appear to cover advanced topics such as database design, performance optimization, or data security

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Combining and Filtering Data with MariaDB with these activities:

Organize and Review Course Materials

Show steps

Stay organized and enhance your retention by compiling and reviewing course materials.

Show steps

Create a dedicated folder or notebook for the course.
Regularly download and organize lecture slides, notes, assignments, and other materials.
Review the materials periodically to reinforce your understanding.
Make annotations or summaries to highlight key concepts.

Review Relational Database Management

Show steps

Refresh your knowledge of relational database management concepts to strengthen your foundation for this course.

Show steps

Review the basics of relational database theory, including data models, normalization, and query languages.
Practice creating and managing relational databases using a database management system.
Review SQL syntax and practice writing queries to retrieve and manipulate data.

Database Query Practice

Show steps

Reinforce your understanding of SQL queries by solving practice problems.

Show steps

Find a set of SQL practice problems online or in a textbook.
Attempt to solve the problems on your own, using the SQL syntax and concepts you have learned.
Check your answers against the provided solutions and identify areas where you need further practice.

Three other activities

Expand to see all activities and additional details

Show all six activities

Follow Tutorials on Advanced SQL Techniques

Show steps

Enhance your SQL skills by following tutorials that cover advanced techniques, such as window functions, stored procedures, and user-defined functions.

Show steps

Identify a specific advanced SQL technique that you want to learn.
Search for tutorials or online courses that cover that technique.
Follow the tutorial step-by-step and practice the techniques in your own database.

Develop a Database Design and Implementation Plan

Show steps

Apply your knowledge of database design and implementation to create a plan for a real-world database project.

Browse courses on Database Design

Show steps

Identify a business problem or scenario that requires a database solution.
Design the database schema, including tables, columns, relationships, and constraints.
Develop a detailed implementation plan, outlining the steps required to create and populate the database.

Contribute to an Open-Source Database Project

Show steps

Gain practical experience and contribute to the database community by participating in an open-source database project.

Show steps

Find an open-source database project that aligns with your interests or skillset.
Review the project's documentation and codebase.
Identify an area where you can contribute, such as bug fixes, feature enhancements, or documentation improvements.
Submit your contributions to the project's repository.

Career center

Learners who complete Combining and Filtering Data with MariaDB will develop knowledge and skills that may be useful to these careers:

Data Analyst

A Data Analyst helps businesses make better decisions by analyzing and interpreting data. The skills you will learn in this course, such as combining and filtering data, are essential for success in this role. This course will help you develop the skills you need to extract meaningful insights from data, which can be used to improve business operations, customer satisfaction, and product development.

See salaries and explore the career path for Data Analyst

Data Scientist

A Data Scientist uses scientific methods to extract knowledge and insights from data. The skills you will learn in this course, such as combining and filtering data, are essential for success in this role. This course will help you develop the skills you need to build predictive models, identify trends, and develop solutions to business problems.

See salaries and explore the career path for Data Scientist

Database Administrator

A Database Administrator manages and maintains databases. The skills you will learn in this course, such as combining and filtering data, are essential for success in this role. This course will help you develop the skills you need to design, implement, and manage databases, as well as to recover data in the event of a system failure.

See salaries and explore the career path for Database Administrator

Data Engineer

A Data Engineer builds and maintains data pipelines. The skills you will learn in this course, such as combining and filtering data, are essential for success in this role. This course will help you develop the skills you need to design, implement, and manage data pipelines, as well as to ensure that data is accurate and reliable.

See salaries and explore the career path for Data Engineer

Business Intelligence Analyst

A Business Intelligence Analyst uses data to improve business processes. The skills you will learn in this course, such as combining and filtering data, are essential for success in this role. This course will help you develop the skills you need to gather, analyze, and interpret data, and to make recommendations for improvements to business processes.

See salaries and explore the career path for Business Intelligence Analyst

Computer Systems Analyst

A Computer Systems Analyst designs, implements, and maintains computer systems. The skills you will learn in this course, such as combining and filtering data, may be useful in this role. This course can help you develop the skills you need to analyze business needs, design and implement computer systems, and evaluate the performance of computer systems.

See salaries and explore the career path for Computer Systems Analyst

Software Engineer

In this role, a Software Engineer designs, develops, and maintains software applications. The skills you will learn in this course, such as combining and filtering data, may be useful in this role. This course will help you develop the skills you need to write efficient and reliable code, as well as to design and implement software applications.

See salaries and explore the career path for Software Engineer

Information Technology Specialist

An Information Technology Specialist provides technical support to users of computer systems. The skills you will learn in this course, such as combining and filtering data, may be useful in this role. This course will help you develop the skills you need to troubleshoot computer problems, install and maintain software, and provide customer service.

See salaries and explore the career path for Information Technology Specialist

Database Manager

A Database Manager manages and maintains databases. The skills you will learn in this course, such as combining and filtering data, may be useful in this role. This course will help you develop the skills you need to design, implement, and manage databases, as well as to recover data in the event of a system failure.

See salaries and explore the career path for Database Manager

Business Analyst

A Business Analyst analyzes business processes and develops solutions to improve business performance. The skills you will learn in this course, such as combining and filtering data, may be useful in this role. This course will help you develop the skills you need to understand business processes, identify and analyze problems, and develop and implement solutions.

See salaries and explore the career path for Business Analyst

Web Developer

A Web Developer designs and develops websites. The skills you will learn in this course, such as combining and filtering data, may be useful in this role. This course can help you develop the skills you need to design and develop websites, as well as to implement and maintain web applications.

See salaries and explore the career path for Web Developer

Network Administrator

A Network Administrator manages and maintains computer networks. The skills you will learn in this course, such as combining and filtering data, may be useful in this role. This course will help you develop the skills you need to design, implement, and maintain computer networks, as well as to troubleshoot and resolve network problems.

See salaries and explore the career path for Network Administrator

Information Security Analyst

An Information Security Analyst protects computer systems and networks from unauthorized access. The skills you will learn in this course, such as combining and filtering data, may be useful in this role. This course will help you develop the skills you need to identify and mitigate security risks, as well as to investigate and respond to security incidents.

See salaries and explore the career path for Information Security Analyst

Systems Administrator

A Systems Administrator manages and maintains computer systems and networks. The skills you will learn in this course, such as combining and filtering data, may be useful in this role. This course will help you develop the skills you need to install, configure, and maintain computer systems and networks, as well as to troubleshoot and resolve problems.

See salaries and explore the career path for Systems Administrator

Data Warehouse Architect

A Data Warehouse Architect designs and builds data warehouses. The skills you will learn in this course, such as combining and filtering data, may be useful in this role. This course will help you develop the skills you need to design and build data warehouses, as well as to manage and maintain data warehouses.

See salaries and explore the career path for Data Warehouse Architect