OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Pluralsight logo

Combining and Filtering Data with PostgreSQL 9

Jason Browning, Ph.D.

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.

Read more

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.

Enroll now

What's inside

Syllabus

Course Overview
Working with String Functions
Aggregating Functions
Exploring Join Types
Read more
Introducing Set Theory
Implementing Subqueries
Simplifying Queries with Common Table Expressions
Limiting Results with Window Functions
Wrapping Up

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Introduces learners to essential SQL skills necessary for more complex database querying
Helps learners analyze data from multiple sources through comprehensive queries
Starts with the basics and gradually introduces more advanced concepts
Taught by Dr. Jason Browning, who has extensive experience and expertise in data analysis and PostgreSQL
Leverages a mix of videos, readings, and interactive materials to enhance understanding

Save this course

Save Combining and Filtering Data with PostgreSQL 9 to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Combining and Filtering Data with PostgreSQL 9 with these activities:
Form a study group with classmates to discuss PostgreSQL concepts
Enhance your understanding through collaboration by engaging in discussions with peers.
Browse courses on PostgreSQL
Show steps
  • Identify classmates who are interested in forming a study group.
  • Schedule regular meetings and set a clear agenda for each session.
  • Take turns presenting concepts and leading discussions.
  • Work together to solve problems and clarify misunderstandings.
  • Provide constructive feedback and support to group members.
Review SQL fundamentals
Refresh your knowledge of basic SQL syntax and concepts to ensure a strong foundation for this course.
Browse courses on SQL
Show steps
  • Review online tutorials on basic SQL syntax
  • Practice writing simple SQL queries
Solve PostgreSQL aggregate function exercises
Strengthen your proficiency in using aggregate functions through dedicated practice exercises.
Browse courses on PostgreSQL
Show steps
  • Find online resources or textbooks that provide PostgreSQL aggregate function exercises.
  • Set aside specific time for practicing these exercises.
  • Solve the exercises and verify your answers using the provided solutions or documentation.
  • Focus on understanding the syntax and logic behind each aggregate function.
  • Repeat the exercises until you feel confident in your abilities.
Eight other activities
Expand to see all activities and additional details
Show all 11 activities
Review 'PostgreSQL: A Comprehensive Guide' by Simon Riggs
Clarify the concepts and commands introduced in the course with this foundational reference text on the subject of PostgreSQL.
View PostgreSQL 16 Administration Cookbook: Solve... on Amazon
Show steps
  • Acquire a copy of the book.
  • Set aside specific blocks of time for reading and studying.
  • Read the introduction and the early chapters to get an overview of PostgreSQL and its key concepts.
  • Review the chapters relevant to the specific topics covered in the course.
  • Take notes and highlight important passages for future reference.
Solve SQL exercises
Reinforce your understanding of SQL concepts by working through exercises and practice problems.
Browse courses on Database Queries
Show steps
  • Find online SQL exercises and practice problems
  • Solve exercises and review solutions
  • Identify areas for improvement and focus on those
Follow tutorials on PostgreSQL joins
Reinforce your understanding of joins by completing guided tutorials that demonstrate practical applications.
Browse courses on PostgreSQL
Show steps
  • Search online for tutorials on PostgreSQL joins.
  • Identify tutorials that are relevant to your skill level and learning objectives.
  • Follow the steps outlined in the tutorials.
  • Practice implementing joins in your own queries.
  • Review the documentation and examples provided by PostgreSQL.
Attend a PostgreSQL workshop on advanced filtering techniques
Enhance your filtering skills by participating in a workshop led by experienced PostgreSQL professionals.
Browse courses on PostgreSQL
Show steps
  • Research and identify relevant PostgreSQL workshops.
  • Register for the workshop that aligns with your learning goals.
  • Attend the workshop and actively participate in the sessions.
  • Take notes and ask questions to clarify concepts.
  • Apply the techniques learned in your own PostgreSQL queries.
Create a data visualization
Solidify your understanding of data analysis and PostgreSQL's capabilities by creating a data visualization using the concepts covered in the course.
Browse courses on Data Visualization
Show steps
  • Choose a dataset and identify key insights
  • Select appropriate visualization techniques
  • Create the visualization using PostgreSQL and visualization tools
  • Analyze and interpret the results
