Скачать или смотреть UTOSC 2009 - Josh Tolley - Fun with SQL

Most developers find database interaction painful at some level; many dread it outright. What developer hasn't spent hours digging through documentation, Google, or the nearest colleague, trying to work out how to write a particular query, only to find out two days too late that some obscure syntax would have made it easy? This talk aims to introduce the attendee to SQL idioms and constructs that can save weeks of debugging, free up hours of coding, and shave precious minutes and seconds from application runtimes.

Josh Tolley participates actively in the PostgreSQL project and works as a PostgreSQL administrator for hire with End Point Corporation. On the rare occasions that the Utah Database Users Group, or UDBUG, happens to do anything, he's likely somewhat responsible for it. He also enjoys gardening, cooking, and trying to learn electronics without hurting himself.