DEV Community

The Table Series' Articles

Back to DbVisualizer's Series
Schemas in PostgreSQL: A Practical Guide for Developers
Cover image for Schemas in PostgreSQL: A Practical Guide for Developers
dbvismarketing profile

Schemas in PostgreSQL: A Practical Guide for Developers

#schema #postgressql
Comments
2 min read
ALTER TABLE ADD COLUMN in SQL: Syntax, Tips & Tools
Cover image for ALTER TABLE ADD COLUMN in SQL: Syntax, Tips & Tools
dbvismarketing profile

ALTER TABLE ADD COLUMN in SQL: Syntax, Tips & Tools

#sql
Comments
2 min read
Postgres TEXT vs VARCHAR: When to Use Which
Cover image for Postgres TEXT vs VARCHAR: When to Use Which
dbvismarketing profile

Postgres TEXT vs VARCHAR: When to Use Which

#postgres #text #varchar
Comments
2 min read
Why Data Visualization Tools Matter for Developers, Managers, and Analysts
Cover image for Why Data Visualization Tools Matter for Developers, Managers, and Analysts
dbvismarketing profile

Why Data Visualization Tools Matter for Developers, Managers, and Analysts

#datavisualization
1
Comments 1
1 min read
Enhancing SQL INSERT INTO Performance: Tips and Tools
Cover image for Enhancing SQL INSERT INTO Performance: Tips and Tools
dbvismarketing profile

Enhancing SQL INSERT INTO Performance: Tips and Tools

#insert #sql
Comments
2 min read
Make Your SQL Cleaner with Common Table Expressions (CTEs)
Cover image for Make Your SQL Cleaner with Common Table Expressions (CTEs)
dbvismarketing profile

Make Your SQL Cleaner with Common Table Expressions (CTEs)

#sql #cte
Comments
2 min read
PostgreSQL Upsert: INSERT ON CONFLICT Explained
Cover image for PostgreSQL Upsert: INSERT ON CONFLICT Explained
dbvismarketing profile

PostgreSQL Upsert: INSERT ON CONFLICT Explained

#postgressql #upsert
1
Comments
2 min read
Learn SQL’s CAST Function for Clean Type Conversion
dbvismarketing profile

Learn SQL’s CAST Function for Clean Type Conversion

Comments 1
1 min read
SQL Add to Date: Simple Guide for MySQL, PostgreSQL, SQL Server & Oracle
dbvismarketing profile

SQL Add to Date: Simple Guide for MySQL, PostgreSQL, SQL Server & Oracle

#sql #mysql #oracle #postgressql
Comments
1 min read
A Developer’s Guide to SQL NOT IN: Smarter Queries, Faster Results
Cover image for A Developer’s Guide to SQL NOT IN: Smarter Queries, Faster Results
dbvismarketing profile

A Developer’s Guide to SQL NOT IN: Smarter Queries, Faster Results

#sql
1
Comments
2 min read
Understanding SUBSTRING_INDEX in SQL: Real Use Cases
Cover image for Understanding SUBSTRING_INDEX in SQL: Real Use Cases
dbvismarketing profile

Understanding SUBSTRING_INDEX in SQL: Real Use Cases

#sql #mysql
Comments
2 min read
Essential SQL Commands for Developers (With Code Samples)
Cover image for Essential SQL Commands for Developers (With Code Samples)
dbvismarketing profile

Essential SQL Commands for Developers (With Code Samples)

#sql #mysql #postgressql
Comments
2 min read
How to Add and Subtract Dates in SQL (MySQL, PostgreSQL, SQL Server)
Cover image for How to Add and Subtract Dates in SQL (MySQL, PostgreSQL, SQL Server)
dbvismarketing profile

How to Add and Subtract Dates in SQL (MySQL, PostgreSQL, SQL Server)

#date #datetime #mysql #postgressql
Comments
2 min read
SQL EXCEPT: Find the Difference Between Two Tables
Cover image for SQL EXCEPT: Find the Difference Between Two Tables
dbvismarketing profile

SQL EXCEPT: Find the Difference Between Two Tables

