Modular SQL

*
Proposal
Short Form
Intermediate

Excerpt

Sometimes, one can get lost in a jungle of SQL code; in this session, we'll go over how to build queries with a more modular design, testing components as they go, and building complex functionality from simpler SQL blocks.

Description

It’s easy to get lost sometimes in the jungle of SQL syntax and code. In this session, we’ll go over tips and tricks for how to build queries in a more modular fashion, so that difficult, complex queries can be broken down into more manageable components that are easier to test and to maintain.

Tags

SQL, cte, PostgreSQL

Speaking experience

I have spoken at four different OSBridge conferences; I have also spoken at OSCON three times. At last year's OSBridge, I presented the "SQL Utility Belt" session; I have not given this particular talk before, however.

Speaker

  • Brewer

    Michael Alan Brewer

    The University of Georgia

    Biography

    Michael Brewer is a Web Developer Principal 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 has served 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 maintains; he also serves on the board of the United States PostgreSQL Association. He holds bachelor degrees in both Mathematics and Music from The University of Georgia, conducts Georgia’s oldest continuously-operating community band, is Director of Music at Emmanuel Episcopal Church (Athens, GA), and is a member of ASCAP.

    Sessions

      • Title: GeekChoir 2015
      • Track: Culture
      • Room: B202/203
      • Time: 5:456:30pm
      • Excerpt:

        In this session, we’ll continue the grand Open Source Bridge tradition of learning how to increase team cohesion, identity, and collaboration through music, joining our voices (in our uniquely geeky way) in harmony.

      • Speakers: Michael Alan Brewer