TheTable Blog

The Table by DbVisualizer  is where we gather together to learn about and simplify the complexity of working with database technologies.

SQL SERVER

SQL Server for Mac: The Ultimate Guide to the Best SQL Server Client

POSTGRESQL
Split

5 Ways to Split a String in PostgreSQL

IFNULL
MySQL

MySQL IFNULL – Everything You Need to Know

CASE
POSTGRESQL

PostgreSQL CASE: A Comprehensive Guide

JOIN

Outer Join in SQL: A Comprehensive Guide

DDL
SQL

SQL DDL: The Definitive Guide on Data Definition Language

VIEWS

SQL Views: A Comprehensive Guide

Create database
MySQL

MySQL CREATE DATABASE Statement: Definitive Guide

DATA TYPES
POSTGRESQL

Discover All PostgreSQL Data Types

BIG DATA

Dangerous Big Data - Big Data Pitfalls to Avoid

SQL Certification: The Ultimate Guide for 2024

How to Create a Temporary Table with SQL

pg_dump
POSTGRESQL

A Complete Guide to pg_dump With Examples, Tips, and Tricks

DATE

Understanding the DATEDIFF SQL Function: A Comprehensive Guide

DATA TYPES
POSTGRESQL

A Comprehensive Guide to Data Types in Postgres

SQL

SQL CONTAINS Function: SQL Server Guide With Examples

MySQL

A Complete Guide to SUBSTRING_INDEX in SQL

DISTINCT
POSTGRESQL
SQL

SQL DISTINCT: A Comprehensive Guide

SQL

SQL Interview Questions – SQL Queries

MySQL

Error: MySQL Shutdown Unexpectedly - The Solution

COALESCE

The Complete Guide to the SQL COALESCE Function

BETWEEN
SQL

The SQL BETWEEN Clause Explained

SQLITE

SQLite Viewer: Guide and top picks

STATIC CODE

Static Code Analysis Tools for SQL Databases – What Can Be Done?

DISTINCT

PostgreSQL DISTINCT: Removing Duplicate Rows from a Result Set

VIEWS

View vs Materialized View in databases: Differences and Use cases

DATE
POSTGRESQL

Date Formatting in Postgres: A Comprehensive Guide

CAST
POSTGRESQL

Casting in PostgreSQL: Handling Data Type Conversions Effectively

POSTGRESQL
VIEWS

PostgreSQL Materialized Views: A Beginner's Guide

JOIN

Inner Join in SQL: A Comprehensive Guide

SNOWFLAKE
TIME TRAVEL

Leveraging Snowflake's Time Travel

MARIADB
MySQL

MariaDB vs MySQL: The Ultimate Comparison

DATA CAPTURE

Change Data Capture: A Comprehensive Guide

NOSQL
SQL

SQL vs NoSQL Databases: Which is Better?

LIST USERS
POSTGRESQL

Postgres List Users: Two Different Approaches 

CHEAT SHEET
SQL

SQL Cheat Sheet: A Comprehensive Guide to SQL Commands and Queries

CONNECTION
ERROR

Error Establishing a database connection - Common Reasons and Solutions

PERFORMANCE

How to work with SQL query optimization

DBA
DRONAHQ

Low-code for DBA's

MySQL

SQL Interview Questions (MySQL): Part 1

MySQL

Working with Numeric Data Types in MySQL: A Comprehensive Guide

QUERY GENERATION

No-code Ways of Generating SQL Queries.

JOIN

Understanding Self Joins in SQL

MySQL
SECURITY

Discover DbVisualizer Security Features for MySQL

MySQL
OPERATORS

MySQL Operators – A Guide

MySQL
NULL

NULLs Are Not The Same – A Guide

MySQL
RESERVED WORDS

Your Database Doesn’t Like Your Data – Reserved Words in MySQL

ORACLE

Oracle Create Database Link

EXPLAIN
POSTGRESQL

Using the EXPLAIN plan to analyze Query execution in PostgreSQL

DELETE

Deleting a Column in SQL: Everything You Need to Know

POSTGRESQL

