[ddj] SQL resources

• Previous message: [ddj] data-journalism how-to tutorials (with demo clips!)
• Next message: [ddj] SQL resources for DB class
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Previous message: [ddj] data-journalism how-to tutorials (with demo clips!)
• Next message: [ddj] SQL resources for DB class
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]