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.
I Almost Published a Chart Saying the Nifty Fell 51% in 2003. It Fell 16%. Here Is the Bug.

I Almost Published a Chart Saying the Nifty Fell 51% in 2003. It Fell 16%. Here Is the Bug.

1
Comments 1
5 min read
SQL for Frontend Engineers: Model the Relationship First

SQL for Frontend Engineers: Model the Relationship First

Comments
6 min read
Writing a Reconciliation Job in SQL and Python That Proves Two Systems Agree

Writing a Reconciliation Job in SQL and Python That Proves Two Systems Agree

2
Comments 2
12 min read
PostgreSQL Generated Column vs Trigger: Which to Use for a Derived Column

PostgreSQL Generated Column vs Trigger: Which to Use for a Derived Column

Comments
10 min read
Text-to-SQL on Oracle: two prompt rules took a light model from 35% to 64%

Text-to-SQL on Oracle: two prompt rules took a light model from 35% to 64%

Comments 4
2 min read
Building KaizenSQL - My Dev Journey

Building KaizenSQL - My Dev Journey

2
Comments 1
5 min read
Oracle SQL: Essential Environment Commands

Oracle SQL: Essential Environment Commands

Comments
2 min read
Currently learning Data Science, here is what I've learnt so far. Pt.3

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

1
Comments 1
2 min read
Oracle SQL: SQL Statement Classifications

Oracle SQL: SQL Statement Classifications

Comments
1 min read
Currently learning Data Science, here is what I've learnt so far.

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

1
Comments 2
3 min read
9 PostgreSQL Queries Every Data Analyst Should Know (Try Them in Your Browser)

9 PostgreSQL Queries Every Data Analyst Should Know (Try Them in Your Browser)

Comments 1
3 min read
PostgreSQL numeric vs double precision vs money: Which Type to Use for Prices

PostgreSQL numeric vs double precision vs money: Which Type to Use for Prices

Comments 1
9 min read
Currently learning Data Science, here is what I've learnt so far. Pt.2

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

1
Comments 1
2 min read
Understanding SQL Execution Order

Understanding SQL Execution Order

Comments 1
2 min read
PostgreSQL Unique Constraint vs Unique Index: Which to Use, and How to Add One Without Locking the Table

PostgreSQL Unique Constraint vs Unique Index: Which to Use, and How to Add One Without Locking the Table

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