Oracle SQL Training

1. Windows 10 Pro, Windows 11 Pro, or Windows 11 Pro for Workstation (not the Home editions). See this page for the required specs of the operating system.
2. Oracle Database Express Edition (XE) 12c, 18c, or 21c - Free edition of Oracle RDBMS.
3. Oracle SQL Developer - The client interface for connecting to Oracle.

Create the Webucator Folder

The first step to setting up for your course package is to create the folder in which you will store most of your class files:

1. Create a new folder named Webucator directly on the C drive (i.e., C:\Webucator).
2. Unzip the class files for the Oracle SQL class into C:\Webucator\SQL\:
3. Unzip the class files for the Oracle PL/SQL class into C:\Webucator\PL-SQL\:

The folder structure should look like this:

• C:
  • Webucator
    • SQL
    • PL-SQL

Install the Software

Follow these instructions to install Oracle Database Express Edition (XE) and Oracle SQL Developer. Then, return to this page and follow the instructions below.

Set up the HR Account and Get the HR Schema

First, you will set up the HR account, which you will use to create and then log in to the schema. Then, you will get the HR schema, which holds the data that is used in class.

1. In SQL Developer, add a new connection:
   1. Click the + icon under Connections:
   2. Enter "HR" as the Name and "system" for both the Username and Password, and click Connect:
   3. Close the dialog.
2. Open the HR_Unlock_Account.sql file from your C:\Webucator\SQL\setup.
   1. Select File > Open:
   2. Navigate to and open the file:
3. Select HR from the connection dropdown in the upper right:
4. With the HR_Unlock_Account.sql file open, click the second green play button to run the script. This will create the HR user and assign it the appropriate privileges:

Now, it is time to get the HR schema.

1. Run the Command Prompt as administrator:
2. Run the following commands:
   1. Change directory to the setup folder within the Webucator folder:

      cd \Webucator\setup\

   2. Start SQL*Plus as the HR user:

      sqlplus C##HR/HR

3. Create and populate the HR Schema by running the following two commands:

   @hr_cre.sql

   @hr_popul.sql

   You should see a lot of messages. The final message should be:

   Commit complete.

4. Open SQL Developer and open the properties of the HR connection by right-clicking it and selecting Properties:
5. Change the username from “system” to “C##HR” and change to password to “HR”:
6. Open a blank SQL Worksheet by right-clicking HR under Connections and selecting Open SQL Worksheet:
7. Enter the following SQL query in the new worksheet:

   SELECT * FROM Regions;

8. Run the query by clicking on the left green triangle. You should get 4 rows in the Query Result:

Congratulations. You are all set for your course.