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.
Author Name: Jason Browning, Ph.D.
Author Description:
Jason Browning is a data and analytics professional with extensive experience in both the public and private sector, currently serving as the chief data officer at Montana State University. 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 holds a Ph.D. in higher education administration from the University of Wy… more

Table of Contents

• Course Overview
  2mins
• Working with String Functions
  16mins
• Aggregating Functions
  13mins
• Exploring Join Types
  25mins
• Introducing Set Theory
  10mins
• Implementing Subqueries
  11mins
• Simplifying Queries with Common Table Expressions
  7mins
• Limiting Results with Window Functions
  18mins
• Wrapping Up
  10mins