When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. 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.

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.

Relational database systems

Name: Relational database systems
Rating: 4.388286334056399 (461 reviews)

This course is part of Database systems Specialization

Instructor: María del Pilar Ángeles

28,995 already enrolled

Included with

Learn more

6 modules

Gain insight into a topic and learn the fundamentals.

461 reviews

Intermediate level

Some related experience required

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

90%

Most learners liked this course

6 modules

Gain insight into a topic and learn the fundamentals.

461 reviews

Intermediate level

Some related experience required

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

90%

Most learners liked this course

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

6 assignments¹

AI Graded see disclaimer

Taught in English

91%

of learners achieved a positive career outcome

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

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Database systems Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 6 modules in this course

Welcome to the specialization course Relational Database Systems. This course will be completed on six weeks, it will be supported with videos and various documents that will allow you to learn in a very simple way how several types of information systems and databases are available to solve different problems and needs of the companies.

Objective: A learner will be able to design, test, and implement analytical, transactional or NoSQL database systems according to business requirements by programming reliable, scalable and maintainable applications and resources using SQL and Hadoop ecosystem. Programming languages: For course 1 you will use the MYSQL language. Software to download: MySQL Workbench In case you have a Mac / IOS operating system you will need to use a virtual Machine (VirtualBox, Vmware).

Module details

In the first module named information systems, we will learn how people, hardware, software, networks, techniques and procedures work together to automate transactional processes that companies need for their daily operations. Let's start!

What's included

2 videos1 reading1 assignment2 discussion prompts

The present module is focused on Conceptual Design. The learner will be able to create an Entity Relationship Diagram through the Conceptual Design from business requirements.

What's included

2 videos1 assignment2 peer reviews2 discussion prompts

The present module is focused on Logical Design. The learner will be able to create an Relational Model from the entity-relationship diagram

What's included

2 videos1 assignment2 peer reviews2 discussion prompts

2 videosTotal 12 minutes

Concepts of the logical design6 minutes
From the conceptual model to the logical design6 minutes

1 assignmentTotal 30 minutes

Logical Design30 minutes

2 peer reviewsTotal 120 minutes

Logical Design: The Bookstore60 minutes
Logical Design: Musical System60 minutes

2 discussion promptsTotal 25 minutes

Confusion about conceptual modelling with logical modelling15 minutes
A relational model10 minutes

The present module is focused on Physical Design. The learner will be able to create database objects with data definition language from the Structured Query Language.

What's included

3 videos2 readings1 assignment2 peer reviews1 discussion prompt

3 videosTotal 12 minutes

Physical modeling6 minutes
Create and populate a database3 minutes
DDL Sailors4 minutes

2 readingsTotal 20 minutes

MySQL Tutorial10 minutes
Create and complete a database. Code10 minutes

1 assignmentTotal 30 minutes

Physical Design30 minutes

2 peer reviewsTotal 120 minutes

Create the DDL: The Bookstore60 minutes
Create the DDL: Musical System60 minutes

1 discussion promptTotal 10 minutes

Create database...10 minutes

The present module is focused on Data Manipulation Language on SQL programming to feed and query relational database objects.

What's included

3 videos2 peer reviews1 discussion prompt

The present module is focused on query optimization according to type of information systems.

What's included

2 videos2 assignments1 peer review1 discussion prompt

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(132 ratings)

María del Pilar Ángeles

Universidad Nacional Autónoma de México

4 Courses47,571 learners

Offered by

Universidad Nacional Autónoma de México

Learner reviews

5 stars
65.07%
4 stars
21.47%
3 stars
5.85%
2 stars
2.38%
1 star
5.20%

Showing 3 of 461

Reviewed on Dec 16, 2019

Best course for learning designing concepts in DBMS

Reviewed on Jan 24, 2023

Da los elementos necesarios para comprender sobre el manejo de datos de SQL, explican muy bien todas las etapas de este lenguaje de programación y tienen ejercicios buenos.

Reviewed on Aug 30, 2021

I really needed a more practical approach to database design and programming. This course gave me both.

View more reviews