DEV Community

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
How MySQL Actually Works: A Deep Dive into Database Internals

How MySQL Actually Works: A Deep Dive into Database Internals

Comments
16 min read
Database Normalization — Step-by-Step from 1NF to 3NF

Database Normalization — Step-by-Step from 1NF to 3NF

Comments
3 min read
Understanding ACID Properties in SQL with Practical Examples

Understanding ACID Properties in SQL with Practical Examples

Comments
2 min read
Understanding ACID Properties in SQL with Practical Examples

Understanding ACID Properties in SQL with Practical Examples

Comments
2 min read
Database Normalization — Step-by-Step from 1NF to 3NF

Database Normalization — Step-by-Step from 1NF to 3NF

Comments
3 min read
The Unbreakable Contract: Mastering Transactions, Deadlocks, and Database Recovery

The Unbreakable Contract: Mastering Transactions, Deadlocks, and Database Recovery

Comments
3 min read
Understanding Data Formats for Analytics: A Practical Guide

Understanding Data Formats for Analytics: A Practical Guide

1
Comments 1
4 min read
Capstone Project: PCI DSS Online Payment Website

Capstone Project: PCI DSS Online Payment Website

5
Comments
11 min read
Normalisation

Normalisation

Comments
3 min read
Mastering Database Normalization with Oracle Live SQL: A Practical Guide

Mastering Database Normalization with Oracle Live SQL: A Practical Guide

Comments
4 min read
SQL Commands Guide

SQL Commands Guide

Comments 1
4 min read
The Backbone of Database Reliability: Exploring ACID in Action with SQL Transactions

The Backbone of Database Reliability: Exploring ACID in Action with SQL Transactions

Comments
3 min read
Indexing, Hashing & Query Optimization

Indexing, Hashing & Query Optimization

1
Comments
2 min read
⚡️ Database Speed Secrets: B-Trees, Hashing, and Query Optimization

⚡️ Database Speed Secrets: B-Trees, Hashing, and Query Optimization

Comments
2 min read
Database System Internals — Transactions, Deadlocks, Recovery & Indexing Explained with SQL Examples

Database System Internals — Transactions, Deadlocks, Recovery & Indexing Explained with SQL Examples

1
Comments 1
3 min read
Polars - Fast DataFrames Library for Python

Polars - Fast DataFrames Library for Python

1
Comments
1 min read
EXPLORING NORMALIZATION

EXPLORING NORMALIZATION

Comments
2 min read
MongoDB in Action: Building a Smart Student Database with CRUD Operations

MongoDB in Action: Building a Smart Student Database with CRUD Operations

Comments
2 min read
SQL Cursor & AFTER INSERT Trigger — Step-by-Step Guide with Example

SQL Cursor & AFTER INSERT Trigger — Step-by-Step Guide with Example

Comments
2 min read
Database Automation Power-Up: Cursors and Triggers in Under 5 Minutes

Database Automation Power-Up: Cursors and Triggers in Under 5 Minutes

Comments
2 min read
Understanding 6 Common Data Formats in Data Analytics

Understanding 6 Common Data Formats in Data Analytics

Comments
3 min read
NORMALIZATION

NORMALIZATION

Comments
3 min read
Cursor And Trigger

Cursor And Trigger

Comments
2 min read
DBMS - Transactions,Deadlocks & Log-based Recovery

DBMS - Transactions,Deadlocks & Log-based Recovery

Comments
2 min read
Indexing, Hashing & Query Optimization

Indexing, Hashing & Query Optimization

1
Comments
2 min read
loading...