Based on the amount of SQL knowledge that you have right now, you are not going to be developing a database for this homework. You also will not be need to use the INSERT or DELETE commands for this assignment either. This page will cover how to get to the 'SQL Query Analyzer' and open up a session on the server. This stuff is pretty easy, but bear with us, ok? The 'SQL Query Analyzer' will be explained on the next set of web page introductory information.
Step 1
Using the 'START' menu, navigate to 'Programs > Microsoft SQL Server 7.0
> Query Analyzer' as shown below.
Step 2
After following this link, it will give you the prompt to login that looks like
this...
Fill in the screen with the following settings:
Server: ISQL01
Login Name: HW3_user
Password: cse444
Step 3
After login, you should have a screen that looks like the following...
At this point, you've been logged into the Movie database that's sitting on ISQL01. Enlarge that smaller window we're ready to write some queries!