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.
Best Oracle Database Design Tools in 2026
DbSchema, Oracle SQL Developer Data Modeler, Redgate Data Modeler, Aqua Data Studio, DataGrip and DBeaver on an Oracle schema: reverse engineering, version control and price. Checked 12 Nov 2026.
Top 5 Database GUI Clients with Git Integration in 2026
DbSchema, DataGrip, Toad for SQL Server, SQL Developer and DBeaver compared on what their Git integration commits, which edition has it, and how a schema change reaches the database.
Top 7 Logical Database Design Tools in 2026
Seven logical database design tools compared on where the shared model lives, what each runs on, which edition carries logical design and the price each vendor publishes, checked in September and November 2026.
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.
Choosing an ER Notation Your Team Can Read
Compare Chen, crow's foot, Barker, IDEF1X and UML class diagrams on one example, pick the ER diagram notation your readers know, and show one model in it.
DBeaver Alternative for Database Design: DbSchema, Edition by Edition and Price by Price | DbSchema
Where DBeaver's diagrams stop for schema design, what DbSchema does instead, and the three-year cost of the edition each one needs for the same work.
Creating an ER Diagram From an Existing Database
Create an ER diagram from an existing database: connect DbSchema, import the schemas, then add and check the relationships that the database never declared.
PostgreSQL JSONB: Operators, GIN Indexes, and Query Examples | DbSchema
Learn PostgreSQL JSONB operators, GIN indexes, path queries, and update patterns. Explore and document JSONB structures visually in DbSchema.
PostgreSQL List All Schemas: psql, information_schema, pg_namespace, and search_path | DbSchema
List PostgreSQL schemas with psql, information_schema, and pg_namespace. Filter system schemas, inspect search_path, and browse them in DbSchema.
PostgreSQL CREATE PROCEDURE: IN/OUT Parameters, CALL, Transactions, and Errors | DbSchema
Learn PostgreSQL CREATE PROCEDURE from short examples with their results: CALL, IN, OUT and INOUT parameters, COMMIT inside a procedure, and EXCEPTION.