TheTable Blog

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

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

Author: Lukas Vileikis
Length: 5 MINS
Type: Guide
Date: 2023-09-28
Oracle

Oracle Create Database Link

Author: Igor Bobriakov
Length: 7 MINS
Type: Guide
Date: 2023-09-26
PostgreSQL
EXPLAIN

Using the EXPLAIN plan to analyze Query execution in PostgreSQL

Author: Bonnie
Length: 6 MINS
Type: Guide
Date: 2023-09-21
DELETE

Deleting a Column in SQL: Everything You Need to Know

Author: Antonello Zanini
Length: 7 MINS
Type: Guide
Date: 2023-09-19
PostgreSQL

PostgreSQL's STRING_AGG() Function - A Comprehensive Guide

Author: TheTable
Length: 3 MINS
Type: Guide
Date: 2023-09-14
PostgreSQL

DESCRIBE TABLE PostgreSQL Alternatives

Author: Antonello Zanini
Length: 5 MINS
Type: Guide
Date: 2023-09-12
PostgreSQL
MySQL

PostgreSQL vs MySQL: The Definitive Comparison

Author: Antonello Zanini
Length: 8 MINS
Type: Guide
Date: 2023-09-08
PostgreSQL
JSON

PostgreSQL JSONPATH: Dealing with the SQL/JSON Path Language

Author: Antonello Zanini
Length: 7 MINS
Type: Guide
Date: 2023-09-05
PostgreSQL
Null

PostgreSQL ISNULL: The Missing Function

Author: Antonello Zanini
Length: 5 MINS
Type: Guide
Date: 2023-09-05
Driver
JDBC
ODBC

What Is a Database Driver and How Does It Work

Author: Antonello Zanini
Length: 5 MINS
Type: Guide
Date: 2023-08-31
PostgreSQL
Connection

How To Kill All Connections to a Database in PostgreSQL

Author: Antonello Zanini
Length: 4 MINS
Type: Guide
Date: 2023-08-29
Deduplication

Duplicate Records in a DBMS – Removal, Upsides and Downsides

Author: Lukas Vileikis
Length: 3 MINS
Type: Guide
Date: 2023-08-24
MySQL

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

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2023-08-22
SQL
Functions

A Beginners Guide to SQL Window Functions

Author: Ochuko Onojakpor
Length: 6 MINS
Type: Guide
Date: 2023-08-18
MySQL
Math

Math Functions in Databases – MySQL Edition

Author: Lukas Vileikis
Length: 4 MINS
Type: Guide
Date: 2023-08-15
Docker
MySQL

Containerizing MySQL with Docker and DbVisualizer

Author: Ochuko Onojakpor
Length: 6 MINS
Type: Guide
Date: 2023-08-07
Views

Efficiently Creating and Managing Views in SQL

Author: Ochuko Onojakpor
Length: 9 MINS
Type: Guide
Date: 2023-08-07
MySQL
Index

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

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2023-07-31
JOIN

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

Author: Leslie S. Gyamfi
Length: 12 MINS
Type: Guide
Date: 2023-07-31
BigQuery

Google BigQuery: A Beginner’s Guide

Author: Bonnie
Length: 7 MINS
Type: Guide
Date: 2023-07-24
Join

How to Join Three or More Tables with SQL

Author: Leslie S. Gyamfi
Length: 7 MINS
Type: Guide
Date: 2023-07-24
PostgreSQL

PostgreSQL CTE: What It Is and How to Use It

Author: Antonello Zanini
Length: 6 MINS
Type: Guide
Date: 2023-07-17
MySQL
Wildcard

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

Author: Lukas Vileikis
Length: 4 MINS
Type: Guide
Date: 2023-07-17
PostgreSQL

Postgres ON DELETE CASCADE - A Guide

Author: Leslie S. Gyamfi
Length: 6 MINS
Type: Guide
Date: 2023-07-10
Trino

Mastering the Trino Connection: Unleash the Power of DbVisualizer!

Author: Ochuko Onojakpor
Length: 9 MINS
Type: Guide
Date: 2023-07-10
PrestoDb

Querying Data with DbVisualizer and PrestoDb

Author: Ochuko Onojakpor
Length: 9 MINS
Type: Guide
Date: 2023-07-07
Ansible
Automation

