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.
Four problems you inherit the moment your SQL client runs on a server
cevheri profile

Four problems you inherit the moment your SQL client runs on a server

#security #database #opensource #sql
Comments
6 min read
The Hard Truth About Data Engineering Interviews Nobody Tells You
rahmanfrr profile

The Hard Truth About Data Engineering Interviews Nobody Tells You

#dataengineering #interview #career #sql
Comments 1
5 min read
Practical SQL Query Optimization: From Slow Scans to Efficient Indexes
lucas_ventavele profile

Practical SQL Query Optimization: From Slow Scans to Efficient Indexes

#sql #database #backend #performance
Comments
5 min read
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 I close a monthly dataset, and the month I found out mine had been lying
juanauriti profile

How I close a monthly dataset, and the month I found out mine had been lying

#data #sql #opensource #webdev
5
Comments
4 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
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
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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.