Data Deliverance Courseware

Oracle® SQL*Plus®

Summary
This course gives an introduction to ORACLE® SQL*Plus® and to SQL, the Structured Query Language used to access a Relational Database. It is based on the ORACLE 8 or 8i relational database but the principles learnt may be applied to databases as diverse as Microsoft SQL Server, Access, DB2 and Mysql.

Prerequisites
The course is suitable for those who have some knowledge of SQL as well as those who are using ORACLE for the first time. Previous experience with an interactive computer system is desirable but not essential.

However, if you have extensive experience of another Relational Database, such as SQL Server, or of Structured Query Language, the follow up course described later may be more appropriate.

Next Steps

Length
3 days

Format
Instructor-led course, with many practical computer-based exercises.

Course Outline

Day 1

Day 2

Day 3

Hardware and Software Requirements
Each student should have access to a PC running Windows 95/98/ME or NT Workstation/2000 Professional with at least 500Mb of free space on the C drive and a CDROM. However, the PCs do NOT have to be on a network.
Note to Oracle licensees
Your Oracle license may not allow the use of the software for providing training to people outside your organisation. Contact Oracle if you are planning to provide third-party training and have any doubts about your license in this regard.