teradataStudentnetwork teradatauniversity - using PineValley

General

teradataStudentnetwork teradatauniversity - using PineValley

I am new so please forgive the simplicity of my question.  

I am teaching an Intro to Database classs with Modern Database Management by Hoffer.  I want my students to do some beginning work in SQL in teradatastudentnetwork.com.  I have registered myself as a faculty and also as a student.  

Using the Trial Assistant, I was able to log in  see the databases in the tree on the left.  I selected the db_pvfc9_std.  However, when I key in a SQL statement I am always getting an error.  It is not syntax.  I actually did a cutNpaste from Hoffer's solution.  The tables show in the tree.  It should run but it is as if it isn't seeing the database.  Did I miss a simple step to connect to the database?  Perhaps it is so obvious I am missing it but I don't see that I should do anything except higlight the db in the tree and then enter/execut the code. 

1 REPLY

Re: teradataStudentnetwork teradatauniversity - using PineValley

Answered my own question.  THere were differences in the table and field names in the Instructor Manuel and the database on TeraData