Combining and Filtering Data with PostgreSQL 9

سرفصل های دوره

This course will teach you how to use PostgreSQL to expand your queries to filter and combine data. Using SQL, you’ll learn how to join data from multiple tables, combine result sets, and use aggregate and window functions.

1. Course Overview

1. Course Overview

2. Working with String Functions

1. Version Check

2. Overview

3. Introduction to Data Types

4. Concatenating Strings

5. Trimming Fields

6. Isolating Parts of a String

7. Changing Cases or Characters

8. Demo Applying String Functions

9. Summary

3. Aggregating Functions

1. Overview

2. Introduction to Numeric Data

3. Arithmetic Operators

4. Aggregate Functions

5. Aggregate Functions in Action

6. Filtering Aggregate Results

7. Summary

4. Exploring Join Types

1. Overview

2. Keys to the Relationship

3. Inner Joins

4. Table Aliases

5. Outer Joins

6. Full Joins

7. Implementing Joins

8. Summary

5. Introducing Set Theory

1. Overview

2. Concept of Set Theory

3. Unions

4. Intersections

5. Exceptions

6. Demo UNIONing Result Sets

7. Summary

6. Implementing Subqueries

1. Overview

2. Defining Subqueries

3. Subqueries and Joins

4. Demo Writing a Subquery

5. Correlated Subqueries

6. Demo Correlated Subquery in Action

7. Summary

7. Simplifying Queries with Common Table Expressions

1. Overview

2. Defining CTEs

3. CTEs and Subqueries

4. Demo Using a CTE

5. Recursive CTEs

6. Summary

8. Limiting Results with Window Functions

1. Overview

2. Defining the Window

3. Ranking and Numbering Rows

4. Demo Applying Rank Functions

5. Special Values and Reusing Windows

6. Lagging and Leading

7. Aggregate Window Functions

8. Order of Evaluation

9. Demo Lag and Window Function Calculation

10. Summary

9. Wrapping Up

1. Overview

2. Selecting Data to Explore

3. Joining Tables

4. Aggregating Results

5. Applying Set Theory

6. Using a Subquery

7. Simplifying Queries with CTEs

8. Correlating a Subquery

9. Ranking our Results

10. Applying String Functions

11. Summary

45,900 تومان

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

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

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

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