2009/Deberg

From SIPB Cluedumps

Jump to: navigation, search

[edit] Beyond Basic SQL

Date: October 20, 2009, at 4:30 PM
Presenters: Matt DeBergalis (deberg)
Location: 4-231
Abstract: Many of us learned SQL in the context of hosted web applications, which often only make use of SQL's most basic capabilities. We'll start with a more mathematical framework for thinking about SQL queries. Then we'll leap into a survey of some of the more interesting capabilities of a modern SQL implementation, including advanced joins, constraints, rules and triggers, views, windowing functions, and performance considerations. I'll leave time for other topics of participants' choosing as well. The less SQL you know coming in, the less there is to unlearn.
Personal tools