blob: 80951021643f1d8ef974169349773d444a1bafc7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
Lab 1: Starting up your account in the Teradata University Network (TUN)
1. Register for TUN as a student member at http://www.teradatauniversitynetwork.com/tun/ (For the student access password please check in the Course News and Announcements or contact your tutor).
2. Create an account for the Teradata SQL Assistant (Note: this account is different from the one you created to be a TUN member): http://tunweb.teradata.ws/tunstudent/
To complete the registration form, please use the following information:
University: Athabasca University
Instructor: Larbi Esmahi
Course: COMP 378: Introduction to Database Management
Course Password: There is no course password, so just leave this field blank
3. Read the SQL Assistant Web Edition User Manuals, which can be found under "Help" on the main menu of http://tunweb.teradata.ws/tunstudent/. Note that there are a number of additional user manuals available under the Help menu, if you need them (but you are not required to read them for the course).
4. Log in to SQL Assistant, but leave the ‘Default database’ field blank.
5. Familiarize yourself with the SQL Assistant using the following queries:
a. Create a table in your default database.
```sql
CREATE TABLE people (id integer, address varchar(20), phone_number varchar(15));
```
b. Insert records in the created table.
```sql
INSERT INTO people values (10, '123 sesame street', '7803333222');
INSERT INTO people values (11, '1 university drive', '7805555444');
```
c. Select records from the table.
```sql
SELECT * from people;
```
6. Log out of the SQL Assistant and TUN.
|
