Computer Information Systems

Database Development - CCL

Major: 
5083
Effective term: 
2009 Fall
Final term: 
9999
Award: 
CCL
Total credits required: 
27
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.

Program notes

Students must earn a grade of "C" or better in all courses within the program.

Requirements
Credits:27
CIS117DMMicrosoft Access: Database Management 3
CIS217AMAdvanced Microsoft Access: Database Management 3
CIS105Survey of Computer Information Systems 3
CIS119DOIntroduction to Oracle: SQL and PL/SQL 3
CIS150Programming Fundamentals 3
 
CIS159Visual Basic Programming I (3) OR
CIS162ADC#: Level I (3) 3
 
CIS164ABOracle: Developer PL/SQL Programming (3) OR
CIS276DAMySQL Database (3) OR
CIS276DBSQL Server Database (3) 3
 
CIS166ACWeb Scripting with Active Server Pages (ASP).NET (3) OR
CIS166AEWeb Scripting with PHP: Hypertext Preprocessor (PHP) (3) 3
 
CIS225ABObject-Oriented Analysis and Design 3
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)