From Padawan to Knight: Expanding your SQL skillset*
Do your SQL skills end at the banks of the Outer Join? This tutorial will help you to improve your SQL Fu.
Most programmers’ knowledge of SQL plateaus after their first year or two of database programming; this tutorial aims to help the attendee move past the basic CRUD operations into making more intelligent databases. We will cover methods of moving business logic out of the application and into the database, including advanced query design, triggers, and stored procedures.
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.