Combining and Filtering Data with PostgreSQL
Offered By: Pluralsight
Course Description
Overview
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.
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.
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.
Syllabus
- 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
Taught by
Jason Browning
Related Courses
Introduction to DatabasesMeta via Coursera Web Development
Udacity Introduction to Data Science
University of Washington via Coursera Datenmanagement mit SQL
openHPI Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX