DB class office hours work! :D

[Momoko Price]

Hey guys,

So I was online yesterday at my designated 6-9 time slot to help people out with the course material and was actually able to guide a few people through some problems, which was awesome!

Some people are finding the relational algebra stuff a bit tricky, but I've finished up all the assignments for this week so if you need help, feel free to find me in the following chat room at the designated hours:

https://www.hipchat.com/ghnfGs6n0

I'm starting to think that Tues/Thurs 6-9pm EST might actually suck for both people in Europe and further east, as well as myself since I end up skipping dinner :P The other issue is most people won't get around to trying exercises until the day that they're due anyway. 

How does 9am-12pm on Sundays sound to you guys for chat room "office hours"? 

Let me know!

M

On Tue, Oct 18, 2011 at 11:27 AM, Nicola Hughes <nic...@scraperwiki.com> wrote:

Here's a good site you can play around with for SQL which goes into
the operators:

http://www.w3schools.com/sql/default.asp

Here is a little application you can 'fork' to play around with the
relational outputs of any dataset in ScraperWiki:

https://scraperwiki.com/views/pcc_sql_query_view_2/

A general overview of the layout of ScraperWiki can be seen here:
http://youtu.be/G1uL_0Nakok

And how to an example use of the view here:
http://youtu.be/AIHN2PRGWWc

you can change the query to look at different scraper data by typing
in the name of the scraper (the stuff after scraperwiki.com/scrapers)
in the box that is currently occupied by pcc-decisions-mark-3

_______________________________________________
data-driven-journalism mailing list
data-driven...@lists.okfn.org
http://lists.okfn.org/mailman/listinfo/data-driven-journalism

--

Momoko Price
Communications Director
BuzzData.com
mom...@buzzdata.com
Twitter: @buzzdata
c: (647) 504-7059
o: (416) 546-9780