#sql
1
Comments
2 min read
SQL ORDER BY: Quick Sorting Examples and Tips
Cover image for SQL ORDER BY: Quick Sorting Examples and Tips
dbvismarketing profile

SQL ORDER BY: Quick Sorting Examples and Tips

#sql #mysql
Comments 1
2 min read
SQL REPLACE Function: Quick Guide with Real Examples
Cover image for SQL REPLACE Function: Quick Guide with Real Examples
dbvismarketing profile

SQL REPLACE Function: Quick Guide with Real Examples

#sql
Comments
2 min read
SQL CASE Statement Explained with Real-World Examples
Cover image for SQL CASE Statement Explained with Real-World Examples
dbvismarketing profile

SQL CASE Statement Explained with Real-World Examples

#sql #case
1
Comments
1 min read
How to Use SQL CONVERT for Clean Type Conversions
Cover image for How to Use SQL CONVERT for Clean Type Conversions
dbvismarketing profile

How to Use SQL CONVERT for Clean Type Conversions

#convert #dataconversion #mysql #sqlserver
Comments
1 min read
How to Use SQL UNION and UNION ALL to Merge Query Results
Cover image for How to Use SQL UNION and UNION ALL to Merge Query Results
dbvismarketing profile

How to Use SQL UNION and UNION ALL to Merge Query Results

#sql #unionall #sqlserver
1
Comments
2 min read
SQL UNION ALL: Combine Queries and Keep Duplicates
Cover image for SQL UNION ALL: Combine Queries and Keep Duplicates
dbvismarketing profile

SQL UNION ALL: Combine Queries and Keep Duplicates

#sql #mysql #union
Comments
2 min read
A Developer's Guide to PostgreSQL Full Text Search
Cover image for A Developer's Guide to PostgreSQL Full Text Search
dbvismarketing profile

A Developer's Guide to PostgreSQL Full Text Search

#postgressql #search
Comments
1 min read
Clean and Compare Strings in SQL with TRIM
dbvismarketing profile

Clean and Compare Strings in SQL with TRIM

#sql #mysql #trim
Comments
2 min read
Write Clean SQL: Tools That Format Your Queries for You
Cover image for Write Clean SQL: Tools That Format Your Queries for You
dbvismarketing profile

Write Clean SQL: Tools That Format Your Queries for You

#sql #formatter
Comments
1 min read
SQL INTERSECT Explained: Find Shared Rows Easily
Cover image for SQL INTERSECT Explained: Find Shared Rows Easily
dbvismarketing profile

SQL INTERSECT Explained: Find Shared Rows Easily

#sql
1
Comments
2 min read
SQL HAVING Explained: Filter Grouped Data With Ease
Cover image for SQL HAVING Explained: Filter Grouped Data With Ease
dbvismarketing profile

SQL HAVING Explained: Filter Grouped Data With Ease

#sql
Comments
2 min read
Simplifying SQL Date Data Types with Practical Tips
Cover image for Simplifying SQL Date Data Types with Practical Tips
dbvismarketing profile

Simplifying SQL Date Data Types with Practical Tips

#sql #mysql #oracle #postgressql
Comments
1 min read
Simplifying SQL DELETE for Developers: Syntax and Best Practices
Cover image for Simplifying SQL DELETE for Developers: Syntax and Best Practices
dbvismarketing profile

Simplifying SQL DELETE for Developers: Syntax and Best Practices

Comments
1 min read
How to Back Up and Restore MySQL Using mysqldump
Cover image for How to Back Up and Restore MySQL Using mysqldump
dbvismarketing profile

How to Back Up and Restore MySQL Using mysqldump

#sql #mysql #backup
1
Comments
2 min read
How to Use SQL Server DATEADD for Real-Time Date Calculations
Cover image for How to Use SQL Server DATEADD for Real-Time Date Calculations
dbvismarketing profile

How to Use SQL Server DATEADD for Real-Time Date Calculations

#sql #sqlserver
Comments
2 min read
How to Discover and Protect Sensitive Data Using CLI and SQL Tools
Cover image for How to Discover and Protect Sensitive Data Using CLI and SQL Tools
dbvismarketing profile

How to Discover and Protect Sensitive Data Using CLI and SQL Tools

#security
Comments
2 min read