PostgreSQL

Summary

A powerful, open-source relational database known for standards compliance, extensibility (JSON support, full-text search) and being the default choice for most new backend projects today.

How to Learn This

1Install PostgreSQL locally and connect to it with a GUI client (e.g. TablePlus, pgAdmin).
2Practice PostgreSQL-specific features like JSONB columns and array types.
3Learn `psql`, the command-line client, for quick queries and debugging.

ACID Properties

MySQL

More topics in SQL Databases

Relational Database Concepts SQL Basics (SELECT, INSERT, UPDATE, DELETE)Joins Indexes Normalization Transactions ACID Properties 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