From Padawan to Knight: Expanding your SQL skillset

*
Proposal
Long form
osb2009-0178

Excerpt

Do your SQL skills end at the banks of the Outer Join? This tutorial will help you to improve your SQL Fu.

Description

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.

Tags

SQL, database, PostgreSQL

Speaking experience

Speaker

  • Brewer

    Michael Alan Brewer

    The University of Georgia

    Biography

    Michael Brewer is the Lead Application Developer 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 maintains; he recently joined the board of the United States PostgreSQL Association. He holds bachelor degrees in both Mathematics and Music from The University of Georgia and is a member of ASCAP.

    Sessions