With the power of PostgreSQL, modern data transformation can happen inside the database rather than with external tools. This is known as the extract, load, and transform (ELT) pattern using built-in functions and SQL features to work with data regardless of the form. Once the data is loaded, knowing how to utilize Common Table Expressions (CTEs), recursive CTEs, and CROSS JOINs can significantly improve your data transformation tasks.

In this session, I’ll explain and demonstrate how each of these features can be used together to build powerful queries that utilize additional PostgreSQL features and functions. Transforming JSON, text, and even emoji into sources of data-driven insights.

By the end of this session, you will understand how to approach data challenges differently, using the power of PostgreSQL and SQL to work more effectively.