RelationalDBDesignRelationalDBDesign





Network Admin  «Prev  Next»
Lesson 2 What you need
Objective Learn what you need to take this course.

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. It is not scored, it is an optional hands-on exercise that you can do if you have access to an Oracle database. (Database support and tutor support are not provided for On Your Own exercises.)
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.)

Oracle11g server software

I recommend that you work with a Oracle SQL*Plus during this course or better yet, Oracle SQL Developer, even though this is not specifically required. If you have an Oracle database available to you, 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 relational database management system. You may also wish to install Oracle Enterprise Manager because many of the exercises reference this tool.


You cannot use another brand of database for practice because the majority of this course covers Oracle's exclusive management tools, parameters, and features .

If you want to obtain Oracle Enterprise Manager or Oracle Personal Edition go to the Oracle
Oracle requires you to register for software downloads and allows you to download the software for free.
To install Oracle, run the Setup program. The Installation Wizard will guide you through the installation.

Course downloads

The Resources files will be made available in the future.
  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 on 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.
In the next lesson, you will learn about course resources.

Course Download 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.
Course Download Exercise