Querying Data from PostgreSQL

In this course, you'll learn how to use PostgreSQL to author queries that retrieve information from databases. Using SQL, you'll learn how to select the data you need, filter that data, and gather data from various tables.
Course info
Rating
(10)
Level
Beginner
Updated
Mar 6, 2019
Duration
1h 29m
Table of contents
Description
Course info
Rating
(10)
Level
Beginner
Updated
Mar 6, 2019
Duration
1h 29m
Description

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, Querying Data from 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.

About the author
About the author

Jason Browning is a data and analytics professional, and loves to solve complex business problems by using Tableau as a visualization tool and SQL to query complex data.

More from the author
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello everyone. My name is Jason Browning, and I'm the Director of Data Analytics at the University of Tulsa. Welcome to my course, Querying Data from PostgreSQL. SQL is the primary language used to work with databases, and PostgreSQL is the leading open-source database platform. These are fundamental building blocks to retrieving data and performing more advanced analyses. This course is an introduction to writing queries with SQL and uses the PostgreSQL environment. No prior knowledge of either is required. Some of the major topics that we will cover include structure of relational databases, how are data organized in a database; retrieving data from databases, how do we get the data that we need; limiting results, filtering results can make them more useful and relevant to you; and combining multiple tables, how to connect and use related data across various tables. By the end of this course, you'll have a solid foundation to start writing your own queries and working with data using SQL. Although the course is based in Postgres, much of what you learn will be applicable to any relational database platform. I hope you'll join me on this journey to learn PostgreSQL with the Querying Data from PostgreSQL course, at Pluralsight.