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.
Web Development or Data Analysis: Which Path Should You Choose?

Web Development or Data Analysis: Which Path Should You Choose?

Comments
8 min read
Testing a Free AI SQL Assistant Against a Real Schema: A Practical Workflow

Testing a Free AI SQL Assistant Against a Real Schema: A Practical Workflow

4
Comments
4 min read
How to change a primary key that foreign keys already point at

How to change a primary key that foreign keys already point at

Comments
6 min read
Best dbt Data Modeling Tools for Documentation, Semantic Layer & Migration

Best dbt Data Modeling Tools for Documentation, Semantic Layer & Migration

Comments
11 min read
Design a Payment System: the system design interview walkthrough

Design a Payment System: the system design interview walkthrough

Comments
14 min read
Design WhatsApp: the chat system design interview walkthrough

Design WhatsApp: the chat system design interview walkthrough

Comments
14 min read
Introducing sqlsift: schema-aware static analysis for SQL, no database needed

Introducing sqlsift: schema-aware static analysis for SQL, no database needed

Comments
3 min read
Design a URL Shortener: the system design interview walkthrough

Design a URL Shortener: the system design interview walkthrough

Comments
14 min read
System Design Interview Questions: the 2026 shortlist

System Design Interview Questions: the 2026 shortlist

Comments
10 min read
Beyond the Hype: A Realistic Guide to Choosing Between SQL and NoSQL Databases

Beyond the Hype: A Realistic Guide to Choosing Between SQL and NoSQL Databases

Comments
5 min read
Five lifecycle campaigns, one two-hour window, and the subqueries that became EXISTS

Five lifecycle campaigns, one two-hour window, and the subqueries that became EXISTS

Comments
5 min read
WHERE vs HAVING in SQL: A Simple Way to Understand the Difference

WHERE vs HAVING in SQL: A Simple Way to Understand the Difference

Comments
3 min read
DuckDB on AWS: Build a Data Validation Pipeline with Amazon S3

DuckDB on AWS: Build a Data Validation Pipeline with Amazon S3

Comments
5 min read
How I Designed & Tested a Production-Ready SQL Server Database Schema for ERP Systems

How I Designed & Tested a Production-Ready SQL Server Database Schema for ERP Systems

Comments
1 min read
I built and 100% tested an enterprise SQL Server database foundation for ERP systems [ApexLedger ERP]

I built and 100% tested an enterprise SQL Server database foundation for ERP systems [ApexLedger ERP]

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