DbSchema Blog

Categories

• Cassandra
• Databases
• Dbschema features
• Design
• Firebird
• Migrations
• Mongodb
• Mysql
• Oracle
• Postgresql
• Release notes
• Snowflake
• Sql server
• Sqlite
• Tool comparisons
• Tools
• Tutorials

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.

Mongodb • 27-Aug-2025

SQL GROUP BY Explained with Examples | DbSchema

Learn SQL GROUP BY with clear examples for COUNT, SUM, AVG, HAVING, and JOIN-based reporting queries.

Tutorials • 21-Aug-2025

How to Design a PostgreSQL Schema Visually (Step-by-Step)

PostgreSQL schema design tutorial. Learn visual database modeling with ER diagrams, create tables, set foreign keys, and generate documentation with a GUI tool.

Postgresql • 12-Aug-2025

SQL Joins Explained – INNER, LEFT, RIGHT, and FULL JOIN Diagrams | DbSchema

Learn SQL JOINs with clear INNER, LEFT, RIGHT, FULL, CROSS, and SELF JOIN diagrams, examples, and FAQs. Build and test joins visually in DbSchema.

Tutorials • 08-Aug-2025

SQL Aggregate Functions – COUNT, SUM, AVG, MIN, MAX, and GROUP BY | DbSchema

Learn SQL aggregate functions with COUNT, SUM, AVG, MIN, MAX, GROUP BY, HAVING, and ROLLUP examples. Build reporting queries faster in DbSchema.

Tutorials • 07-Aug-2025

What Is a Primary Key in SQL? Definition and Examples (2026) | DbSchema

Learn what a primary key in SQL is, with syntax and examples for MySQL, PostgreSQL, and SQL Server, plus composite keys and primary key vs unique vs foreign key.

Tutorials • 06-Aug-2025

What Is a Foreign Key in SQL? Syntax, Rules, and Examples (2026) | DbSchema

Learn SQL foreign key syntax with examples, ON DELETE and ON UPDATE actions, composite keys, and how to add or drop constraints in MySQL, PostgreSQL, and SQL Server.

Tutorials • 31-Jul-2025

How to Create ER Diagrams for SQLite with a Free Tool

Create or explore ER diagrams for your SQLite database using a free modeling tool. Visual design, schema sync, Git support, and interactive documentation.

Sqlite • 23-Jul-2025

MongoDB Aggregation Pipeline Tutorial for Beginners in 2025

Understand MongoDB aggregation pipelines with clear examples. Learn how to filter, group, sort, and transform data step by step in this beginner-friendly guide.

Mongodb • 21-Jul-2025

Create ER Diagrams for PostgreSQL with a Free Design Tool

Design and manage PostgreSQL schemas with a visual ERD tool. Track table relationships, export diagrams, and sync your schema model with Git.

Postgresql • 08-Jul-2025