Master SQL Queries in PostgreSQL with OutSystems & AWS Aurora Integration!

Описание: In this video, you'll learn how to write powerful SQL queries in PostgreSQL , using real data from an AWS Aurora Postgres database displayed inside an OutSystems dashboard .

We'll cover essential SQL techniques for developers and data professionals, including:
-DISTINCT and DISTINCT ON – what's the difference and when to use each
-CTEs (Common Table Expressions) – for cleaner, more modular queries
-Window Functions like RANK() and ROW_NUMBER() – perfect for advanced analytics and reporting
-Feeding dynamic charts, tables, and counters with live database data
-How to use OutSystems Advanced Queries for External Data
-Querying multiple databases using OutSystems newest feature

🔗 Perfect for OutSystems developers, PostgreSQL enthusiasts, and anyone building dashboards or working with external data sources.
📈 Boost your low-code + SQL skills and learn how to connect it all in a real-world app!

Bonus : Can you find the artists and songs that Miguel references through the video? Is it Taylor Swift? Is it the Doors? Play along and leave your answer in the comments.

Useful links:

OutSystems: https://www.outsystems.com/developers...
Amazon Aurora: https://aws.amazon.com/rds/aurora/
More information about SQL Queries for External Entities in ODC: https://www.outsystems.com/product-up...

00:00 - Intro
01:06 - Use-case setup
01:54 - Dashboard!
02:52 - Counters - Distinct & Distinct ON
08:15 - Rentings chart - Common Table expressions & generate_series
13:01 - Unpopular Fleet - More CTE
14:52 - Top Branches - Lag, Row_Number, Rank, Partition and more
23:13 - SQL querying on external entities in OutSystems - Timestampdiff
27:52 - Wrap-up