Your First SELECT
Selecting Specific Columns
Column Aliases with AS
Expressions in SELECT
DISTINCT Values
Comments in SQL
© 2026 Dometrain. All rights reserved.
Learn PostgreSQL through hands-on coding exercises. Practice what you learn with interactive challenges designed for every level.
PostgreSQL is by far the most popular database according to the latest StackOverflow annual survey, and for good reason. It is free, open source, and extremely powerful, powering millions of websites and services. In fact, it is what we use here at Dometrain to achieve incredible database performance with amazing feature flexibility. This hands-on lab course will teach you PostgreSQL from scratch, all the way to some of its more advanced features, by having you complete exercises on our PostgreSQL web editor with explanations and AI-assisted learning.
I enjoyed completing small excercises and i have also found out new things about postgresql.
I learned about LATERAL JOINS and about windows functions
The depth of knowledge on each topic, especially the advanced topics.
Advanced data operations, partitioned window functions.
The interactive exercises are fantastic. it was useful to be able to run queries and test things without having to install or set up anything on my computer.
The most useful thing for me was to see how PostgreSQL is similar to other SQL databases and where it differs.
I like the interactive exercises combined with DomeBrain for assistance.
I learned about advanced topics like lateral joins, text search and more windows functions.
Very in-depth course with useful lessons that are very helpful to understand many things from basic concepts up to more advanced stuff related to PostgreSQL
There are a lot of things I learned including getting information about a query and its cost, basic CRUD and lots of cool things like JSONB and text-search
Loved this for the details where PostgreSql deviated from MS SQL Server. Very helpful and educational.
Anything that doesn't come with OOB MS SQL Server, Specifically the full text search
