| Lesson 2 | Database Course Prerequisites |
| Objective | This page discusses the prerequisites for this course. |
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. (Database support and tutor support is 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).
Oracle8 server software
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. (Database support and tutor support is 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).
I recommend that you work with a real Oracle server during this course even though this is not specifically required. If you have an Oracle
database available to you now, go to the Resources page and 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 Oracle8i. You may also wish to install Oracle
Enterprise Manager because many of the courses reference this tool.
You cannot use another 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 look into ordering a trial version of Oracle8i Enterprise Edition Server, Oracle Enterprise Manager, or Personal Oracle8i, go to
the OracleStore Web site.
You can also download Oracle8i from Oracle's Web site.
Oracle requires you to register and allows you to download the software for free.
You can purchase all of this software online by visiting our Software Store[[Software Store page]]. You can reach the Software Store at any time by clicking the Resources button on the toolbar, then clicking the software link at the top of the Resources page.
Course downloads
You can also download Oracle8i from Oracle's Web site.
Oracle requires you to register and allows you to download the software for free.
You can purchase all of this software online by visiting our Software Store[[Software Store page]]. You can reach the Software Store at any time by clicking the Resources button on the toolbar, then clicking the software link at the top of the Resources page.
The houseopets.zip file on the Resources page contains several files that you need to complete the course project exercises:
Download Course Project - Exercise- 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
- Sample data for the optional On Your Own exercises: the SQL file will help you create the sample database for the course project
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
Download Course Project - Exercise
