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.
Diving Deeper into SQL: Advanced Queries and Real-World Applications

Diving Deeper into SQL: Advanced Queries and Real-World Applications

Comments
3 min read
SQL Case Files: A Free, Story Driven way to practice SQL

SQL Case Files: A Free, Story Driven way to practice SQL

12
Comments
2 min read
Getting Started with Database Migrations using FluentMigrator

Getting Started with Database Migrations using FluentMigrator

Comments
6 min read
Practical SQL Observability for Forge Apps with forge-sql-orm

Practical SQL Observability for Forge Apps with forge-sql-orm

2
Comments
8 min read
🧠 Understanding SQL Execution Order: The Real Flow Behind Your Queries

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

Comments
2 min read
Data Analyst Checklist

Data Analyst Checklist

6
Comments
1 min read
Free Interactive SQL Practice Platform for Developers

Free Interactive SQL Practice Platform for Developers

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
LLMSQL&Arabic WikiTableQA&Payment-SQL:SQL Dataset(202510)

LLMSQL&Arabic WikiTableQA&Payment-SQL:SQL Dataset(202510)

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

Optimizing SQL LIKE Security, Performance and Best Practices

Comments
10 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
PART 5 — The Rise of Network SQL (N-SQL)

PART 5 — The Rise of Network SQL (N-SQL)

4
Comments
26 min read
catalog

catalog

Comments
1 min read
dupl

dupl

Comments
1 min read
Introducing the All-New SLS SQL Copilot

Introducing the All-New SLS SQL Copilot

Comments
15 min read
🚀 Cómo Crear una Vista en SQL Server 2022: Simplifica tu Acceso a Datos

🚀 Cómo Crear una Vista en SQL Server 2022: Simplifica tu Acceso a Datos

Comments
2 min read
select2

select2

Comments
1 min read
How I Optimized an Extremely Slow Oracle SQL Query (Real Case Study)

How I Optimized an Extremely Slow Oracle SQL Query (Real Case Study)

Comments
2 min read
loading...