TheTable Blog

The Table by DbVisualizer  is where we gather together to learn about and simplify the complexity of working with database technologies. See the full list of published articles below.

ARTICLES TABLE

Title Tags Length Date Author
title

SQL INTERSECT: Everything You Need to Know

tags SQL 2 min 2024-05-23author theTable
title

SQL Formatter: Definition and Best Tools

tags SQL 9 min 2024-05-20author theTable
title

SQL TRIM: Removing Extra Space Characters From a String

tags MySQL ORACLE POSTGRESQL SQL SQL SERVER 6 min 2024-05-16author theTable
title

PostgreSQL Full Text Search: The Definitive Guide

tags POSTGRESQL Search 11 min 2024-05-13author theTable
title

SQL UNION ALL: Keeping Duplicates When Combining Result Sets

tags MySQL ORACLE POSTGRESQL SQL UNION 8 min 2024-05-09author theTable
title

SQL UNION Operator: How To Combine Result Sets

tags MySQL ORACLE POSTGRESQL SQL SQL SERVER UNION 9 min 2024-05-06author theTable
title

SQL CONVERT: The Handbook of Data Conversion in SQL

tags CONVERT Data Conversion MySQL SQL SERVER 7 min 2024-05-02author theTable
title

SQL CASE Statement: Definitive Guide

tags CASE ORACLE POSTGRESQL SQL SQL SERVER 5 min 2024-04-29author theTable
title

SQL REPLACE Function: A Comprehensive Guide

tags SQL 5 min 2024-04-25author theTable
title

SQL ORDER BY Clause: Definitive Guide

tags MySQL ORACLE POSTGRESQL SQL SQL SERVER 7 min 2024-04-22author theTable
title

SQL EXCEPT: Everything You Need to Know

tags SQL 7 min 2024-04-18author theTable
title

Adding Dates in SQL: A Complete Tutorial

tags DATE DATETIME MySQL POSTGRESQL SQL SERVER 7 min 2024-04-15author theTable
title

Glossary of the SQL Commands You Need to Know

tags MySQL ORACLE POSTGRESQL SQL SQL SERVER 12 min 2024-04-11author theTable
title

SUBSTRING_INDEX in SQL Explained: A Guide

tags MySQL SQL 8 min 2024-04-08author theTable
title

SQL NOT IN: the Good, Bad & the Ugly

tags MySQL SQL 7 min 2024-04-04author theTable
title

SQL Add to Date Operations: A Complete Guide

tags DATE DATETIME MySQL ORACLE POSTGRESQL SQL SQL SERVER 6 min 2024-04-01author theTable
title

SQL CAST Function: Everything You Need to Know

tags CAST MySQL ORACLE POSTGRESQL SQL SQL SERVER 7 min 2024-03-28author theTable
title

PostgreSQL Upsert: INSERT ON CONFLICT Guide

tags POSTGRESQL UPSERT 7 min 2024-03-25author theTable
title

Unlocking the Power of CTEs in SQL

tags 9 min 2024-03-21author theTable
title

INSERT INTO SQL Clause

tags INSERT SQL 6 min 2024-03-18author theTable
title

Enhancing Business Operations with Visualization Tools

tags Data Visualization Tools 3 min 2024-03-15author theTable
title

Postgres TEXT vs VARCHAR: Comparing String Data Types

tags POSTGRESQL TEXT VARCHAR 6 min 2024-03-14author theTable
title

ALTER TABLE ADD COLUMN in SQL: A Comprehensive Guide

tags SQL 5 min 2024-03-12author theTable
title

Schemas in PostgreSQL

tags POSTGRESQL SCHEMA 6 min 2024-03-11author theTable
title

Database Schema Design: A Comprehensive Guide for Beginners

tags SCHEMA 13 min 2024-03-07author theTable
title

SQL Comment: A Comprehensive Guide

tags 5 min 2024-03-06author theTable
title

Introduction to Database Migration: A Beginner's Guide

tags MIGRATION 11 min 2024-03-04author theTable
title

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

tags SQL SERVER 7 min 2024-03-01author theTable
title

5 Ways to Split a String in PostgreSQL

tags POSTGRESQL Split 6 min 2024-02-29author theTable
title

MySQL IFNULL – Everything You Need to Know

tags IFNULL MySQL 6 min 2024-02-26author theTable
title

PostgreSQL CASE: A Comprehensive Guide

tags CASE POSTGRESQL 7 min 2024-02-22author theTable
title

