Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

SAKTHI SREE N S 24CB051

Oct 5 '25

HASHING IN SQL

#oracle #database #sql #learning

2 min read

Nov 4 '25

Building a Sales Database in PostgreSQL — Schema, Data & JOIN Examples

#database #postgres #dataengineering #sql

6 min read

Rost

Nov 4 '25

Multi-Tenancy Database Patterns with examples in Go

#go #database #sql #saas

9 min read

Pranav Aadithya

Oct 1 '25

Cursors and Triggers

#mysql #database #sql #programming

3 min read

Thushitha

Oct 4 '25

💾Database Reliability Explained: Transactions, Deadlocks & Log-Based Recovery

#computerscience #database #tutorial #sql

3 min read

Nov 3 '25

Your ORM is Lying to You About SQL (CTEs Explained)

#sql #database #performance #productivity

8 min read

Oct 4 '25

Understanding 1NF, 2NF, and 3NF in DBMS with SQL Examples

#database #design #tutorial #sql

2 min read

Valter Zanchetti Filho

Oct 12 '25

Algo entre o VARCHAR2 e o CLOB: VARCHAR2 com esteróides [MAX_STRING_SIZE]

#database #oracle #sql

2 min read

Youngho Andrew Chaa

Sep 30 '25

The Pitfall of ORDER BY Timestamp (And How to Fix It)

#sql #postgres

3 min read

Vishnu KN

Nov 3 '25

TIL: Temp table vs CTE

#performance #beginners #sql #database

1 min read

Oct 3 '25

Cursor and Trigger

#database #tutorial #beginners #sql

2 min read

Oct 3 '25

Database Normalization

#database #computerscience #tutorial #sql

2 min read

Sep 29 '25

A Developer’s Guide to PostgreSQL REGEXP_MATCH (with Snippets)

#sql #postgressql

2 min read

Sep 29 '25

DBMS Made simple

#sql #nosql #beginners

2 min read

Oct 2 '25

Database Normalization

#dbms #oracle #sql

3 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.