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 Constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL | DbSchema
Learn SQLite constraints with PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL, DEFAULT, Python examples, edge cases, and DbSchema tooling.
How to Create ER Diagrams for SQLite with a Free Tool
Turn a SQLite database into an ER diagram with DbSchema: connect to the .db file, reverse-engineer it, arrange the diagram, and document what it shows.
SQLite CREATE TABLE: Syntax, Data Types, Constraints, and Examples | DbSchema
Learn SQLite CREATE TABLE syntax, data types, IF NOT EXISTS, constraints, AUTOINCREMENT, temp tables, and visual table design in DbSchema.
MySQL DROP CONSTRAINT Foreign Key, Unique, Check, and Primary Key Syntax | DbSchema
Learn MySQL DROP CONSTRAINT patterns for 5.7, 8.0, and 8.4. Remove foreign keys, unique indexes, checks, and primary keys safely in DbSchema.
MySQL ER Diagram, Reverse Engineer and Design Schemas Visually | DbSchema
Create a MySQL ER diagram from an existing database or design one from scratch. See version-aware examples, docs links, and DbSchema workflow tips.
MySQL CREATE TRIGGER Syntax, BEFORE/AFTER Examples, and Audit Patterns | DbSchema
Learn MySQL CREATE TRIGGER syntax for 5.7, 8.0, and 8.4 with BEFORE/AFTER examples, audit trail patterns, validation logic, and DbSchema tips.
Best MySQL Database Design Tools in 2026: Buyer's Comparison
Seven MySQL design tools compared on engines, reverse engineering, offline use, documentation, Git and prices, with what each one is built for and where DbSchema fits.
MySQL Default Username and Password | DbSchema
Find the real MySQL default root login behavior for 5.7, 8.0, and 8.4, reset passwords safely, and secure access faster with DbSchema.
SQL Server Table Partitioning: Partition Functions, Schemes, RANGE LEFT/RIGHT, and Best Practices | DbSchema
Learn SQL Server table partitioning with partition functions, schemes, RANGE LEFT/RIGHT examples, list/hash alternatives, and DbSchema design tips.
SQL Server Insert Multiple Rows in a Single Query | DbSchema
Insert multiple rows in one SQL Server statement: the multi-row VALUES syntax, the documented 1,000-row limit and error 10738, and INSERT ... SELECT.