Nov 22, 2024  
2023-2024 Catalog 
    
2023-2024 Catalog [PAST CATALOG]

Planner for Online Courses Database Management Systems - Database Administration (A.A.S.)


This planner contains a recommended sequence of courses to complete the degree online in five terms. Recommended courses are high-enrolled courses that can be expected to have online sections in the term in which they appear. Other courses from the same category can be substituted when they meet the program requirements. Refer to the course catalog, your academic advisor or your academic chair for more information.

Refer to AACC’s Transfer Agreements page: https://www.aacc.edu/resources/academic-services/transfer-services/transfer-agreements/.

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.

Faculty Contact (webapps.aacc.edu/directory): Krysten Hall

Courses to improve skills and prepare for college-level classes may be needed. It is best to see an advisor as you plan your education.

Course/Advising Notes: ___________________________________________

Term 1 (Fall)

Course Name Credits Term Taken Grade
ENG 101 - Academic Writing and Research 1 / ENG 101A - Academic Writing and Research 1   3 credit hours    
Required General Education Mathematics
MAT 137 - College Algebra  
3 credit hours     
Technology Requirement
CTP 103 - Theories and Applications of Digital Technology  
3 credit hours     
Required General Education Arts and Humanities
CTP 194 - Ethics and the Information Age  OR
COM 111 - Fundamentals of Oral Communication  OR
COM 116 - Fundamentals of Oral Communication for Non-Native Speakers  
3 credit hours     
ACA 110 - Achieving Success in the Online Classroom  
Recommended course. Substitute any elective course.
1 credit hour     

Term 2 (Spring)

Course Name Credits Term Taken Grade
ENG 102 - Academic Writing and Research 2   3 credit hours     
CTA 115 - Personal Computer Database Management Systems   4 credit hours     
CTS 107 - Cyber Essentials   3 credit hours     
CTP 145 - Relational Databases and SQL   4 credit hours     

Term 3 (Summer)

Course Name Credits Term Taken Grade
General Education Social and Behavioral Science/Diversity Requirement
SOC 111 - Introduction to Sociology  OR  GSS 101 - Introduction to Women’s Studies  
These are recommended courses for the online sequence. Students may substitute any course from the same general education category. Consult your academic advisor or refer to the college catalog.
The diversity requirement can be met here, or with another course.
3 credit hours    
Required General Education Biological and Physical Science/Wellness Requirement
BIO 135 - Principles of Nutrition  
3 credit hours     

Term 4 (Fall)

Course Name Credits Term Taken Grade
Elective
Contact department chair for recommendations.
3 credit hours    
CTP 147 - PL-SQL Programming   3 credit hours     
CTS 120 - Introduction to Linux   4 credit hours     
CTS 110 - Network Essentials   4 credit hours     

Term 5 (Spring)

Course Name Credits Term Taken Grade
CTP 200 - Systems Analysis and Design   4 credit hours     
CTP 245 - Database Administration 1   3 credit hours     
CTP 247 - Database Administration 2   3 credit hours     
Elective
Contact department chair for recommendations.
3 credit hours