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.

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

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

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