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.
The Restart Challenge: Day 03

The Restart Challenge: Day 03

Comments
1 min read
Understanding DDL and DML SQL concepts

Understanding DDL and DML SQL concepts

Comments
3 min read
Best roadmap to learn SQL programming

Best roadmap to learn SQL programming

Comments
4 min read
Writing a SQL Formatter With a Handwritten Tokenizer

Writing a SQL Formatter With a Handwritten Tokenizer

Comments
3 min read
DuckDB 1.5.2, SQLite JSON Join Speedup, & Postgres NOTIFY Debugger

DuckDB 1.5.2, SQLite JSON Join Speedup, & Postgres NOTIFY Debugger

Comments
3 min read
SQL FUNCTIONS,QUERIES AND JOINTS.

SQL FUNCTIONS,QUERIES AND JOINTS.

Comments
2 min read
From Scratch to Queries: Building a School Database with SQL – My Nairobi Academy Project.

From Scratch to Queries: Building a School Database with SQL – My Nairobi Academy Project.

1
Comments
3 min read
SQL Fundamentals: DDL, DML, and Practical Data Manipulation

SQL Fundamentals: DDL, DML, and Practical Data Manipulation

Comments
6 min read
How I Fixed a Correlated Subquery That Was Behaving Like an N+1 Problem in Production

How I Fixed a Correlated Subquery That Was Behaving Like an N+1 Problem in Production

Comments
2 min read
SQL Made Simple: A Beginner’s Guide to Understanding and Working with Data

SQL Made Simple: A Beginner’s Guide to Understanding and Working with Data

Comments
3 min read
Mastering SQL Fundamentals: From Data Definition to Data Transformation

Mastering SQL Fundamentals: From Data Definition to Data Transformation

Comments
3 min read
The Restart Challenge: Day 1

The Restart Challenge: Day 1

Comments
1 min read
Why PostgreSQL Ignores Your Index

Why PostgreSQL Ignores Your Index

Comments
9 min read
NL2SQL in 2026: How Multi-Agent Pipelines Convert Natural Language to Safe SQL

NL2SQL in 2026: How Multi-Agent Pipelines Convert Natural Language to Safe SQL

Comments
5 min read
Introduction to Databases with SQL

Introduction to Databases with SQL

2
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.