|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/relational-database-design-sql/
课程评论：没有评论
**课程名称：EssentialSQL: 数据建模与关系数据架构** **课程概述：** 本课程是入门级数据建模和关系数据库表设计的理想选择。课程宗旨是使用简单易懂的英语教授关系数据库的逻辑设计。我们将一步步引导学习者完成需求建模、概念数据模型构建和逻辑数据库模型设计，最终创建用于创建物理表的脚本。如果您希望了解数据架构，本课程将非常实用！ 我们将以披萨店老板 Lou 的业务为例，通过建模、设计和创建数据库来跟踪他的业务。 **学习目标：** * 根据 Lou's Pizza Shops 的需求创建概念数据模型。 * 使用 ER （实体-关系）图来建模和设计数据库表及其之间的关系。 * 理解并围绕数据修改异常进行设计。 * 识别结构良好的数据库表。 * 回答与关系数据库范式和数据架构相关的常见面试问题。 * 识别设计不佳的表。 * 与他人就表设计进行沟通。 * 理解令人困惑的范式规则！ * 识别设计中的数据库范式问题并知道如何修复它们。 * 使用 ERD （实体关系图）创建数据库脚本。 **课程将帮助你克服以下痛点：** * 对学习新知识感到兴奋，却不知从何开始。 * 浪费时间学习错误的功能。 * 被众多选项淹没，不知如何选择。 **学习后你将获得：** * **知识：** 能够快速理解数据库设计，将 SQL 水平提升到新的高度。 * **信心：** 确信自己走在正确的学习轨道上。 * **成就感：** 获得常人难以企及的学习成就。 * **乐趣：** 在学习数据库的过程中享受乐趣。 课程结束后，您将能够使用表、键、关系以及 MySQL、PostgresSQL 和 SQL Server 中的 SQL 命令来设计和实现关系数据库，以满足用户和运营需求。
This course is perfect if you're looking for entry-level course to learn data modeling and relational database table design.Its singular purpose is to teach you relational database logical design using simple to understand English. We'll walk though modeling requirements, building the conceptual data model, and logical database model. Finally we create scripts to create the physical tables. If you looking to understand data architecture, then you'll find this course very practical!Join me as we work through Lou's, the owner of several pizza shops, to model, design and create a database he can use to track is business.In this Course you will Learn to:Create a conceptual data model based on Lou's Pizza Shops' requirements.Use ER (Entity-Relationship) diagrams to model and design database tables and relationships between one another.Appreciate and design around data modification anomalies.Identify a properly formed database table.Answer common interview questions related to relational database normalization and data architecture.Spot a poorly designed table.Communicate with others about table design.Finally understand those confounding normalization rules!Identify database normalization issues within our design and know how to fix them.Use an ERD (Entity Relationship Diagram) to create database scripts.Nothing is worse thanBeing excited to learn something new but not knowing where to start.Wasting time learning the wrong features.Being overwhelmed with options and not know which to use.Imagine Having...Knowledge - Knowing how to quickly understand database design to take your SQL to the next level.Confidence - Feeling good that you're on the right track.Accomplishment - Having a sense of accomplishment that you've learned something most cannot.Fun - Having fun learning databases!By the time you've completed this course you'll be able to design and implement relational databases using tables, keys, relationships, and SQL commands in MySQL, PostgresSQL, and SQL Server to meet user and operational needs.
