|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-the-basics-of-entity-relationship-diagram/
课程评论:没有评论
本课程旨在教授实体关系图(ERD)的基础知识,帮助学习者理解和设计数据库。ERD是数据库设计的重要工具,用于构思数据库的结构、表格、字段以及它们之间的关系,这对于开发者和数据库设计者来说至关重要。 课程共包含7个单元,总时长约59分钟。通过案例场景下的练习,学员将学习如何创建ERD。课程内容包括: * **ERD实体**:讲解实体的概念,并通过练习加深理解,之后会提供练习解答。 * **ERD实体属性**:介绍实体的属性,同样包含练习和分两部分提供的练习解答。 * **ERD实体关系**:讲解实体间的关系,并提供包含练习的单元,最后会给出练习解答。 完成本课程后,学员将掌握制作个人ERD的基础技能。
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 courseThe 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)