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.
Answered my own question. THere were differences in the table and field names in the Instructor Manuel and the database on TeraData