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.
Schema Design in SQL vs NoSQL: A Visual Comparison
Learn how schema design changes between SQL and NoSQL databases. See real visual examples, normalization tips, and when to use each model.
Logical Design Documentation for Database Development
Document a logical and physical database design in DbSchema: comments, tags, the naming and conversion dictionaries, and interactive HTML5 documentation.
Firebird CREATE TABLE Guide in isql and DbSchema
Learn how to create Firebird tables in isql and DbSchema, including data types and practical setup steps.
Firebird CREATE DATABASE Guide in isql and DbSchema
Learn how to create a Firebird database using isql and DbSchema, with connection setup and practical workflow tips.
PostgreSQL CREATE TRIGGER Guide with psql and DbSchema | DbSchema
Learn how to create triggers in PostgreSQL using psql and DbSchema, with trigger types, parameters, examples, and practical guidance.
PostgreSQL Aggregate Functions Guide with Examples | DbSchema
Learn how to use PostgreSQL aggregate functions like AVG, COUNT, MIN, MAX, and SUM in psql and DbSchema with practical examples.
How to Document a PostgreSQL Schema
Learn how to create diagrams, add comments, track changes, and export HTML5 docs to fully document your PostgreSQL schema using DbSchema.
Drop Table in PostgreSQL: Syntax, IF EXISTS, CASCADE, and Safety Tips | DbSchema
Use DROP TABLE in PostgreSQL with IF EXISTS, CASCADE, and multi-table examples. Review dependencies first and manage changes visually in DbSchema.
How to Document PostgreSQL Databases Effectively | DbSchema
Learn how to document PostgreSQL databases using psql comments and DbSchema visual documentation workflows for teams.
PostgreSQL CREATE DATABASE Guide with psql and DbSchema | DbSchema
Learn how to create a PostgreSQL database using psql and DbSchema, with setup steps, command examples, and verification tips.