Lectures

Check out a real-life relational database architecture for a big e-commerce platform (Marketplace). This lecture breaks down the schemas, tables, and subject areas in detail, plus gives you tips on how to create and load the structure and data into PostgreSQL. It's an awesome chance to see how real-world production databases are built!

In this lecture, you'll learn how to properly link tables from different schemas in the Marketplace relational database using foreign keys. We'll check out examples of cross-schema relationships, tips for ON DELETE, and a full list of all the foreign keys you need to keep your data solid.

This material brings together the 50 most in-demand SQL queries for a marketplace, recommendations for creating indexes to speed up your database, and a set of functions to centralize business logic and optimize data handling. It's a hands-on guide for designing, optimizing, and maintaining a modern e-commerce platform.

In this lecture, you’ll learn how to design and implement procedures and triggers to automate marketplace business processes: order placement, restocking, bulk updates, notifications, logging, automatic status management, and a bunch more. You’ll get practical tips and best practices to boost the reliability and transparency of your database.

In this lecture, you'll learn how to automate business report generation and data backups on a schedule in complex systems like marketplaces. We'll cover types of regular reports, their business value, and also strategies and types of backups to make sure your data is reliable and can be restored when needed.