TheTable Blog

The Table by DbVisualizer ↗ is where we gather together to learn about and simplify the complexity of working with database technologies.
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