MCCCD Program Description

Major: 5083 Catalog Year: 2023-2024 Effective Term: 2019 Spring Last Admit Term: 2020 Summer Award: CCL Total Credits: 27 CIP Code: 11.0802	Primary College: Initiating College: Scottsdale Community College Program Availability: Not Found Program Availability: College-Specific Program Availability: Field of Interest: Computer and Information Technology Instructional Council: Computer Information Systems (12) GPA: 2.0
SOC Code: 15-1141

Description: The Certificate of Completion (CCL) in Database Development prepares students to design and implement the infrastructure for business solutions using database and programming tools. The Certificate focuses on administrative tasks and building database applications using programming skills such as data collection, query techniques and database creation.

Required Courses

CIS117DM Microsoft Access: Database Management 3
+ CIS217AM Advanced Microsoft Access: Database Management 3
CIS105 Survey of Computer Information Systems 3
+ CIS119DO Introduction to Oracle: SQL and PL/SQL 3
+ CIS150 Programming Fundamentals 3

+ CIS159 Visual Basic Programming I (3) OR
+ CIS162AD C#: Level I (3) 3

+ CIS164AB Oracle: Developer PL/SQL Programming (3) OR
+ CIS276DA MySQL Database (3) OR
+ CIS276DB SQL Server Database (3) 3

+ CIS166AC Web Scripting with Active Server Pages (ASP).NET (3) OR
+ CIS166AE Web Scripting with PHP: Hypertext Preprocessor (PHP) (3) 3

+ CIS225AB Object-Oriented Analysis and Design 3

Credits: 27

Restricted Electives
	Credits:

General Electives
	Credits:

Program Competencies
1. Use the basic elements and components of the Microsoft Access program and analyze common database management problems related to the program. (CIS117DM) 2. Use advanced elements and components of the Microsoft Access program to create and analyze unique database management problems. (CIS217AM) 3. Demonstrate a working knowledge of computer information systems, fundamental computer concepts, and programming techniques. (CIS105) 4. Design and develop database structures to store, retrieve, and update using Oracle SQL and PL/SQL. (CIS119DO) 5. Develop programs using structured design and logic tools. (CIS150) 6. Use Visual Basic programming language to solve a variety of problems related to business and other disciplines. (CIS159 OR CIS162AD) 7. Write SQL procedures and functions to automate a variety of problems related to business and other disciplines. (CIS164AB OR CIS276DA OR CIS276DB) 8. Design software that integrates web sites and databases including client and server-side scripting. (CIS166AC OR CIS166AE) 9. Investigate, analyze, design, implement, and evaluate business computer systems using appropriate object-oriented analysis and design methods. (CIS225AB)
+ indicates course has prerequisites and/or corequisites. ++ indicates that any suffixed course may be selected. MCCCD Governing Board Approval Date: 6-23-09

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.