UNSOLVED

vfokeeffe

updated

5 months ago

V

vfokeeffe

3 Posts

0

1939

November 6th, 2015 01:00

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

Where can I get a copy of the Training1 and Training2 databases used in the Labs for the VILT course E20-007 (EMCDSA)? I've downloaded the source code and data in course resources but that doesn't include that databases.

  • KEHutchinson

    4 Apprentice

    •

    633 Posts

    559

    0

    Posted December 1st, 2015 06:00

    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.

  • vfokeeffe

    3 Posts

    559

    0

    Posted December 2nd, 2015 11:00

    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

  • youness1

    2 Posts

    561

    0

    Posted December 5th, 2015 12:00

    Hi Kate,

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

    regards

    youness

  • youness1

    2 Posts

    559

    0

    Posted December 7th, 2015 18:00

    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

  • vfokeeffe

    3 Posts

    560

    0

    Posted December 14th, 2015 12:00

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

    Vinny