Learn SQL in your browser
A free SQL tutorial in short lessons on one shop database. Every example runs on real PostgreSQL in your browser, and the page checks your answers.
DbSchema Blog
Database design, migrations, SQL and everyday database work — explained with practical examples.
How to Work Better with Foreign Keys and Virtual Keys
Understand foreign keys and learn how to recreate missing relationships using Virtual Foreign Keys in DbSchema for clear, consistent database design.
When Not to Normalise
Discover when denormalization is the right choice for your database, the native alternatives to try first, and how to manage the update costs.
Reviewing an AI-Proposed Schema Change
An ai schema generator accelerates design but requires expert review. Learn how database architects validate and deploy AI-proposed schema changes safely.
Exploring Master-Detail Data Across Foreign Keys
Explore master-detail data across foreign keys. Understand relational database connections and browse multiple child tables visually without writing SQL.
Designing a Schema for a Collaborative Task App
Learn how to design a collaborative task app schema using a Git-based workflow. Discover how backend teams branch, diff, and sync XML models safely.
Documenting a PostgreSQL Database
Document a PostgreSQL database with COMMENT ON, read the text back from pg_description and psql, and export the diagram and data dictionary as one HTML5 file.
How to Generate Random Data in PostgreSQL | DbSchema
Learn how to generate realistic random data for PostgreSQL tables using DbSchema Data Generator patterns, seeds, and preview tools.
PostgreSQL JOINs Explained with Examples | DbSchema
Learn how to use PostgreSQL JOIN types with practical examples in psql and DbSchema, including INNER, LEFT, RIGHT, FULL, CROSS, NATURAL, and SELF JOIN.
Improve Your PostgreSQL Database Design and Management with DbSchema
Connect DbSchema to PostgreSQL, reverse-engineer the schema into diagrams, build queries, edit related rows, and export HTML5 documentation.
How to Copy a PostgreSQL Database Safely | DbSchema
Learn how to copy a PostgreSQL database using SQL and command-line tools, including connection cleanup and template-based cloning.