Initiating College: Chandler-Gilbert Community College
Program Availability: Not Found
Program Availability: College-Specific
Program Availability:
Field of Interest: Not Found
Instructional Council: Computer Information Systems (12)
GPA: 2.00
SOC Code:
Description: Description: Chandler-Gilbert Community College, an Oracle Academic Initiative institution, prepares students for industry-recognized certifications. The Certificate of Completion in Oracle Database Operations provides training for professionals who design, create, and maintain databases and create application code that can be shared by multiple forms, reports, and data management tools. Courses in the program also help prepare students for the Oracle Application Developer Certified Associate and Oracle Database Administrator Certified Associate industry-certified examinations (Oracle Corporation OCA certifications).
Job Description: The Oracle Certified Associate will be required to perform various job tasks such as enterprise database planning and design; creating and maintaining the database and its objects; and storing, retrieving, and manipulating data utilizing SQL. In addition, they will be responsible for resolving technical issues and providing application and user support. They are also responsible for creating PL/SQL application code that can be shared by multiple forms, reports, and data management applications.
Program Notes: Students must earn a grade of "C" or better in all courses within the program.
+ indicates course has prerequisites and/or corequisites.
Overall program minimum G.P.A. = 2.00
Admission Criteria:
Program Prerequisites: None
Program Prerequisites
In lieu of the course listed below, students with experience in the information technology field may meet this program prerequisite requirement with the permission of the division.
CIS105 Survey of Computer Information Systems (3) OR
Permission of the Division 3
Credits: 3
Required Courses
+ CIS119DO Introduction to Oracle: SQL and PL/SQL 3
+ CIS119DP Oracle: Database Administration 3
+ CIS164AB Oracle: PL/SQL Programming 3
+ CIS164AG Oracle: Data Modeling and Relational Database Design 2
Credits: 11
Restricted Electives
Credits:
General Electives
Credits:
Program Competencies
1. Retrieve, display, and manipulate data from tables and other database objects using SQL. (CIS119DO)
2. Create and manage database users, privileges, and resources in an Oracle database. (CIS119DP)
3. Configure, administer, monitor, and maintain an Oracle database. (CIS119DP)
4. Create and manage stored PL/SQL procedures, functions, packages, and triggers in an Oracle development environment. (CIS164AB)
5. Develop comprehensive data model to represent business information requirements. (CIS164AG)
6. Create appropriate relational database design from data model. (CIS164AG)
+ indicates course has prerequisites and/or corequisites.
++ indicates that any suffixed course may be selected.
MCCCD Governing Board Approval Date: 6-17-03
All information published is subject to change without notice. Every effort has been made to ensure the accuracy of information presented, but based on the dynamic nature of the
curricular process, course and program information is subject to change in order to reflect the most current information available.