Forem

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.
Come estrarre una singola tabella da un file dump MySQL
Cover image for Come estrarre una singola tabella da un file dump MySQL
minnogit profile

Come estrarre una singola tabella da un file dump MySQL

#mysql #sql
Comments
1 min read
In some scenarios, relying on LLMs to generate SQL is neither rigorous nor reliable.Right way to teach LLMs to generate SQL is here
jaco_siu_748a48197d7f91e9 profile
Coco

In some scenarios, relying on LLMs to generate SQL is neither rigorous nor reliable.Right way to teach LLMs to generate SQL is here

#ai #sql #database #opensource
Comments
4 min read
Cleaning Messy Phone Numbers in PostgreSQL Using REGEXP_REPLACE
Cover image for Cleaning Messy Phone Numbers in PostgreSQL Using REGEXP_REPLACE
sharonnyabuto profile

Cleaning Messy Phone Numbers in PostgreSQL Using REGEXP_REPLACE

#sql #postgres #beginners
Comments
6 min read
Eight window-function tricks beyond LAG and ROW_NUMBER
fixelsmith profile

Eight window-function tricks beyond LAG and ROW_NUMBER

#sql #analytics #frauddetection #database
Comments
6 min read
DuckDB EC2 Optimization, Postgres FDW Pushdown, SQLite NetBeans Connectivity
soytuber profile
soy

DuckDB EC2 Optimization, Postgres FDW Pushdown, SQLite NetBeans Connectivity

#database #sql #sqlite
1
Comments
4 min read
Data Analyst Interviews in 2026: How to Clear SQL, Case Studies, and Behavioral in the Same Loop
manyoffer_career profile

Data Analyst Interviews in 2026: How to Clear SQL, Case Studies, and Behavioral in the Same Loop

#career #interview #dataanalysis #sql
Comments
4 min read
Top ORM Tools: Practical Comparison
dbdeveloper profile

Top ORM Tools: Practical Comparison

#backend #database #softwareengineering #sql
Comments
5 min read
"Wrong Answer" is the worst feedback you can give a SQL learner — so I built something better
yuva_kunaal profile

"Wrong Answer" is the worst feedback you can give a SQL learner — so I built something better

#sql #python #beginners #backend
7
Comments 1
5 min read
SQL Index Anatomy: The Logic of Choosing Right for Performance
merbayerp profile

SQL Index Anatomy: The Logic of Choosing Right for Performance

#sql #database #performance #tutorials
Comments
7 min read
Stop Naming Your Healthcare Columns Wrong — ISO-11179 Explained
season_mudbhary_7856e4083 profile

Stop Naming Your Healthcare Columns Wrong — ISO-11179 Explained

#healthcare #dataengineering #sql #database
Comments 2
6 min read
SQLite 3.53.0 Bug, PostgreSQL Performance, New Postgres TUI
soytuber profile
soy

SQLite 3.53.0 Bug, PostgreSQL Performance, New Postgres TUI

#database #sql #sqlite
Comments
3 min read
The anatomy of an APEX 26.1 APEXlang file
Cover image for The anatomy of an APEX 26.1 APEXlang file
usmankhan1 profile

The anatomy of an APEX 26.1 APEXlang file

#database #softwaredevelopment #sql #tooling
Comments
5 min read
Slowly Changing Dimensions Explained: How Data Warehouses Keep History Accurate
anthony-gicheru profile

Slowly Changing Dimensions Explained: How Data Warehouses Keep History Accurate

#sql #datawarehouse #dataengineering #scd
1
Comments
12 min read
All Data and AI Weekly #242–18 May 2026
Cover image for All Data and AI Weekly #242–18 May 2026
timothy_spann_a41a639e47c profile

All Data and AI Weekly #242–18 May 2026

#news #ai #data #sql
4
Comments
8 min read
🎮 The SQL Arcade : No Boring Textbooks Allowed
Cover image for 🎮 The SQL Arcade : No Boring Textbooks Allowed
anveshasri profile

🎮 The SQL Arcade : No Boring Textbooks Allowed

#webdev #database #sql #beginners
1
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.
HTTPS · forem.com
← Home