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.
Oracle ORA-00911 Error: Causes and Solutions Complete Guide

Oracle ORA-00911 Error: Causes and Solutions Complete Guide

Comments
3 min read
[Tutorial] Building an AI-Powered BI Tool on Upsun 🤖

[Tutorial] Building an AI-Powered BI Tool on Upsun 🤖

Comments
1 min read
SQL or Python? The line is sharper than you think (with code)

SQL or Python? The line is sharper than you think (with code)

2
Comments
9 min read
Create condition using JooqTemplate

Create condition using JooqTemplate

Comments
2 min read
Database AI Agents: A Paradigm Shift in Proactive Database Management

Database AI Agents: A Paradigm Shift in Proactive Database Management

Comments
20 min read
Data Analyst Interview Questions 2026: SQL, Case Studies & Behavioral (With Answers)

Data Analyst Interview Questions 2026: SQL, Case Studies & Behavioral (With Answers)

Comments
4 min read
Cross-Row Validation Risk in PostgreSQL CHECK Constraints

Cross-Row Validation Risk in PostgreSQL CHECK Constraints

1
Comments
3 min read
Coding Cat Oran S2 Ep3 — The Auditor Arrives

Coding Cat Oran S2 Ep3 — The Auditor Arrives

Comments
5 min read
SQL Transactions and Write Conflicts

SQL Transactions and Write Conflicts

Comments
3 min read
Real-Time Metrics Dashboards with SQL: Patterns That Actually Scale

Real-Time Metrics Dashboards with SQL: Patterns That Actually Scale

2
Comments
7 min read
Deleting Millions of Rows in PostgreSQL Without Taking Down Production

Deleting Millions of Rows in PostgreSQL Without Taking Down Production

Comments
15 min read
Designing an Expiring-Points System on an RDBMS (with Benchmarks)

Designing an Expiring-Points System on an RDBMS (with Benchmarks)

Comments
9 min read
Data Lake Architecture for Data Engineering Interviews

Data Lake Architecture for Data Engineering Interviews

Comments
44 min read
Beyond the Lift-and-Shift: Real-Time MySQL Migration to AWS RDS with GoldenGate 19c

Beyond the Lift-and-Shift: Real-Time MySQL Migration to AWS RDS with GoldenGate 19c

Comments
1 min read
Top 12 SQL Interview Problems for Data Engineers, With Answers

Top 12 SQL Interview Problems for Data Engineers, With Answers

Comments
9 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.