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.

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

Sep 29 '25

Build2Learn Event

#programming #sql #powerplatform #python

1 min read

Pranav Aadithya

Oct 3 '25

CRUD Operations in MongoDB: Hands-On with a Student Collection

#programming #mysql #sql #database

2 min read

BHARANIKA D 24CB005

Nov 1 '25

Cursor & Trigger

#database #sql #tutorial

2 min read

Thiago da Silva Adriano

Sep 28 '25

Change Data Capture (CDC): Capturando mudanças em tempo real

#dataengineering #database #architecture #sql

4 min read

Oct 2 '25

DBMS – Transactions, Deadlocks & Log-Based Recovery

#coding #sql #learning #programming

2 min read

Vahid Yousefzadeh

Sep 27 '25

Buffer Busy Wait and Read by Other Session in Oracle

#oracle #linux #database #sql

4 min read

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