← Back to courses
Data Science and AI
SQL Queries Essentials
Two weeks to reading data out of a database yourself
A two-week classroom course on one chapter of the PostgreSQL 18 documentation — Queries — with the data-manipulation chapter beside it. You learn to select, filter, sort, join and group, and to insert, update and delete safely. This course prepares for no exam.
6Modules
BeginnerLevel
2 weeksDuration
COURSE THUMBNAIL
What you will be able to do
Write queries that filter, sort and join tables
Summarise data with GROUP BY
Change data without damaging it
Course outline
01
Tables, rows and a first SELECT
02
Filtering and sorting
03
Joining tables
04
Grouping and aggregates
05
Subqueries
06
Data manipulation: insert, update and delete
Tools you will use
PostgreSQLpsqlSQL
What you need
General computer skills
