Not-so-Common Table Expressions for Developers

As applications get more complex, so does their interaction with the database. In this talk, we will walk through SQL’s Common Table Expressions and how these can improve application code. By using CTEs a developer can reduce transaction handling complexity while at the same time boosting performance, and readability which can reduce development time. For this talk we’ll use PostgreSQL, but most techniques work with any modern RDBMS.

Location: Chambers III Date: July 22, 2017 Time: 9:30 am - 10:30 am Brian Dunavant