What you'll 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.
- The willingness to learn, no prior knowledge is needed, beginners are welcome.
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)
Who this course is for:
- Beginner database designer or a software developer or anyone who has interest in creating an ERD.
My name is Yanling. I have 6+ years of experience in software development, working mainly with the Microsoft .NET Framework developing transport and distribution software.
I completed my Computer Science studies at Rotterdam University and got my bachelor's degree. I like to pass on the IT knowledge I have gained to others, especially women who are in the IT sector.
In my free time, I also had been studying Bazi through self-study. I have been reading Bazi charts and writing reports to clients for several years.