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.
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
Turso: A Rust Rewrite of SQLite. Setup Guide and Whether It's Worth Your Time
arshtechpro profile

Turso: A Rust Rewrite of SQLite. Setup Guide and Whether It's Worth Your Time

#ai #sql #database #programming
11
Comments 2
5 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
DBMS & SQL Cheat Sheet You Need for Tech Interviews in 2026
juhi_singhal_7d7fb8634472 profile

DBMS & SQL Cheat Sheet You Need for Tech Interviews in 2026

#database #sql #computerscience #interview
1
Comments
4 min read
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
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
Turn Any API Into a SQL Database
mukhtar_onif profile

Turn Any API Into a SQL Database

#api #database #sql #tooling
5
Comments 2
7 min read
PostgreSQL Upgraded to Latest Minor Versions on SQLize.online 🐘🚀
rozhnev profile

PostgreSQL Upgraded to Latest Minor Versions on SQLize.online 🐘🚀

#postgressql #sandbox #database #sql
Comments
1 min read
Coding Cat Oran S2 Ep5 — The Many-to-Many Disaster
syslayer profile

Coding Cat Oran S2 Ep5 — The Many-to-Many Disaster

#webdev #database #sql #career
Comments
5 min read
Coding Cat Oran S2 Ep6 — The Abstract Table and the Gateway
syslayer profile

Coding Cat Oran S2 Ep6 — The Abstract Table and the Gateway

#webdev #sql #career #database
Comments
6 min read
Coding Cat Oran S2 Ep4 — The Voluntary Table
syslayer profile

Coding Cat Oran S2 Ep4 — The Voluntary Table

#webdev #database #sql #career
Comments
4 min read
Exodus Point Data Engineering Interview Questions: Full DE Prep Guide
gowthampotureddi profile

Exodus Point Data Engineering Interview Questions: Full DE Prep Guide

#python #sql #interview #dataengineering
Comments
20 min read
Oracle Fusion vs EBS: 7 SQL Patterns Every BIP Report Developer Needs
david_jiang_9686f6cf0cfb7 profile

Oracle Fusion vs EBS: 7 SQL Patterns Every BIP Report Developer Needs

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