Skip to content

DEV Community

The Table Series' Articles

Back to DbVisualizer's Series

Cover image for Understanding SQL COALESCE for Null Handling

Oct 17 '24

Understanding SQL COALESCE for Null Handling

#coalesce

2 min read

Cover image for SQL Inner Joins Simplified

Oct 21 '24

SQL Inner Joins Simplified

#joins

2 min read

Cover image for Essential MySQL Operators and Their Applications

Oct 24 '24

Essential MySQL Operators and Their Applications

#mysql #operators

2 min read

Cover image for MySQL Daemon Overview and Tools

Oct 28 '24

MySQL Daemon Overview and Tools

#daemon #mysql

1 min read

Cover image for MySQL Numeric Data Types Explained

Oct 31 '24

MySQL Numeric Data Types Explained

#mysql

2 min read

Cover image for Quick Guide to INSERT Queries in MySQL

Nov 4 '24

Quick Guide to INSERT Queries in MySQL

1 min read

Cover image for Boosting Performance with SELECT Queries in CRUD

Nov 7 '24

Boosting Performance with SELECT Queries in CRUD

1 min read

Cover image for Unlocking the Power of UPDATE Queries in Databases

Nov 11 '24

Unlocking the Power of UPDATE Queries in Databases

1 min read

Cover image for A Brief Guide to SQL DELETE Queries

Nov 14 '24

A Brief Guide to SQL DELETE Queries

1 min read

Cover image for Quick Guide to MySQL Math Functions for SQL Users

Nov 18 '24

Quick Guide to MySQL Math Functions for SQL Users

#mysql

2 min read

Cover image for Simplify Data Migration Between Databases Using DbVisualizer

Nov 21 '24

Simplify Data Migration Between Databases Using DbVisualizer

#migration #mysql #postgres

1 min read

Cover image for Database Deadlocks: Causes, Examples, and Solutions

Nov 25 '24

Database Deadlocks: Causes, Examples, and Solutions

#performance

1 min read

Cover image for SQL Interview Prep for MySQL: Key Questions to Know

Nov 28 '24

SQL Interview Prep for MySQL: Key Questions to Know

2 min read

Cover image for Boost MySQL Performance with Data Partitioning

Dec 2 '24

Boost MySQL Performance with Data Partitioning

#mysql #partitions

2 min read

Cover image for Why Large Tables Slow Down Your Database

Dec 5 '24

Why Large Tables Slow Down Your Database

#performance

2 min read

Cover image for SQL vs NoSQL Databases: Choosing the Right Tool

Dec 9 '24

SQL vs NoSQL Databases: Choosing the Right Tool

1 min read

Cover image for ALTER TABLE: A Quick Overview for Developers

Dec 12 '24

ALTER TABLE: A Quick Overview for Developers

1 min read

Cover image for Avoiding Errors with MySQL Reserved Words

Dec 16 '24

Avoiding Errors with MySQL Reserved Words

1 min read

Cover image for Streamlining Data Auditing with Snowflake Time Travel

Dec 19 '24

Streamlining Data Auditing with Snowflake Time Travel

1 min read

Cover image for Change Data Capture: A Beginner’s Overview

Dec 23 '24

Change Data Capture: A Beginner’s Overview

1 min read

Cover image for Avoiding the Pitfalls of Duplicate Indexes in MySQL

Dec 30 '24

Avoiding the Pitfalls of Duplicate Indexes in MySQL

#index #mysql

1 min read

Cover image for Simplify Distributed Queries with Presto and DbVisualizer

Jan 2 '25

Simplify Distributed Queries with Presto and DbVisualizer

#prestodb

2 min read

Cover image for How to Use SUBSTRING_INDEX in MySQL

Jan 6 '25

How to Use SUBSTRING_INDEX in MySQL

#mysql

1 min read

Cover image for Simplifying PostgreSQL User Management: Two Methods

Jan 9 '25

Simplifying PostgreSQL User Management: Two Methods

#postgres #userlist

1 min read

Cover image for How to Quickly Fix the "Error Establishing a Database Connection"

Jan 13 '25

How to Quickly Fix the "Error Establishing a Database Connection"

2 min read

Cover image for A Practical Guide to NULL in SQL Databases

Jan 16 '25

A Practical Guide to NULL in SQL Databases

2 min read

Cover image for Advanced SQL Techniques for PostgreSQL Using DbVisualizer

Jan 20 '25

Advanced SQL Techniques for PostgreSQL Using DbVisualizer

#postgressql

1 min read

Cover image for Secure Your Database: How DbVisualizer Prevents SQL Injection

Jan 23 '25

Secure Your Database: How DbVisualizer Prevents SQL Injection

2 min read

Jan 27 '25

Practical SQL Query Optimization Tips You Should Know

#performance

1 min read

Cover image for A Beginner’s Guide to MySQL Character Sets and Collations

Jan 30 '25

A Beginner’s Guide to MySQL Character Sets and Collations

#mysql

2 min read