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.
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.
SQL, cte, PostgreSQL
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.
The University of Georgia
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.
- Title: GeekChoir 2015
- Track: Culture
- Room: B202/203
- Time: 5:45 – 6:30pm
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