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.
What Is an AI Agent, and How Often Is It Right

What Is an AI Agent, and How Often Is It Right

Comments
4 min read
Google Maps timezone lookups in Python: measure match displacement

Google Maps timezone lookups in Python: measure match displacement

Comments
6 min read
Corners and Yellow Cards per Match by League: One Match Table, SQL and pandas, 2025/26 vs 2026/27

Corners and Yellow Cards per Match by League: One Match Table, SQL and pandas, 2025/26 vs 2026/27

Comments
3 min read
Make CI catch a SQL migration that changed after review

Make CI catch a SQL migration that changed after review

6
Comments
1 min read
How to Delete or Update Millions of Rows in SQL Server Safely (Batching)

How to Delete or Update Millions of Rows in SQL Server Safely (Batching)

Comments
4 min read
SQL Running Total: Calculate Cumulative Daily Sales Using SUM() OVER() in Oracle SQL

SQL Running Total: Calculate Cumulative Daily Sales Using SUM() OVER() in Oracle SQL

Comments
2 min read
How We Built 1,200 SEO Landing Pages for a Local Plumber in 4 Hours (Programmatic SEO + Supabase)

How We Built 1,200 SEO Landing Pages for a Local Plumber in 4 Hours (Programmatic SEO + Supabase)

Comments
3 min read
ORA-04068 After a Deploy: The Retry Works. The Package State Is Gone.

ORA-04068 After a Deploy: The Retry Works. The Package State Is Gone.

Comments
12 min read
A Practical OLAP Walkthrough with DuckDB: Star Schema, Rollups, and Drill-Down

A Practical OLAP Walkthrough with DuckDB: Star Schema, Rollups, and Drill-Down

Comments
4 min read
9 PostgreSQL fixes that took real queries from ~100 ms to under 1 ms (with EXPLAIN output)

9 PostgreSQL fixes that took real queries from ~100 ms to under 1 ms (with EXPLAIN output)

1
Comments
4 min read
Building a Zero-AWS Power Grid OLAP Explorer in the Browser with DuckDB-Wasm and Apache Parquet

Building a Zero-AWS Power Grid OLAP Explorer in the Browser with DuckDB-Wasm and Apache Parquet

Comments
5 min read
Excel, SQL and Power BI Interview Questions for Fresher Data Roles

Excel, SQL and Power BI Interview Questions for Fresher Data Roles

Comments
8 min read
Learn SQL From Scratch: 7 Essential SQL Queries Every Beginner Should Know

Learn SQL From Scratch: 7 Essential SQL Queries Every Beginner Should Know

Comments
2 min read
How to get a data analyst internship

How to get a data analyst internship

Comments 1
3 min read
SQL

SQL

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