2021-2022 Pierce College Catalog 
    
    Mar 28, 2024  
2021-2022 Pierce College Catalog [ARCHIVED CATALOG]

Healthcare Database Management and Design Certificate Course Map


Return to {$returnto_text} Return to: Course Maps and Programs A-Z

Created by Pierce faculty, this map outlines the initial coursework for this career field. It provides you a clear path to complete your certificate 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 certificate 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 Healthcare Database Management and Design Certificate, you are responsible for fulfilling all certificate requirements. Questions? Your Success Network is ready to help you!

Required Prerequisites


Take as advised.

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. Business Analysis


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

3. Systems Analysis and Design


  • Course purpose: You will learn systematic approaches to defining needs, creating specifications and designing information systems. Course discussion and hands-on case studies providing practical knowledge and experience. Waterfall and agile systems analysis and design techniques will be used to develop and document effective computer-based information systems projects. You will also learn project management standards and create project plans using currently available project management application software.

Action Item: Meet with 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.  

4. Database Management Systems


  • Course purpose: You will learn concepts, theory, analysis and design of relational database management systems (RDBMS). This project-based class explores Entity Relationship modeling and database design fundamentals. Practical application includes case study analysis within the health-care industry and comparison to other industries as applicable.

5. Medical Terminology I


  • Course purpose: Professionals working in the health information technology field need to be literate in the vocabulary of the medical field. This is the first of a two course sequence.

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

6. Structured Query Language


7. Advanced SQL Programming and Tuning


8. Database Administration Backup and Recovery


  • Course purpose: In this course you will learn the key tasks and functions required of a database administrator in a production environment. You will gain experience creating and implementing a database, managing data, expanding the size of the database, implementing basic security and data integrity measures, and granting data access privileges to individual users.

9. Electronic Health Records


  • Course purpose: Health information technology professionals must understand the medical laws and policies governing the medical data as well as understand how the stakeholders create and use the data. This course will prepare you for the management of health information through the use of electronic health records. You will complete common work tasks and practice data entry while creating a variety of electronic medical records (EMRs) in both inpatient and outpatient settings using training software. The course will also provide background on existing and evolving government-driven standards and regulations as they apply to the health-care environment.

Total Credits without Prerequisites 43


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: 529C


Return to {$returnto_text} Return to: Course Maps and Programs A-Z