course
PostgreSQL Querying Fundamentals
Learn how to retrieve the data you need from a PostgreSQL database using SQL.
Description
You will build practical PostgreSQL querying skills from the ground up. Starting with SELECT and FROM, you will quickly move into filtering with WHERE, combining conditions with AND and OR, sorting with ORDER BY, and joining data across multiple tables. You will also shape results with CASE expressions, built-in text and date functions, and grouping and aggregation using GROUP BY and HAVING. By the end, you will confidently use subqueries for real query scenarios and apply core data modification statements.
Learning Goals
 Write clear, structured and documented queries | Apply  |
| Apply filters and ordering to query results | Apply |
| Use joins to retrieve columns from multiple tables | Apply |
| Apply built-in functions or CASE statements to query results | Apply |
| Produce queries to group and aggregate rows, and filter on groups | Apply |
| Use functions to modify text, date and time | Apply |
| Use subqueries for complex scenarios | Apply |
| Differentiate between the statements to insert, update or delete rows | Understand  |
Prior Knowledge
- Basic understanding of data in tables (rows and columns)
Subjects
- Querying Data with PostgreSQL
- The SELECT Statement
- Joining Tables
- CASE Expressions
- NULL and Data Conversion
- Grouping and Aggregating
- Subqueries
- Built-in Functions
- Data Manipulation Language (DML)
Querying Data with PostgreSQL
- Query structure and execution order
The SELECT Statement
- Selecting, filtering, and sorting data
- Aliases, DISTINCT, operators, and LIKE
- LIMIT and OFFSET
Joining Tables
- JOIN types and combining multiple tables
- Self joins and legacy join syntax
CASE Expressions
- Simple and searched CASE
NULL and Data Conversion
- NULL behavior and COALESCE
- Data types, implicit and explicit conversion
- Text functions
Grouping and Aggregating
- Aggregate functions and GROUP BY
- Filtering groups with HAVING
Subqueries
- Self-contained and correlated subqueries
- EXISTS and NOT EXISTS
Built-in Functions
- Mathematical, date, and time functions
Data Manipulation Language (DML)
- INSERT, UPDATE, and DELETE
Schedule
All courses can also be conducted within your organization as customized or incompany training.
Our training advisors are happy to help you provide personal advice or find Incompany training within your organization.
Follow-up courses
"This training was immediately applicable to the project"Attendee
-
Hoge waardering
-
Praktijkgerichte trainingen
-
Gecertificeerde trainers
-
Eigen docenten