Outer Join in SQL: A Comprehensive Guide

tags JOIN 11 min 2024-02-19author theTable
title

SQL DDL: The Definitive Guide on Data Definition Language

tags DDL SQL 7 min 2024-02-15author theTable
title

SQL Views: A Comprehensive Guide

tags VIEWS 5 min 2024-02-12author theTable
title

MySQL CREATE DATABASE Statement: Definitive Guide

tags Create database MySQL 7 min 2024-02-08author theTable
title

Discover All PostgreSQL Data Types

tags DATA TYPES POSTGRESQL 12 min 2024-02-05author theTable
title

Dangerous Big Data - Big Data Pitfalls to Avoid

tags BIG DATA min 2024-02-01author theTable
title

SQL Certification: The Ultimate Guide for 2024

tags 8 min 2024-01-31author theTable
title

How to Create a Temporary Table with SQL

tags 10 min 2024-01-29author theTable
title

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

tags pg_dump POSTGRESQL 8 min 2024-01-25author theTable
title

Understanding the DATEDIFF SQL Function: A Comprehensive Guide

tags DATE 7 min 2024-01-24author theTable
title

A Comprehensive Guide to Data Types in Postgres

tags DATA TYPES POSTGRESQL 10 min 2024-01-23author theTable
title

SQL CONTAINS Function: SQL Server Guide With Examples

tags SQL 8 min 2024-01-18author theTable
title

A Complete Guide to SUBSTRING_INDEX in SQL

tags MySQL 6 min 2024-01-16author theTable
title

SQL DISTINCT: A Comprehensive Guide

tags DISTINCT POSTGRESQL SQL 5 MINS 2024-01-11author theTable
title

SQL Interview Questions – SQL Queries

tags SQL 6 MINS 2024-01-08author theTable
title

Error: MySQL Shutdown Unexpectedly - The Solution

tags MySQL 5 MINS 2024-01-04author theTable
title

The Complete Guide to the SQL COALESCE Function

tags COALESCE 5 MINS 2024-01-02author theTable
title

The SQL BETWEEN Clause Explained

tags BETWEEN SQL 6 MINS 2023-12-28author theTable
title

SQLite Viewer: Guide and top picks

tags SQLITE 4 MINS 2023-12-26author theTable
title

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

tags STATIC CODE 3 MINS 2023-12-21author theTable
title

PostgreSQL DISTINCT: Removing Duplicate Rows from a Result Set

tags DISTINCT 6 MINS 2023-12-18author theTable
title

View vs Materialized View in databases: Differences and Use cases

tags VIEWS 8 MINS 2023-12-14author theTable
title

Date Formatting in Postgres: A Comprehensive Guide

tags DATE POSTGRESQL 7 MINS 2023-12-11author theTable
title

Casting in PostgreSQL: Handling Data Type Conversions Effectively

tags CAST POSTGRESQL 5 MINS 2023-12-07author theTable
title

PostgreSQL Materialized Views: A Beginner's Guide

tags POSTGRESQL VIEWS 7 MINS 2023-12-04author theTable
title

Inner Join in SQL: A Comprehensive Guide

tags JOIN 10 MINS 2023-11-30author theTable
title

Leveraging Snowflake's Time Travel

tags SNOWFLAKE TIME TRAVEL 11 MINS 2023-11-28author theTable
title

MariaDB vs MySQL: The Ultimate Comparison

tags MARIADB MySQL 7 MINS 2023-11-23author theTable
title

Change Data Capture: A Comprehensive Guide

tags DATA CAPTURE 14 MINS 2023-11-21author theTable
title

SQL vs NoSQL Databases: Which is Better?

tags NOSQL SQL 16 MINS 2023-11-20author theTable
title

Postgres List Users: Two Different Approaches 

tags LIST USERS POSTGRESQL 3 MINS 2023-11-16author theTable
title

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

tags CHEAT SHEET SQL 18 MINS 2023-11-15author theTable
title

Error Establishing a database connection - Common Reasons and Solutions

tags CONNECTION ERROR 12 MINS 2023-11-13author theTable
title

How to work with SQL query optimization

tags PERFORMANCE 10 MINS 2023-11-09author theTable
title

Low-code for DBA's

tags DBA DRONAHQ 4 MINS 2023-10-31author theTable
title

SQL Interview Questions (MySQL): Part 1

tags MySQL 6 MINS 2023-10-25author theTable
title

Working with Numeric Data Types in MySQL: A Comprehensive Guide

