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.
SQL JOINS WITH EXAMPLES OF EACH
super_b8c82b4153dee9fab1c profile

SQL JOINS WITH EXAMPLES OF EACH

#beginners #database #sql #tutorial
Comments
2 min read
PostgreSQL psql: Schema Navigation Quick Reference
amelye_chatila_717552aace profile

PostgreSQL psql: Schema Navigation Quick Reference

#sql #database #postgres #devtips
Comments
1 min read
Bringing Relational SQL Databases to the P2P World
ozymandiasthegreat profile

Bringing Relational SQL Databases to the P2P World

#architecture #database #software #sql
Comments
3 min read
A SQL interview is a translation test, not a syntax test
fourleaf profile

A SQL interview is a translation test, not a syntax test

#sql #career #interview #database
Comments
6 min read
Why Regex SQL Converters Break on Legacy Stored Procedures and How to Fix Them)
harulmozhi profile

Why Regex SQL Converters Break on Legacy Stored Procedures and How to Fix Them)

#database #sql #dataengineering #architecture
Comments
3 min read
Zero updated rows do not fail a D1 batch: testing the rollback boundary
hirodeath profile

Zero updated rows do not fail a D1 batch: testing the rollback boundary

#cloudflare #sql #database #javascript
1
Comments 2
4 min read
5 SQL patterns that run fine and still return the wrong answer
analyticsdurgesh profile

5 SQL patterns that run fine and still return the wrong answer

#career #dataengineering #sql #beginners
1
Comments
4 min read
Customer Segmentation in SQL With CASE WHEN
michaelnocito profile

Customer Segmentation in SQL With CASE WHEN

#sql #database #tutorial #beginners
Comments
14 min read
How to Practice SQL Online With Nothing Installed (And Where Your Data Goes)
michaelnocito profile

How to Practice SQL Online With Nothing Installed (And Where Your Data Goes)

#sql #database #tutorial #beginners
Comments
11 min read
Where to Get a Sample Database to Practice SQL (And How to Check It Loaded)
michaelnocito profile

Where to Get a Sample Database to Practice SQL (And How to Check It Loaded)

#sql #database #tutorial #beginners
Comments
13 min read
NOT IN can be executed as an Anti-Join (NOT EXISTS) in PG19
franckpachot profile

NOT IN can be executed as an Anti-Join (NOT EXISTS) in PG19

#postgres #sql #database #performance
Comments 2
7 min read
Which SQL Database Should You Install?
michaelnocito profile

Which SQL Database Should You Install?

#sql #database #tutorial #beginners
Comments
6 min read
How to Find Duplicate Rows in SQL (and Decide What Counts as One)
michaelnocito profile

How to Find Duplicate Rows in SQL (and Decide What Counts as One)

#sql #database #tutorial #beginners
Comments
15 min read
Month-over-Month Growth in SQL: LAG, the Growth Formula, and the Traps
michaelnocito profile

Month-over-Month Growth in SQL: LAG, the Growth Formula, and the Traps

#sql #database #tutorial #beginners
Comments
15 min read
COMMENT ON TABLE: How to Store a Table Description in the Database Itself
michaelnocito profile

COMMENT ON TABLE: How to Store a Table Description in the Database Itself

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