- 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
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
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
- Relational database literacy
- Relational databases (SQL Server
- MariaDB
- OracleDB)
- Database administration
- Database development
- Business Intelligence Platforms like Tableau
- Power BI
- Database use in web development


