DbSchema Blog

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

Tutorials • 20-Jul-2023

Learn how to create a Firebird database using isql and DbSchema, with connection setup and practical workflow tips.

Firebird • 20-Jul-2023

Learn SQL basics and database fundamentals with real-world examples, core concepts, and practical next steps.

Tutorials • 19-Jul-2023

Learn SQL syntax and basic commands in this tutorial. Understand SQL fundamentals to improve your database skills and start writing queries.

Tutorials • 19-Jul-2023

Learn the SQL SELECT statement with syntax, WHERE, DISTINCT, JOINs, GROUP BY, ORDER BY, subqueries, and FAQs. Build queries visually in DbSchema.

Tutorials • 19-Jul-2023

Learn how to use SQL Server spatial data types (geometry and geography) with examples in sqlcmd and DbSchema.

Sql server • 16-Jul-2023

Learn SQL Server MERGE for UPSERT and sync jobs, compare WHEN MATCHED options, OUTPUT logging, and safer alternatives. Test the logic in DbSchema.

Sql server • 16-Jul-2023

Learn how SQL Server distributed transactions work, including permissions, transaction types, and practical execution in sqlcmd and DbSchema.

Sql server • 15-Jul-2023

Learn how to set up SQL Server replication with sqlcmd, understand replication roles and types, and validate replicated data in DbSchema.

Sql server • 15-Jul-2023

Learn SQL Server database sharding with shard keys, routing, cross-shard design, and trade-offs. Plan scalable SQL Server architectures in DbSchema.

Sql server • 14-Jul-2023

Categories