PostgreSQL's STRING_AGG() Function - A Comprehensive Guide

POSTGRESQL

DESCRIBE TABLE PostgreSQL Alternatives

MySQL
POSTGRESQL

PostgreSQL vs MySQL: The Definitive Comparison

JSON
POSTGRESQL

PostgreSQL JSONPATH: Dealing with the SQL/JSON Path Language

NULL
POSTGRESQL

PostgreSQL ISNULL: The Missing Function

DRIVER
JDBC
ODBC

What Is a Database Driver and How Does It Work

CONNECTION
POSTGRESQL

How To Kill All Connections to a Database in PostgreSQL

DEDUPLICATION

Duplicate Records in a DBMS – Removal, Upsides and Downsides

MySQL

MySQL FAQs Explained: Your Guide to MySQL Facts, Myths, and Optimization Tips

FUNCTIONS
SQL

A Beginners Guide to SQL Window Functions

MATH
MySQL

Math Functions in Databases – MySQL Edition

Docker
MySQL

Containerizing MySQL with Docker and DbVisualizer

VIEWS

Efficiently Creating and Managing Views in SQL

JOIN

SQL Cheat Sheet: The Ultimate Guide to All Types of SQL JOINS

INDEX
MySQL

Duplicate Indexes in MySQL – the Good, the Bad and the Ugly

BIGQUERY

Google BigQuery: A Beginner’s Guide

JOIN

How to Join Three or More Tables with SQL

POSTGRESQL

PostgreSQL CTE: What It Is and How to Use It

MySQL
WILDCARD

Wildcards in MySQL: A Comprehensive Guide on LIKE and FULLTEXT Search Wildcards

POSTGRESQL

Postgres ON DELETE CASCADE - A Guide

TRINO

Mastering the Trino Connection: Unleash the Power of DbVisualizer!

PRESTODB

Querying Data with DbVisualizer and PrestoDb

ANSIBLE
AUTOMATION

Automating Database Operations with Ansible and DbVisualizer

MONGODB

Exploring MongoDB Data Structure with DbVisualizer's Nested Tree-Table View

POSTGRESQL

PostgreSQL COALESCE Function: Handling NULL Values Effectively

JSON
NOSQL
POSTGRESQL

Bridging the Gap Between SQL and NoSQL in PostgreSQL with JSON

DATA TYPES
ORACLE

A Guide to Data Types in Oracle

SECURITY

Preventing SQL Injection Attacks with DbVisualizer

ELASTICSEARCH

How to Delete Elasticsearch Indices: An In-Depth Tutorial

Design
Language

Designing a Multi-Language Database

CRUD
DELETE

DELETE Queries – Advanced CRUD explanation part 4

CRUD
UPDATE

UPDATE Queries - Advanced CRUD explanation part 3

CRUD
SELECT

SELECT Queries - Advanced CRUD explanation part 2

CRUD
INSERT

INSERT Queries - Advanced CRUD explanation part 1

POSTGRESQL

Mastering Advanced SQL Queries With DbVisualizer And PostgreSQL

MySQL

MySQL’s UTF-8: Is It Real?

DAEMON
MySQL

Exploring the MySQL Daemon – A Guide

BUG

Why do we call software bugs, bugs?

MySQL
PARTITIONS

Archiving Data in MySQL Using Partitions

MIGRATION
MySQL
POSTGRESQL

Migrating Data Between Databases Using DbVisualizer

SQL

The Top Four Sites for Database Professionals Seeking New Job Opportunities

HSTORE
POSTGRESQL

Storing Unstructured Data With Hstore in PostgreSQL

SQL

How to Pronounce SQL: SQL or Sequel?

SECURITY
SQL SERVER

How to Make Your SQL Server More Secure

MySQL

How to update a value incrementally (+1) in MySQL

VISUALIZE

Creating Custom Visualizations with DbVisualizer

MySQL

MySQL SUBSTRING Function: The Complete Guide

SECURITY
SQL

Parameterized Queries in SQL – A Guide

POSTGRESQL

Understanding PostgreSQL Data Integrity

