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.
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

Hackerrank - SQL - Weather Observation Station

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

Hackerrank - SQL - Weather Observation Station 4

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
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
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
Hackerrank - SQL - Revising the Select Query II

Hackerrank - SQL - Revising the Select Query II

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

Understanding SQL Injection: The Classic Web App Attack

2
Comments 3
2 min read
N+1 Query Problem

N+1 Query Problem

7
Comments
1 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
Understanding Query Cost in SQL

Understanding Query Cost in SQL

1
Comments
7 min read
Learn SQL Fast: A Step-by-Step Tutorial for Beginners

Learn SQL Fast: A Step-by-Step Tutorial for Beginners

Comments
3 min read
Database Design Errors to Avoid & How To Fix Them

Database Design Errors to Avoid & How To Fix Them

11
Comments 1
5 min read
🍰Top 10 Best Cake Shop Full-Stack Projects for Beginners in C#, ASP.NET, and .NET Core

🍰Top 10 Best Cake Shop Full-Stack Projects for Beginners in C#, ASP.NET, and .NET Core

4
Comments
2 min read
loading...