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.
77.1% on BIRD dev with one model call per question, and a test-set submission in

77.1% on BIRD dev with one model call per question, and a test-set submission in

Comments
2 min read
Convert Time Columns into Rows and Pivot into a New Cross Table

Convert Time Columns into Rows and Pivot into a New Cross Table

5
Comments
7 min read
SQL Concepts Using Hospital Data

SQL Concepts Using Hospital Data

Comments
15 min read
5 SQL Window-Function Exercises Taken From Real Business Problems

5 SQL Window-Function Exercises Taken From Real Business Problems

Comments
3 min read
Writing SQL in Go Without Losing Type Safety: An Introduction to sqlc

Writing SQL in Go Without Losing Type Safety: An Introduction to sqlc

Comments
2 min read
Your average response time is lying to you (use p95 and p99)

Your average response time is lying to you (use p95 and p99)

Comments
3 min read
How to Auto-Update an updated_at Column: MySQL ON UPDATE vs a Database Trigger vs the ORM

How to Auto-Update an updated_at Column: MySQL ON UPDATE vs a Database Trigger vs the ORM

Comments
10 min read
SQL Ties Python at 58%: What It Means for Data Engineer Interviews

SQL Ties Python at 58%: What It Means for Data Engineer Interviews

Comments
8 min read
Your hiring chart may measure who posts most often

Your hiring chart may measure who posts most often

Comments
7 min read
A Single SQL Constraint Can Save Your Database From Bad Data — Do You Know Which One?

A Single SQL Constraint Can Save Your Database From Bad Data — Do You Know Which One?

Comments
5 min read
Automatic maintenance tasks controls the automatic optimizer statistics

Automatic maintenance tasks controls the automatic optimizer statistics

Comments
4 min read
SQL Injection with SQLmap on Kali: From Login Form to Database

SQL Injection with SQLmap on Kali: From Login Form to Database

Comments
3 min read
DuckDB 2.0 shipped today. I ran its headline features — triggers work, VARIANT has a silent-NULL trap

DuckDB 2.0 shipped today. I ran its headline features — triggers work, VARIANT has a silent-NULL trap

Comments
5 min read
Julian Date Conversion in Code: YYDDD, CYYDDD, JD and MJD in Python, JavaScript, SQL and Excel

Julian Date Conversion in Code: YYDDD, CYYDDD, JD and MJD in Python, JavaScript, SQL and Excel

Comments
4 min read
SQL Interview Rounds: What to Expect and How to Prepare

SQL Interview Rounds: What to Expect and How to Prepare

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