DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Subqueries vs. CTEs vs. Stored Procedures: What’s the Real Difference?

Subqueries vs. CTEs vs. Stored Procedures: What’s the Real Difference?

5
Comments
3 min read
Exploring the Similarities Between SQL Stored Procedures and Python Functions

Exploring the Similarities Between SQL Stored Procedures and Python Functions

10
Comments
2 min read
Database Optimization: Techniques, Benefits, and Best Practices

Database Optimization: Techniques, Benefits, and Best Practices

2
Comments
15 min read
Write Clean SQL: Tools That Format Your Queries for You

Write Clean SQL: Tools That Format Your Queries for You

Comments
1 min read
Understanding the Difference Between MongoDB, SQL, NoSQL, and PostgreSQL – Without the Code

Understanding the Difference Between MongoDB, SQL, NoSQL, and PostgreSQL – Without the Code

Comments
2 min read
Hibernate Performance: Boost High-Volume Queries with Read-Only Sessions

Hibernate Performance: Boost High-Volume Queries with Read-Only Sessions

2
Comments
2 min read
History of NoSQL: The Data Management Revolution

History of NoSQL: The Data Management Revolution

5
Comments
4 min read
Leetcode Hardest SQL 185: Is the Best Solution Still Slow?

Leetcode Hardest SQL 185: Is the Best Solution Still Slow?

2
Comments
3 min read
Indexes in MySQL: How long do you wait before calling an index "unused"?

Indexes in MySQL: How long do you wait before calling an index "unused"?

5
Comments
1 min read
You Can't Trust COUNT and SUM: Scalable Data Validation with Merkle Trees

You Can't Trust COUNT and SUM: Scalable Data Validation with Merkle Trees

2
Comments 1
8 min read
How to Build Maintenance Sub-Workflow to Use on n8n for MySQL

How to Build Maintenance Sub-Workflow to Use on n8n for MySQL

1
Comments
3 min read
SQL for Data Professionals: From Basics to Advanced Analytics

SQL for Data Professionals: From Basics to Advanced Analytics

15
Comments 1
7 min read
Hands-On MySQL Labs: CRUD, Constraints & Student Data Management

Hands-On MySQL Labs: CRUD, Constraints & Student Data Management

Comments
2 min read
Clean and Compare Strings in SQL with TRIM

Clean and Compare Strings in SQL with TRIM

Comments
2 min read
How SQL Queries Really Work: From Parsing to Execution

How SQL Queries Really Work: From Parsing to Execution

3
Comments
4 min read
Leveraging Stack Traces for SQL Performance Analysis in Spring Boot Applications

Leveraging Stack Traces for SQL Performance Analysis in Spring Boot Applications

Comments
5 min read
SQL Joins Explained - INNER, LEFT, RIGHT, FULL

SQL Joins Explained - INNER, LEFT, RIGHT, FULL

7
Comments
3 min read
Building an End-to-End Data Engineering Pipeline with DuckDB and Python

Building an End-to-End Data Engineering Pipeline with DuckDB and Python

1
Comments
5 min read
filesql: SQL Driver for CSV, TSV, LTSV, Parquet, and Excel Files in Go

filesql: SQL Driver for CSV, TSV, LTSV, Parquet, and Excel Files in Go

Comments
3 min read
SQL Q. series 1 - Last Person to Fit in the Bus 🚌🚌

SQL Q. series 1 - Last Person to Fit in the Bus 🚌🚌

1
Comments
2 min read
Relacionamentos Bidirecionais vs Unidirecionais no Spring JPA

Relacionamentos Bidirecionais vs Unidirecionais no Spring JPA

1
Comments
3 min read
Day-88 Memory Management in Java

Day-88 Memory Management in Java

1
Comments
1 min read
How to Design a PostgreSQL Schema Visually (Step-by-Step)

How to Design a PostgreSQL Schema Visually (Step-by-Step)

7
Comments 2
4 min read
Stop Your SQL JOINs from Crawling: A Quick Index Fix

Stop Your SQL JOINs from Crawling: A Quick Index Fix

Comments
2 min read
Beginner's Guide to SQL for Data Analysis

Beginner's Guide to SQL for Data Analysis

Comments
2 min read
loading...