Program Overview

This Associate Degree or Certificate of Achievement is a two-year program leading to the Associate in Science (A.S.) degree. The Database Management Systems concentration includes coursework in the design, development and maintenance of relational databases. The program is designed to prepare students for employment in a computer field following graduation. Students wishing a Bachelors’ degree (transfer program) should meet with a counselor or advisor to discuss transferability of courses.

REQUIRED CORE COURSEWORK:

Course Course Name Units
BCOM 15

Business Communications

Formerly CAOTO 15. This course covers the principles of collecting, organizing, analyzing, and presenting business information. Written and oral communication involving problem solving in business is emphasized.

3
COSA 25

Microsoft Access for Windows

Recommended Preparation: COSA 1

Formerly CAOTC 47A and COSA 25AD. Relational databases concepts using Microsoft Access including design fundamentals, creation of tables, queries, forms, and reports are covered. This course satisfies the technology component of the Information Competency graduation requirement. Upon successful completion of this course, students will be provided with a voucher to take the Microsoft Office Specialist (MOS) industry certification exam.

3
COSP 238

Database Cloud Technologies

Recommended Preparation: COSP 38

This class will introduce the topics of data centers, DBMS virtualization, cloud data storage and programming models. This class reviews the motivating factors, benefits, challenges, and service models of cloud databases. Topics include, concepts behind cloud data center design and management, use of virtualization as a key cloud technique for offering software, computation and storage services, presentation of real use cases such as Amazon EC2, and cloud storage concepts including data distribution, durability, consistency, and redundancy.

3
COSP 36

Systems Analysis and Design

Recommended Preparation:  COSA 50 and COSP 38

Formerly CBIS 36. This course  covers the broad concepts and methods of system analysis and design, while emphasizing the latest object-oriented techniques. Topics include development processing models, conceptual and physical design, system implementation and maintenance techniques, project management, collaborative communication skills, and the responsibilities of systems analysts. Students should have completed the COSA 50 and COSP 38 courses or equivalent as preparation for this course.

4
COSP 38

Database Concepts

Recommended Preparation:  COSA 50

Formerly CBIS 38. This course covers concepts and technologies of database systems. Topics include data modeling, design, and the implementation of relational databases; Structured Query Language-SQL; concurrency control; distributed database systems; data warehousing; Web-enabled database technologies; and the functions of database administration. Upon successful completion of this course, students will be given a voucher to sit for the Microsoft Technology Associate (MTA) industry certification exam.

4
COSP 7

Programming Concepts and Methodologies

Recommended Preparation:  COSA 50

Formerly CBIS 7. This course is an introduction to programming concepts and methodologies including syntax, structured design, debugging, variables identifiers, flowchart and simple UML design, programming error detection, extracting and manipulating data from arrays, array sorting with passing parameter and augmenting test data.

4
COSW 30

Web Development with PHP/MySQL

Recommended Preparation: COSW 10 and COSP 38

This course covers PHP & MySQL, one of the most popular technology combinations for developing interactive Web sites. It is designed to provide students with a real-world experience in developing database driven website programming concepts for personal and small business needs  Students write PHP code to interact with data stored in a database including record creation, update, deletion, and retrieval. Emphasis will be placed on creating web forms, searching databases, and session management. It is recommended that students enter this course with beginning knowledge of Web development concepts including HTML and CSS.

4

IN ADDITION, select TWO (2) courses from the following:
COSA 210

Introduction to Project Management for IT

Recommended Preparation: COSA 50

Formerly CBIS 436A. This class is an introduction to Project Management. Popular project management software will be introduced. In addition, the class will focus on the methods and techniques for managing projects as well as preparing students for the CompTIA's IT Project+ certification.

3
COSN 205

UNIX/LINUX Fundamentals

Recommended Preparation: COSA 50


Formerly CBIS 235A and COSN 210AD. This course is an in-depth study of the Linux operating system. The focus is on Linux installation and administration.  The course will also examine the theoretical concepts common to all Linux systems that have increased its popularity.  The course will also take the form of a practical hands-on approach to Linux to prepare students for the CompTIA Linux+ or LPI certifications. Students should have already completed a foundation course in Linux.

4
COSN 225

Microsoft Windows Client

Recommended Preparation: COSN 10

Formerly CBIS 226. In this class, students will install, configure and administer Windows OS. They will install and upgrade client systems, manage file systems and devices and perform system maintenance.  The class will prepare the student to take the corresponding MTA Certification Exam.

3
COSN 230

Microsoft Windows Server

Recommended Preparation:  COSN 225

Formerly CBIS 227. In this class, students will install, configure and administer Windows Server Operating System. The class will prepare the student to take the corresponding MTA Certification Exam.

4
COSW 221

Database Programming with PHP/MySQL II

This is the second course in PHP programming with a MySQL database for developing data driven web sites. Students can expect to write PHP code to create real world database applications that allow for database record creation, update, deletion and retrieval. Emphasis will be placed on creating web forms, searching databases, and session management.

3
Total units needed to complete - 32-33