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.

Haresh B

Oct 7 '25

Mastering SQL: A Practical Guide to Cursors and Triggers in Oracle

#sql #oracle #database #programming

3 min read

Rama Pandu Cheti

Nov 10 '25

How I built a free AI Regex Generator using Hugging Face + Next.js (no API costs)

#ai #nextjs #sql #regex

2 min read

Oct 8 '25

Employee Data sales Dashboard

#python #datascience #dataengineering #sql

1 min read

Haresh B

Oct 7 '25

Solving a DBMS Assignment on Oracle Live SQL: Transactions, Deadlocks & Log-Based Recovery

#oracle #sqlserver #database #sql

3 min read

Haresh B

Oct 8 '25

Understanding ACID Properties with Oracle Live SQL

#sql #database #oracle #acid

4 min read

Kanishka L

Oct 7 '25

Transactions, Deadlocks & Log-Based Recovery

#oracle #tutorial #database #sql

2 min read

Kamwemba Tinashe C

Oct 7 '25

Indexing, Hashing & Query Optimization

#sql

2 min read

ABITHA N 24CB001

Oct 7 '25

Database normalization

#tutorial #database #computerscience #sql

3 min read

Kamwemba Tinashe C

Oct 7 '25

Transactions, Deadlocks & Log Based Recovery

#sql

2 min read

Rokesh . S

Oct 7 '25

Transactions, Deadlocks & Log Based Recovery

#computerscience #database #sql

1 min read

Rokesh . S

Oct 7 '25

CURSOR + TRIGGER

#database #sql #tutorial

2 min read

TERERA FAITH TANAKA 24CB070

Oct 7 '25

ACID property with SQL transactions

#tutorial #database #sql #computerscience

2 min read

Kamwemba Tinashe C

Oct 7 '25

Cursor + Trigger

#programming #sql #oracle

2 min read

Nov 10 '25

Recursive CTEs: Because Writing Nested Loops for Trees is Psychopathic (and a Little Masochistic Too)

#database #sql

10 min read

Kamwemba Tinashe C

Oct 7 '25

Normalization

#programming #sql #mongodb

3 min read

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