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.
The road to SeaQuery 1.0

The road to SeaQuery 1.0

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

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

Comments
8 min read
Data Analyst Checklist

Data Analyst Checklist

5
Comments
1 min read
CHW Monthly Activity Aggregation: Turning Visit Logs into Insight

CHW Monthly Activity Aggregation: Turning Visit Logs into Insight

Comments
5 min read
A Sneak Peek at SeaORM 2.0

A Sneak Peek at SeaORM 2.0

Comments
7 min read
compare7

compare7

Comments
1 min read
compare3

compare3

Comments
1 min read
Free SQL courses for beginners in 2026

Free SQL courses for beginners in 2026

Comments
4 min read
HackerRank 'The Pads' MySQL

HackerRank 'The Pads' MySQL

Comments
3 min read
7 Best Resources to Learn SQL: My Journey from Confusion to Confidence

7 Best Resources to Learn SQL: My Journey from Confusion to Confidence

Comments
3 min read
From 40% to 100% SQL Generation Accuracy: Why Local AI Needs Self-Correction, Not Perfect Prompts

From 40% to 100% SQL Generation Accuracy: Why Local AI Needs Self-Correction, Not Perfect Prompts

1
Comments
4 min read
Clean Code in ETL:How Python, Go, and SQL Each Teach You to Think Differently

Clean Code in ETL:How Python, Go, and SQL Each Teach You to Think Differently

Comments
3 min read
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
Stop Waiting for the Cloud: Building a Hybrid SQL+Python Data Pipeline Locally with DuckDB

Stop Waiting for the Cloud: Building a Hybrid SQL+Python Data Pipeline Locally with DuckDB

Comments
5 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
A Complete Guide to MariaDB: Architecture, Features, Installation, and Best Practices

A Complete Guide to MariaDB: Architecture, Features, Installation, and Best Practices

Comments
4 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
Level Up Your SQL Skills: 8 Interactive Games That Make Learning Fun

Level Up Your SQL Skills: 8 Interactive Games That Make Learning Fun

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

Using LIKE with Variables and Patterns in SQL

Comments
10 min read
loading...