|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-data-modeling-fundamentals/
课程评论:没有评论
课程名称:掌握数据建模基础 概述: 如果您是当前或未来的IT专业人士,想要寻找实用的技术来分析和建模数据,作为整体数据管理生命周期的一部分,那么本课程非常适合您。在课程中,您将应用所学知识,定义示例数据模型片段,采用“经典”的实体-关系符号和“乌鸦脚”符号,强调本课程所涵盖的最佳实践和技术。每个章节都有基于场景的测验题或动手作业,以强化该部分材料的主要学习目标。通过这种方式,您可以自信地在课程中前行,掌握数据建模的关键要点。 本课程的构建者拥有超过30年的数据建模和相关领域的工作经验。早在1980年代末,我曾是全球第二大计算机系统供应商的工程师,开发了一个“概念和逻辑数据库设计工具”——即数据建模工具。我自己的咨询公司Thinking Helmet, Inc.专注于数据管理和分析,其中数据建模至关重要。在这门课中,我将从数据建模的基本概念和原理讲起,逐步深入到构建数据模型所需的一系列最佳实践和技术。 您将在课程中看到许多示例,清晰展示所覆盖的关键概念和技术。到课程结束时,您不仅能够将这些原则应用于实践,还能做出必要的数据建模和设计决策,这些决策超越了具体的技术和设计模式。 具体而言,本课程将涵盖以下内容: - 数据建模的基础概念和原理 - 数据建模与数据库设计之间的协同关系(提示:两者并不完全相同!) - 各种建模方法、技术和符号,您可以在工作中应用 - 实体、属性和关系的基本知识以及如何在多种建模符号中表达这些概念 - 如何将现实复杂性纳入我们的实体、属性和关系 - 数据建模生命周期,包括将概念数据模型向逻辑模型和物理模型的正向工程,以及如何将物理数据模型反向工程回概念层面 - 不同的软件数据建模工具的方法 数据建模兼具艺术与科学。尽管我们多年来已经形成了大量最佳实践,但在建模工作中,我们依然需要基于深入的经验做出具体决策,而非单一规则。这就是我在课程中融入的内容:数据建模艺术与科学的结合,您可以将其带入自己的组织和工作中。欢迎加入我,一起探索数据建模的世界!
If you are a current or aspiring IT professional in search of sound, practical techniques to analyze and model data as part of the overall data management lifecycle, this is the course for you.During the course, you'll put what you learn to work and define sample data model segments in both "classic" entity-relationship notation and also the "crow's foot" notation to help emphasize the best practices and techniques covered in this course. Each section has either scenario based quiz questions or hands on assignments that emphasizes key learning objectives for that section's material. This way, you can be confident as you move through the course that you're picking up the key points about data modeling.To build this course, I drew from more than 30 years of my own work involving data modeling and related disciplines. Long ago, in the late 1980s, I was a software engineer at what was then the world's second largest computer systems vendor, Digital Equipment Corporation. I wrote software for a "conceptual and logical database design tool" - in other words, a data modeling tool. My own consulting firm, Thinking Helmet, Inc., specializes in data management and analytics-focused disciplines for which data modeling is essential. I've rolled up my sleeves and personally tackled every aspect of what you'll learn in this course. I've even learned a few painful lessons, and have built a healthy share of "lessons learned" into the course material.In this course, I take you from the fundamentals and concepts of data modeling all the way through a number of best practices and techniques that you'll need to build data models in your organization. You'll find many examples that clearly demonstrate the key concepts and techniques covered throughout the course. By the end of the course, you'll be all set to not only put these principles to work, but also to make the key data modeling and design decisions required by the "art" of data modeling that transcend the nuts-and-bolts techniques and design patterns.Specifically, this course will cover:Foundational data modeling concepts and fundamentalsThe symbiotic relationship between data modeling and database design (Hint: the two are not exactly the same!)Different modeling approaches, techniques, and notations that you can put to workThe fundamentals of entities, attributes, and relationships, as well as how to express these concepts in multiple modeling notationsHow we incorporate real-world complexities into our entities, attributes, and relationshipsThe data modeling lifecycle that includes forward engineering a conceptual data model to a logical and then a physical model, as well as how we reverse-engineer a physical data model back to the conceptual levelDifferent software-based approaches for data modeling toolsData modeling is both an art and a science. While we have developed a large body of best practices over the years, we still have to make this-or-that types of decisions throughout our data modeling work, often based on deep experience rather than specific rules. That's what I've instilled into this course: the fusion of data modeling art and science that you can bring to your organization and your own work. So come join me on this journey through the world of data modeling!