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.
Your lowest-rated product list may contain highly rated items
dataspryva profile

Your lowest-rated product list may contain highly rated items

#datascience #python #sql #analytics
1
Comments 7
6 min read
Design a Payment System: the system design interview walkthrough
gowthampotureddi profile

Design a Payment System: the system design interview walkthrough

#python #sql #interview #dataengineering
Comments
14 min read
Design WhatsApp: the chat system design interview walkthrough
gowthampotureddi profile

Design WhatsApp: the chat system design interview walkthrough

#python #sql #interview #dataengineering
Comments
14 min read
Introducing sqlsift: schema-aware static analysis for SQL, no database needed
yukikotani231 profile

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

#sql #postgres #typescript #rust
Comments
3 min read
Design a URL Shortener: the system design interview walkthrough
gowthampotureddi profile

Design a URL Shortener: the system design interview walkthrough

#python #sql #interview #dataengineering
Comments
14 min read
System Design Interview Questions: the 2026 shortlist
gowthampotureddi profile

System Design Interview Questions: the 2026 shortlist

#python #sql #interview #dataengineering
Comments
10 min read
Beyond the Hype: A Realistic Guide to Choosing Between SQL and NoSQL Databases
talo_oyweka_d7847a162c1ad profile

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

#architecture #backend #database #sql
Comments
5 min read
Five lifecycle campaigns, one two-hour window, and the subqueries that became EXISTS
daniel_pertu profile

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

#postgres #sql #webdev #typescript
Comments
5 min read
WHERE vs HAVING in SQL: A Simple Way to Understand the Difference
solo_495 profile

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

#beginners #database #sql #tutorial
Comments
3 min read
DuckDB on AWS: Build a Data Validation Pipeline with Amazon S3
omayrashraf profile

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

#aws #database #python #sql
Comments
5 min read
How I Designed & Tested a Production-Ready SQL Server Database Schema for ERP Systems
wael_ezzat_hafez profile

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

#architecture #backend #database #sql
Comments
1 min read
I built and 100% tested an enterprise SQL Server database foundation for ERP systems [ApexLedger ERP]
wael_ezzat_hafez profile

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

#showdev #sql #database #architecture
Comments 1
1 min read
dbt Macros & Jinja Explained (With Real Examples)
neha_christina_1ac8651819 profile

dbt Macros & Jinja Explained (With Real Examples)

#dbt #sql #dataengineering #snowflake
5
Comments 3
4 min read
Currently learning Data Science, here is what I've learnt so far. Pt.4
ndelacruz_dev profile

Currently learning Data Science, here is what I've learnt so far. Pt.4

#sql #datascience #learning #beginners
1
Comments
2 min read
From 35 seconds to half a second: 70 faster dashboards in plain Postgres
devon_theriault_85735c82a profile

From 35 seconds to half a second: 70 faster dashboards in plain Postgres

#postgres #performance #database #sql
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.