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.
Understanding 1NF, 2NF, and 3NF in DBMS with SQL Examples

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

Comments
2 min read
Algo entre o VARCHAR2 e o CLOB: VARCHAR2 com esteróides [MAX_STRING_SIZE]

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

1
Comments
2 min read
The Pitfall of ORDER BY Timestamp (And How to Fix It)

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

Comments
3 min read
TIL: Temp table vs CTE

TIL: Temp table vs CTE

1
Comments
1 min read
Cursor and Trigger

Cursor and Trigger

Comments 1
2 min read
Database Normalization

Database Normalization

Comments
2 min read
A Developer’s Guide to PostgreSQL REGEXP_MATCH (with Snippets)

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

Comments
2 min read
DBMS Made simple

DBMS Made simple

Comments
2 min read
Database Normalization

Database Normalization

2
Comments
3 min read
Build2Learn Event

Build2Learn Event

Comments
1 min read
CRUD Operations in MongoDB: Hands-On with a Student Collection

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

2
Comments
2 min read
Cursor & Trigger

Cursor & Trigger

Comments
2 min read
Change Data Capture (CDC): Capturando mudanças em tempo real

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

Comments
4 min read
DBMS – Transactions, Deadlocks & Log-Based Recovery

DBMS – Transactions, Deadlocks & Log-Based Recovery

4
Comments
2 min read
Buffer Busy Wait and Read by Other Session in Oracle

Buffer Busy Wait and Read by Other Session in Oracle

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