- Learning Path Libraries: This path is only available in the libraries listed. To access this path, purchase a license for the corresponding library.
- Data
Querying Data with SQL from PostgreSQL
5 Courses
10 Hours
Skill IQ
SQL (“sequel” or Structured Query Language) is a common language used to query and manage data in relational database and data stream management systems. This skill will teach you how to use SQL to query data from the PostgreSQL relational database.
Content in this path
Beginner
Learn to use the SELECT statement, along with JOINs and WHERE clasues, to create organized projections of data stored in PostgreSQL.
Intermediate
Insert, update, and delete data from PostgreSQL.
Advanced
Create PostgreSQL database objects, such as functions to capture reusable query logic.
Try this learning path for free
Access this learning path and other top-rated tech content with a free
trial.
Have questions? Get them answered now.
What You'll Learn
- Querying data with the SELECT statement
- Filtering data with the WHERE clause
- Combining data with JOINs
- Aggregating data
- Inserting, updating, and deleting data
Prerequisites
- Relational database literacy
Related topics
- Relational databases (SQL Server
- MariaDB
- OracleDB)
- Database administration
- Database development
- Business Intelligence Platforms like Tableau
- Power BI
- Database use in web development
Not sure where to start?
With over 500 assessments to choose from, you can see where your skills
stand and receive adaptive learning recommendations to fill knowledge gaps in as little as 10 minutes.
Learn more