Maricopa Community Colleges  CIS164AB   20016-20025 
Official Course Description: MCCCD Approval: 06/26/01
CIS164AB 20016-20025 L+L 2 Credit(s) 3 Period(s)
Oracle: Developer PL/SQL
Writing PL/SQL procedures, functions, and packages. Creating and managing PL/SQL program units and database triggers in both the Procedure Builder and SQL*Plus environments. Prerequisites: CIS119DO, or permission of the instructor.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS164AB   20016-20025 Oracle: Developer PL/SQL
1. Describe PL/SQL and its development environment. (I)
2. Work with Procedure Builder. (I, II)
3. Create procedures and functions. (III, IV)
4. Create packages and database triggers. (V, VI)
5. Manage subprograms. (VII)
6. Work with object types. (VIII)
7. Manage large objects. (IX)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS164AB   20016-20025 Oracle: Developer PL/SQL
    I. Overview of PL/SQL
        A. Anonymous PL/SQL blocks versus PL/SQL subprograms
        B. The PL/SQL development environment
      II. Working with Procedure Builder
          A. Features of Procedure Builder
          B. Managing program units using the Object Navigator
          C. Creating and compiling program units using the Program Unit Editor
          D. Invoking program units using the PL/SQL interpreter
        III. Creating procedures
            A. Uses of procedures
            B. Creating client-side and server-side procedures
            C. Creating procedures with arguments
            D. Invoking a procedure
            E. Removing a procedure
          IV. Creating functions
              A. The uses of functions
              B. Creating client-side and server-side functions
              C. Invoking a function
              D. Removing a function
              E. Differentiating between a procedure and a function
            V. Creating packages
                A. Packages and their possible components
                B. Creating a package to group together related variables, cursors, constructs, exceptions, procedures, and functions
                C. Making a package construct either public or private
                D. Invoking a package construct
                E. Writing packages that make use of the overloading feature of PL/SQL
                F. Avoiding errors with mutually referential subprograms
                G. Initializing public or private variables with an automatic one time only procedure
                H. Declaring ref cursors in a package
                I. Controlling the extent to which functions permit database operations
                J. Describing the use and application of the Oracle supplied packages
              VI. Creating database triggers
                  A. Database triggers and their use
                  B. Creating database triggers
                  C. Describing database trigger firing rules
                  D. Dropping database triggers
                VII. Managing subprograms
                    A. System privilege requirements
                    B. Tracking procedural dependencies
                    C. Predicting the effect of changing a database object upon stored procedures and functions
                    D. Describing object dependencies
                    E. Debugging client-side and server-side subprograms
                  VIII. Working with object types
                      A. Object types
                      B. Creating transient objects
                      C. Manipulating objects in object tables
                    IX. Managing large objects
                        A. LONG and LOB (large objects) datatypes
                        B. Creating and maintaining LOB datatypes
                        C. Differentiating between internal and external LOBs
                        D. Utilizing the DBMS_LOB PL/SQL packages
                    Go to Description    Go to top of Competencies    Go to top of Outline