Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
12. Relational Databases: Can you relate... > Dataville Dispatch extracted your da...
Dataville Dispatch extracted your data using the SQL language
SQL, or Structured Query Language, is how data is extracted from relational databases. You can get your database to respond to your SQL questions either by tying the code directly or using a graphical interface that will create the SQL code for you.
Load this!
Here’s the output from the query that gets you the table you want.
www.headfirstlabs.com/books/hfda/hfda_ch12_articleHitsComments.csv
The query that created this data is much more complex than the example on the left.
You don’t have to learn SQL, but it’s a good idea. What’s crucial is that you understand how to ask the right questions of the database by understanding the tables inside the database and the relations among them.
