Download Training1 and Training2 DBs for E20-007 (EMCDSA)

The datasets were made available for use with the textbook version of the course. You can download them from the publisher's website here: http://www.wiley.com/WileyCDA/WileyTitle/productCd-111887613X.html

You should be sure to check out the Read Me file before using them.

Hi Kate,

Thanks so much for your response. I followed that link but couldn't see where to download the Training1 and Training2 DB's. There is a downloads section with R Commands and CSV Files but I can't see the PostgreSQL Databases. Are they downloadable?

Regards,

Vinny

Hi Kate,

I'm facing the same issue, could you please support, where can i find training2 and housing table?

regards

youness

hi there

i found this

############################################################

# the following code is for illustrative purposes only

# a functioning SQL database is required

install.packages("RODBC")

library(RODBC)

conn <- odbcConnect("training2", uid="user", pwd="password")

housing_data <- sqlQuery(conn, "select serialno, state, persons, rooms

  from housing

  where hinc > 1000000")

head(housing_data)

# end of SQL-related R code

############################################################

so there is nothing you will find with training2 db or housing_data i think

regards

youness

Yeah, I think you're right Youness. It's a shame the Training Databases aren't available with the rest of the content.

Vinny