Learn the basics of Entity Relationship Diagram
For database design
What you will learn
Creating an Entity Relationship Diagram (ERD) for a database design from scratch.
Recognising the entities and creating them that are needed for the design of the database system.
Creating the attributes for the entities in the ERD including the keys.
Recognising the relationships between entities and creating these relationships.
Why take this course?
Whenever you come into contact with data that is stored in a database, you need to learn how to retrieve the data, how to add new data and how to modify and delete existing data from the tables in a database.
These tables or entities are set up in a certain way, they have connections with one another.
Before we even start to create the tables, unless they are already there, we need to have a design. We need to think of what tables we need, what are the column names and their values, and what are the keys and how they relate to other tables.
We can make this design using ERD. ERD is there to help design a database.
If you are a developer or an aspiring developer, who will inevitably work with databases at some point, then it is good to know how to design a database system. Needless to say, a database designer needs to know this as it is their job to create database systems.
Content of the course
The course consists of 7 lessons with a total duration of 58 minutes 46 seconds.
The exercises that come with the lessons are aiming towards creating an ERD with a case scenario. The exercises’ solutions are also explained in the lessons.
At the end of the course, you will have the basics to make your very own ERD.
This is an overview of the lessons and their content. In the brackets is the duration of each lesson.
Lesson 1: ERD Entities (has exercise) (08:03)
Lesson 2: ERD Entities (exercise answers) (07:42)
Lesson 3: ERD Entity Attributes (has exercise) (08:12)
Lesson 4: ERD Entity Attributes (exercise answers part 1) (07:10)
Lesson 5: ERD Entity Attributes (exercise answers part 2) (07:06)
Lesson 6: ERD Entity Relationships (has exercise) (11:04)
Lesson 7: ERD Entity Relationships (exercise answers) (09:29)