Lectures

Get to know the basics of data types in PostgreSQL: why we need them, how they're classified, and why picking the right data type matters for your database's structure, performance, and reliability.

Learn how to pick the right numeric data types in PostgreSQL: what's the difference between INTEGER, NUMERIC and FLOAT, when to use each, and what gotchas you might run into when working with numbers in your database.

Find out what makes the data types CHAR, VARCHAR and TEXT in PostgreSQL different, when to use each one, and what gotchas you might run into when working with text fields.

Find out what the BOOLEAN data type is in PostgreSQL, how to use it to store true and false values, plus common mistakes and best practices for working with this data type.

Learn how to use the DATE, TIME, and TIMESTAMP data types in PostgreSQL to store and handle dates and times. Examples, common mistakes, and practical tips for beginners.