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.
Team Collaboration in Schema Design with Git
How a team shares one DbSchema model through Git: commit the .dbs file, branch per change, review the diff, resolve a conflicted table.
DbSchema vs Navicat: Full Feature Comparison for Teams in 2026 | DbSchema
DbSchema 10.5 vs Navicat Premium 17.3.11, compared job by job: ER modelling, offline design, schema sync, Git, NoSQL, documentation and automation.
Database Design Best Practices: Principles, Normalization and Keys
Database design best practices in one page: the five design principles, the four-step process, 1NF to 3NF with worked examples, and primary, foreign and secondary keys in SQL.
MySQL vs MongoDB: Key Differences, Decision Table and Data Models
MySQL vs MongoDB compared on schema enforcement, joins vs $lookup, one-to-one and one-to-many modeling, transactions and schema evolution, with a decision table checked against MySQL 9.7 LTS and MongoDB 8.3.
Querying a Database Without Writing SQL
Learn how data analysts can query relational and NoSQL databases without writing SQL by using visual query builders, data explorers, and offline models.
Indexes and Foreign Keys Design Tips | DbSchema
Learn practical tips for using indexes and foreign keys to improve database consistency and query performance.
What an AI Assistant Sees of Your Database
Learn what an AI assistant sees of your database, the privacy risks of shadow AI, and how DbSchema keeps your schema secure while automating query design.
Best Database Tools with Git for Team Design in 2026
Discover collaborative database design tools with Git integration. Compare top options for schema versioning, teamwork, and offline modeling.
Window Functions in SQL for Data Analysis | DbSchema
Learn SQL window functions with practical PostgreSQL examples for ranking, cumulative metrics, and feature engineering using DbSchema.
SQL Interview Questions for Developers and DBAs | DbSchema
Practice SQL interview questions and solutions for developers and database administrators with realistic PostgreSQL exercises.