Relational Database Design
About this course
This course provides you with the opportunity to learn about relational database design. You will be provided an in-depth understanding of the design principles and methodologies involved in creating well-structured, normalized, and efficient relational databases to manage data for small, medium, and large-scale enterprises. Possessing database design skills will enable you to excel in careers such as Database Administrators, Data Analysts, Software Developers, Data Engineers, and Business Intelligence Developers; capitalizing on the ability to create robust and efficient data solutions for any organization. These are one of the top sought-after careers across many industries today. At the end of this course, you will be able to: - Describe the process and the design aspects involved in relational database design. - Interpret the main components of an Entity-Relationship diagram (ERD) using unified modeling language (UML) notation. - Develop entity-relationship diagrams using basic and extended Entity-relationship features in relational design. - Translate Entity-Relationships diagrams into logical schemas (relation schemas). - Describe the theory and practical application of functional dependencies in relational database design. - Use the theory to recognize candidate keys and primary keys. - Derive minimal and canonical covers of functional dependencies. - Describe the principles of database normalization. - Identify and apply normalization techniques.
68/100
CourseAsk score
- What the provider tells you
- 32/45
- Who stands behind it
- 20/35
- How complete the listing is
- 16/20
Scores how much the provider publishes and who stands behind it — not how well it is taught.
What you'll learn
- Describe the process and design aspects of relational database design
- Interpret Entity-Relationship diagrams using UML notation
- Develop ER diagrams with basic and extended features
- Translate ER diagrams into logical schemas
- Recognize candidate keys and primary keys
- Apply normalization techniques
Price shown by Coursera — confirm on their site.
Enroll on CourseraYou'll be redirected to Coursera to complete enrollment.
- Listed & compared by CourseAsk
- English · 0
Coursera
Udemy
Compared on these lists
Where this course ranks against the alternatives.