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.
SQL ANY and ALL Operators Explained with Examples | DbSchema
ANY is true when one subquery row matches, ALL only when every row does. See each operator form, IN and EXISTS, and what NULLs and an empty subquery do.
SQL SELECT INTO Statement Explained with Examples | DbSchema
SELECT INTO copies a query result into a new table. Syntax, examples with their results, what the copy keeps, and what to use on MySQL, Oracle and SQLite.
MongoDB Virtual Foreign Keys Explained | DbSchema
Learn how to create virtual foreign keys in MongoDB using DbSchema to visualize relationships and browse related collection data.
Introduction to MongoDB Tutorial (2025) | DbSchema
MongoDB for beginners: the NoSQL document model, collections and BSON, replica sets and sharding, the SQL to MongoDB mapping, and where the document model fits.
MongoDB $lookup: Join Collections with Examples, Pipelines, and $unwind | DbSchema
Learn MongoDB $lookup with simple joins, pipeline lookups, $unwind, indexing, and performance tips. Build and inspect joins visually in DbSchema.
Best Oracle Database Design Tools in 2026
Six Oracle database design tools compared on reverse engineering, validation, version control, documentation and price, with an Oracle test schema to try each one on.
Cassandra ALTER TABLE Guide: What You Can and Cannot Change
What ALTER TABLE changes in Cassandra 5.0, from adding and dropping columns to table options, and what to do when you need a new column type, primary key or table name.
Cassandra CREATE TABLE Guide in cqlsh and DbSchema
Learn how to create Cassandra tables in cqlsh and DbSchema, choose partition and clustering keys, and use table options without common modeling mistakes.
Top 5 Database GUI Clients with Git Integration in 2026
Learn how Git integration in database tools helps teams track changes, prevent conflicts, and collaborate efficiently on database projects.
Top 7 Logical Database Design Tools in 2026
Seven logical database design tools compared on where the shared model lives, what each runs on and the price each vendor publishes, checked in September 2026.