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.
SQL: Aggregate Queries

SQL: Aggregate Queries

Comments
4 min read
Query Optimization in IFS: The Hidden Performance Killer

Query Optimization in IFS: The Hidden Performance Killer

Comments
5 min read
SQL: Normalização e Formas Normais

SQL: Normalização e Formas Normais

Comments
4 min read
SQL Keyword, Tipos de Dados & Operators

SQL Keyword, Tipos de Dados & Operators

Comments
3 min read
Introduzindo SQL

Introduzindo SQL

Comments
5 min read
String#squish Quietly Changed My SQL

String#squish Quietly Changed My SQL

Comments
4 min read
Data Definition Language (DDL)

Data Definition Language (DDL)

Comments
2 min read
Data Manipulation Language (DML)

Data Manipulation Language (DML)

Comments
2 min read
Learning to Think in Sets, Not Loops

Learning to Think in Sets, Not Loops

1
Comments
2 min read
My First Time Using GitHub Copilot to Master SQL Window Functions! 🚀

My First Time Using GitHub Copilot to Master SQL Window Functions! 🚀

Comments
1 min read
Stop the Schema Chaos: A Workflow Guide for Healthcare Data Architects

Stop the Schema Chaos: A Workflow Guide for Healthcare Data Architects

Comments
3 min read
Epic Clarity Data Model Guide for Healthcare Data Engineers

Epic Clarity Data Model Guide for Healthcare Data Engineers

Comments
5 min read
Apprendre SQL : la méthode par la pratique (2026)

Apprendre SQL : la méthode par la pratique (2026)

1
Comments
3 min read
Why Schema-Aware Query Generation Beats Generic AI Templates for Production Databases

Why Schema-Aware Query Generation Beats Generic AI Templates for Production Databases

Comments
3 min read
🌐 Building a Lead Generation Website with Modern .NET and Azure SQL

🌐 Building a Lead Generation Website with Modern .NET and Azure SQL

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