Automating Database Operations with Ansible and DbVisualizer

Author: Ochuko Onojakpor
Length: 8 MINS
Type: Guide
Date: 2023-07-04
MongoDB

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

Author: Ochuko Onojakpor
Length: 14 MINS
Type: Guide
Date: 2023-06-28
PostgreSQL

PostgreSQL COALESCE Function: Handling NULL Values Effectively

Author: Antonello Zanini
Length: 6 MINS
Type: Guide
Date: 2023-06-27
PostgreSQL
NoSQL
JSON

Bridging the Gap Between SQL and NoSQL in PostgreSQL with JSON

Author: Leslie S. Gyamfi
Length: 10 MINS
Type: Guide
Date: 2023-06-22
Oracle
Data types

A Guide to Data Types in Oracle

Author: Igor Bobriakov
Length: 8 MINS
Type: Guide
Date: 2023-06-20
ElasticSearch

How to Delete Elasticsearch Indices: An In-Depth Tutorial

Author: TheTable
Length: 3 MINS
Type: Guide
Date: 2023-06-13
Security

Preventing SQL Injection Attacks with DbVisualizer

Author: Ochuko Onojakpor
Length: 8 MINS
Type: Guide
Date: 2023-06-13
Language
Design

Designing a Multi-Language Database

Author: Lukas Vileikis
Length: 5 MINS
Type: Guide
Date: 2023-06-12
CRUD
DELETE

DELETE Queries – Advanced CRUD explanation part 4

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2023-06-08
CRUD
UPDATE

UPDATE Queries - Advanced CRUD explanation part 3

Author: Lukas Vileikis
Length: 7 MINS
Type: Guide
Date: 2023-06-08
CRUD
SELECT

SELECT Queries - Advanced CRUD explanation part 2

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2023-06-07
CRUD
INSERT

INSERT Queries - Advanced CRUD explanation part 1

Author: Lukas Vileikis
Length: 4 MINS
Type: Guide
Date: 2023-06-07
MySQL

MySQL’s UTF-8: Is It Real?

Author: Lukas Vileikis
Length: 7 MINS
Type: Guide
Date: 2023-06-01
PostgreSQL

Mastering Advanced SQL Queries With DbVisualizer And PostgreSQL

Author: Leslie S. Gyamfi
Length: 20 MINS
Type: Guide
Date: 2023-06-01
Bug

Why do we call software bugs, bugs?

Author: TheTable
Length: 4 MINS
Type: Guide
Date: 2023-05-30
MySQL
Daemon

Exploring the MySQL Daemon – A Guide

Author: Lukas Vileikis
Length: 7 MINS
Type: Guide
Date: 2023-05-30
MySQL
Partitions

Archiving Data in MySQL Using Partitions

Author: Lukas Vileikis
Length: 7 MINS
Type: Guide
Date: 2023-05-25
Migration
MySQL
PostgreSQL

Migrating Data Between Databases Using DbVisualizer

Author: Leslie S. Gyamfi
Length: 7 MINS
Type: Guide
Date: 2023-05-25
SQL

The Top Four Sites for Database Professionals Seeking New Job Opportunities

Author: TheTable
Length: 2 MINS
Type: Guide
Date: 2023-05-23
PostgreSQL
hstore

Storing Unstructured Data With Hstore in PostgreSQL

Author: Antonello Zanini
Length: 9 MINS
Type: Guide
Date: 2023-05-23
SQL

How to Pronounce SQL: SQL or Sequel?

Author: TheTable
Length: 3 MINS
Type: Guide
Date: 2023-05-23
SQL server
Security

How to Make Your SQL Server More Secure

Author: Igor Bobriakov
Length: 8 MINS
Type: Guide
Date: 2023-05-17
MySQL

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

Author: TheTable
Length: 2 MINS
Type: Guide
Date: 2023-05-17
Visualize

Creating Custom Visualizations with DbVisualizer

Author: Ochuko Onojakpor
Length: 6 MINS
Type: Guide
Date: 2023-05-16
MySQL

MySQL SUBSTRING Function: The Complete Guide

Author: TheTable
Length: 2 MINS
Type: Guide
Date: 2023-05-16
SQL
Security

