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 Wildcard Characters: LIKE Patterns, ESCAPE Rules, and Examples | DbSchema

Learn SQL wildcard characters with %, _, ESCAPE, ILIKE, and NOT LIKE examples. Compare databases and test safe pattern searches in DbSchema.

Tutorials • 11-Sep-2026

SQL NULL Functions Explained with Examples | DbSchema

Learn SQL NULL-handling functions like IFNULL, ISNULL, COALESCE, and NVL, with examples, pitfalls, and practice exercises.

Tutorials • 11-Sep-2026

SQL HAVING Clause: GROUP BY Filters, Examples, and HAVING vs WHERE | DbSchema

Learn SQL HAVING with GROUP BY using COUNT, SUM, AVG, JOIN, and COUNT DISTINCT examples. Understand HAVING vs WHERE and write safer reporting queries.

Tutorials • 11-Sep-2026

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.

Tutorials • 11-Sep-2026

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.

Tutorials • 11-Sep-2026

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.

Mongodb • 11-Sep-2026

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

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

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.

Oracle • 11-Sep-2026

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