1 - Getting Started with Relational Database Design
Identify Database ComponentsIdentify Common Database Design ProblemsFollow a Database Design ProcessGather Requirements
2 - Defining the Database Conceptual Model
Create the Conceptual ModelIdentify Entity Relationships
3 - Defining the Database Logical Model
Identify ColumnsIdentify Primary KeysIdentify and Diagram Relationships
4 - Normalizing Data
Avoid Common Database Design ErrorsComply with Higher Normal Forms
5 - Finalizing the Database Design
Adapt the Physical Model for Different SystemsEnsure Referential IntegrityEnsure Data Integrity at the Column LevelEnsure Data Integrity at the Table LevelDesign for the Cloud
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
This course is designed for students who need to learn database design essentials, typically in preparation for, or as a supplement to, a course on SQL such as SQL Querying: Fundamentals and courses on specific relational database platforms.
To ensure your success in this course you should have fundamental computer skills.