Material Detail

The Health IT Workforce Curriculum was developed for U.S. community colleges to enhance workforce training programmes in health information technology. The curriculum consist of 20 courses of 3 credits each. Each course includes instructor manuals, learning objectives, syllabi, video lectures with accompanying transcripts and slides, exercises, and assessments. The materials were authored by Columbia University, Duke University, Johns Hopkins University, Oregon Health & Science University, and University of Alabama at Birmingham. The project was funded by the U.S. Office of the National Coordinator for Health Information Technology. All of the course materials are available under a Creative Commons Attribution-Non Commercial-ShareAlike License. Course description, learning objectives, author information, and other details may be found in the instructor manual.  Component 4 - Introduction to Information and Computer Science Component Overview: For students without an IT background, this Component provides a basic overview of computer architecture; data organization, representation and structure; structure of programming languages; networking and data communication. It also includes basic terminology of computing. Unit Title  Databases and SQL Unit Overview:  This unit discusses the purposes of databases, a relational database, and the querying language SQL. Students will design a simple database using data modeling and normalization. This unit will define basic data operations, provide instruction on how to create common query statements, and discuss SQL implementation.  Unit Objectives:  By the end of this unit the student will be able to: 1. Define and describe the purpose of databases (Lecture a) 2. Define a relational database (Lecture a) 3. Describe data modeling and normalization (Lecture b) 4. Describe the structured query language (SQL) (Lecture c) 5. Define the basic data operations for relational databases and how to implement them in SQL (Lecture c) 6. Design a simple relational database and create corresponding SQL commands (Lecture c) 7. Examine the structure of a healthcare database component (Lecture d)

This will delete the comment from the database. This operation is not reversible. Are you sure you want to do it?

Thank you for reporting a broken "Go to Material" link in MERLOT to help us maintain a collection of valuable learning materials.

If you feel this material is inappropriate for the MERLOT Collection, please click SEND REPORT, and the MERLOT Team will investigate. Thank you!

You are being taken to the material on another site. This will open a new window.

Do not show me this again