Course Section 1 Content Section 1 Content Left Section 1 Content Right Credit Type: Course ACE ID: ADVN-0007 Version: 2 Organization's ID: AI 331 Organization: Advantec Institute Location: Classroom-based Length: 35 hours (5 days) ACE Credit Recommendation Period: 1/31/2002 - 2/1/2007 1/1/1997 - 1/31/2002 Credit Recommendation & Competencies Section 2 Content Section 2 Content Left Section 2 Content Right Level Credits (SH) Subject Upper-Division Baccalaureate 1 Computer Science, Computer Information Systems, Sql Programming, or Applications Description Section 3 Content Section 3 Content Left Section 3 Content Right Objective: To provide students with an introduction to the main features of the Pl/SQL language to aid students in developing effective programming habits and coding styles. Learning Outcomes: Define Pl/S!L and how it differs from SQL Describe, invoke, and use the Oracle Procedure Builder Describe PL/SQL's block structure and its three components Create variables and constants in PL/SQL, and assign values to them Control program flow using loops and if-then logic Handle errors using the EXCEPTION block in PL/SQL Create cursors to handle multiple-row queries Write stored, named procedures, functions, and database triggers Pass parameters to a procedure Use the Oracle DE Instruction & Assessment Section 4 Content Section 4 Content Left Section 4 Content Right Instructional Strategies: Classroom Exercise Discussion Lectures Supplemental Materials Section 5 Content Section 5 Content Left Section 5 Content Right Equivalencies Section 6 Content Section 6 Content Left Section 6 Content Right Button Content Rail Content 1 Page Content