Parameterized Queries in SQL – A Guide

Author: Lukas Vileikis
Length: 5 MINS
Type: Guide
Date: 2023-05-12
PostgreSQL

Understanding PostgreSQL Data Integrity

Author: Antonello Zanini
Length: 10 MINS
Type: Guide
Date: 2023-05-08
PostgreSQL
Docker

How to Set Up Postgres using Docker

Author: TheTable
Length: 3 MINS
Type: Guide
Date: 2023-05-08
MSSQL
Dates

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

Author: TheTable
Length: 4 MINS
Type: Guide
Date: 2023-05-04
PostgreSQL

How to List Databases in Postgres Using psql and Other Techniques

Author: Antonello Zanini
Length: 6 MINS
Type: Guide
Date: 2023-05-03
MySQL
Connection

How to Connect to MySQL Using Admin Account Remotely

Author: Lukas Vileikis
Length: 7 MINS
Type: Guide
Date: 2023-05-03
MariaDB
Security

Solved: sudo mysql_secure_installation command not found in MariaDB

Author: TheTable
Length: 3 MINS
Type: Guide
Date: 2023-04-27
Performance

Why Are Your Databases Slow with Large Tables? An Overview

Author: Lukas Vileikis
Length: 9 MINS
Type: Guide
Date: 2023-04-27
Security

MySQL User Management: A Guide

Author: Lukas Vileikis
Length: 8 MINS
Type: Guide
Date: 2023-04-25
Columns

The Ultimate Guide to Generated Columns

Author: Antonello Zanini
Length: 7 MINS
Type: Guide
Date: 2023-04-20
ERD

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

Author: Antonello Zanini
Length: 8 MINS
Type: Guide
Date: 2023-04-19
Performance

A Guide to Multithreading in SQL

Author: Ochuko Onojakpor
Length: 8 MINS
Type: Guide
Date: 2023-04-14
SQL

Best Practices for SQL Coding and Development

Author: Ochuko Onojakpor
Length: 12 MINS
Type: Guide
Date: 2023-04-11
MySQL

Character Sets vs. Collations in a MySQL Database Infrastructure

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2023-04-06
Performance
Indexes

10x Query Performance with a Database Index

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2023-04-04
MySQL
Subquery

A Guide to Subqueries in MySQL

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2023-03-30
Performance

Deadlocks in Databases: A Guide

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2023-03-28
ACID

ACID in Database Systems: All You Need to Know

Author: Lukas Vileikis
Length: 5 MINS
Type: Guide
Date: 2023-03-28
ALTER TABLE

ALTER TABLE Explained

Author: Lukas Vileikis
Length: 8 MINS
Type: Guide
Date: 2023-03-23
MySQL
Ports

The Ultimate Guide to the MySQL Port

Author: TheTable
Length: 3 MINS
Type: Guide
Date: 2023-03-23
MySQL
Security

Preventing Illicit Uploads in MySQL – secure_file_priv

Author: Lukas Vileikis
Length: 7 MINS
Type: Guide
Date: 2023-03-21
ACID
MySQL
Security

A Guide to ACID In MySQL

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2023-03-17
BLOB

BLOB Data Type: Everything You Can Do With It

Author: Antonello Zanini
Length: 8 MINS
Type: Guide
Date: 2023-03-13
Foreign Key
PostgreSQL

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

Author: TheTable
Length: 3 MINS
Type: Guide
Date: 2023-03-13
PostgreSQL
Concurrency

Getting Started with Multiversion Concurrency Control (MVCC) in PostgreSQL

Author: Leslie S. Gyamfi
Length: 8 MINS
Type: Guide
Date: 2023-03-10
Security
Encryption

Best Practices for Encrypting Data In Your Database

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2023-03-07
Security

Database Security 101: Best Practices to Secure Your Data

Author: Lukas Vileikis
Length: 7 MINS
Type: Guide
Date: 2023-03-02
MySQL
NULL

Working with NULL in Databases: Turn Your Frustration Into Delight

Author: Lukas Vileikis
Length: 5 MINS
Type: Guide
Date: 2023-02-23
Security
PostgreSQL

How To Secure Data In A Postgres Database: A Guide

