DbSchema Blog

Categories

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

SQL AND, OR, NOT Operators Explained with Examples | DbSchema

SQL AND, OR and NOT explained with runnable examples: what each returns, why precedence breaks AND/OR combinations, and how NOT behaves against NULL.

Tutorials • 05-Sep-2026

SQL Aliases Explained with Examples | DbSchema

SQL aliases explained: rename columns and tables with AS, quote aliases with spaces or reserved words, and see where an alias may be referenced in WHERE, GROUP BY, HAVING and ORDER BY.

Tutorials • 05-Sep-2026

SQL GROUP BY Statement Explained with Examples | DbSchema

Learn SQL GROUP BY with single and multi-column examples, HAVING, JOINs, aggregations, and common mistakes.

Tutorials • 05-Sep-2026

SQL SELECT DISTINCT Statement Explained with Examples | DbSchema

Learn SQL SELECT DISTINCT with single and multi-column examples, NULL behavior, DISTINCT vs GROUP BY, and common mistakes.

Tutorials • 05-Sep-2026

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 • 05-Sep-2026

SQL BETWEEN Operator Explained with Range Examples | DbSchema

Learn SQL BETWEEN and NOT BETWEEN with numeric, date, text, and time examples, plus common mistakes and best practices.

Tutorials • 05-Sep-2026

How to Create Custom Data Types in DbSchema

Create custom data types in DbSchema’s Logical Design to standardize columns; on deployment they convert to native DBMS types like VARCHAR.

Tutorials • 05-Sep-2026

What Is an Index in MongoDB? Beginner Guide with Examples

Learn what an index is in MongoDB, why it matters, and how to use it. This beginner tutorial explains single-field, compound, and text indexes with examples in MongoDB shell and DbSchema.

Mongodb • 05-Sep-2026

MongoDB Relationships: Embed vs Reference and Visualize in DbSchema | DbSchema

Learn how to visualize MongoDB relationships with embedding, references, one-to-many patterns, and DbSchema diagrams. Decide when to embed vs reference.

Mongodb • 05-Sep-2026

MongoDB Diagram Design and Visualization with DbSchema

Learn how to create diagrams for MongoDB, implement validation rules and visually manage MongoDB databases.

Mongodb • 05-Sep-2026