Pluralsightbeginneren

Combining and Filtering Data with MariaDB

Learn to combine & filter relational database data for efficient results. Master data retrieval techniques to deliver valuable insights.

4.9(15)
2h 36m
Certificate
Pinal Dave
Pinal DaveInstructor

Course Content

Combining and Filtering Data with MariaDB is a beginner-level Pluralsight course taught by Pinal Dave. It runs 2h 36m, is taught in English, and includes a certificate of completion. Learners rate it 4.9 out of 5 from 15 reviews. It is a paid course, first published November 2019.

Unlock the power of MariaDB! This course, Combining and Filtering Data with MariaDB, equips you with essential skills to master complex data manipulation within the relational database environment.

Learn how to effectively work with multiple columns, fields, and tables to generate valuable insights for your users. You'll delve into powerful SQL techniques specifically tailored for MariaDB, one of the leading RDBMS systems.

Here's what you'll master:

  • Aggregate Data with GROUP BY: Discover how to summarize and analyze data using the GROUP BY clause for insightful reporting.
  • Manipulate Data Fields: Learn to effectively work with both string and numeric column fields within your MariaDB database.
  • Common Table Expressions (CTEs): Utilize CTEs to create temporary, named result sets for cleaner and more readable queries.
  • Union Queries: Combine the results of multiple queries into a single, unified result set using UNION.
  • Joins: Master various JOIN types to combine data from multiple tables based on related columns, creating comprehensive datasets.
  • Windowing Functions: Explore the use of windowing functions to perform calculations across a set of table rows that are related to the current row. This allows you to return meaningful results without collapsing rows.

By the end of this course, you'll possess the practical MariaDB SQL skills needed to tackle challenging business problems and extract maximum value from your data. Become proficient in data filtering, data combining, and advanced MariaDB techniques.

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.