Nov 08, 2024

2024-2025 Catalog

HELP

2024-2025 Catalog

Database Management Systems - Database Administration (A.A.S.)

Print Degree Planner (opens a new window) |

Official Title of Major: Database Management Systems - Database Administration, A.A.S.

Award: Associate of Applied Science degree, A.A.S.

Total Credit Hours: 60

Code: AAS.CPS.DATABASE-ADM

About the Computer Science Department

Purpose: Prepares students for careers requiring a strong background in computer technology and information systems. Covers fundamental concepts in database administration, computer technology, networking, and security. The students are eligible to sit for the following certifications: MOS Access 2013, Oracle PL/SQL Developer Certified Associate (comprised of the Oracle Database SQL Fundamentals exam and the Oracle Database Program with PL/SQL exam) and Oracle Database Administrator Certified Associate Certification (comprised of the Oracle Database SQL Fundamentals exam and the Oracle Administration exam).

Emphasizes the development of expertise in SQL syntax and usage, the development of both large and small scale databases, the roles and responsibilities of a database administrator, and the experiences in designing, implementing, monitoring, and maintaining a production level, industrial grade database. Note: Students have the option of learning either Windows or LINUX/UNIX operating systems.

Range of Occupations

Database administrator (DBA)
Database analyst
Database manager
Database architect
Database engineer

Related Major

Students may wish to also review requirements for the similar major linked below.

Database Management Systems - Database Development (A.A.S.)

Graduation Requirements

Refer to Academic Regulations on Graduation Requirements for college-wide graduation requirements.

Planning Tool: Two-Year Sequence of Courses

Open/Print this Planning Tool

Open/Print Online Courses Tool

General Education Requirements: 21 credits

An approved list of general education courses can be found in the General Education and Diversity, Technology and Wellness Requirements section of the catalog. Choose general education courses from the following topics:

English Composition: 6 credits

ENG 101 - Academic Writing and Research 1 3 credit hours
ENG 102 - Academic Writing and Research 2 3 credit hours
ENG 101A and ENG 101 are equivalent courses. Students may take ENG 101A -ENG 102 or ENG 101 -ENG 102 to meet their English Composition General Education requirement.

Arts and Humanities: 3 credits

CTP 194 - Ethics and the Information Age 3 credit hours
OR
COM 111 - Fundamentals of Oral Communication 3 credit hours
OR
COM 116 - Fundamentals of Oral Communication for Non-Native Speakers 3 credit hours

Biological and Physical Sciences: 3 credits

BIO 135 - Principles of Nutrition 3 credit hours

Mathematics: 3 credits

MAT 137 - College Algebra 3 credit hours
Or more advanced level if qualified.

Social and Behavioral Sciences: 3 credits

See General Education Social and Behavioral Sciences Requirements for a list of approved courses.

Additional General Education Requirements: 3 credits

CTP 103 - Theories and Applications of Digital Technology 3 credit hours
This course meets the General Education Technology Requirement.

Program Requirements: 18 credits

These are the common program requirements for both areas of concentration. Students must complete all of these courses with a grade of C or better.

CTS 107 - Cyber Essentials 3 credit hours
CTA 115 - Personal Computer Database Management Systems 4 credit hours
CTP 145 - Relational Databases and SQL 4 credit hours
CTP 147 - PL-SQL Programming 3 credit hours
CTP 200 - Systems Analysis and Design 4 credit hours

Area of Concentration Requirements: 21 credits

CTP 245 - Database Administration 1 3 credit hours
CTP 247 - Database Administration 2 3 credit hours
CTS 110 - Network Essentials 4 credit hours
CTS 120 - Introduction to Linux 4 credit hours
Electives 7 credit hours

Diversity Requirement

All students in associate degree programs must satisfy the Diversity Requirement . In many cases, students may satisfy this requirement simultaneously as they satisfy a general education course requirement or with an elective.

Technology Requirement

Satisfied by CTP 103 .

Wellness Requirement

Satisfied by BIO 135 .

Fast Track Option

This program has a Fast Track Option for those holding a college degree.

Program Outcomes

Upon successful completion of the Database Administration Area of Concentration, students will be able to:

Review database concepts and data models.
Apply normalization of databases.
Design and implement a production level, industrial grade database using structured query language.
Discuss distributed database management systems.
Explain the use of database warehousing.
Examine database administration and security.

This program aligns with all the college’s core competencies.

Approximate Cost

Related Offerings

Students may wish to also review requirements for the related majors or programs linked below.

Career and Educational Advancement Resources

Career, Workforce Certifications, Education, and Transfer Resources