The guided tutorials at Postgres Playground that we developed at Crunchy Data may be helpful. Answer from prlaur782 on reddit.com
Pgexercises
pgexercises.com
PostgreSQL Exercises
Welcome to PostgreSQL Exercises! This site was born when I noticed that there's a load of material out there to help people learn about SQL, but not a great deal to make it easy to learn by doing. PGExercises provides a series of questions and explanations built on a single, simple dataset.
W3Schools
w3schools.com › postgresql › postgresql_exercises.php
PostgreSQL Exercises
PostgreSQL CREATE TABLE PostgreSQL INSERT INTO PostgreSQL Fetch Data PostgreSQL ADD COLUMN PostgreSQL UPDATE PostgreSQL ALTER COLUMN PostgreSQL DROP COLUMN PostgreSQL DELETE PostgreSQL DROP TABLE Create Demo Database
Websites to practice postgreSQL ?
The guided tutorials at Postgres Playground that we developed at Crunchy Data may be helpful. More on reddit.com
11
13
October 19, 2023Is there a real-life Sample Database for PostgreSQL for beginner practice?
https://wiki.postgresql.org/wiki/Sample_Databases That page lists various sources. More on reddit.com
7
7
February 12, 2024PostgreSQL Certification Question
As a DBA you are required to at least be proficient in SQL, if not fluent as you will be the person your developers will turn to when they have issues.
Postgres is open source so there's really no certification entity. EnterpriseDB sells Postgres support and they have a certification program, but it includes SQL and many other concepts.
Bottom line, SQL is the language of the database, so you're going to want to learn it through and through.
More on reddit.com 6
9
March 17, 2014Best practice to sync many offline databases with a single online one?
This is probably a case that can be addressed with Logical Replication . The implementation though is very application specific. The reason being that it's entirely possible, depending on your application's schema, to have data streams that are individually valid but not logically reconcilable. The most obvious way in which this can happen is of the individual servers choose overlapping key values. No problem, you say, I'll make sure that can never happen. I'll assign them different sequence ranges. Or I'll make all of my keys UUIDs. Alright then, what happens if one client DB deletes a parent value for which another client still has child values? You have to decide whether the right thing is to keep the parent or delete the parent and all children. Or what about if two client DBs have conflicting changes to the same record? Or how do you deal with rolling out schema upgrades? There are many such cases to think about. To what extent they can happen in your data streams really depends on your application and how much independence the client DBs are permitted. More on reddit.com
5
8
April 15, 2020What is the PostgreSQL Playground?
The Postgres Playground is an online PostgreSQL database that runs directly in your browser. It’s a simple, no-setup solution for testing SQL queries and learning PostgreSQL.
aiven.io
aiven.io › tools › pg-playground
Free PostgreSQL Online Playground | Sandbox | Compiler
Is my data and code secure when using the PostgreSQL Playground?
Yes, your data and SQL code remain secure. All operations are executed locally in your browser, and we do not store your queries or data on any external servers.
aiven.io
aiven.io › tools › pg-playground
Free PostgreSQL Online Playground | Sandbox | Compiler
How long does data persist in the PostgreSQL Playground?
Data in the Postgres Playground is temporary. It is stored only in your browser’s memory and will disappear when you close or refresh the browser. It is not saved to disk or stored in browser local storage.
aiven.io
aiven.io › tools › pg-playground
Free PostgreSQL Online Playground | Sandbox | Compiler
Videos
01:00:07
Learn PostgreSQL fast! | PostgreSQL for beginners - YouTube
02:53:27
PostgreSQL Tutorial for Beginners - YouTube
PostgreSQL Tutorial Full Course 2022
34:20
How to INSTALL PostgreSQL for learning and practicing SQL ...
20:09
Practice basic SQL using PostgreSQL. Learning SQL is a great skill ...
LabEx
labex.io › free-labs › postgresql
PostgreSQL Free Labs | Practice SQL Online | LabEx
Practice PostgreSQL in Free Labs. Gain hands-on experience with SQL queries, database design, and data management in an interactive and free PostgreSQL playground.
OneCompiler
onecompiler.com › postgresql
PostgreSQL Online Editor
The editor shows sample boilerplate ... is a open source relational database system and is also knows as Postgres. Postgres is not only free and open-source but also it is highly extensible....
Reddit
reddit.com › r/postgresql › websites to practice postgresql ?
r/PostgreSQL on Reddit: Websites to practice postgreSQL ?
October 19, 2023 -
I have been learning postgreSQL for few days now this is my first relational database, I have been using https://pgexercises.com/ for practice. could you guys suggest me some similar sites to practice and a postgreSQL playground as well.
SQL Fiddle
sqlfiddle.com › postgresql › online-compiler
FREE AI-Enhanced Online PostgreSQL Compiler - For learning & practice
Explore our free online PostgreSQL editor to practice and execute SQL. AI-enhanced to chat, explain, and generate code. Start coding smarter today!
Aiven
aiven.io › tools › pg-playground
Free PostgreSQL Online Playground | Sandbox | Compiler
Free online PostgreSQL playground environment to test your PostgreSQL queries in a sandbox environment. It's a free PostgreSQL Fiddle tool to run your SQL queries.
PostgreSQL
postgresql.org › docs › online-resources
PostgreSQL: Tutorials & Other Resources
Copyright © 1996-2026 The PostgreSQL Global Development Group
Vertabelo Academy
academy.vertabelo.com › course › postgresql-queries-online-practice › aggregation-and-grouping › introduction › introduction
PostgreSQL Queries (Online Practice) | Exercise Set | Vertabelo Academy
Solidify your knowledge of using PostgreSQL queries! This online practice set is dedicated to users who know SQL basics.
SQLPad
sqlpad.io › playground › postgres
Postgres Playground with Real Data | SQLPad
Practice Postgres SQL with interview-style questions, real datasets, and fast in-browser results on SQLPad.
LearnSQL.com
learnsql.com › blog › how-to-practice-postgresql-online
How to Practice PostgreSQL Online | LearnSQL.com
You can try to use free online datasets or even try to create some projects on your own. But it can be hard to come up with practice problems and scenarios. Also, it’s good to have a learning path, where you can find your current level of experience and see what you need to do to progress. That is why LearnSQL’s Practice Set in PostgreSQL ...
ExtendsClass
extendsclass.com › postgresql-online.html
Postgres online - Test SQL queries
This playground allows you to test postgres online (PostgreSQL 11.10).
W3Resource
w3resource.com › postgresql-exercises
PostgreSQL Exercises, Practice, Solution - w3resource
October 30, 2025 - The best way to learn PostgreSQL is through practice. This section is for beginners to intermediate users to enhance their SQL skills with exercises.
LearnSQL.com
learnsql.com › blog › free-course-postgresql-practice
Course of the Month: SQL Practice Set in PostgreSQL | LearnSQL.com
September 1, 2025 - There is no catch! For September, our free SQL course is SQL Practice Set in PostgreSQL.
LearnSQL
learnsql.com › home › sql courses › sql practice set in postgresql
SQL Practice Set in PostgreSQL | Online Course
This exercise set is designed for users who already know how to write basic PostgreSQL queries. It will also be of interest to anyone who wants some online practice to polish or refresh their knowledge of writing queries in PostgreSQL.
CoderPad
coderpad.io › languages › postgresql
PostgreSQL Online IDE & Code Editor for Technical Interviews
May 10, 2023 - PostgreSQL mode spins up a PostgreSQL server with a default database with some sample data in it. The schema of the default database looks like:
W3Schools
w3schools.com › postgresql › postgresql_quiz.php
PostgreSQL Quiz
PostgreSQL CREATE TABLE PostgreSQL INSERT INTO PostgreSQL Fetch Data PostgreSQL ADD COLUMN PostgreSQL UPDATE PostgreSQL ALTER COLUMN PostgreSQL DROP COLUMN PostgreSQL DELETE PostgreSQL DROP TABLE Create Demo Database
OneCompiler
onecompiler.com › postgresql › 3xk8tb9w4
3xk8tb9w4 - PostgreSQL - OneCompiler
The editor shows sample boilerplate ... is a open source relational database system and is also knows as Postgres. Postgres is not only free and open-source but also it is highly extensible....
G Solutions
freeonlinecompiler.com › home › postgresql
PostgreSQL Online Compiler – Run PostgreSQL Online Free | freeonlinecompiler.com
March 26, 2026 - Free postgresql online compiler powered by a real PGlite WASM engine. Practice SELECT, JOIN, CTEs, and window functions in your browser.
SQL Practice Online
sql-practice.online
SQL Practice Online — Free SQL Compiler & Editor
Free SQL online ide & sql sandbox — practice PostgreSQL, MySQL, SQL Server & Oracle. Free sql editor, sql query builder, 5 real databases, no signup.