FB
Query Analyser

Aqua Data Studio vs DBeaver: A Comparison

Aqua Data Studio and DBeaver are two feature-packed SQL editors that developers can use to work with SQL queries and do much more on a database. In this post, I’ll compare the major features of both of these tools.

two tables

How to Create a Simple ERD in SSMS

In this post you’ll learn: how to create a new Entity Relationship Diagram in SQL Server Management Studio how to add tables and columns how to relate two tables together using a foreign key Let’s get started.

file saved

How to Create a Simple ERD in pgAdmin

In this post you’ll learn: how to create a new Entity Relationship Diagram in pgAdmin how to add tables and columns how to relate two tables together using a foreign key Let’s get started.

mysql erd

How to Create a Simple ERD in MySQL Workbench

In this post you’ll learn: how to create a new Entity Relationship Diagram in MySQL Workbench what a model is and how it relates to an ERD or EERD. how to add tables and columns how to relate the tables together Let’s get started.

calendar icon

How to Format a Date in PostgreSQL

In this guide, you’ll learn how to format DATE values into many different formats, how to insert DATE values into a table, and more.

live sql logo

Oracle Live SQL: The Complete Guide

In this guide, you’ll learn all about Oracle Live SQL, the web-based tool by Oracle that has a built-in Oracle database for practising your SQL.

SQL function

SQL Decimal: Guide and Examples

The SQL DECIMAL data type is useful for storing numbers with decimal places. Learn all about it, including which databases support it, and how to work with it, in this guide.