MySQL + SQL · Lesson 1

Rdbms Tutorial

What is RDBMS?

RDBMS (Relational Database Management System) is a DBMS based on the relational model proposed by E.F. Codd. Data is stored in tables and accessed using SQL.

Key Features

Data stored in tables (relations).
Each row is unique (primary key).
Tables linked via foreign keys.
Supports SQL, constraints and ACID transactions.

Popular RDBMS

MySQL
Free, web apps

Oracle
Large enterprise

SQL Server
Microsoft stack

PostgreSQL
Advanced open-source

Summary

RDBMS follows Codd's relational model.
Tables + keys + SQL + ACID = RDBMS.