'CISD' -- CIS Database Courses
 
   
 

 
CISD 31 Course Image

CISD 31 - Database Management
               - Oracle  (4 units)
This course covers Oracle databse functions, concepts, and terms.  PL/SQL is used to code, test, and implement stored procedures, functions, triggers, and packages.   Relational database projects will be built using PL/SQL.

The student receives extensive hands-on instruction on a Windows-based personal computer.
 
(54 hours lecture;  54 hours lab;  Degree appropriate)
Advisory Prerequisite:   CISB 11 - Computer Information Systems

Course Measurable Objectives:

  1. Analyze business problems using relational databases.
  2. Describe Oracle database functions and commands.
  3. Write, test, and implement complex queries and subqueries to retrieve data from multiple tables.
  4. Design PL/SQL program to access database data using cursors with exception handling.
  5. Develop (write, test, and implement) stored procedures, functions, triggers, and packages using PL/SQL.

Course Level Student Learning Outcomes:


Students completing CISD 31 - Database Management - Oracle will be able to:
  1. create queries to retrieve data from multiple tables using Oracle functions, views, and scripts.
  2. use decision making statements, loops, and cursors in order to create a business application.
Send questions or comments about this Web site to the  Business Division's  Web Content Manager .
Use of this Web server is subject to the Mt. San Antonio College   Terms of Use  and  Privacy Policy .
 
   
Invisible Login Button