Instructions for SQL Lab

SQL Tutorials take place in the Database Teaching Lab SoC1-06-31
Here is the lab schedule.
The lab questions are published in the IVLE Workbin (Tutorials folder)

Click here for instructions on setting up a local Sybase server on your PC


Connection to SyBase Database (sundbl)
Follow these instructions to connect to the Sybase Database server from the Lab computers:

• Run Interactive SQL (ISQL)
• Goto Start -> All Programs -> SQL Anywhere 9 -> Adaptive Server Anywhere -> Interactive SQL
• You will see 3 tabs (Identification, Database,Advanced). Choose the Database tab.
• At "Server Name", clcik the "Find" button. It should report that there is a server named "course" with hostname "sundbl.comp.nus.edu.sg". Choose "course" by double-clicking on it.
• Login with userid and password
• Go back to the Identification tab, use your NUSNET account userid. The initial password is your matric number.

CHANGE PASSWORD
You will have to change your password since this is the FIRST time you're loggin into the Sybase server.
Please change your password by using this command in the SQL window:

GRANT CONNECT TO your_userid IDENTIFIED BY new_password

Note: replace your_userid and new_password accordingly with your own userid and your new password.