|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/relational-database-design/
课程评论：没有评论
**课程名称：** 关系型数据库设计 **课程概述：** 这门Coursera课程将教你如何设计一个优秀的关系型数据库。无论你是想提升软件开发技能、进入数据库管理或设计领域，还是仅仅对数据库设计感兴趣，这门课程都将帮助你掌握有效的数据库设计方法，从而提高系统性能，增强数据质量，并简化未来的系统变更。 **课程亮点：** * **无需SQL或编程经验：** 零基础即可学习。 * **时长:** 包含近三小时的视频课程。 * **学习资料:** 提供关键数据库图的PDF文件，助你深入理解。 * **核心内容:** * 数据库规范化与范式 * 识别表和列 * 主键与外键 * 建立表之间的关系 * 通过实体关系图（ERD）进行数据库设计 * 附带数据库软件的下载和安装教程 * **实践学习:** 通过一个示例数据库，讲解为何需要数据库、关系型数据库的优势，以及如何识别实体、创建和优化表结构。 **学习目标：** 学完本课程，你将能够设计出高效的关系型数据库，全面提升数据库和软件的整体质量。
Learn how to design a proper relational database with this course! This course will teach you how to create an effective relational database design using proven concepts and industry knowledge. Effective database designs will help make systems faster, improve data quality, and ensure future changes are easier. If you want to improve your software development career, get into database admin or database design, or are just curious on this topic, this course is for you. You don't need to know SQL or have any programming experience to be able to take this Relational Database Design course. This course includes:Almost three hours of video lessonsIncluded PDF files of the database diagrams at keys steps will help you learn all about database design.The topics covered include normalisation and the normal forms, identifying tables and columns, primary and foreign keys, and setting up relationships. The videos include explanations of the key topics in the process, as well as demonstrations on how to set up a database using an Entity Relationship Diagram.I also show you how to download and install the software that is being used for this. What topics are covered in this database design course?The topics covered are:We'll walk through a sample databaseReason or why the database is neededSome advantages of relational databasesIdentify entities for the tables and attributesCreate tables and columnsReorganise them to make the layout and design more efficient. If you want to know how to design a database and improve the overall quality of your databases and software, then this is the course for you. You'll learn all you need to be able to design an effective database!