Docker
POSTGRESQL

How to Set Up Postgres using Docker

CONNECTION
MySQL

How to Connect to MySQL Using Admin Account Remotely

DATES
MSSQL

Extracting Time and Date in MS SQL Server: A Comprehensive Guide

POSTGRESQL

How to List Databases in Postgres Using psql and Other Techniques

COLUMNS

The Ultimate Guide to Generated Columns

MARIADB
SECURITY

Solved: sudo mysql_secure_installation command not found in MariaDB

PERFORMANCE

Why Are Your Databases Slow with Large Tables? An Overview

SECURITY

MySQL User Management: A Guide

ERD

ER Model, ER Diagram, and Relational Schema: What's the Difference?

PERFORMANCE

A Guide to Multithreading in SQL

SQL

Best Practices for SQL Coding and Development

MySQL

Character Sets vs. Collations in a MySQL Database Infrastructure

INDEXES
PERFORMANCE

10x Query Performance with a Database Index

MySQL
SUBQUERY

A Guide to Subqueries in MySQL

ACID

ACID in Database Systems: All You Need to Know

PERFORMANCE

Deadlocks in Databases: A Guide

ALTER TABLE

ALTER TABLE Explained

MySQL
PORTS

The Ultimate Guide to the MySQL Port

MySQL
SECURITY

Preventing Illicit Uploads in MySQL – secure_file_priv

ACID
MySQL
SECURITY

A Guide to ACID In MySQL

BLOB

BLOB Data Type: Everything You Can Do With It

FOREIGN KEY
POSTGRESQL

How to Use a FOREIGN KEY Referring to the Source Table in Postgres

CONCURRENCY
POSTGRESQL

Getting Started with Multiversion Concurrency Control (MVCC) in PostgreSQL

ENCRYPTION
SECURITY

Best Practices for Encrypting Data In Your Database

SECURITY

Database Security 101: Best Practices to Secure Your Data

MySQL
NULL

Working with NULL in Databases: Turn Your Frustration Into Delight

POSTGRESQL
SECURITY

How To Secure Data In A Postgres Database: A Guide

SUBQUERY

The Complete Guide to SQL Subqueries

TRANSACTIONS

Database Transactions 101: The Essential Guide

DATA STRUCTURES

A Comprehensive Guide to Data Structures in SQL

TRIGGERS

Firing Database Actions: A Guide to Using SQL Triggers with DbVisualizer

MySQL

How To Create a Table Like Another Table in MySQL

SSH

SSH Tunneling: the Good, the Bad, and the Ugly

MySQL
STORED PROCEDURE

Stored Procedures in SQL: A Complete Tutorial

TRIGGERS

SQL Triggers: What They Are and How to Use Them

POSTGRESQL

Using PostgreSQL to Manage Business Inventory Data and Visualize It

MICROSOFT SQL SERVER
OPTIMIZATION

Top five query tuning techniques for Microsoft SQL Server

POSTRESQL

How To Design And Build A Database In Postgres

REUSABLE QUERIES

Writing Reusable SQL Queries For Your Application with DbVisualizer Scripts

BIG DATA

How To Deal With a Database With Billions of Records

MySQL
SECURITY

The Data You‘ve Left Behind – an Attacker‘s Perspective

MySQL

Fixing Messy Queries with DbVisualizer – a Guide for MySQL

BEGINNER
SQL

SQL for Beginners: 3 Sites You Should Know About

CRUD
SQL TRANSACTIONS

SQL Transactions in a Flask CRUD Application

MySQL
SECURITY

Architecting for Security: MySQL Edition

JSON
POSTGRESQL

JSON vs. JSONB in PostgreSQL: A Complete Comparison

IBDATA1
INNODB
MySQL

InnoDB and ibdata1: Things You Need to Know

MySQL

Optimizing Queries for Performance: MySQL Edition

FILTER

Filtering on aggregated data

SQLITE

Create Your Own SQLite Database

ERD
JOIN

How to join your tables using ERD

EXCEL
EXPORT

Excel to SQL Basics

Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