Information
Close
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
PostgreSQL
Mastering Advanced SQL Queries With DbVisualizer And PostgreSQL
Author: Leslie S. Gyamfi
Length: 20 MINS
Type: Guide
Date: 2023-06-01
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
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
ERD
Join
How to join your tables using ERD
Author: Scott A. Adams
Length: 8 MINS
Type: Guide
Date: 2021-12-21