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.
When to Index a Table: A Practical Guide for Analysts
michaelnocito profile

When to Index a Table: A Practical Guide for Analysts

#sql #database #tutorial #beginners
Comments
15 min read
Cohort Retention Analysis in SQL, Step by Step
michaelnocito profile

Cohort Retention Analysis in SQL, Step by Step

#sql #database #tutorial #beginners
Comments
14 min read
Funnel Conversion in SQL, and the Step That Shows 100%
michaelnocito profile

Funnel Conversion in SQL, and the Step That Shows 100%

#sql #database #tutorial #beginners
Comments
14 min read
SQL Date Functions: How to Group by Month Without Losing One
michaelnocito profile

SQL Date Functions: How to Group by Month Without Losing One

#sql #database #tutorial #beginners
Comments
16 min read
SQL Injection thời AI: Cách phòng thủ tối ưu
phantam38 profile

SQL Injection thời AI: Cách phòng thủ tối ưu

#ai #cybersecurity #security #sql
Comments
4 min read
Why Your SQL Server Database Is Slow (and How to Fix It)
sunny_badgujar_13 profile

Why Your SQL Server Database Is Slow (and How to Fix It)

#sql #database #dotnet #performance
1
Comments 1
4 min read
How to Set Up DuckDB (Run SQL on a CSV With No Import Step)
michaelnocito profile

How to Set Up DuckDB (Run SQL on a CSV With No Import Step)

#sql #database #tutorial #beginners
Comments
10 min read
I built a free, interactive SQL practice tool for data engineering interviews
harishdataengineer profile

I built a free, interactive SQL practice tool for data engineering interviews

#dataengineering #sql #webdev #interview
Comments
1 min read
Subqueries vs CTEs: Query Optimizer Internals & Memory Spooling Explained
arpitmbangre profile

Subqueries vs CTEs: Query Optimizer Internals & Memory Spooling Explained

#database #sql #dataengineering #performance
Comments
2 min read
Learn SQL by Typing It: Three Browser Database Terminals Compared
devopsdaily profile

Learn SQL by Typing It: Three Browser Database Terminals Compared

#sql #postgres #mongodb #database
16
Comments
5 min read
My security test was green for six weeks because it could not turn red
guidondor profile

My security test was green for six weeks because it could not turn red

#postgres #testing #sql #security
Comments
3 min read
Day 1: starting the road to backend developer
afrin_rabikm profile
Afrin

Day 1: starting the road to backend developer

#backend #buildinpublic #java #sql
1
Comments
1 min read
Prisma vs Drizzle vs Raw SQL: What Every Backend Developer Should Understand Before Choosing an ORM
surajsrggupta profile

Prisma vs Drizzle vs Raw SQL: What Every Backend Developer Should Understand Before Choosing an ORM

#sql #prisma #drizzle #database
Comments
13 min read
What Has To Be True Before You Trust An AI Data Agent
paulcrinigan profile

What Has To Be True Before You Trust An AI Data Agent

#ai #data #sql #agents
2
Comments 1
3 min read
Tối Ưu Truy Vấn SQL & Connection Pool Tải Cao
phantam38 profile

Tối Ưu Truy Vấn SQL & Connection Pool Tải Cao

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