Write blog posts on PostgreSQL window functions
Solidify your understanding of window functions by explaining them in your own words and providing examples.
Browse courses on PostgreSQL
Show steps
  • Research window functions in PostgreSQL.
  • Identify different types of window functions and their applications.
  • Write blog posts explaining the concepts and providing practical examples.
  • Share your blog posts with others or post them on online forums.
  • Engage in discussions and answer questions related to window functions.
Participate in PostgreSQL query optimization challenges
Test your query optimization abilities against other PostgreSQL users and receive valuable feedback.
Browse courses on PostgreSQL
Show steps
  • Identify online platforms or communities that host PostgreSQL query optimization challenges.
  • Register for the challenge and download the provided dataset.
  • Analyze the dataset and design efficient queries.
  • Submit your queries and compare your results with others.
  • Review feedback and learn from the techniques used by top performers.
Build a data analysis dashboard using PostgreSQL and a visualization tool
Apply your PostgreSQL skills in a practical project to create a meaningful data visualization dashboard.
Browse courses on PostgreSQL
Show steps
  • Define the purpose and scope of your dashboard.
  • Gather and prepare the necessary data from PostgreSQL.
  • Choose an appropriate visualization tool and connect it to your data source.
  • Design and implement interactive visualizations to represent your data.
  • Deploy and share your dashboard with stakeholders or users.

Career center

