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.
Building an ELT Pipeline with Python and SQL Server: A Netflix Dataset Walkthrough

Building an ELT Pipeline with Python and SQL Server: A Netflix Dataset Walkthrough

7
Comments 1
6 min read
Deduplicate between an uncertain number of columns:SQL VS SPL #15

Deduplicate between an uncertain number of columns:SQL VS SPL #15

7
Comments
2 min read
Pagination with COUNT(*) OVER() in Atlassian Forge SQL: How to avoid double queries — and stay secure in TypeScript

Pagination with COUNT(*) OVER() in Atlassian Forge SQL: How to avoid double queries — and stay secure in TypeScript

Comments
2 min read
The Life of a Query in SQL - It's More Dramatic Than You Think 😨

The Life of a Query in SQL - It's More Dramatic Than You Think 😨

5
Comments
2 min read
One SQL Query That Could Destroy Your Entire Database (And How Hackers Use It)

One SQL Query That Could Destroy Your Entire Database (And How Hackers Use It)

6
Comments
5 min read
Hyperparameter Tuning in Deep Learning: Best Practices for Optimizing Your Model

Hyperparameter Tuning in Deep Learning: Best Practices for Optimizing Your Model

Comments
4 min read
Payment data processing

Payment data processing

Comments
1 min read
Foreign Keys: A must in SQL, but not in a Document Database?

Foreign Keys: A must in SQL, but not in a Document Database?

20
Comments
7 min read
Hacker rank's Median SQL Solution

Hacker rank's Median SQL Solution

1
Comments
3 min read
The World Is Too Messy for SQL to Work

The World Is Too Messy for SQL to Work

21
Comments 15
10 min read
DuckDB 🦆: Unleashing the Powerhouse Query Engine Within

DuckDB 🦆: Unleashing the Powerhouse Query Engine Within

3
Comments
6 min read
(Beyond) The Art of Database Indexing

(Beyond) The Art of Database Indexing

1
Comments
3 min read
Desire for Structure (read “SQL”)

Desire for Structure (read “SQL”)

1
Comments
10 min read
SQL Temporary Tables: A Quick and Practical Guide

SQL Temporary Tables: A Quick and Practical Guide

1
Comments
2 min read
Basic Relational Database Schemas 📚 to amplify development

Basic Relational Database Schemas 📚 to amplify development

Comments
2 min read
Automating SQL Queries with LangChain and Gemini : A Step-by-Step Guide

Automating SQL Queries with LangChain and Gemini : A Step-by-Step Guide

5
Comments
4 min read
DAY-8 PSQL, Difference Function vs. Procedure

DAY-8 PSQL, Difference Function vs. Procedure

Comments
2 min read
The Evolution of Databases: Relational vs. NoSQL

The Evolution of Databases: Relational vs. NoSQL

11
Comments
3 min read
7 Best SQL Books for Beginners

7 Best SQL Books for Beginners

11
Comments 2
3 min read
I Will Teach You SQL in 3 Minutes

I Will Teach You SQL in 3 Minutes

6
Comments 1
2 min read
Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025

Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025

6
Comments
7 min read
Desvendando SQL: Functions

Desvendando SQL: Functions

1
Comments
3 min read
SQL 101 | Chapter 9: Common Table Expression (CTE)

SQL 101 | Chapter 9: Common Table Expression (CTE)

Comments
5 min read
How to simplify nested SQL in applications with esProc

How to simplify nested SQL in applications with esProc

11
Comments
4 min read
Practical SQL Injection Exploitation Cheat Sheet - @verylazytech

Practical SQL Injection Exploitation Cheat Sheet - @verylazytech

5
Comments
3 min read
loading...