tags MySQL 4 MINS 2023-10-19author theTable
title

No-code Ways of Generating SQL Queries.

tags QUERY GENERATION 6 MINS 2023-10-17author theTable
title

Understanding Self Joins in SQL

tags JOIN 5 MINS 2023-10-12author theTable
title

Discover DbVisualizer Security Features for MySQL

tags MySQL SECURITY 6 MINS 2023-10-10author theTable
title

MySQL Operators – A Guide

tags MySQL OPERATORS 5 MINS 2023-10-05author theTable
title

NULLs Are Not The Same – A Guide

tags MySQL NULL 4 MINS 2023-10-03author theTable
title

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

tags MySQL RESERVED WORDS 5 MINS 2023-09-28author theTable
title

Oracle Create Database Link

tags ORACLE 7 MINS 2023-09-26author theTable
title

Using the EXPLAIN plan to analyze Query execution in PostgreSQL

tags EXPLAIN POSTGRESQL 6 MINS 2023-09-21author theTable
title

Deleting a Column in SQL: Everything You Need to Know

tags DELETE 7 MINS 2023-09-19author theTable
title

PostgreSQL's STRING_AGG() Function - A Comprehensive Guide

tags POSTGRESQL 3 MINS 2023-09-14author theTable
title

DESCRIBE TABLE PostgreSQL Alternatives

tags POSTGRESQL 5 MINS 2023-09-12author theTable
title

PostgreSQL vs MySQL: The Definitive Comparison

tags MySQL POSTGRESQL 8 MINS 2023-09-08author theTable
title

PostgreSQL JSONPATH: Dealing with the SQL/JSON Path Language

tags JSON POSTGRESQL 7 MINS 2023-09-05author theTable
title

PostgreSQL ISNULL: The Missing Function

tags NULL POSTGRESQL 5 MINS 2023-09-05author theTable
title

What Is a Database Driver and How Does It Work

tags DRIVER JDBC ODBC 5 MINS 2023-08-31author theTable
title

How To Kill All Connections to a Database in PostgreSQL

tags CONNECTION POSTGRESQL 4 MINS 2023-08-29author theTable
title

Duplicate Records in a DBMS – Removal, Upsides and Downsides

tags DEDUPLICATION 3 MINS 2023-08-24author theTable
title

A Beginners Guide to SQL Window Functions

tags FUNCTIONS SQL 6 MINS 2023-08-18author theTable
title

Math Functions in Databases – MySQL Edition

tags MATH MySQL 4 MINS 2023-08-15author theTable
title

Containerizing MySQL with Docker and DbVisualizer

tags Docker MySQL 6 MINS 2023-08-07author theTable
title

Efficiently Creating and Managing Views in SQL

tags VIEWS 9 MINS 2023-08-07author theTable
title

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

tags JOIN 12 MINS 2023-07-31author theTable
title

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

tags INDEX MySQL 6 MINS 2023-07-31author theTable
title

Google BigQuery: A Beginner’s Guide

tags BIGQUERY 7 MINS 2023-07-24author theTable
title

How to Join Three or More Tables with SQL

tags JOIN 7 MINS 2023-07-24author theTable
title

PostgreSQL CTE: What It Is and How to Use It

tags POSTGRESQL 6 MINS 2023-07-17author theTable
title

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

tags MySQL WILDCARD 4 MINS 2023-07-17author theTable
title

Postgres ON DELETE CASCADE - A Guide

tags POSTGRESQL 6 MINS 2023-07-10author theTable
title

Mastering the Trino Connection: Unleash the Power of DbVisualizer!

tags TRINO 9 MINS 2023-07-10author theTable
title

Querying Data with DbVisualizer and PrestoDb

tags PRESTODB 9 MINS 2023-07-07author theTable
title

Automating Database Operations with Ansible and DbVisualizer

tags ANSIBLE AUTOMATION 8 MINS 2023-07-04author theTable
title

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

tags MONGODB 14 MINS 2023-06-28author theTable
title

PostgreSQL COALESCE Function: Handling NULL Values Effectively

tags POSTGRESQL 6 MINS 2023-06-27author theTable
title

Bridging the Gap Between SQL and NoSQL in PostgreSQL with JSON

tags JSON NOSQL POSTGRESQL 10 MINS 2023-06-22author theTable
title

A Guide to Data Types in Oracle

tags DATA TYPES ORACLE 8 MINS 2023-06-20author theTable
title

Preventing SQL Injection Attacks with DbVisualizer

