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.
🧠 Understanding SQL Execution Order: The Real Flow Behind Your Queries

🧠 Understanding SQL Execution Order: The Real Flow Behind Your Queries

Comments
2 min read
Free Interactive SQL Practice Platform for Developers

Free Interactive SQL Practice Platform for Developers

Comments
1 min read
Generate UUID in PostgreSQL

Generate UUID in PostgreSQL

1
Comments
1 min read
Getting Started with PostgreSQL: A Comprehensive Guide

Getting Started with PostgreSQL: A Comprehensive Guide

Comments
2 min read
БД2 Практ (подзапрос)

БД2 Практ (подзапрос)

Comments
2 min read
Master SQL with Interactive Hands-On Practice

Master SQL with Interactive Hands-On Practice

Comments
1 min read
How to Generate SQL Queries with AI: Step-by-Step Guide Using Claude Code and DBHub

How to Generate SQL Queries with AI: Step-by-Step Guide Using Claude Code and DBHub

Comments
10 min read
Optimizing SQL LIKE Security, Performance and Best Practices

Optimizing SQL LIKE Security, Performance and Best Practices

Comments
10 min read
SQL for Data Analytics: A Must Read for Beginner Data Analysts Before Diving Into SQL

SQL for Data Analytics: A Must Read for Beginner Data Analysts Before Diving Into SQL

Comments
4 min read
Using LIKE with Variables and Patterns in SQL

Using LIKE with Variables and Patterns in SQL

Comments
10 min read
A Minimal Go Toolkit for Cleaning, Validating, and Querying CSV/TSV/Excel/Parquet Files

A Minimal Go Toolkit for Cleaning, Validating, and Querying CSV/TSV/Excel/Parquet Files

Comments
3 min read
Computed columns in D365FO – Using Correlated Subqueries with Real SQL

Computed columns in D365FO – Using Correlated Subqueries with Real SQL

1
Comments
2 min read
How I Automated 90% of Data Requests Using LLM-Powered SQL Generation

How I Automated 90% of Data Requests Using LLM-Powered SQL Generation

5
Comments 2
7 min read
Database Transactions and ACID Properties: Guaranteeing Data Consistency

Database Transactions and ACID Properties: Guaranteeing Data Consistency

Comments
8 min read
EP 13: SQL Injection Isn't Dead - It Just Evolved

EP 13: SQL Injection Isn't Dead - It Just Evolved

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