- Course
Query Data with SQL in PostgreSQL
SQL is a foundational tool in the data analyst toolkit. This course will introduce you to SQL, the foundational tool used to query and retrieve data from relational data sources and databases.
Beginner
- Course
Query Data with SQL in PostgreSQL
SQL is a foundational tool in the data analyst toolkit. This course will introduce you to SQL, the foundational tool used to query and retrieve data from relational data sources and databases.
Beginner
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
SQL is the foundational tool to retrieve data from relational data sources. While each organization will have its own database preference, data analysts will benefit from knowing the basics of querying data from PostgreSQL, a popular open-source database platform. In this course, Query Data with SQL in PostgreSQL, you will get a comprehensive introduction of how to query data using PostgreSQL and its pgAdmin tool. First, you will learn the basic structure of a relational database. Next, you will discover how to select data from tables, apply criteria and filters to limit your results, and enhance these skills by retrieving data from multiple tables. Finally, you will explore basic aggregation functions and be exposed to ANSI-compliant SQL. When you're finished with this course, you will have the skills and knowledge of PostgreSQL necessary to easily retrieve data from relational databases.
Query Data with SQL in PostgreSQL
Beginner
Table of contents
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.
