Have you ever wanted to build a database but don't know where to start? This course will provide you a step-by-step guidance. We are going to start from a raw idea to an implementable relational database. Getting on the path, practicing the real-life mini cases, you will be confident and comfortable with Relational Database Design. Let's get started!
课程信息
This course is for beginners, but you should be interested in databases and database design!
您将学到的内容有
Create Entity Relationship Models and Entity Relationship Diagrams
Create Relational Models
Normalize a Relational Model to 3NF
您将获得的技能
- Database (DB) Design
- Database (DBMS)
- Relational Models
- Normalization
- Entity–Relationship (E-R) Model
This course is for beginners, but you should be interested in databases and database design!
提供方

科罗拉多大学波德分校
CU-Boulder is a dynamic community of scholars and learners on one of the most spectacular college campuses in the country. As one of 34 U.S. public institutions in the prestigious Association of American Universities (AAU), we have a proud tradition of academic excellence, with five Nobel laureates and more than 50 members of prestigious academic academies.
立即开始攻读硕士学位
授课大纲 - 您将从这门课程中学到什么
Introduction to DBMS, and Entity Relational Models
Introduce students to Database Management Systems. Introduce and train students with how to build conceptual entity relationship models.
Relational Models
Introduce the concepts about relational models. Train students with how to convert a conceptual entity relationship model to a relational model.
Normalization
Introduce students with the reasons and process of normalization. Train students with skills to normalize a relational model to 3NF.
Case Study
A summary of the knowledge we learned in this course, starting from an Entity Relationship Model to a Relational Model in 3NF and ready for implementation.
关于 Databases for Data Scientists 专项课程
Whether you are a beginning programmer with an interest in Data Science, a data scientist working closely with content experts, or a software developer seeking to learn about the database layer of the stack this specialization is for you! We focus on the relational database which is the most widely used type of database. Relational databases have dominated the database software marketplace for nearly four decades and form a core, foundational part of software development. In this specialization you will learn about database design, database software fundamentals, and how to use the Structured Query Language (SQL) to work with databases. The specialization, will conclude with an overview of future trends in databases, including non-relational databases (NoSQL) and Big Data. Upon completion of this specialization you will be well prepared to design and create efficient and effective relational databases, fill them with data, and work with them using SQL.

常见问题
我什么时候能够访问课程视频和作业?
我订阅此专项课程后会得到什么?
有助学金吗?
还有其他问题吗?请访问 学生帮助中心。