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.
Database Design Tools on Linux: Which Modellers Install Natively
Compare database design tools that run natively on Linux, see which modellers list only Windows and macOS, and open your own database in DbSchema Community
Data Modelling Tools for Snowflake: Five Tools Compared
Compare five data modelling tools for Snowflake on connection, reverse engineering, VARIANT support and model storage, with a fit guide per team.
Creating an ER Diagram From an Existing Database
Learn how to connect a tool to a live database, reverse-engineer a schema into an ER diagram, and uncover undeclared foreign keys with DbSchema.
pgAdmin ER Diagrams Compared With a Modelling Tool
How DbSchema's free Community Edition opens the PostgreSQL database behind pgAdmin's ERD tool, what that ERD does, and where a modelling tool goes further.
AI ER Diagram Generators Compared
Compare six AI ER diagram generators on input, output and where the model lives, and see how to draw an ER diagram from your real database instead.
Erwin Compared With ER/Studio and PowerDesigner
Compare erwin Data Modeler, ER/Studio, and PowerDesigner on repository features, cross-platform support, and team licensing costs for database architects.
DBeaver ER Diagrams and Where They Fall Short
Open, export and fix DBeaver ER diagrams, learn why relationship lines go missing, and know when to open the same database in DbSchema.
SQL Wildcard Characters: LIKE Patterns, ESCAPE Rules, and Examples | DbSchema
Learn SQL wildcard characters with %, _, ESCAPE, ILIKE, and NOT LIKE examples. Compare databases and test safe pattern searches in DbSchema.
SQL NULL Functions Explained with Examples | DbSchema
Learn SQL NULL-handling functions like IFNULL, ISNULL, COALESCE, and NVL, with examples, pitfalls, and practice exercises.
SQL HAVING Clause: GROUP BY Filters, Examples, and HAVING vs WHERE | DbSchema
Learn SQL HAVING with GROUP BY using COUNT, SUM, AVG, JOIN, and COUNT DISTINCT examples. Understand HAVING vs WHERE and write safer reporting queries.