tags SECURITY 8 MINS 2023-06-13author theTable
title

How to Delete Elasticsearch Indices: An In-Depth Tutorial

tags ELASTICSEARCH 3 MINS 2023-06-13author theTable
title

Designing a Multi-Language Database

tags Design Language 5 MINS 2023-06-12author theTable
title

DELETE Queries – Advanced CRUD explanation part 4

tags CRUD DELETE 6 MINS 2023-06-08author theTable
title

UPDATE Queries - Advanced CRUD explanation part 3

tags CRUD UPDATE 7 MINS 2023-06-08author theTable
title

SELECT Queries - Advanced CRUD explanation part 2

tags CRUD SELECT 6 MINS 2023-06-07author theTable
title

INSERT Queries - Advanced CRUD explanation part 1

tags CRUD INSERT 4 MINS 2023-06-07author theTable
title

Mastering Advanced SQL Queries With DbVisualizer And PostgreSQL

tags POSTGRESQL 20 MINS 2023-06-01author theTable
title

MySQL’s UTF-8: Is It Real?

tags MySQL 7 MINS 2023-06-01author theTable
title

Exploring the MySQL Daemon – A Guide

tags DAEMON MySQL 7 MINS 2023-05-30author theTable
title

Why do we call software bugs, bugs?

tags BUG 4 MINS 2023-05-30author theTable
title

Archiving Data in MySQL Using Partitions

tags MySQL PARTITIONS 7 MINS 2023-05-25author theTable
title

Migrating Data Between Databases Using DbVisualizer

tags MIGRATION MySQL POSTGRESQL 7 MINS 2023-05-25author theTable
title

Storing Unstructured Data With Hstore in PostgreSQL

tags HSTORE POSTGRESQL 9 MINS 2023-05-23author theTable
title

How to Pronounce SQL: SQL or Sequel?

tags SQL 3 MINS 2023-05-23author theTable
title

How to Make Your SQL Server More Secure

tags SECURITY SQL SERVER 8 MINS 2023-05-17author theTable
title

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

tags MySQL 2 MINS 2023-05-17author theTable
title

Creating Custom Visualizations with DbVisualizer

tags VISUALIZE 6 MINS 2023-05-16author theTable
title

MySQL SUBSTRING Function: The Complete Guide

tags MySQL 2 MINS 2023-05-16author theTable
title

Parameterized Queries in SQL – A Guide

tags SECURITY SQL 5 MINS 2023-05-12author theTable
title

Understanding PostgreSQL Data Integrity

tags POSTGRESQL 10 MINS 2023-05-08author theTable
title

How to Set Up Postgres using Docker

tags Docker POSTGRESQL 3 MINS 2023-05-08author theTable
title

How to Connect to MySQL Using Admin Account Remotely

tags CONNECTION MySQL 7 MINS 2023-05-05author theTable
title

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

tags DATES MSSQL 4 MINS 2023-05-04author theTable
title

How to List Databases in Postgres Using psql and Other Techniques

tags POSTGRESQL 6 MINS 2023-05-03author theTable
title

The Ultimate Guide to Generated Columns

tags COLUMNS 7 MINS 2023-04-29author theTable
title

Solved: sudo mysql_secure_installation command not found in MariaDB

tags MARIADB SECURITY 3 MINS 2023-04-27author theTable
title

Why Are Your Databases Slow with Large Tables? An Overview

tags PERFORMANCE 9 MINS 2023-04-27author theTable
title

MySQL User Management: A Guide

tags SECURITY 8 MINS 2023-04-25author theTable
title

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

tags ERD 8 MINS 2023-04-19author theTable
title

A Guide to Multithreading in SQL

tags PERFORMANCE 8 MINS 2023-04-14author theTable
title

Best Practices for SQL Coding and Development

tags SQL 12 MINS 2023-04-11author theTable
title

Character Sets vs. Collations in a MySQL Database Infrastructure

tags MySQL 6 MINS 2023-04-06author theTable
title

10x Query Performance with a Database Index

tags INDEXES PERFORMANCE 6 MINS 2023-04-04author theTable
title

A Guide to Subqueries in MySQL

tags MySQL SUBQUERY 6 MINS 2023-03-30author theTable
title

ACID in Database Systems: All You Need to Know

tags ACID 5 MINS 2023-03-28author theTable
title

Deadlocks in Databases: A Guide

tags PERFORMANCE 6 MINS 2023-03-28author theTable
title

