Combining and Filtering Data with PostgreSQL 9

Focused View

Jason Browning, Ph.D.

1:57:26

51 View

1. Course Overview

1. Course Overview.mp4

02:16

2. Working with String Functions

1. Version Check.mp4

00:15

2. Overview.mp4

00:40

3. Introduction to Data Types.mp4

02:06

4. Concatenating Strings.mp4

03:10

5. Trimming Fields.mp4

02:18

6. Isolating Parts of a String.mp4

03:24

7. Changing Cases or Characters.mp4

01:28

8. Demo Applying String Functions.mp4

02:42

9. Summary.mp4

00:38

3. Aggregating Functions

1. Overview.mp4

00:39

2. Introduction to Numeric Data.mp4

02:00

3. Arithmetic Operators .mp4

02:15

4. Aggregate Functions.mp4

02:59

5. Aggregate Functions in Action.mp4

03:10

6. Filtering Aggregate Results.mp4

01:57

7. Summary.mp4

00:42

4. Exploring Join Types

1. Overview .mp4

01:01

2. Keys to the Relationship.mp4

01:50

3. Inner Joins.mp4

04:35

4. Table Aliases.mp4

02:57

5. Outer Joins.mp4

05:18

6. Full Joins.mp4

01:45

7. Implementing Joins.mp4

06:27

8. Summary.mp4

01:18

5. Introducing Set Theory

1. Overview.mp4

00:29

2. Concept of Set Theory.mp4

01:28

3. Unions.mp4

02:56

4. Intersections.mp4

01:34

5. Exceptions.mp4

02:15

6. Demo UNIONing Result Sets.mp4

01:11

7. Summary.mp4

00:37

6. Implementing Subqueries

1. Overview.mp4

00:33

2. Defining Subqueries.mp4

02:11

3. Subqueries and Joins.mp4

01:50

4. Demo Writing a Subquery.mp4

01:18

5. Correlated Subqueries.mp4

03:27

6. Demo Correlated Subquery in Action.mp4

01:57

7. Summary.mp4

00:31

7. Simplifying Queries with Common Table Expressions

1. Overview.mp4

00:36

2. Defining CTEs.mp4

01:17

3. CTEs and Subqueries.mp4

00:54

4. Demo Using a CTE.mp4

02:38

5. Recursive CTEs .mp4

01:45

6. Summary.mp4

00:30

8. Limiting Results with Window Functions

1. Overview.mp4

00:47

2. Defining the Window.mp4

01:31

3. Ranking and Numbering Rows .mp4

03:25

4. Demo Applying Rank Functions.mp4

02:44

5. Special Values and Reusing Windows.mp4

02:59

6. Lagging and Leading.mp4

01:22

7. Aggregate Window Functions.mp4

01:50

8. Order of Evaluation.mp4

01:36

9. Demo Lag and Window Function Calculation.mp4

01:56

10. Summary.mp4

00:44

9. Wrapping Up

1. Overview.mp4

00:27

2. Selecting Data to Explore.mp4

00:38

3. Joining Tables.mp4

00:30

4. Aggregating Results .mp4

01:46

5. Applying Set Theory.mp4

01:02

6. Using a Subquery.mp4

00:53

7. Simplifying Queries with CTEs.mp4

01:02

8. Correlating a Subquery.mp4

01:36

9. Ranking our Results.mp4

01:24

10. Applying String Functions.mp4

01:09

11. Summary.mp4

00:18

Description

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.

What You'll Learn?

In this course, Combining and Filtering Data with PostgreSQL 9, you will learn how to expand your queries to retrieve additional data and achieve your desired results. First, you will learn the fundamentals of data types and how to work with string functions. Next, you will discover aggregate functions and how to filter aggregate results. Then, you will explore how to use joins to retrieve data from multiple tables. Set theory and unions will also be used to combine multiple result sets. Subqueries and common table expressions are introduced to help conduct more sophisticated analyses using multiple filter criteria. Finally, you will figure out window functions and how to partition and analyze data. When you’re finished with this course, you will have the skills and knowledge of PostgreSQL necessary to begin writing more complex queries to analyze data from multiple sources.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

PostgreSQL

Database Programming

Jason Browning, Ph.D.

Instructor's Courses

Jason Browning is a data and analytics professional with extensive experience in both the public and private sector. As a Tableau Desktop Certified Professional, Jason loves to build data visualizations that both inform and inspire. He is capable of wrangling messy data both inside and outside of Tableau, and using SQL to perform complex queries. He works in higher education as a data governance and management consultant, and holds a Ph.D. in higher education administration from the University of Wyoming. He loves to interrogate information systems with SQL to answer business questions and satisfy his data consumers. Jason lives in the Seattle area with his wife and two canine companions, and loves to get outdoors or do woodworking. Even in these pursuits, he is looking for the next data viz inspiration!

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.