SQL104

Technical Requirements

Oracle Database 10g/11g

You need to have full administrative access to Oracle 10g or 11g. If you do not, you can use Oracle 10g Express Edition:

1. Download Oracle Database Express Edition: http://www.oracle.com/technology/software/products/database/xe/htdocs/102xewinsoft.html. Note: you will need to register for a free account to gain access to the download.
2. Execute the file you downloaded by double-clicking on the folder and then double-clicking on Setup.exe.
3. Run through the Installer accepting all the defaults. Use system (all lowercase) as your password. Make sure to write down and keep your password.

Oracle Client Options

1. Download SQL Developer
2. Create a folder called sqldeveloper in the Oracle folder located on c: and then extract the sqldeveloper.zip to that sqldeveloper folder you just created.
3. Within that folder, open the sqldeveloper folder
4. Double-click sqldeveloper.exe to start SQL Developer

Class Files

1. Download the class files.
2. After downloading the class files, create a directory on your hard drive named "Webucator" that can be found easily.
   1. On Windows it is recommended the new folder have a path of C:\Webucator.*
   2. On Mac OS X a good location for the new folder may be in your Documents directory.
3. Extract the files to the folder you just created.

Installing the Northwind Database using SQL Developer for Oracle

NOTE: you should download the class files below before following these instructions, as it contains the Northwinds Database file(s).

1. In SQL Developer, add the following connection:
   1. Connection Name: system
   2. Username: system
   3. Password: system (this should be the password you created when you installed Oracle)
   4. Click on Connect
2. Click on File>Open and open up the Northwind-Oracle.sql file located in your class files.
3. Click on the second green play button (F5) to run the sql script.
4. Under the connections tab, click on the green + button to create another connection.
   1. Connection Name: student
   2. Username: student
   3. Password: student
   4. Click connect
5. To test, right click on the student connection and choose open SQL worksheet. Type the following query and click on the second green play button (F5)

SELECT * FROM Employees;

FAQs

1. What if I have an older version of Oracle or Oracle SQL Developer Tool?
   1. You will probably be fine.
      Important: If you are not using Oracle XE, you will need to find out the settings for your installation of Oracle. If you don't know them, you may need to speak with an IT administrator in your organization.