Skip to content

DEV Community

The Table Series' Articles

Back to DbVisualizer's Series

Cover image for MySQL utf8 vs utf8mb4: Which One Should You Use?

Feb 3 '25

MySQL utf8 vs utf8mb4: Which One Should You Use?

#mysql

1 min read

Cover image for How Database Indexes Improve SQL Query Performance

Feb 6 '25

How Database Indexes Improve SQL Query Performance

#indexes #performance

2 min read

Cover image for MySQL INSERT Queries Made Simple

Feb 10 '25

MySQL INSERT Queries Made Simple

#insert

2 min read

Cover image for Faster SELECT Queries: Key Tips for Efficient Database Reads

Feb 13 '25

Faster SELECT Queries: Key Tips for Efficient Database Reads

#sql

2 min read

Cover image for Quick Guide to UPDATE Queries: How to Modify Data Efficiently

Feb 17 '25

Quick Guide to UPDATE Queries: How to Modify Data Efficiently

#update

2 min read

Cover image for Simplified Guide to SQL DELETE Queries

Feb 20 '25

Simplified Guide to SQL DELETE Queries

#delete

1 min read

Cover image for Database Security Made Simple: Essential Practices

Feb 24 '25

Database Security Made Simple: Essential Practices

#security

2 min read

Cover image for Mastering MySQL Security: Key Steps to Protect Your Database

Feb 27 '25

Mastering MySQL Security: Key Steps to Protect Your Database

#mysql #security

2 min read

Cover image for Simplify SQL Queries with COALESCE

Mar 3 '25

Simplify SQL Queries with COALESCE

#sqlserver

1 min read

Cover image for Fixing MySQL Shutdown Unexpectedly Error

Mar 6 '25

Fixing MySQL Shutdown Unexpectedly Error

#mysql

2 min read

Cover image for Ace Your SQL Interview with These Query Tips

Mar 10 '25

Ace Your SQL Interview with These Query Tips

#sql

1 min read

Cover image for Getting Started with SQL DISTINCT

Mar 13 '25

Getting Started with SQL DISTINCT

#sql #postgres

2 min read

Cover image for SUBSTRING_INDEX in MySQL: A Simple Guide to String Extraction

Mar 17 '25

SUBSTRING_INDEX in MySQL: A Simple Guide to String Extraction

#mysql

2 min read

Cover image for Mastering SQL Server CONTAINS for Advanced Text Search

Mar 20 '25

Mastering SQL Server CONTAINS for Advanced Text Search

#sql

1 min read

Cover image for PostgreSQL Data Types: An Essential Guide

Mar 24 '25

PostgreSQL Data Types: An Essential Guide

#datatype #postgres

1 min read

Cover image for SQL DATEDIFF Explained: Syntax and Database Differences

Mar 27 '25

SQL DATEDIFF Explained: Syntax and Database Differences

#date

1 min read

Cover image for pg_dump PostgreSQL Backups: A Quick and Practical Guide

Mar 31 '25

pg_dump PostgreSQL Backups: A Quick and Practical Guide

#pgdump #postgres

2 min read

Apr 3 '25

SQL Temporary Tables: A Quick and Practical Guide

#sql

2 min read

Cover image for Handling Big Data in SQL Databases – Pitfalls to Avoid

Apr 7 '25

Handling Big Data in SQL Databases – Pitfalls to Avoid

#bigdata

2 min read

Cover image for Essential PostgreSQL Data Types Explained

Apr 10 '25

Essential PostgreSQL Data Types Explained

2 min read

Cover image for Three practical ways to create a database in MySQL

Apr 14 '25

Three practical ways to create a database in MySQL

#createtable #mysql

2 min read

Cover image for How to Use SQL Views to Simplify Data Access and Reporting

Apr 17 '25

How to Use SQL Views to Simplify Data Access and Reporting

#sqlviews

1 min read

Cover image for SQL DDL Commands Explained: Structuring Your Database

Apr 21 '25

SQL DDL Commands Explained: Structuring Your Database

#sql #ddl

2 min read

Cover image for Outer Joins in SQL: The Key to Keeping Unmatched Rows

Apr 24 '25

Outer Joins in SQL: The Key to Keeping Unmatched Rows

#join

2 min read

Cover image for PostgreSQL CASE: Build Smarter Queries with Conditional Logic

Apr 28 '25

PostgreSQL CASE: Build Smarter Queries with Conditional Logic

#postgressql #case

1 min read

Cover image for PostgreSQL CASE: Conditional Logic for Powerful SQL Queries

May 1 '25

PostgreSQL CASE: Conditional Logic for Powerful SQL Queries

#postgressql #case

2 min read

Cover image for Efficient String Splitting in PostgreSQL: 5 Essential Functions

May 5 '25

Efficient String Splitting in PostgreSQL: 5 Essential Functions

#postgressql #split

1 min read

Cover image for How to Start with Database Migrations

May 8 '25

How to Start with Database Migrations

#migration

2 min read

Cover image for Clean SQL with Comments: Syntax and Practices for All Engines

May 12 '25

Clean SQL with Comments: Syntax and Practices for All Engines

#sql

1 min read

Cover image for Database Schema Design: How to Structure Your App’s Data Effectively

May 15 '25

Database Schema Design: How to Structure Your App’s Data Effectively

#schema

2 min read