ALTER TABLE Explained

tags ALTER TABLE 8 MINS 2023-03-23author theTable
title

The Ultimate Guide to the MySQL Port

tags MySQL PORTS 3 MINS 2023-03-23author theTable
title

Preventing Illicit Uploads in MySQL – secure_file_priv

tags MySQL SECURITY 7 MINS 2023-03-21author theTable
title

A Guide to ACID In MySQL

tags ACID MySQL SECURITY 6 MINS 2023-03-17author theTable
title

BLOB Data Type: Everything You Can Do With It

tags BLOB 8 MINS 2023-03-13author theTable
title

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

tags FOREIGN KEY POSTGRESQL 3 MINS 2023-03-13author theTable
title

Getting Started with Multiversion Concurrency Control (MVCC) in PostgreSQL

tags CONCURRENCY POSTGRESQL 8 MINS 2023-03-10author theTable
title

Best Practices for Encrypting Data In Your Database

tags ENCRYPTION SECURITY 6 MINS 2023-03-07author theTable
title

Database Security 101: Best Practices to Secure Your Data

tags SECURITY 7 MINS 2023-03-02author theTable
title

Working with NULL in Databases: Turn Your Frustration Into Delight

tags MySQL NULL 5 MINS 2023-02-23author theTable
title

How To Secure Data In A Postgres Database: A Guide

tags POSTGRESQL SECURITY 13 MINS 2023-02-21author theTable
title

The Complete Guide to SQL Subqueries

tags SUBQUERY 7 MINS 2023-02-17author theTable
title

Database Transactions 101: The Essential Guide

tags TRANSACTIONS 5 MINS 2023-02-14author theTable
title

A Comprehensive Guide to Data Structures in SQL

tags DATA STRUCTURES 8 MINS 2023-02-09author theTable
title

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

tags TRIGGERS 8 MINS 2023-02-06author theTable
title

How To Create a Table Like Another Table in MySQL

tags MySQL 5 MINS 2023-02-03author theTable
title

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

tags SSH 7 MINS 2023-01-31author theTable
title

Stored Procedures in SQL: A Complete Tutorial

tags MySQL STORED PROCEDURE 12 MINS 2023-01-27author theTable
title

SQL Triggers: What They Are and How to Use Them

tags TRIGGERS 6 MINS 2023-01-26author theTable
title

Using PostgreSQL to Manage Business Inventory Data and Visualize It

tags POSTGRESQL 7 MINS 2023-01-23author theTable
title

Top five query tuning techniques for Microsoft SQL Server

tags MICROSOFT SQL SERVER OPTIMIZATION 8 MINS 2023-01-19author theTable
title

How To Design And Build A Database In Postgres

tags POSTRESQL 12 MINS 2023-01-16author theTable
title

Writing Reusable SQL Queries For Your Application with DbVisualizer Scripts

tags REUSABLE QUERIES 7 MINS 2023-01-12author theTable
title

How To Deal With a Database With Billions of Records

tags BIG DATA 7 MINS 2023-01-06author theTable
title

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

tags MySQL SECURITY 9 MINS 2022-12-28author theTable
title

Fixing Messy Queries with DbVisualizer – a Guide for MySQL

tags MySQL 8 MINS 2022-12-22author theTable
title

SQL for Beginners: 3 Sites You Should Know About

tags BEGINNER SQL 4 MINS 2022-12-22author theTable
title

SQL Transactions in a Flask CRUD Application

tags CRUD SQL TRANSACTIONS 8 MINS 2022-12-16author theTable
title

Architecting for Security: MySQL Edition

tags MySQL SECURITY 10 MINS 2022-12-08author theTable
title

JSON vs. JSONB in PostgreSQL: A Complete Comparison

tags JSON POSTGRESQL 5 MINS 2022-12-02author theTable
title

InnoDB and ibdata1: Things You Need to Know

tags IBDATA1 INNODB MySQL 6 MINS 2022-11-09author theTable
title

Optimizing Queries for Performance: MySQL Edition

tags MySQL 9 MINS 2022-11-09author theTable
title

Filtering on aggregated data

tags FILTER 7 MINS 2022-03-21author theTable
title

Create Your Own SQLite Database

tags SQLITE 8 MINS 2021-12-21author theTable
title

How to join your tables using ERD

tags ERD JOIN 8 MINS 2021-12-21author theTable
title

Excel to SQL Basics

tags EXCEL EXPORT 10 MINS 2021-12-21author theTable
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 ↗