Connection software
To use and develop databases in this unit you will need software to connect over the Internet to the Oracle database:
Connecting to the server redstart, where the Oracle DBMS is
- SQL Developer is a much more sophisticated program that provides a Windows interface. It is also larger (96 MB) and for non-commercial use can be downloaded from:
File transfer
- WinScp software will allow you to transfer files easily between redstart and your PC
Visio
Visio can be used to draw ER diagrams and is the tool we used for the examples throughout the unit.
If you choose to use Visio, here is the stencil we used to create the examples for this unit.
Sample databases
Two sample databases are used throughout this unit.
- INVOICE database: this database is used throughout the first module: Using a database
- INVOICE database: see the Creating Tables topic in the first
module: Using a database
For details on how to use SQL*Loader, see Oracle links.
