Relational database systems

Ends today! Save 40% on your access to 10,000+ programs and make a real impact in your career. Save now.

Relational database systems

This course is part of Database systems Specialization

Instructor: María del Pilar Ángeles

29,086 already enrolled

Included with Learn more

Ask Coursera

6 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Some related experience required

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

6 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Some related experience required

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

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

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).

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: Musical System60 minutes
Logical Design: The Bookstore60 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: Musical System60 minutes
Create the DDL: The Bookstore60 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

María del Pilar Ángeles

Universidad Nacional Autónoma de México

4 Courses47,730 learners

Offered by

Universidad Nacional Autónoma de México

Explore more from Data Analysis

Illinois Tech
Introduction to Relational Databases
Course
Status: Free Trial
Birla Institute of Technology & Science, Pilani
Relational Databases
Course
Universidad Nacional Autónoma de México
NoSQL systems
Course
Status: Free Trial
Illinois Tech
Relational Database Implementation and Applications
Course
Status: Free Trial

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions

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.

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.

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.