|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/relational-database-design-o/
课程评论：没有评论
课程名称：关系数据库设计：数据建模研讨会 课程概述：在本基础课程中，我们将从关系数据库的基本概念和工作原理开始讲解。接下来，您将学习数据建模的过程——将一系列商业需求转化为可用于创建数据库的可视化“实体关系图”。在本课程中，您不会实际创建数据库，主要侧重于数据建模流程。课程的最大价值在于通过实际项目教您如何将业务需求转化为数据模型！我们将与两个虚构的客户合作，他们将提供一系列商业需求。我们将创建图表以满足他们的需求，并随着业务需求的变化不断修改图表。总之，您将通过实践数据建模来学习数据建模技能。 课程大纲包括以下主题： 1. 关系数据库简介： - 关系数据库组件 - 表格 - 主键和外键 2. 正确的数据库设计： - 数据异常和避免冗余数据 - 正规化（第一到第三范式） - 过度正规化 3. 数据建模： - 实体关系图：实体和属性 - 实体关系和基数 - 解决多对多关系 4. 数据建模项目 1：市中心花卉 - 基于业务需求构建初始数据模型 - 根据业务变化更新模型（多轮） 5. 数据建模项目 2：最佳科技大学 - 基于业务需求构建初始数据模型 - 根据业务变化更新模型（多轮） 我期待着引导您完成本课程。不要被术语所困扰，我们将一步一步地进行，您一定会表现出色！
In this foundational course, we begin by teaching you the basics of relational databases and how they work. You will then learn the process of data modeling-translating a set of business needs into a visual "entity relationship diagram" that can be used to create a database. You won't actually create the database in this course-this is primarily about the data modeling process. What is most valuable about this course is the way that it will teach you to translate business requirements into data models using hands-on projects! We will work with two imaginary clients who will give us a set of business requirements. We'll create diagrams to serve their needs and modify the diagrams as their business needs grow and change. In short, you will learn data modeling skills by DOING data modeling. An outline of the topics includes:1. An Introduction to Relational Databases:Components of Relational DatabasesTablesPrimary and Foreign Keys2. Proper Database DesignData Anomalies and Avoiding Redundant DataNormalization (First - Third Normal Forms)Over-Normalization3. Data ModelingEntity Relationship Diagrams: Entities and AttributesEntity Relationships and CardinalityResolving Many-to-Many Relationships4. Data Modeling Project 1: Downtown FloralBuild the Initial Data Model Based on Business RequirementsUpdate Model Based on Business Changes (Several Rounds)4. Data Modeling Project 2: Best Tech UBuild the Initial Data Model Based on Business RequirementsUpdate Model Based on Business Changes (Several Rounds)I look forward to guiding you through this course. Don't be intimidated by the terminology. We'll take this a step at a time and you'll do great!
