Teradata Student Network Teradata Database for Your Classes These pages are designed to provide a simple way to register, learn about, and access Teradata SQL Assistant/Web Edition for use in your classes. Home Page On the top half of the screen you will see links to the Teradata Database Web Site Overview, registering to use Teradata SQL Assistant/Web Edition in your classes, and a link to retrieve your SQL Assistant password. On the bottom half of the screen, you will see links for Teradata SQL Assistant/Web Edition, as well as a tutorial, list of Teradata reserved words, and a user manual. You are currently reading the Teradata Database Web Site Overview, which provides a quick overview of this web site. The second link on the home page, “Register to use Teradata SQL Assistant/Web Edition”, is used to register to use SQL Assistant in a course. You will need a separate account for each course that uses SQL Assistant. Once you have registered for a SQL Assistant account for your course, you will be able to access Teradata SQL Assistant/Web Edition.Teradata Student Network There are also four links associated with Teradata SQL Assistant/Web Edition. The first link will take you to the product executable (connecting to a Teradata database, executing a query, and manipulating the results). The second is a tutorial that gives you a quick overview of the product, the third is a list of Teradata reserved words, and the fourth is the user guide for a more detailed description of the product.Teradata Student Network Student Registration This is the first page you see once you enter the site to create a SQL Assistant account for a course. 1) Pick the University you are attending from the drop down menu. * 2) Pick your Instructor from the drop down menu. 3) Pick your course you are currently taking from the drop down menu. 4) If your instructor has given you a password for the course, please enter it in „Course Password‟. Your instructor may not have password protected the course. 5) Enter the SQL Login you wish to use. This will be your login to access Teradata SQL Assistant/Web Edition. This can only be alphanumeric and start with a letter, no spaces or special characters. 6) Enter a SQL Password. This will be your password to access Teradata SQL Assistant/Web Edition. Again, you may only use alphanumeric and start with a letter, no spaces or special characters * You can use Teradata SQL Assistant / Web Edition even if you are not enrolled in a class. You should select Demo University, then Stu Demo as your instructor and either Database Demo 101 or Database Demo 102 as the dataset you work with. Database Demo 101 is the data set that is used with the textbook, Watson, Richard T., Data Management: Databases and Organizations, 4th ed., New York, NY, Wiley, 2004. Database Demo 102 is the data set that is used with the textbook, Hoffer, Jeffrey A., et all, Modern Database Management, 6th ed., New Jersey, Pearson Education, 2002.Teradata Student Network Student Registration (cont.) 7) Re-enter your password for verification. 8) Enter your email address. This will enable the system to email your SQL Assistant Password to you if you forget it. 9) Use the Hint Phrase to select a hint, and enter your Hint Answer. 10) Click Register. You should see a message at the top stating you are registered for the course. If you do not enter the input correctly, you will get an error message. The necessary corrections will appear in red in the appropriate areas of the screen. Once you have completed the registration, you may use the links in the orange bar at the top of the page to navigate to the home page or login to Teradata SQL Assistant/web Edition.Teradata Student Network Retrieve Password This is the link you will use if you forget your SQL Assistant password. 1) Simply type in your SQL Account ID, your Hint Phrase, and your Hint Answer. This is the ID you created when you registered for Teradata SQL Assistant/Web Edition. 2) Click „Send Password‟. You will receive an email with your password. The Teradata SQL Assistant Web functionality for Teradata Student Network has been enhanced to include write capabilities. In addition to select statements, your SQL can include create, grant, insert, update, delete, etc. The Teradata SQL user account for each student has 2MB of writeable space (perm space) to use for creating tables. Each Teradata user can create tables in their user account. Sets of SQL statements are provided for copying an entire sample database into user accounts. The “Teradata SQL Assistant / Web Edition Tutorial” contains detailed instructions for using the perm space.Teradata Student Network Conclusion Now that you have registered, you are ready to use Teradata SQL Assistant/Web Edition in a course. Please use the lower half of the home page and click on the link to Teradata SQL Assistant/Web Edition. There are also links to the tutorial and user guide. The tutorial will give you a quick view of how you can use SQL Assistant in your course. The user guide will give you a more in-depth overview of the product. NCR Teradata SQL Assistant/Web Edition - NCR Teradata SQL Assistant/Web Edition is a utility that provides web based access to submit SQL queries to a Teradata database. Requires Internet Explorer 5.5 or higher. o Execute Teradata SQL Assistant/Web Edition o Teradata SQL Assistant/Web Edition Tutorial o Teradata Database Reserved Words o Teradata Database User Manuals o Teradata SQL Assistant/Web Edition User Manual We hope that we have given you a good overview of how to register, learn about, and use Teradata SQL Assistant/Web Edition. Please see your Professor if you have any problems with the