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.

Comments

Comments are closed.

CTEs blew my mind. I didn't know it was even a thing. Thanks Brian!