I've published my talk "PostgreSQL As data Integration Tool" given at PGDay Amsterdam 2018, Netherlands, on GitHub at https://github.com/sjstoelting/talks/tree/master/postgresql-as-data-integration-tool-pgday-amsterdam-2018.
It does include the slides as ODF and PDF and the SQL used for the live database examples.
Instead of using ETL Tools, which consume tons of memory on their own system, you will learn how to do ETL jobs directly in and with a database. PostgreSQL Management of External Data (SQL/MED) is also known as Foreign Data Wrapper (FDW). With FDW, there is nearly no limit of external data, that you could use directly inside a PostgreSQL database.
Published on 2018-08-02