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/?utm_source=youtube&utm_medium=social-organic&utm_campaign=Better+Together&utm_term=gl-better-together&utm_content=video&utm_campaignteam=community&utm_partner=none
Amazon Aurora: https://aws.amazon.com/rds/aurora/
More information about SQL Queries for External Entities in ODC: https://www.outsystems.com/product-updates/sql-external-entities/?utm_source=youtube&utm_medium=social-organic&utm_campaign=Better+Together&utm_term=gl-better-together&utm_content=video&utm_campaignteam=community&utm_partner=none

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

Видео Master SQL Queries in PostgreSQL with OutSystems & AWS Aurora Integration! канала OutSystems