Getting Started and Setup with Oracle

This course uses the Oracle DBMS for the duration of the course. We will be accessing the database through the SQL Developer GUI. Your login and password credentials will be provided to you in one of 2 ways

The following video is a video tutorial on installing SQL Developer:  YOu can either watch the video or follow the instructions below.

Downloading and Installing SQL Developer

This procedure will change based on if you are using school lab computers or your own personal computer. If using your own personal computer, the process will change slightly. This guide only covers installing SQL Developer on Windows 10 machines.

Using School Lab Computers

When accessing SQL Developer from a lab computer, simply find SQL Developer in MyApps and launch the software.

Using Personal Computers

Through MyApps

As a registered student at Seneca College, you should have access to MyApps from any computer, although it will require setting up the first time.

Installing Locally

If you wish to install SQL Developer on your machine and still have access to it after leaving school or are not using a Windows PC, you will want to download the installation package and install it from there.

SQL Developer GUI and Sample Database

  1. Open the SQL Developer Application. There should be an icon on your desktop or in the start menu search for SQL Developer.
  2. This screen will appear. If you previously logged on and made connections, there will be entries below the word connections. You can then click on those entries and it will save entering data each time.
    SQL Developer Loaded
  3. Click on the green PLUS to create a new connection and fill in the data as shown below. The connection name can be anything such as your id or initials.
    1. Connection Name: Anything you want to call it: example: MyConnection or DBS211
    2. UserName and Password: have been assigned to you
    3. Save Password: is optional, I would save it for class purposes, but in the real world, we would not save that information
    4. Hostname:
    5. Port: 1521
    6. Click the Service Name radio button and enter: oracle12c
    7. Test the connect, if successful, click Save and then Connect
  4. SQL Developer Connection Screen
  5. Once you successfully connect, the following screen appears:
    SQL Developer, Connection Loaded
  6. The first time you connect to the Oracle server through SQL Developer, you will need to run an SQL Creation Script to create the tables, data, constraints, etc. for the course sample database.  A couple of creation scripts that are available are: in order to run the creation scripts:
    1. Open the provided file in your favourite text editor (example: Notepad++)
    2. copy all of the content ctrl-A, and paste it ctrl-Vinto the large editor window shown above.
    3. Select all the content ctrl-A and run the script using the Run Statement button ctrl-enter: It looks like a green arrow near the top left corner.
  7. Expand the connection and then the “Tables” section from the left menu. If the tables do not appear, try clicking the refresh button and the expanding tables again.
  8. Erase the creation script from the SQL Worksheet window (ctrl-A and delete key).
  9. Enter a simple SQL Select statement to test the data is present:
    SELECT * FROM employees;
    Highlight the code and click the run button
  10. If the data appears in the Query Results window at the bottom, you have successfully connected.

Return to the Preface