If you're new to Linux this is the group for you!
|Welcome Athens Linux Users!||Follow @ClassicHackers Join Group|
What is CHUGALUG?
Local Linux Resources
World Wide Linux links
Date: December 17th, 2009
Brandon Checketts gave a presentation starting with some basics of SQL and built up to some more complicated queries.
It started out with a simple table for kids who were either naughty or nice. We then added some reports to that. Then imported kids' wish lists from CSV files. From there we were able to generate some manufacturing reports for the workshop.
When we joined the wish list table with the kids table, we were then able to generate a sleigh-loading report which included only gifts for kids who had been good. Then we got even more complicated and introduced several joins with some complicated mathematics to select gifts for kids within a certain radius from a given zip code.
The presentation is available for download here. And Brian recorded part of the presentation which is available to view on uStream.tv or here. (We're still experimenting with getting the video recording set up correctly)