Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

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

Roxana Maria Haidiner

Jul 24 '25

How to Create ER Diagrams for SQLite with a Free Tool

#sql #database #sqlite #datastructures

4 min read

Mohamed Hussain S

Jul 24 '25

⚡ 3 ClickHouse Query Optimization Lessons I Learned the Hard Way

#clickhouse #dataengineering #performance #sql

3 min read

Jul 23 '25

# The Ultimate SQL Cheatsheet and Guide for 2025

#webdev #programming #sql #database

3 min read

Jun 19 '25

A Developer’s Guide to SQL NOT IN: Smarter Queries, Faster Results

#sql

2 min read

David Emmanuel G

Jul 2 '25

🧠 Optimizing PostgreSQL Queries in a Full-Stack App: A Developer’s Playbook

#database #sql #postgres #productivity

3 min read

Mr Punk da Silva

Jul 23 '25

Hackerrank - SQL - Weather Observation Station 3

#sql #learning

1 min read

Mr Punk da Silva

Jul 23 '25

Hackerrank - SQL - Weather Observation Station 4

#sql #learning

1 min read

Mr Punk da Silva

Jul 23 '25

Hackerrank - SQL - Weather Observation Station

#sql #learning

1 min read

Mr Punk da Silva

Jul 23 '25

Hackerrank - SQL - What Type of Triangle

#sql #learning

2 min read

Cristian Sifuentes

Jul 22 '25

Become a SQL Scientist: Explore Every Layer of Table Metadata in SQL Server

#sql #sqlserver #database #backend

3 min read

Cristian Sifuentes

Jul 22 '25

How to Discover Every Foreign Key That References a Table in SQL Server — Like a Data Scientist

#database #sql #sqlserver #computerscience

3 min read

Apache SeaTunnel

Jun 18 '25

How to Build Real-Time Data Pipelines with SQL Server CDC and Apache SeaTunnel

#programming #cdc #seatunnel #sql

2 min read

Mr Punk da Silva

Jul 21 '25

Hackerrank - SQL - The PADS

#sql #beginners #database #hackerrank

2 min read

Mr Punk da Silva

Jul 21 '25

Hackerrank - SQL - Select By ID

#hackerrank #sql #beginners #learning

1 min read

Mr Punk da Silva

Jul 21 '25

Hackerrank - SQL - Revising the Select Query II

#sql #learning #beginners #hackerrank

1 min read

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