Relational Database Concepts

Summary

The model of organizing data into tables with rows and columns, related to each other via keys — the foundation of SQL databases and still the default choice for most structured application data.

How to Learn This

1Sketch out tables for a simple app (e.g. a blog) and how they relate.
2Learn the difference between a table, row, column and schema.
3Compare relational databases to the document/key-value models you'll see in NoSQL.

File Upload Service

SQL Basics (SELECT, INSERT, UPDATE, DELETE)

More topics in SQL Databases

SQL Basics (SELECT, INSERT, UPDATE, DELETE)Joins Indexes Normalization Transactions ACID Properties PostgreSQL MySQL Constraints & Keys Views Stored Procedures Database Design & ER Diagrams Migrations

Stuck on this topic? Ask an Insider

Get 1:1 guidance from people who've walked this exact path — free on the InsideEdge app.

Download