2021-2022 Pierce College Catalog 
    
    Sep 18, 2021  
2021-2022 Pierce College Catalog

Database Management and Design (AAS) Course Map


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


  • 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


  • Course purpose: Business data resides in spreadsheet silos around a company.  In order to import or export data for your stakeholders, you will learn basic through advanced spreadsheet design and development.

4. Business Analysis


  • Course purpose: You will learn tools to analyze the business environment and define stakeholder needs in order to make recommendations for Information Technology solutions that enable the organization to achieve its goals.

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


  • 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. 

13. Public Speaking


14. Introduction to Statistics


15. Advanced SQL Programming and Tuning


  • 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.

Action Item: Apply for Graduation


Way to go!  It is time to apply for graduation.  Visit the Pierce College Graduation website for details.  https://www.pierce.ctc.edu/graduation

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


  • 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


  • 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


  • 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


  • Course purpose: You will gain relevant experience working in a local business environment. This requires 250 hours of supervised work including associated resume preparation, job interviews and internship documentation.

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.

Program Code: 503