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 Functions: Data Analysis just got better
ron-njuguna profile

SQL Functions: Data Analysis just got better

#data #database #sql
Comments
2 min read
SQL Subqueries and CTEs: Writing More Powerful Queries
ron-njuguna profile

SQL Subqueries and CTEs: Writing More Powerful Queries

#backend #database #sql #tutorial
Comments
2 min read
Why Learning Data Engineering Is Still a Smart Bet in 2026 (Even With AI Eating the Easy Parts)
rahmanfrr profile

Why Learning Data Engineering Is Still a Smart Bet in 2026 (Even With AI Eating the Easy Parts)

#dataengineering #career #sql #ai
Comments 1
2 min read
One Cell, Many Values: When a Column Holds a List
michaelnocito profile

One Cell, Many Values: When a Column Holds a List

#sql #database #tutorial #beginners
Comments
8 min read
Why Using FLOAT for Financial Pipelines is a Silent $100k Trap (and How PostgreSQL NUMERIC Saves Your Ledger)
arpitmbangre profile

Why Using FLOAT for Financial Pipelines is a Silent $100k Trap (and How PostgreSQL NUMERIC Saves Your Ledger)

#sql #datascience #database #dataengineering
Comments
2 min read
How to Master Intermediate SQL in Under 10 Minutes
rahmanfrr profile
Rahman

How to Master Intermediate SQL in Under 10 Minutes

#sql #database #tutorial #programming
Comments
5 min read
SQL Joins: Understanding How to combine Data from Multiple Tables
ron-njuguna profile

SQL Joins: Understanding How to combine Data from Multiple Tables

#beginners #database #sql #tutorial
Comments
2 min read
Your Login Tests Are Green. What Did cursor.execute Actually Receive?
yuan_ming_3549dae7e400994 profile

Your Login Tests Are Green. What Did cursor.execute Actually Receive?

#python #security #sql #testing
Comments 1
4 min read
Who gets rated higher: age, age gap and the reciprocity myth - from 24 million ratings
temer profile

Who gets rated higher: age, age gap and the reciprocity myth - from 24 million ratings

#datascience #analytics #sql #statistics
Comments 1
4 min read
SQL Window Functions Explained
opaul profile

SQL Window Functions Explained

#backend #database #sql
Comments
4 min read
LIKE in SQL, Explained for Beginners
michaelnocito profile

LIKE in SQL, Explained for Beginners

#sql #database #tutorial #beginners
Comments
7 min read
Learning SQL? Here is a Practical Guide to Read and Write SQL Queries.
okall_omondi profile

Learning SQL? Here is a Practical Guide to Read and Write SQL Queries.

#sql #programming #beginners #tutorial
Comments
6 min read
Ottoch - ask your database questions in you plain language, self-hosted....
santhosh_bhandari_aee9f66 profile

Ottoch - ask your database questions in you plain language, self-hosted....

#showdev #ai #sql #opensource
Comments
1 min read
Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 2)
zgl20053779 profile

Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 2)

#productivity #opensource #database #sql
Comments
6 min read
Relational Database Performance and Indexing at Scale
sazm_ profile

Relational Database Performance and Indexing at Scale

#database #performance #sql #webdev
5
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.