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.
How to Get the Raw SQL Query from Laravel Query Builder

How to Get the Raw SQL Query from Laravel Query Builder

1
Comments
3 min read
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
Oracle 23ai — Automatic SQL Transpiler Feature

Oracle 23ai — Automatic SQL Transpiler Feature

Comments
1 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
loading...