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.
Design and Manage SQLite Databases with a Modeling Tool
Is SQLite relational, and what is a .sqlite file? Then open one in DbSchema as an editable ER diagram, with the SQLite rules that change the model.
SQL Server Failover Clustering Setup Guide in sqlcmd and DbSchema
Learn how to set up SQL Server failover clustering and connect from DbSchema for high-availability environments.
SQL Server Database Sharding: Strategies, Shard Keys, and Architecture | DbSchema
Learn SQL Server database sharding with shard keys, routing, cross-shard design, and trade-offs. Plan scalable SQL Server architectures in DbSchema.
SQL Server CREATE TABLE: Syntax, Constraints, Temp Tables, and Examples | DbSchema
Learn SQL Server CREATE TABLE syntax, data types, constraints, temp tables, and SELECT INTO patterns. Design and deploy tables faster with DbSchema.
SQL Server MERGE Statement: UPSERT Patterns, WHEN MATCHED, and Safer Alternatives | DbSchema
Learn SQL Server MERGE for UPSERT and sync jobs, compare WHEN MATCHED options, OUTPUT logging, and safer alternatives. Test the logic in DbSchema.
Free Database Diagram Tool for Easy Design and Management | DbSchema
What a database diagram shows, how to read the lines between tables, and how DbSchema's free Community Edition reverse-engineers a live database into an interactive diagram.
SQL DELETE Statement Explained with Examples (2026) | DbSchema
Learn SQL DELETE syntax with WHERE, JOIN, and subquery examples plus transaction-safe cleanup patterns. Includes DELETE vs TRUNCATE vs DROP and production safety tips.
SQL UPDATE Statement: Syntax, Examples, and Safe Patterns (2026) | DbSchema
Learn SQL UPDATE syntax with practical examples, WHERE safety checks, JOIN-based updates, and transaction-safe patterns for MySQL, PostgreSQL, and SQL Server.
SQL MIN() and MAX() Functions Explained with Examples | DbSchema
SQL MIN() and MAX() explained: syntax, NULL handling, GROUP BY and ORDER BY, WHERE vs HAVING, text and date columns, and selecting the full row.
SQL Tables Explained: CREATE, ALTER, DROP, and Examples | DbSchema
Learn SQL tables with practical examples: what a table is, how to CREATE, ALTER, and DROP tables, and how primary keys and constraints work.