MCCCD Program Description

Major: 5183N Catalog Year: 2024-2025 Effective Term: 2020 Fall Last Admit Term: 2021 Summer Award: CCL Total Credits: 12 CIP Code: 11.0802	Primary College: Chandler-Gilbert Community College Initiating College: Mesa Community College Program Availability: Not Found Program Availability: College-Specific Program Availability: College-Specific: CG Field of Interest: Computer and Information Technology Instructional Council: Computer Information Systems (12) GPA: 2.00
SOC Code: Upon completion of this certificate and requisite industry experience, students may pursue a career as: 15-1242.00 Database Administrators

Description: The Certificate of Completion (CCL) in Oracle Database Operations program provides training for students seeking professional positions in designing, creating, and maintaining databases. This program allows students to create PL/SQL application code that can be shared by multiple forms, reports, and data management tools. As an Oracle Academic Initiative institution, this program is designed to prepare students for industry-recognized certifications. Courses in the program also help prepare students wanting to pursue Oracle Application Developer Certified Associate and Oracle Database Administrator Certified Associate industry-certified examinations (Oracle Corporation OCA certifications). This certificate can embed into the Associate of Applied Science (AAS) degree in Information Technology.

Learning Outcomes
1. Create and manage database objects using SQL. (CIS105, CIS119DO, CIS119DP, CIS164AB) 2. Perform administrative duties within an Oracle database. (CIS119DP) 3. Create and manage stored PL/SQL procedures, functions, packages, and triggers in an Oracle development environment. (CIS164AB) 4. Design a comprehensive data model using an entity-relationship (ER) diagram that reflects the business requirements. (CIS154)

Program Notes
This program is not eligible for Title IV Federal Financial Aid. Students must earn a grade of C or better in all courses within the program. This Certificate of Completion (CCL) is intended for industry professionals with the requisite experience of foundational knowledge in word processing, spreadsheets, databases, presentation software, operating systems, and networking. Consult with a program advisor or director to determine if this CCL aligns with intended academic/career goals. The Computer Information System (CIS) courses required by this program are not applicable if taken more than eight (8) years prior to the completion of the program of study. Consult with an Academic Advisor for complete information.

Required Courses

+ CIS119DO Introduction to Oracle: SQL 3
+ CIS119DP Oracle: Database Administration 3
+ CIS154 Database Modeling and Design 3
+ CIS164AB Oracle: PL/SQL Programming 3

Credits: 12

Restricted Electives
	Credits:

General Electives
	Credits:

+ indicates course has prerequisites and/or corequisites.
++ indicates that any suffixed course may be selected.

MCCCD Governing Board Approval Date: February 25, 2020

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.