Oracle SQL and SQL*Plus

				
				COURSE DESCRIPTION

	Participants will be introduced to the Oracle database, SQL, and the
	SQL*Plus tool. Several exercises use SQL to query the database and
 	create simple reports using the SQL*Plus tool. The participant will 
	also learn how to work with views and synonyms.


				  COURSE AUDIENCE

	Personnel needing to create and execute queries against the Oracle
 	database using SQL*Plus. No programming background or experience 
	is necessary, although a technical orientation is helpful.

				  COURSE TOPICS
                				
			Relational database concepts 
                        SQL syntax and usage 
                        SELECT statement 
                        Joins 
                        Outer joins 
                        Nested Queries 
                        Views 
                        Synonyms 
                        SQL*Plus report creation 
                        Editing and saving queries 
                        Spooled output 


				COURSE DURATION

   	This course requires three (3) days, approximately 
	50% lecture, and 50% lab time.

                             
				COURSE PREREQUISITES

	Participants should be familiar with the terminals to be used 
	in class exercises. A basic understanding of the host system 
	editing tool is useful, but not required.