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
oramirezperera profile

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

#python #sql #elt
7
Comments 1
6 min read
Deduplicate between an uncertain number of columns：SQL VS SPL #15
esproc_spl profile

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

#sql #programming #devops #esproc
7
Comments
2 min read
Pagination with COUNT(*) OVER() in Atlassian Forge SQL: How to avoid double queries — and stay secure in TypeScript
vzakharchenko profile

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

#atlassian #forge #drizzle #sql
Comments
2 min read
One SQL Query That Could Destroy Your Entire Database (And How Hackers Use It)
yuvasec profile

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

#cybersecurity #sql #php #privacy
6
Comments
5 min read
Foreign Keys: A must in SQL, but not in a Document Database?
franckpachot profile

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

#mongodb #sql #database #postgres
21
Comments
7 min read
The World Is Too Messy for SQL to Work
franckpachot profile

The World Is Too Messy for SQL to Work

#sql #database #relational #document
22
Comments 15
10 min read
Hacker rank's Median SQL Solution
meghanananju profile

Hacker rank's Median SQL Solution

#sql #hackerrank #tircky #programming
1
Comments
3 min read
DuckDB 🦆: Unleashing the Powerhouse Query Engine Within
mikekenneth77 profile

DuckDB 🦆: Unleashing the Powerhouse Query Engine Within

#duckdb #sql #database #performance
3
Comments 1
6 min read
Basic Relational Database Schemas 📚 to amplify development
aryan015 profile

Basic Relational Database Schemas 📚 to amplify development

#sql #dbms #mongodb #postgres
Comments
2 min read
Automating SQL Queries with LangChain and Gemini : A Step-by-Step Guide
exson_joseph profile

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

#sql #llm #gemini #langchain
6
Comments
4 min read
The Evolution of Databases: Relational vs. NoSQL
satyamlucifer profile

The Evolution of Databases: Relational vs. NoSQL

#database #sql #nosql #productivity
11
Comments
3 min read
7 Best SQL Books for Beginners
bobbyiliev profile

7 Best SQL Books for Beginners

#sql #database #postgres #books
11
Comments 2
3 min read
Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025
op3ratordec profile

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

#postgres #sqlserver #database #sql
6
Comments
7 min read
Practical SQL Injection Exploitation Cheat Sheet - @verylazytech
verylazytech profile

Practical SQL Injection Exploitation Cheat Sheet - @verylazytech

#programming #sql #cybersecurity #database
5
Comments
3 min read
How to simplify nested SQL in applications with esProc
esproc_spl profile

How to simplify nested SQL in applications with esProc

#discuss #programming #devops #sql
11
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.