RelationalDBDesign 





Database Administration   «Prev  Next»
Lesson 2 Database Course Prerequisites
Objective This page discusses the prerequisites for this course.

Database Administration Course Prerequisites

On Your Own exercises

This course makes use of optional On Your Own exercises.
An On Your Own exercise is a good way for you to practice the skills you have learned.
The exercise is not scored.
It is an optional hands-on exercise that you can do if you have access to an Oracle database. (The download for the Oracle software is listed below)
If you want to perform the optional hands-on On Your Own course exercises, you will need the following hardware and software (Please note that this setup is optional and is not required to take the course).

Oracle SQL Developer

I recommend that you work with Oracle SQL Developer during this course even though this is not specifically required. If you have an Oracle database available to you now, download the sample database script and instructions on how to install it on your database.
To run the database script and populate the database with data, you will need access to Oracle. You may also wish to install Oracle Enterprise Manager because many of the courses reference this tool.


You will need to use the Oracle brand of database for practice because the majority of this course covers Oracle's own extensions to SQL, such as the Decode function.
If you want to obtain Oracle Enterprise Manager, visit the following link Oracle Enterprise Manager.
You can also download Oracle from Oracle's website.
Oracle requires you to register and allows you to download the software for free. If you are interested in obtaining this software directly from Oracle, the following link will let you download Oracle Database 12c Release 2.

Course downloads

The houseopets.zip file on the Resources page contains several files that you need to complete the course project exercises:
  1. The House-O-Pets course project schema: a database diagram and a document listing of all the tables and data you need to work the course projects without any database software
  2. Sample data for the optional On Your Own exercises: the SQL file will help you create the sample database for the course project

Download Course Project - Exercise

Click the Exercise link below to download the files you will need to complete the course project exercises and the On Your Own optional exercises.
Download Course Project - Exercise