SQL for PostgreSQL

This part of the course focuses on building accurate, efficient queries. You’ll learn how to construct SELECT statements that bring back the right data, apply filters for precision, and sort results for readability. We’ll also work through creating meaningful column names, performing calculations, and using aggregate functions to summarise data. By combining these techniques, you’ll be able to present information exactly as it’s needed. 

PostgreSQL’s built-in functions are powerful tools for transforming data, and this section gives you the practice to use them effectively. You’ll apply numeric, text, and date functions to real-world examples, manage conversions between data types, and handle incomplete or inconsistent values with CASE, COALESCE, and NULLIF. The focus is on writing SQL that is flexible, clear, and able to handle a variety of scenarios. 

This final section equips you to create and manage the building blocks of a PostgreSQL database. You’ll design tables with the right constraints to ensure reliability, make structural changes when needed, and use indexes to improve performance. We’ll also explore views, showing you how they can make complex queries more straightforward while keeping the underlying database secure and well-organised.