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.

1. Course Overview

1. Course Overview

2. Aggregating Results with GROUP BY

1. Version Check

2. Introduction

3. GROUP BY

4. Common Aggregate Functions

5. Demo - Common Aggregate Functions - Avg

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

7. Summary

3. Manipulating String and Numeric Column Fields

1. Introduction

2. Manipulating String and Numbers

3. Demo - Manipulating String Data

4. Demo - Manipulating Numeric Data

5. Summary

4. Using Common Table Expressions for Efficiency

1. Introduction

2. Common Table Expressions (CTEs)

3. Demo - Non-recursive CTE

4. Demo - Recursive CTE

5. Summary

5. Combining Data from Two or More Tables Using Joins

01. Introduction

02. SQL Join

03. Inner Join

04. Demo - Inner Join

05. Left Outer Join

06. Right Outer Join

07. Demo - Outer Join

08. Cross Join

09. Demo - Cross Join

10. Summary

6. Limiting Results with Windowing Functions

1. Introduction

2. Window Functions

3. Window Function Syntax

4. Demo - Ranking Window Function

5. Demo - Value Window Function

6. Demo - Aggregate Window Function

7. Summary

7. Combining Results Set of Multiple SELECT with UNION

1. Introduction

2. UNION Queries

3. Demo - Basics of UNION Queries

4. Demo - Real World Scenario for UNION Statement

5. Summary

8. Summary

1. Summary

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight