Combining and Filtering Data with MariaDB

Focused View

Pinal Dave

2:36:23

45 View

1. Course Overview

1. Course Overview.mp4

01:27

2. Aggregating Results with GROUP BY

1. Version Check.mp4

00:15

2. Introduction.mp4

00:48

3. GROUP BY.mp4

02:42

4. Common Aggregate Functions.mp4

01:25

5. Demo - Common Aggregate Functions - Avg.mp4

06:42

6. Demo - Common Aggregate Functions - Sum, Min, Max, Count.mp4

06:21

7. Summary.mp4

01:18

3. Manipulating String and Numeric Column Fields

1. Introduction.mp4

00:52

2. Manipulating String and Numbers.mp4

01:15

3. Demo - Manipulating String Data.mp4

11:24

4. Demo - Manipulating Numeric Data.mp4

09:27

5. Summary.mp4

01:20

4. Using Common Table Expressions for Efficiency

1. Introduction.mp4

01:04

2. Common Table Expressions (CTEs).mp4

03:38

3. Demo - Non-recursive CTE.mp4

08:24

4. Demo - Recursive CTE.mp4

09:33

5. Summary.mp4

00:55

5. Combining Data from Two or More Tables Using Joins

01. Introduction.mp4

01:07

02. SQL Join.mp4

01:38

03. Inner Join.mp4

02:53

04. Demo - Inner Join.mp4

08:03

05. Left Outer Join.mp4

02:13

06. Right Outer Join.mp4

01:59

07. Demo - Outer Join.mp4

06:16

08. Cross Join.mp4

02:06

09. Demo - Cross Join.mp4

02:35

10. Summary.mp4

01:24

6. Limiting Results with Windowing Functions

1. Introduction.mp4

01:49

2. Window Functions.mp4

02:58

3. Window Function Syntax.mp4

01:19

4. Demo - Ranking Window Function.mp4

11:32

5. Demo - Value Window Function.mp4

07:06

6. Demo - Aggregate Window Function.mp4

07:04

7. Summary.mp4

01:17

7. Combining Results Set of Multiple SELECT with UNION

1. Introduction.mp4

01:19

2. UNION Queries.mp4

03:41

3. Demo - Basics of UNION Queries.mp4

07:57

4. Demo - Real World Scenario for UNION Statement.mp4

05:23

5. Summary.mp4

01:41

8. Summary

1. Summary.mp4

04:13

Description

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.

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Database Programming

Pinal Dave

Instructor's Courses

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 45 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at https://blog.sqlauthority.com.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.