Maricopa Community Colleges  CIS117DO   20006-20015 
Official Course Description:   MCCCD Approval:  04/25/00
CIS117DO     20006-20015 L+L 3 Credit(s) 4 Period(s)
Introduction to Oracle: SQL and PL/SQL
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. Prerequisites: CIS105 or permission of instructor.
 
 Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS117DO   20006-20015 Introduction to Oracle: SQL and PL/SQL
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)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS117DO   20006-20015 Introduction to Oracle: SQL and PL/SQL
    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 and debugging PL/SQL code
            B. Code decisions and repetitive actions
            C. Handling PL/SQL errors
            D. Modularizing programming with procedures and Functions
        Go to Description    Go to top of Competencies    Go to top of Outline