Skip to main content

WITH What? CTEs For Fun And Profit

Michael Brewer (UGA: Franklin College OIT)
Average rating: ****.
(4.25, 4 ratings)

There are some use cases for which plain SQL might not be enough; you need to use recursion, but don’t know how. Common Table Expressions may be able to help!

In this session, we will use PostgreSQL to introduce the attendees to Common Table Expressions. We will go over their syntax, view their results, and discuss best practices and use cases for this powerful SQL feature.

Photo of Michael Brewer

Michael Brewer

UGA: Franklin College OIT

Michael Brewer is an Application Programmer Specialist for the Franklin College Office of Information Technology at The University of Georgia. He designs database-backed web applications used by thousands of students and faculty and serves on several college and University-wide committees on Web development, best practices, and application security. In 2005, he won an Advising Technology Innovation Award from the National Academic Advising Association for an academic advising application he created and maintains. A speaker at OSCON in 2011 and 2012, he is also on the board of the United States PostgreSQL Association. He holds dual degrees in Mathematics and Music from The University of Georgia. A member of ASCAP, he also conducts the oldest continually operating community band in the state of Georgia; he has arranged music for orchestra, band, chorus, and has even composed incidental music for plays and musicals.