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.
SQLite EXPLAIN and EXPLAIN QUERY PLAN Guide | DbSchema
Learn how to use SQLite EXPLAIN and EXPLAIN QUERY PLAN to understand execution steps and optimize queries in sqlite3 and DbSchema.
SQLite Transactions Explained with Examples | DbSchema
Learn how SQLite transactions work with BEGIN, COMMIT, and ROLLBACK in sqlite3 and DbSchema using practical examples.
SQLite Views Explained with Examples | DbSchema
Learn how to create and use SQLite views in sqlite3 and DbSchema, including examples, benefits, and common limitations.
How to Rename a MySQL Database Using mysqldump | DbSchema
MySQL has no RENAME DATABASE statement. Dump, create the target, restore, verify table and row counts, drop the original, and fix what did not follow.
SQL Server User-Defined Functions (UDF) Guide with Examples | DbSchema
Learn how to create SQL Server user-defined functions in sqlcmd and DbSchema, including function types, permissions, syntax, and examples.
SQL Server Distributed Transactions Guide with sqlcmd and DbSchema | DbSchema
Learn how SQL Server distributed transactions work, including permissions, transaction types, and practical execution in sqlcmd and DbSchema.
SQL Server Spatial Data Types Guide in sqlcmd and DbSchema
Learn how to use SQL Server spatial data types (geometry and geography) with examples in sqlcmd and DbSchema.
SQL Server Design Tool for 2025: Visual Schema Diagrams, Documentation, and Sync | DbSchema
Need a SQL Server design tool for 2025? Compare features, model schemas visually, document changes, and sync safely with DbSchema.
SQL Server CREATE TRIGGER: AFTER, INSTEAD OF, Audit, and DDL Examples | DbSchema
Learn SQL Server CREATE TRIGGER with AFTER, INSTEAD OF, audit logging, inserted/deleted tables, and DDL examples. Build and review triggers in DbSchema.
SQL Server CREATE INDEX Guide with Types and Examples | DbSchema
Learn how to create indexes in SQL Server using sqlcmd and DbSchema, with index types, permissions, examples, and verification steps.