Learners who complete Combining and Filtering Data with PostgreSQL 9 will develop knowledge and skills that may be useful to these careers:
Data Analyst
A Data Analyst is a professional that uses data to solve problems, answer questions, and provide insights. Data Analysts work in a variety of industries, including finance, healthcare, retail, and government. They use a variety of tools and techniques, including SQL, to analyze data from various sources. The Combining and Filtering Data with PostgreSQL 9 course is a great way to learn the basics of SQL and how to use it to analyze data. This course can help you develop the skills you need to become a successful Data Analyst.
See salaries and explore the career path for Data Analyst
Data Engineer
A Data Engineer is a professional who designs, builds, and maintains data systems. Data Engineers work with data scientists, data analysts, and other data professionals to ensure that data is reliable, accessible, and secure. They use a variety of tools and techniques, including SQL, to manage and analyze data. The Combining and Filtering Data with PostgreSQL 9 course is a great way to learn the basics of SQL and how to use it to manage and analyze data. This course can help you develop the skills you need to become a successful Data Engineer.
See salaries and explore the career path for Data Engineer
Database Administrator
A Database Administrator (DBA) is a professional who manages and maintains databases. DBAs work with data engineers, data scientists, and other data professionals to ensure that databases are running smoothly and efficiently. They use a variety of tools and techniques, including SQL, to manage and analyze data. The Combining and Filtering Data with PostgreSQL 9 course is a great way to learn the basics of SQL and how to use it to manage and analyze data. This course can help you develop the skills you need to become a successful DBA.
See salaries and explore the career path for Database Administrator
Data Scientist
A Data Scientist is a professional who uses data to solve problems, answer questions, and provide insights. Data Scientists work in a variety of industries, including finance, healthcare, retail, and government. They use a variety of tools and techniques, including SQL, to analyze data from various sources. The Combining and Filtering Data with PostgreSQL 9 course is a great way to learn the basics of SQL and how to use it to analyze data. This course can help you develop the skills you need to become a successful Data Scientist.
See salaries and explore the career path for Data Scientist
Statistician
A Statistician is a professional who uses data to solve problems, answer questions, and provide insights. Statisticians work in a variety of industries, including finance, healthcare, retail, and government. They use a variety of tools and techniques, including SQL, to analyze data from various sources. The Combining and Filtering Data with PostgreSQL 9 course is a great way to learn the basics of SQL and how to use it to analyze data. This course can help you develop the skills you need to become a successful Statistician.
See salaries and explore the career path for Statistician
Business Analyst
A Business Analyst is a professional who uses data to solve business problems. Business Analysts work with businesses to identify their needs and develop solutions. They use a variety of tools and techniques, including SQL, to analyze data and develop recommendations. The Combining and Filtering Data with PostgreSQL 9 course is a great way to learn the basics of SQL and how to use it to analyze data. This course can help you develop the skills you need to become a successful Business Analyst.
See salaries and explore the career path for Business Analyst
Market Researcher
A Market Researcher is a professional who uses data to understand consumer behavior. Market Researchers work with businesses to identify their target market and develop marketing strategies. They use a variety of tools and techniques, including SQL, to analyze data and develop recommendations. The Combining and Filtering Data with PostgreSQL 9 course is a great way to learn the basics of SQL and how to use it to analyze data. This course can help you develop the skills you need to become a successful Market Researcher.
See salaries and explore the career path for Market Researcher
Financial Analyst
A Financial Analyst is a professional who uses data to make investment decisions. Financial Analysts work with businesses and investors to analyze financial data and develop recommendations. They use a variety of tools and techniques, including SQL, to analyze data and develop recommendations. The Combining and Filtering Data with PostgreSQL 9 course is a great way to learn the basics of SQL and how to use it to analyze data. This course can help you develop the skills you need to become a successful Financial Analyst.
See salaries and explore the career path for Financial Analyst
Software Engineer
A Software Engineer is a professional who designs, develops, and maintains software applications. Software Engineers work with businesses to develop software solutions that meet their needs. They use a variety of tools and techniques, including SQL, to develop and maintain software applications. The Combining and Filtering Data with PostgreSQL 9 course is a great way to learn the basics of SQL and how to use it to develop and maintain software applications. This course can help you develop the skills you need to become a successful Software Engineer.
See salaries and explore the career path for Software Engineer
Computer Scientist
A Computer Scientist is a professional who studies the theory and practice of computation. Computer Scientists work with computers to develop new technologies and solve problems. They use a variety of tools and techniques, including SQL, to develop and maintain software applications. The Combining and Filtering Data with PostgreSQL 9 course is a great way to learn the basics of SQL and how to use it to develop and maintain software applications. This course can help you develop the skills you need to become a successful Computer Scientist.
See salaries and explore the career path for Computer Scientist
Data Analytics Manager
A Data Analytics Manager is a professional who manages and oversees data analytics teams. Data Analytics Managers work with businesses to develop and implement data analytics solutions. They use a variety of tools and techniques, including SQL, to manage and oversee data analytics teams. The Combining and Filtering Data with PostgreSQL 9 course is a great way to learn the basics of SQL and how to use it to manage and oversee data analytics teams. This course can help you develop the skills you need to become a successful Data Analytics Manager.
See salaries and explore the career path for Data Analytics Manager
Database Architect
A Database Architect is a professional who designs and develops database systems. Database Architects work with businesses to develop and implement database solutions. They use a variety of tools and techniques, including SQL, to design and develop database systems. The Combining and Filtering Data with PostgreSQL 9 course is a great way to learn the basics of SQL and how to use it to design and develop database systems. This course can help you develop the skills you need to become a successful Database Architect.
See salaries and explore the career path for Database Architect
Information Systems Manager
An Information Systems Manager is a professional who manages and maintains information systems. Information Systems Managers work with businesses to develop and implement information systems solutions. They use a variety of tools and techniques, including SQL, to manage and maintain information systems. The Combining and Filtering Data with PostgreSQL 9 course is a great way to learn the basics of SQL and how to use it to manage and maintain information systems. This course can help you develop the skills you need to become a successful Information Systems Manager.
See salaries and explore the career path for Information Systems Manager
Quantitative Analyst
A Quantitative Analyst is a professional who uses data to make investment decisions. Quantitative Analysts work with businesses and investors to analyze financial data and develop recommendations. They use a variety of tools and techniques, including SQL, to analyze data and develop recommendations. The Combining and Filtering Data with PostgreSQL 9 course is a great way to learn the basics of SQL and how to use it to analyze data. This course can help you develop the skills you need to become a successful Quantitative Analyst.
See salaries and explore the career path for Quantitative Analyst
Risk Analyst
A Risk Analyst is a professional who uses data to identify and assess risks. Risk Analysts work with businesses to identify and assess risks to their business. They use a variety of tools and techniques, including SQL, to identify and assess risks. The Combining and Filtering Data with PostgreSQL 9 course is a great way to learn the basics of SQL and how to use it to identify and assess risks. This course can help you develop the skills you need to become a successful Risk Analyst.
See salaries and explore the career path for Risk Analyst

