Presented by:
Ben Lis
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
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 EDT
- Duration:
- 50 min
- Room:
- Grammercy
- Conference:
- Postgres Conference
- Language:
- Track:
- Data
- Difficulty:
- Medium