Maricopa Community Colleges  CIS117DO   19986-20005 
Official Course Description:   MCCCD Approval:  06/23/98  
CIS117DO     19986-20005 L+L 3 Credit(s) 4 Period(s)
Introduction to Oracle: SQL and PL/SQL Using Procedure Builder
Use of Oracle tools and methodologies to fulfill real-world business information requirements. Hands-on exercises for designing and creating database structures to store, retrieve, update, and display data in a relational database. Creating PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Using Oracle Procedure Builder to develop and debug PL/SQL programs. Prerequisites: CIS105 and (CIS123AA or previous Windows 95NT operating system experience), or permission of instructor.
 
 Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS117DO   19986-20005 Introduction to Oracle: SQL and PL/SQL Using Procedure Builder
1. Define an Oracle relational database. (I)
2. Employ a structured approach to system development. (I)
3. Design, develop, and implement Oracle Server applications using SQL, SQL* Plus, and PL/SQL. (I, II, III)
4. Modularize programming with procedures and functions. (I, II, III)
5. Manipulate, compute, and display data from tables and data structures using SQL. (II)
6. Develop applications using Procedural Capabilities (PL/SQL). (III)
7. Use the Procedure Builder tool to develop and debug PL/SQL code. (III)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS117DO   19986-20005 Introduction to Oracle: SQL and PL/SQL Using Procedure Builder
    I. Oracle relational database development
        A. Designing and developing an Oracle relational database
        B. System and data modeling
        C. Retrieving and displaying information
        D. Manipulating information
        E. Creating tables and data structures
        F. Controlling user access
      II. SQL and SQL*Plus
          A. Performing computations with data
          B. Displaying data from multiple tables
          C. Nest queries
        III. PL/SQL
            A. Developing applications using Procedural Capabilities (PL/SQL)
            B. Developing and debugging PL/SQL code
            C. Code decisions and repetitive actions
            D. Handling PL/SQL errors
            E. Modularizing programming with procedures and functions
        Go to Description    Go to top of Competencies    Go to top of Outline