Presented by:

3a4bc7d7ee096aecdacf615ecb2851ad

Ben Lis

LEI Smart

Some relevant points about me:

  • Data Engineer at LEI Smart
  • Writes recursive queries on corporate hierarchy data
  • Initially found recursive SQL a bit confusing
  • PostgreSQL user since 2015; longtime RDBMS user
  • Adjunct Associate Faculty in Applied Analytics at Columbia University
  • Held various technical, product, and management roles on Wall Street
No video of the event yet, sorry!
Download the Slides

Recursive queries enable PostgreSQL users to retrieve hierarchical data from relational tables. Attendees learn:

  • why we need recursive queries
  • how they work
  • how to write them

The talk assumes knowledge of SQL through outer joins and a general understanding of programming concepts.

The schema and queries used in the talk are available for download at https://github.com/benjlis/talk-writing-recursive-queries.

Date:
2019 March 20 14:00
Duration:
50 min
Room:
Grammercy
Conference:
Postgres Conference
Language:
Track:
Data
Difficulty:
Medium