Nov 22, 2024  
2019-2020 Catalog 
    
2019-2020 Catalog [PAST CATALOG]

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


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 - see www.aacc.edu

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 (https://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


Course Name Credit Hours Term Taken Grade
ENG 101 - Academic Writing and Research 1   OR
ENG 101A - Academic Writing and Research 1  
3 credit hours    
MAT 137 - College Algebra  
3 credit hours     
CTP 103 - Theories and Applications of Digital Technology  
Students with technical expertise beyond the level of this course should meet with the Computer Science Department Chair.
3 credit hours     
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    
Biological & Physical Sciences GER
BIO 135 - Principles of Nutrition  (BIO 135 also meets Wellness Requirement)
3 credit hours     

 

Term 2


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


Course Name Credits Term Taken Grade
CTP 245 - Database Administration 1  
3 credit hours     
CTP 147 - PL-SQL Programming  
3 credit hours     
CTS 120 - Introduction to UNIX/LINUX  
4 credit hours     
CTP 247 - Database Administration 2  
3 credit hours     
CTS 110 - Network Essentials  
4 credit hours     

 

Term 4


Course Name Credits Term Taken Grade
CTP 200 - Systems Analysis and Design  
4 credit hours     
Social & Behavioral Sciences GER  
3 credit hours    
Electives 7 credit hours    

 

About the Planner Symbols