Database Design and SQL

Catalog description

This course covers fundamental database design topics in a health care context, including data modeling, entity-relationship diagrams, the top-down database design methodology, the bottom-up database design methodology, functional dependencies, and the normalization process. You will learn about Structured Query Language (SQL), which is used to retrieve and modify health care-related data in relational databases. This course emphasizes designing queries for optimum performance and using query execution plans as a tool for creating appropriate indexes to improve query performance.