Oracle PL/SQL for Developers

				
				COURSE DESCRIPTION

	Participants will learn to use PL/SQL to enhance the operations of
 	their Oracle applications. Several exercises will take students
 	from the basics of PL/SQL through fairly extensive routines
 	complete with looping, cursors, and error handling. Oracle8i and
 	Oracle8 students will learn and practice using the new features of
 	PL/SQL. 


				  COURSE AUDIENCE

	Application developers and designers who will use PL/SQL in their
	applications. 


				  COURSE TOPICS
                				
		Introduction to PL/SQL, syntax and fundamentals 

                        PL/SQL statements including:
                            Arithmetic, Looping, and Conditional Logic 
                            Error handling (Oracle-defined & user-defined) 
                            Using cursors 
                            PL/SQL Tables 
                            User Defined Records 
                            Procedures, Functions, and Packages 
                            PL/SQL Parameters 
                            Triggers 
                            Built-in Packaged Procedures 
			
			New features of PL/SQL


				COURSE DURATION

   	This course requires two (2) days, approximately 
	50% lecture, and 50% lab time.

                             
				COURSE PREREQUISITES

	Prior knowledge of Oracle fundamentals and basic SQL is necessary.
 	No previous experience with PL/SQL is required.