Reading list

We've selected six books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Combining and Filtering Data with PostgreSQL 9.
Cover image
Database Systems: The Complete Book
Save
Provides a comprehensive overview of database systems. It covers a wide range of topics, from data models to query processing.
Database Systems: The Complete Book
Kindle Edition
$$$
Database Systems The Complete Book
Paperback
$$
Database Systems: The Complete Book
Hardcover
$$$$
Goal Student Access Code Card for Database Systems:...
Printed Access Code
$$
Cover image
Hadoop: The Definitive Guide
Save
Provides a comprehensive overview of Hadoop. It covers a wide range of topics, from data storage to data processing. Serves as a foundational reference or background reading for those interested in expanding upon their knowledge of Hadoop after the course.
Hadoop: The Definitive Guide: Storage and Analysis...
Paperback
$$
Hadoop: The Definitive Guide
Kindle Edition
$$
Hadoop: The Definitive Guide
Paperback
$$
Hadoop: The Definitive Guide
Paperback
$$
Cover image
Data Science for Business
Save
Provides a practical introduction to data science for business. It covers a wide range of topics, from data collection to model deployment.
Data Science for Business: What You Need to Know...
Paperback
$$
Data Science for Business: What You Need to Know...
Kindle Edition
$$
Cover image
PostgreSQL: Up and Running
Save
Provides a comprehensive overview of PostgreSQL, including installation, configuration, and administration. It good choice for foundational knowledge before taking the course.
PostgreSQL: Up and Running
Paperback
Check
PostgreSQL: Up and Running
Kindle Edition
Check
Cover image
SQL and Relational Theory
Save
Covers the theoretical underpinnings of SQL, including relational theory. It good choice for those who want to understand the 'why' behind SQL syntax.
SQL and Relational Theory
Paperback
Check
SQL and Relational Theory
Kindle Edition
Check
Cover image
PostgreSQL 16 Administration Cookbook
Save
Provides practical recipes for administering PostgreSQL databases. It useful reference for those who need to manage PostgreSQL databases on a day-to-day basis.
PostgreSQL 16 Administration Cookbook: Solve real...
Kindle Edition
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Combining and Filtering Data with PostgreSQL 9.
Learn SQL Using PostgreSQL: From Zero to Hero
Most relevant
Querying Data from PostgreSQL
Most relevant
SQL Mathematical Functions
Most relevant
SQL Window Functions for Analytics
Most relevant
SQL CASE Statements
Most relevant
Querying Data with SQL Server
Most relevant
SQL Date Time Functions
Most relevant
Handling Batch Data with Apache Spark on Databricks
Most relevant
C# 9 Language-Integrated Query (LINQ)
Most relevant
Course image
Time
117 hours
Level
Introductory
Via
Pluralsight
Instructor
Jason Browning, Ph.D.
Language
English
This course belongs to a collection called Querying Data with SQL from PostgreSQL. It's comprised of five courses:
  1. Querying Data from PostgreSQL
  2. Combining and Filtering Data with PostgreSQL 9 (viewing)
  3. PostgreSQL Data Manipulation Playbook
  4. PostgreSQL Functions Playbook
  5. Capturing Logic with Custom Functions in PostgreSQL
Good to know
Introduces learners to essential SQL skills necessary for more complex database querying
Helps learners analyze data from multiple sources through comprehensive queries
Starts with the basics and gradually introduces more advanced concepts
Taught by Dr. Jason Browning, who has extensive experience and expertise in data analysis and PostgreSQL
Leverages a mix of videos, readings, and interactive materials to enhance understanding
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser