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.
6 Timeless SQL Books for Software Engineers and Developers

6 Timeless SQL Books for Software Engineers and Developers

17
Comments
8 min read
How to Create ER Diagrams for SQLite with a Free Tool

How to Create ER Diagrams for SQLite with a Free Tool

11
Comments 1
4 min read
Day 1: Data Analytics

Day 1: Data Analytics

1
Comments
1 min read
⚡ 3 ClickHouse Query Optimization Lessons I Learned the Hard Way

⚡ 3 ClickHouse Query Optimization Lessons I Learned the Hard Way

4
Comments
3 min read
# The Ultimate SQL Cheatsheet and Guide for 2025

# The Ultimate SQL Cheatsheet and Guide for 2025

Comments
3 min read
A Developer’s Guide to SQL NOT IN: Smarter Queries, Faster Results

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

1
Comments
2 min read
🧠 Optimizing PostgreSQL Queries in a Full-Stack App: A Developer’s Playbook

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

1
Comments
3 min read
Hackerrank - SQL - Weather Observation Station 3

Hackerrank - SQL - Weather Observation Station 3

Comments
1 min read
Hackerrank - SQL - What Type of Triangle

Hackerrank - SQL - What Type of Triangle

Comments
2 min read
Hackerrank - SQL - Weather Observation Station 4

Hackerrank - SQL - Weather Observation Station 4

Comments
1 min read
Hackerrank - SQL - Weather Observation Station

Hackerrank - SQL - Weather Observation Station

Comments
1 min read
Become a SQL Scientist: Explore Every Layer of Table Metadata in SQL Server

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

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

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

Comments
3 min read
How to Build Real-Time Data Pipelines with SQL Server CDC and Apache SeaTunnel

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

Comments
2 min read
Building a Sales Analytics Dashboard on Azure PostgreSQL + Azure Data Studio

Building a Sales Analytics Dashboard on Azure PostgreSQL + Azure Data Studio

Comments
3 min read
Understanding SQL Injection: The Classic Web App Attack

Understanding SQL Injection: The Classic Web App Attack

2
Comments 3
2 min read
Hackerrank - SQL - The PADS

Hackerrank - SQL - The PADS

1
Comments
2 min read
Hackerrank - SQL - Select By ID

Hackerrank - SQL - Select By ID

1
Comments
1 min read
Hackerrank - SQL - Revising the Select Query II

Hackerrank - SQL - Revising the Select Query II

1
Comments
1 min read
Mastering Automation: 5 Real-World n8n Workflow Examples (With Step-by-Step Guides)

Mastering Automation: 5 Real-World n8n Workflow Examples (With Step-by-Step Guides)

1
Comments
4 min read
N+1 Query Problem

N+1 Query Problem

7
Comments
1 min read
🧱 OLTP vs OLAP: When Transaction Meets Analytics

🧱 OLTP vs OLAP: When Transaction Meets Analytics

1
Comments
2 min read
🔍 Mastering Blind SQL Injection with Out-of-Band (OAST) Techniques

🔍 Mastering Blind SQL Injection with Out-of-Band (OAST) Techniques

Comments
1 min read
📚 Error-Based SQL Injection – A Deep Dive! 🎓🔍

📚 Error-Based SQL Injection – A Deep Dive! 🎓🔍

Comments
4 min read
SQL Server 2025 - What’s New and How to Visualize the Schema

SQL Server 2025 - What’s New and How to Visualize the Schema

14
Comments 1
7 min read
loading...