Lectures

Learn how to use the ALTER TABLE command in PostgreSQL to add and remove columns in existing tables. Practical examples, syntax, common mistakes, and handy tips for both beginner and experienced database developers.

Learn how to safely and efficiently change column data types in PostgreSQL: syntax, examples, common mistakes, and tips for transforming data using the ALTER TABLE command.

In this lecture, you'll learn how to safely and properly drop tables from your database using the DROP TABLE command, get the hang of its syntax, options like CASCADE, RESTRICT, IF EXISTS, plus you'll get some handy tips and find out about common mistakes when working with dropping tables.

Learn how to create and use temporary tables in PostgreSQL for short-term data storage, query optimization, and analytics. Real-life examples, tips, and common mistakes — everything you need for effective work with temporary tables!

Learn about the most common mistakes when creating and modifying tables in PostgreSQL: from picking the right data type to working with constraints and temp tables. Tips and examples will help you dodge typical pitfalls and make your database work more reliable!