DEV Community

The Table Series' Articles

Back to DbVisualizer's Series
Working with Numeric Data Types in MySQL: A Comprehensive Guide
Cover image for Working with Numeric Data Types in MySQL: A Comprehensive Guide
dbvismarketing profile

Working with Numeric Data Types in MySQL: A Comprehensive Guide

#mysql
Comments
5 min read
SQL Interview Questions (MySQL): Part 1
Cover image for SQL Interview Questions (MySQL): Part 1
dbvismarketing profile

SQL Interview Questions (MySQL): Part 1

#mysql
Comments 1
5 min read
How to work with SQL query optimization
Cover image for How to work with SQL query optimization
dbvismarketing profile

How to work with SQL query optimization

#performance
1
Comments
9 min read
Error Establishing a database connection - Common Reasons and Solutions
Cover image for Error Establishing a database connection - Common Reasons and Solutions
dbvismarketing profile

Error Establishing a database connection - Common Reasons and Solutions

#connection #errors
Comments
12 min read
SQL Cheat Sheet: A Comprehensive Guide to SQL Commands and Queries
Cover image for SQL Cheat Sheet: A Comprehensive Guide to SQL Commands and Queries
dbvismarketing profile

SQL Cheat Sheet: A Comprehensive Guide to SQL Commands and Queries

#sql #cheatsheet
3
Comments 2
2 min read
Postgres List Users: Two Different Approaches
Cover image for Postgres List Users: Two Different Approaches
dbvismarketing profile

Postgres List Users: Two Different Approaches

#postgres #listusers
1
Comments
4 min read
SQL vs NoSQL Databases: Which is Better?
Cover image for SQL vs NoSQL Databases: Which is Better?
dbvismarketing profile

SQL vs NoSQL Databases: Which is Better?

#nosql #sql
Comments
11 min read
Change Data Capture: A Comprehensive Guide
Cover image for Change Data Capture: A Comprehensive Guide
dbvismarketing profile

Change Data Capture: A Comprehensive Guide

#datacapture
1
Comments
11 min read
MariaDB vs MySQL: The Ultimate Comparison
Cover image for MariaDB vs MySQL: The Ultimate Comparison
dbvismarketing profile

MariaDB vs MySQL: The Ultimate Comparison

#mariadb #mysql
1
Comments
8 min read
Leveraging Snowflake's Time Travel
Cover image for Leveraging Snowflake's Time Travel
dbvismarketing profile

Leveraging Snowflake's Time Travel

Comments
10 min read
Inner Join in SQL: A Comprehensive Guide
Cover image for Inner Join in SQL: A Comprehensive Guide
dbvismarketing profile

Inner Join in SQL: A Comprehensive Guide

#sql #join
Comments
10 min read
PostgreSQL Materialized Views: A Beginner's Guide
Cover image for PostgreSQL Materialized Views: A Beginner's Guide
dbvismarketing profile

PostgreSQL Materialized Views: A Beginner's Guide

#postgres #views
Comments
8 min read
Casting in PostgreSQL: Handling Data Type Conversions Effectively
Cover image for Casting in PostgreSQL: Handling Data Type Conversions Effectively
dbvismarketing profile

Casting in PostgreSQL: Handling Data Type Conversions Effectively

#cast #postgres
Comments 1
6 min read
Date Formatting in Postgres: A Comprehensive Guide
Cover image for Date Formatting in Postgres: A Comprehensive Guide
dbvismarketing profile

Date Formatting in Postgres: A Comprehensive Guide

#date #postgres
Comments
7 min read
View vs Materialized View in databases: Differences and Use cases
Cover image for View vs Materialized View in databases: Differences and Use cases
dbvismarketing profile

View vs Materialized View in databases: Differences and Use cases

#views
Comments
9 min read
SQL Deep Dive: Mastering DATEDIFF with Code Examples
Cover image for SQL Deep Dive: Mastering DATEDIFF with Code Examples
dbvismarketing profile

SQL Deep Dive: Mastering DATEDIFF with Code Examples

#datediff
Comments
1 min read
Automating Databases with SQL Triggers
Cover image for Automating Databases with SQL Triggers
dbvismarketing profile

Automating Databases with SQL Triggers

Comments
1 min read
PostgreSQL's ON DELETE CASCADE Feature
Cover image for PostgreSQL's ON DELETE CASCADE Feature
dbvismarketing profile

PostgreSQL's ON DELETE CASCADE Feature

Comments
2 min read
Simplified Overview of JSON vs. JSONB in PostgreSQL
Cover image for Simplified Overview of JSON vs. JSONB in PostgreSQL
dbvismarketing profile

Simplified Overview of JSON vs. JSONB in PostgreSQL

#json #jsonb
Comments
2 min read
SQL Column Deletion Techniques
Cover image for SQL Column Deletion Techniques
dbvismarketing profile

SQL Column Deletion Techniques

#sql #delete
Comments
2 min read
Implementing Self Joins in SQL: A Guide for Developers
Cover image for Implementing Self Joins in SQL: A Guide for Developers
dbvismarketing profile

Implementing Self Joins in SQL: A Guide for Developers

#joins
1
Comments
1 min read
PostgreSQL - How To Kill Connections
Cover image for PostgreSQL - How To Kill Connections
dbvismarketing profile

PostgreSQL - How To Kill Connections

#connection #postgres
Comments
1 min read
Oracle Data Types: An Overview
Cover image for Oracle Data Types: An Overview
dbvismarketing profile

Oracle Data Types: An Overview

#datatypes #oracle
Comments
1 min read
ER Models, Diagrams, and Schemas: A Developer's Brief
Cover image for ER Models, Diagrams, and Schemas: A Developer's Brief
dbvismarketing profile

ER Models, Diagrams, and Schemas: A Developer's Brief

#erd
Comments
2 min read
Introduction to the BLOB Data Type
Cover image for Introduction to the BLOB Data Type
dbvismarketing profile

Introduction to the BLOB Data Type

#blob
Comments
2 min read
Quick Guide to Parameterized Queries in SQL
Cover image for Quick Guide to Parameterized Queries in SQL
dbvismarketing profile

Quick Guide to Parameterized Queries in SQL

#sql #security
Comments
1 min read
SQL Joins: Easy Guide for Joining tables
Cover image for SQL Joins: Easy Guide for Joining tables
dbvismarketing profile

SQL Joins: Easy Guide for Joining tables

Comments
2 min read
A Beginner's Guide to Database Transactions
Cover image for A Beginner's Guide to Database Transactions
dbvismarketing profile

A Beginner's Guide to Database Transactions

#transactions
Comments
1 min read
Postgres in Docker: A Simplified Setup Process
Cover image for Postgres in Docker: A Simplified Setup Process
dbvismarketing profile

Postgres in Docker: A Simplified Setup Process

Comments
1 min read
Resolving "sudo mysql_secure_installation: command not found" in MariaDB
Cover image for Resolving "sudo mysql_secure_installation: command not found" in MariaDB
dbvismarketing profile

Resolving "sudo mysql_secure_installation: command not found" in MariaDB

Comments
1 min read