This course is part of the Databases for Data Scientists Specialization

4.7
stars
71 ratings

Di Wu

5,809 already enrolled

Offered By

Want to earn credit towards a degree? Find out how

You can earn credits from the University of Colorado Boulder that count towards a Master of Science in Data Science

Databases for Data Scientists SpecializationUniversity of Colorado Boulder

About this Course

52,097 recent views

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!
Relational Database Design can be taken for academic credit as part of CU Boulder’s Master of Science in Data Science (MS-DS) degree offered on the Coursera platform. The MS-DS is an interdisciplinary degree that brings together faculty from CU Boulder’s departments of Applied Mathematics, Computer Science, Information Science, and others. With performance-based admissions and no application process, the MS-DS is ideal for individuals with a broad range of undergraduate education and/or professional experience in computer science, information science, mathematics, and statistics. Learn more about the MS-DS program at https://www.coursera.org/degrees/master-of-science-data-science-boulder.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 1 of 3 in the

Databases for Data Scientists Specialization

Beginner Level

This course is for beginners, but you should be interested in databases and database design!

Approx. 36 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

What you will learn

Create Entity Relationship Models and Entity Relationship Diagrams
Create Relational Models
Normalize a Relational Model to 3NF

Skills you will gain

Database (DB) Design
Database (DBMS)
Relational Models
Normalization
Entity–Relationship (E-R) Model

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 1 of 3 in the

Databases for Data Scientists Specialization

Beginner Level

This course is for beginners, but you should be interested in databases and database design!

Approx. 36 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Instructor rating

4.41/5 (32 Ratings)

Di Wu

Instructor

Data Science

9,459 Learners

5 Courses

Offered by

University of Colorado Boulder

Start working towards your degree

This Course is part of an online degree program offered by the University of Colorado Boulder. When you enroll in a for-credit non-degree course through the university and complete it online, it counts as credit hours towards a degree at CU-Boulder. All you have to do is apply through the university.

Master of Science in Data Science

University of Colorado Boulder

Enroll for credit

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Week

Week 1

9 hours to complete

Introduction to DBMS, and Entity Relational Models

9 hours to complete

9 videos (Total 105 min), 8 readings, 4 quizzes

9 videos

Course Overview3m

Data, Information, Knowledge, and Intelligence6m

Solutions for Data Management17m

Data Stored in DBMS5m

What are Entities and Attributes (Identifiers)?19m

What are Relationships? Degree, Cardinality and Participation of Relationships16m

Entity Relationship Model Representation3m

Crow's foot notation9m

In-Class Exercise24m

8 readings

Welcome and Where to Find Help 10m

Assessment Strategy10m

Lab 1: Entity Relationship Models1h

Lab 1: Solutions 30m

Lab 2: Entity Relationship Diagrams1h

Lab 2: Solutions 30m

Entity Relationship Models 1h

Entity Relationship Models: Solutions 30m

3 practice exercises

Unlock Lab 1 Solutions 1m

Unlock Lab 2 Solutions 1m

Unlock Entity Relationship Models Solutions 1m

Week

Week 2

9 hours to complete

Relational Models

9 hours to complete

5 videos (Total 52 min), 8 readings, 5 quizzes

5 videos

What are Relations?11m

What are Keys?10m

What are Relational Schemas?7m

How to Convert ERDs to Relational Models13m

Practice9m

8 readings

Lab 1: Relations1h

Lab 1: Solutions 30m

Lab 2: Relational Schema1h

Lab 2: Solutions 30m

Lab 3: Convert ERDs to Relational Models1h

Lab 3: Solutions 30m

Relational Models 1h 30m

Relational Models: Solutions 30m

4 practice exercises

Unlock Lab 1 Solutions 1m

Unlock Lab 2 Solutions 1m

Unlock Lab 3 Solutions 1m

Unlock Relational Models Solutions 1m

Week

Week 3

11 hours to complete

Normalization

11 hours to complete

4 videos (Total 66 min), 8 readings, 5 quizzes

4 videos

Data Redundancy and Normalization16m

Functional Dependencies9m

Full, Partial, and Transitive Functional Dependencies15m

Normal Forms and Normalization Process25m

8 readings

Lab 1: Functional Dependencies 1h

Lab 1: Solutions 30m

Lab 2: Identify Special FDs 1h

Lab 2: Solutions 30m

Lab 3: Normalization Process1h 30m

Lab 3: Solutions 1h

Normalization1h 30m

Normalization: Solutions 1h

4 practice exercises

Unlock Lab 1 Solutions 1m

Unlock Lab 2 Solutions 1m

Unlock Lab 3 Solutions 1m

Unlock Normalization Solutions 1m

Week

Week 4

8 hours to complete

Case Study

8 hours to complete

12 readings

12 readings

Background30m

Background: Solutions 30m

Build the Entity Relationship Model30m

Build the Entity Relationship Model: Solutions30m

Create the Entity Relationship Diagram30m

Create the Entity Relationship Diagram: Solutions 30m

Convert the ERD to the Relational Model30m

Convert the ERD to the Relational Model: Solutions 30m

Normalize the Relational Model to 3NF1h

Normalize the Relational Model to 3NF: Solutions 1h

Final Output for Implementation10m

Final Output for Implementation: Solutions 10m

6 practice exercises

Unlock Step 1 Solutions 1m

Unlock Step 2 Solutions 1m

Unlock Step 3 Solutions 1m

Unlock Step 4 Solutions 1m

Unlock Step 5 Solutions 1m

Unlock Step 6 Solutions 1m

Reviews

4.7

22 reviews

5 stars
76.05%
4 stars
18.30%
3 stars
4.22%
2 stars
1.40%

TOP REVIEWS FROM RELATIONAL DATABASE DESIGN

by ESJul 2, 2022

Sometimes, there were mistakes in the slides or exercises

by SRJul 3, 2022

This course help me alot to learn new things. Thanks Coursera...

by MGDec 17, 2022

Excellent course. Glad I have completed all crucial concepts related to the course. Special thanks to our course instructor, Di Wu.

by MDJul 17, 2022

I am very glad to getting great knowledge of Relational database design from coursera

View all reviews

About the Databases for Data Scientists Specialization

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.

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

Relational Database Design

About this Course

What you will learn

Skills you will gain