Lectures

Intro to databases: why we need them, how they work, how they're different from Excel, and why modern devs can't live without them. Simple examples, explanations, and motivation to start learning SQL using PostgreSQL.

Intro to the relational data model: what it is, how tables, keys, and relationships work, and why relational databases became the go-to standard for storing structured info.

An overview of the main types of database management systems: relational and NoSQL. We'll check out their differences, advantages, use cases, and when you should pick one approach over the other.

Intro to SQL: why you need SELECT, main goals of the language, its perks, real-life examples, and how to write comments in PostgreSQL. Learn how to fetch, filter, and analyze data with SQL!

In this lecture, you'll get to know the basic structure of an SQL SELECT query, learn how to pick the columns you need from a table, find out the order in which a query runs, and see some common mistakes when working with SELECT.