Développement
Design the Logical Model of Your Relational Database
Relational databases, which use Structured Query Language (SQL), are used in a wide variety of applications!
Building an effective and reliable database starts with good design. This is the foundation for a stable and long-lasting data collection and storage system.
Learning how to design a database is essential for back-end developers but can be useful for front-end developers too, as understanding how data is collected and stored will help you create better websites!
In this course, you will learn about the elements that make up a relational database: entities, attributes, and data types. You'll learn to manage the relationships between records of data with primary keys and foreign keys and by respecting database integrity constraints. You'll practice designing and representing these relationships with an Entity Relationship Diagram (ERD). Lastly, you'll learn to reduce redundancy and optimize the stability of your database through normalization.
Join me in this course, and you’ll be able to design almost any database with a little practice!
Learning outcomes
- Distinguish relational databases from NoSQL databases
- Describe the elements of relational databases
- Manage the structure of a relational database
Turn it into a career
Take one of our 100% online diploma training programs, and transform your know-how into professional skills.
- Up to 100% of your training program funded
- Flexible start date
- Career-focused projects
- Individual mentoring
1/3
Table of contents
- Part 1
What Is a Relational Database?
- Part 2
Design your logical model
- 1
Connect Your Data With a Relational Data Model
- 2
Identify Database Integrity Constraints
- 3
Build a Solid Database Foundation Through Normalization
- 4
Normalize to the First, Second, and Third Normal Forms
- 5
Put it all Together
- 6
Get some practice by designing an ERD
Quiz: Check What You've Learned About Structuring a Relational Database!