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.
Leetcode Hardest SQL 185: Is the Best Solution Still Slow?

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

1
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
How to Build Maintenance Sub-Workflow to Use on n8n for MySQL

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

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
Day-89,90 Understanding Set in Java

Day-89,90 Understanding Set in Java

2
Comments 1
2 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

Comments
5 min read
Transaction Numbers in a System

Transaction Numbers in a System

Comments
3 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
Day-88 Memory Management in Java

Day-88 Memory Management in Java

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

Relacionamentos Bidirecionais vs Unidirecionais no Spring JPA

1
Comments
3 min read
10 Database Design Lessons Learned Working for a Startup

10 Database Design Lessons Learned Working for a Startup

1
Comments 1
7 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
What is the Modern Data Stack?

What is the Modern Data Stack?

Comments
3 min read
Updates to the Same Value: MongoDB Optimization

Updates to the Same Value: MongoDB Optimization

2
Comments 1
7 min read
Building a Food Price & Inflation Analysis Pipeline in Kenya (2006–2024)

Building a Food Price & Inflation Analysis Pipeline in Kenya (2006–2024)

Comments
3 min read
Building a Modern Data Warehouse in SQL Server with Medallion Architecture

Building a Modern Data Warehouse in SQL Server with Medallion Architecture

Comments
11 min read
Building Trust in AI: Enterprise Knowledge Base Validation with MindsDB

Building Trust in AI: Enterprise Knowledge Base Validation with MindsDB

Comments
10 min read
Create MySQL ER Diagrams with a Free Design Tool

Create MySQL ER Diagrams with a Free Design Tool

6
Comments
4 min read
loading...