- Learning Path Libraries: This path is only available in the libraries listed. To access this path, purchase a license for the corresponding library.
- Data
Query Data with SQL in PostgreSQL
This learning path is actively in production. More content will be added to this page as it gets published and becomes available in the library. Planned content includes: 1. Query Data with SQL in PostgreSQL (video course) 2. Explore Patient Data with SQL in PostgreSQL (code lab) 3. Filter and Sort Data with SQL in PostgreSQL (video course) 4. Filter and Organize Enrollment Records with SQL in PostgreSQL (code lab) 5. Join and Combine Data with SQL in PostgreSQL (video course) 6. Combine Shipment and Inventory Data with SQL in PostgreSQL (code lab) 7. Group and Aggregate Data with SQL in PostgreSQL (video course) 8. Analyze Performance Metrics with Aggregates using SQL in PostgreSQL (code lab) 9 . Modify Data with SQL in PostgreSQL (video course) 10. Modify Customer Order Data with SQL in PostgreSQL (code lab) 11. Query Semi-structured Data with SQL in PostgreSQL (video course) 12. Write Reusable and Reliable Code with SQL in PostgreSQL (video course) PostgreSQL is a powerful open-source relational database system used by data analysts, engineers, and developers to store and query data efficiently. This path teaches you how to query, filter, and aggregate data using SQL within PostgreSQL, then progress to modifying, analyzing, and automating data tasks with advanced features like JSON, arrays, and user-defined functions. By the end, you’ll be able to write clear, performant, and production-ready SQL for real-world PostgreSQL environments.
Content in this path
Querying Foundations in PostgreSQL
Learn how PostgreSQL structures data and build a strong foundation in writing, filtering, and sorting SQL queries.
Combining and Analyzing Data in PostgreSQL
Learn how to join, aggregate, and analyze multi-table datasets in PostgreSQL to uncover insights and create meaningful reports.
Managing and Extending Data in PostgreSQL
Gain the skills to modify, automate, and extend PostgreSQL using transactions, semi-structured data, and procedural logic.
Try this learning path for free
What You'll Learn
- How to query data with SQL in PostgreSQL
- How to filter and sort data with SQL in PostgreSQL
- How to join and combine data with SQL in PostgreSQL
- How to group and aggregate data with SQL in PostgreSQL
- How to modify data with SQL in PostgreSQL
- How to query semi-structured data with SQL in PostgreSQL
- How to write reusable and reliable code with SQL in PostgreSQL
- Learners interested in this path should have a basic understanding of data concepts such as tables, rows, and columns, along with some familiarity with general SQL syntax. No prior PostgreSQL experience is required, but comfort with basic data analysis or database interaction will help.
- Relational databases
- Data analysis
- Data transformation
- Data aggregation
- SQL
Learn with the best
