Skip to main content
Scottsdale Community College - Learn. Grow. Achieve
Fetching Content....

CCL - Database Development

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.
Major Code: 5083
Award: CCL
First Term: 4096
Total Credits: 27
Program Last Updated in MCCCD Records: Jan 19th, 2010
Prerequesites: None
Required Courses: 27 credits
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
Restricted Electives: None
Free Electives: None
General Education Requirement: None
General Education Core: None
First Year Composition: None
Oral Communication: None
Critical Reading: None
Mathematics: None
General Education Distributed Credits: None
Humanities and Fine Arts: None
Social and Behavioral Sciences: None
Natural Sciences: None
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)