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.
Learning SQL As If You Built It Yourself
edriso profile

Learning SQL As If You Built It Yourself

#learning #database #sql
1
Comments
12 min read
Building a Simple Java JDBC Project with MySQL: Displaying Cricket Players and Scores
jayashree_a84b6eff7bc414e profile

Building a Simple Java JDBC Project with MySQL: Displaying Cricket Players and Scores

#database #java #sql #tutorial
3
Comments
2 min read
T-SQL on Microsoft Fabric - Episode 1: Mastering Data Retrieval with SELECT, WHERE, and ORDER BY
lamkhac profile

T-SQL on Microsoft Fabric - Episode 1: Mastering Data Retrieval with SELECT, WHERE, and ORDER BY

#microsoft #sql #fabric #dataengineering
Comments
3 min read
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 Ep4 — The Voluntary Table
syslayer profile

Coding Cat Oran S2 Ep4 — The Voluntary Table

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