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

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

3
COSA 25

Microsoft Access for Windows

This class provides an introduction to Microsoft Access, a computerized relational database management system. Through hands-on practice, students learn to create and modify tables, queries, reports, forms, data access pages, macros, and modules. Students will also learn to share information by integrating Access with data and other applications. This course satisfies the technology component of the Information Competency graduation requirement. Upon successful completion of this course, students will be given a voucher to sit for the Microsoft Office Specialist (MOS) industry certification exam. This course satisfies the technology portion of the information competency requirement.

3
COSP 238

Database Cloud Technologies

In this course, students will learn about the major areas of database administration: installation and maintenance of MS SQL Server; T-SQL programming; database performance, logging, backup, recovery, security and replication; and the role of a database administrator. Upon successful completion of this course, students will be given a voucher to sit for the Microsoft Technology Associate (MTA) industry certification exam.

3
COSP 36

Systems Analysis and Design

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

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

This course is an introduction to programming including syntax, structured design, debugging, variables, flowchart and simple UML design, validity checking, extracting and manipulating data from arrays, and sorting. This class prepares the student for additional programming classes. Students should have completed a 3 unit computer concepts and applications course such as COSA 50 as preparation for this course.

4
COSW 30

Web Development with PHP/MySQL

This course covers PHP & MySQL, one of the most popular technology combinations for developing interactive Web sites. It is designed to provides 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

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

This course trains students to use the Linux operating system as an alternative to other operating systems for managing files, running applications, and developing application procedures. Course topics include an overview of basic operating system concepts, a history of UNIX and its influence on modern operating systems, basic internal operating system structure, details of UNIX/Linus file system structures, pipes, filters and redirection, scripts, processes, shells, and UNIX/Linux utilities. Students should have completed a 3-unit computer concepts and applications course such as COSA 50 as preparation for this course. Completion of this course qualifies students for COSN 210, Linux System Administration.

4
COSN 225

Microsoft Windows Client

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. Upon successful completion of this course, students will be given a voucher to sit for the Microsoft Technology Associate (MTA) industry certification exam.

3
COSN 230

Microsoft Windows Server

In this class, students will install, configure and administer Windows Server Operating System. Upon successful completion of this course, students will be given a voucher to sit for the Microsoft Technology Associate (MTA) industry certification exam.

3
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