Author: Bonnie
Length: 13 MINS
Type: Guide
Date: 2023-02-21
Subquery

The Complete Guide to SQL Subqueries

Author: Antonello Zanini
Length: 7 MINS
Type: Guide
Date: 2023-02-17
Transactions

Database Transactions 101: The Essential Guide

Author: Antonello Zanini
Length: 5 MINS
Type: Guide
Date: 2023-02-14
Data structures

A Comprehensive Guide to Data Structures in SQL

Author: Ochuko Onojakpor
Length: 8 MINS
Type: Guide
Date: 2023-02-09
Triggers

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

Author: Ochuko Onojakpor
Length: 8 MINS
Type: Guide
Date: 2023-02-06
MySQL

How To Create a Table Like Another Table in MySQL

Author: Antonello Zanini
Length: 5 MINS
Type: Guide
Date: 2023-02-03
SSH

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

Author: Lukas Vileikis
Length: 7 MINS
Type: Guide
Date: 2023-01-31
Stored procedure
MySQL

Stored Procedures in SQL: A Complete Tutorial

Author: Antonello Zanini
Length: 12 MINS
Type: Guide
Date: 2023-01-27
Triggers

SQL Triggers: What They Are and How to Use Them

Author: Antonello Zanini
Length: 6 MINS
Type: Guide
Date: 2023-01-26
PostgreSQL

Using PostgreSQL to Manage Business Inventory Data and Visualize It

Author: Bonnie
Length: 7 MINS
Type: Guide
Date: 2023-01-23
Microsoft SQL Server
Optimization

Top five query tuning techniques for Microsoft SQL Server

Author: Igor Bobriakov
Length: 8 MINS
Type: Guide
Date: 2023-01-19
PostreSQL

How To Design And Build A Database In Postgres

Author: Bonnie
Length: 12 MINS
Type: Guide
Date: 2023-01-16
Reusable queries

Writing Reusable SQL Queries For Your Application with DbVisualizer Scripts

Author: Ochuko Onojakpor
Length: 7 MINS
Type: Guide
Date: 2023-01-12
BIG Data

How To Deal With a Database With Billions of Records

Author: Antonello Zanini
Length: 7 MINS
Type: Guide
Date: 2023-01-06
MySQL
Security

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

Author: Lukas Vileikis
Length: 9 MINS
Type: Guide
Date: 2022-12-28
MySQL

Fixing Messy Queries with DbVisualizer – a Guide for MySQL

Author: Lukas Vileikis
Length: 8 MINS
Type: Guide
Date: 2022-12-22
Beginner
SQL

SQL for Beginners: 3 Sites You Should Know About

Author: TheTable
Length: 4 MINS
Type: Guide
Date: 2022-12-22
CRUD
SQL Transactions

SQL Transactions in a Flask CRUD Application

Author: Ochuko Onojakpor
Length: 8 MINS
Type: Guide
Date: 2022-12-16
MySQL
Security

Architecting for Security: MySQL Edition

Author: Lukas Vileikis
Length: 10 MINS
Type: Guide
Date: 2022-12-08
PostgreSQL
JSON

JSON vs. JSONB in PostgreSQL: A Complete Comparison

Author: Antonello Zanini
Length: 5 MINS
Type: Guide
Date: 2022-12-02
MySQL
InnoDB
ibdata1

InnoDB and ibdata1: Things You Need to Know

Author: Lukas Vileikis
Length: 6 MINS
Type: Guide
Date: 2022-11-09
MySQL

Optimizing Queries for Performance: MySQL Edition

Author: Lukas Vileikis
Length: 9 MINS
Type: guide
Date: 2022-11-09
Filter

Filtering on aggregated data

Author: Scott A. Adams
Length: 7 MINS
Type: Guide
Date: 2022-03-21
SQLite

Create Your Own SQLite Database

Author: Scott A. Adams
Length: 8 MINS
Type: Guide
Date: 2021-12-21
Excel
Export

Excel to SQL Basics

Author: Scott A. Adams
Length: 10 MINS
Type: Guide
Date: 2021-12-21
ERD
Join

How to join your tables using ERD

Author: Scott A. Adams
Length: 8 MINS
Type: Guide
Date: 2021-12-21