|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-modelling-and-relational-database-design/
课程评论：没有评论
课程名称：数据建模与关系数据库设计 课程概述： 现代数据库及应用开发软件的使用越来越简便，许多人能够在短短一周内快速学习实施简单的数据库和开发简单的应用，而对设计思考不多。然而，随着数据量的增加，用户在请求新增功能时可能会错误地在表中添加列，因为没有适当的数据库设计。这不仅导致数据库中的数据冗余，还会对应用和数据库的性能造成影响，最终因为糟糕的数据库设计而损失业务。一个良好的数据库设计不仅可以避免数据冗余，还能在数据库量增长和业务变更时提高数据库性能，使得理解在何处进行适当更改变得更加容易。数据建模和数据库设计如同建筑蓝图，最终将使应用用户感到满意，业务也会受益。 本课程广泛使用Oracle SQL数据建模工具，讨论并演示数据库建模及设计。Oracle SQL数据建模器是一个工具，使学习数据建模和数据库设计变得更加容易，并为您提供一个专业的方法，有效地为业务应用设计数据库以进行规划、开发、实施及维护。 在本课程中，您将学习： - 过程建模：通过识别过程、外部参与者、信息存储和信息流，开发数据流图，展示信息的流动。 - 业务流程图：创建实体关系图，通过识别实体、属性和关系，形成逻辑模型。将实体关系图标准化至三范式。 - 关系模型：通过设计规则验证逻辑模型和关系模型，将实体关系模型工程化为关系数据库设计，完成物理模型并生成DDL脚本。 最后，您将理解数据建模和数据库设计的重要性。祝您学习愉快！
Modern database and applications development software is so easy to use that many people can quickly learn to implement a simple database and develop simple applications within a week or so, without giving design much thought. As data volume grows and when users request addition functionality, they might incorrectly add columns in table since appropriate database design is not available. This not only causes data redundancy in database but also can cause performance issue to application and database as well. Ultimately, due to poor database design, the business would be the loser.A good database design not only avoids data redundancy but also improves database performance over period of time as the database volume grows and when business changes are requested , it would be far more easier to understand as where to make the appropriate changes in the Database. The data modelling and database design is like a building blue print and ultimately it would make application users happy and business would benefit.This course uses the Oracle SQL Data modeler extensively to discuss and demonstrate Database modelling and Database design.Oracle SQL Data modeler is a tool, which make learning Data modelling and Database design much easier and also provides you with a professional approach design database for business application effectively to plan, develop, implement and maintain them on an ongoing process.In this course you would learn:Process Modelling Develop a Data Flow Diagram by identifying processes, external agents, information stores and information flows that show how the information flows Business flow DiagramLogical Model Create an Entity Relationship Diagram by identifying entities, attributes, relationships. Normalize the Entity Relationship Diagram to third Normal formRelational Model Validate Logical and Relational Model through Design rules Engineer the Entity Relationship Model into an relational database design Complete the Physical Model and generate the DDL scriptsFinally, at the end of the course, you would understand the importance of data modelling and database design.Happy Learning!!
