2020-2021 Pierce College Catalog [ARCHIVED CATALOG]
Database Management and Design (AAS) Course Map
|
|
Return to: Science, Technology, Engineering and Math (STEM) Career Pathway
Created by Pierce faculty, this map outlines the initial coursework for this career field. It provides you a clear path to complete your degree by listing a specific set of courses relevant to your program and career. The map is designed with the appropriate number of credits and meets degree requirements. Courses are organized in a recommended sequence; please schedule accordingly. If a course is unavailable, work with the CIS/CNE Navigator to select the appropriate replacement. For each course, a purpose statement explains how the content relates to your career field. On this map, there may be instances when you will be required to select a course from several options. Use these purpose statements and notes to choose the course that best aligns with your interests and needs. You will also find action items to complete to assure you progress and graduate on time. While this map is a great guide to courses required to complete the Associate in Applied Science Database Management and Design, you are responsible for fulfilling all degree requirements. Questions? Your Success Network is ready to help you!
|
1. College Success
- COLLG 110 College Success (3 credits)
Course purpose: A foundational course to explore and affirm a career choice and build upon the skills, knowledge, and resources that will support you at Pierce College and beyond. Note: The College Success course you select will depend on the Career Pathway Map you are following. Your advisor will assist you in selecting either the 3- or 5- credit version of the course. Should you choose to repeat a College Success course you must enroll in a College Success course with the same credit amount as the original course; a COLLG 110 course grade can only be replaced with a grade from another COLLG 110 course and a COLLG 115 course grade can only be replaced with a grade from another COLLG 115 course.
2. Computer Information/Keyboarding Skills Course Recommendation
Action Item: Meet with CIS/CNE Navigator/Advisor
Use your Success Network! In your first quarter, meet with your advisor to revisit your career and transfer path, make adjustments to your goals as needed, and plan for your next steps.
3. Spreadsheet Applications
5. Introduction to Computer Programming
6. Systems Analysis and Design
7. Database Management Systems
8. Human Relations/Psychology/Sociology Course Recommendation
Choose one
9. Client-Side Web Development
10. Structured Query Language
11. Introduction to Object Oriented Programming (OOP)
12. English Composition I
- ENGL& 101 English Composition I (5 credits)
Course purpose: In this field you need to be able to create technical documentation. Note: Your advisor will assist you in reviewing your Guided Self Placement and selecting either the 5-credit or the 7-credit co-requisite ENGL& 101 + ENGLC 101 course.
14. Introduction to Statistics
15. Advanced SQL Programming and Tuning
- CIS 269 Advanced SQL Programming and Tuning (5 credits)
Course purpose: You will continue to advance you Structured Query Language (SQL) skills by covering advanced topics to develop script files, stored procedures, and procedural language units, as well as diagnose and tune performance problems.
16. Server-Side Web Development
17. Database Administration Backup and Recovery
Action Item: Complete Certification Exam(s)
Please complete certification exam(s) (ex. MTA Database Fundamentals, MTA Software Fundamentals, IIBA ECBA), and begin job readiness preparation for internship and post-graduation job search.
18. Intermediate Object Oriented Programming (OOP)
19. CCNA 1: Introduction to Networks
20. Business Analytics/Intelligence
- CIS 275 Business Analytics/Intelligence (5 credits)
Course purpose: In this course you will learn how to develop business intelligence (BI) solutions, including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation. BI tools are used for reporting (SSRS), integration (SSIS), and analysis (SSAS).
21. Installing and Configuring Windows Server
- CNE 232 Installing and Configuring Windows Server (5 credits)
Course purpose: In order for databases and programs to work correctly you must be able to build your own development environment. In this course you will learn how to install and configure Windows Server with Active Directory, Network Services, Local Storage, File and Print Services, Group Policy and virtualization.
22. CIS Project Capstone
- CIS 264 CIS Project Capstone (5 credits)
Course purpose: In this course you will demonstrate your proficiency of prior core course outcomes by analyzing, designing, developing, implementing and evaluating a real-life data driven application project using one or more software development life cycles.
23. Supervised Internship
Total Credits 106-116
Note: Due to the rapid changes in the IT industry, the Special Topics courses CIS 155 and CNE 155 may be substituted as needed into the CIS or CNE degree programs, on the advice of the CIS/CNE Faculty and program coordinator.
|
Return to: Science, Technology, Engineering and Math (STEM) Career Pathway
|
|
|