Relational database systems (Coursera)

Relational database systems (Coursera)

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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

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).
Course 1 of 4 in the Database systems Specialization.

Syllabus

WEEK 1
Information Systems
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!

WEEK 2
Entity Relationship Theory and Conceptual Design
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.

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

WEEK 4
Structured Query Language Data Manipulation Language
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.

WEEK 5
Structured Query Language and Advanced SQL Programming
The present module is focused on Data Manipulation Language on SQL programming to feed and query relational database objects.

WEEK 6
Transactions and query optimization
The present module is focused on query optimization according to type of information systems.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Bioinformatic Methods II (Coursera) Coursera
University of Toronto

Bioinformatic Methods II (Coursera)

Large-scale biology projects such as the sequencing of the human genome and gene expression surveys using RNA-seq, microarrays and other technologies have created a wealth of data for biologists. However, the challenge facing scientists is analyzing and even accessing these data to extract useful information pertaining to the system being studied. This course focuses on employing existing bioinformatic resources – mainly web-based programs and databases – to access the wealth of data to answer questions relevant to the average biologist, and is highly hands-on.

Sep 28th 2026
5-12 Weeks
Business Intelligence and Competitive Analysis (Coursera) Coursera
Rutgers University

Business Intelligence and Competitive Analysis (Coursera)

By the end of 2019, it is clear that American Airlines (AAL), the world’s largest airline group, is in trouble. With the growth rate of its stock price ranked at the bottom of all major US airlines and going in the opposite direction from the SP500 index, AAL needs to find out what is going on, and how to turn the company and its stock price around.

Sep 28th 2026
4 Weeks
Data Visualization with Tableau Project (Coursera) Coursera
University of California, Davis

Data Visualization with Tableau Project (Coursera)

In this project-based course, you will follow your own interests to create a portfolio worthy single-frame viz or multi-frame data story that will be shared on Tableau Public. You will use all the skills taught in this Specialization to complete this project step-by-step, with guidance from your instructors along the way.

Oct 5th 2026
5-12 Weeks
Business Applications of Hypothesis Testing and Confidence Interval Estimation (Coursera) Coursera
Rice University

Business Applications of Hypothesis Testing and Confidence Interval Estimation (Coursera)

Confidence intervals and Hypothesis tests are very important tools in the Business Statistics toolbox. A mastery over these topics will help enhance your business decision making and allow you to understand and measure the extent of ‘risk’ or ‘uncertainty’ in various business processes. This course advances your knowledge about Business Statistics by introducing you to Confidence Intervals and Hypothesis Testing. These are done by easy to understand applications.

Oct 5th 2026
4 Weeks
Population Health: Responsible Data Analysis (Coursera) Coursera
Leiden University

Population Health: Responsible Data Analysis (Coursera)

In most areas of health, data is being used to make important decisions. As a health population manager, you will have the opportunity to use data to answer interesting questions. In this course, we will discuss data analysis from a responsible perspective, which will help you to extract useful information from data and enlarge your knowledge about specific aspects of interest of the population.

Oct 5th 2026
4 Weeks
MySQL for Data Analytics and Business Intelligence (Coursera) Coursera
Edureka

MySQL for Data Analytics and Business Intelligence (Coursera)

Embark on a thorough educational expedition through the "Fundamentals of Database Management with MySQL" module. This foundational program aims to impart a robust comprehension of MySQL, a prominent Relational Database Management System (RDBMS). Participants will delve into crucial concepts, ranging from the fundamentals of SQL to more advanced topics like data retrieval, relationships, business intelligence, and data visualization.

Oct 5th 2026
1 Week
AWS Cloud Practitioner Essentials (Coursera) Coursera
AWS

AWS Cloud Practitioner Essentials (Coursera)

Welcome to AWS Cloud Practitioner Essentials. If you’re new to the cloud, whether you’re in a technical or non-technical role such as finance, legal, sales, marketing, this course will provide you with an understand of fundamental AWS Cloud concepts to help you gain confidence to contribute to your organization’s cloud initiatives. This course is also the starting point to prepare for your AWS Certified Cloud Practitioner certification whenever it’s convenient for you.

Oct 5th 2026
5-12 Weeks
Global Statistics - Composite Indices for International Comparisons (Coursera) Coursera
University of Geneva

Global Statistics - Composite Indices for International Comparisons (Coursera)

In this course on global statistics, offered by the University of Geneva jointly with the ETH Zürich KOF, you will learn the general approach of constructing composite indices and some of resulting problems. We will discuss the technical properties, the internal structure (like aggregation, weighting, stability of time series), the primary data used and the variable selection methods. These concepts will be illustrated using a sample of the most popular composite indices. We will try to address not only statistical questions but also focus on the distinction between policy-, media- and paradigm-driven indicators.

Sep 28th 2026
5-12 Weeks
Necessary Condition Analysis (NCA) (Coursera) Coursera
Erasmus University Rotterdam

Necessary Condition Analysis (NCA) (Coursera)

Welcome to Necessary Condition Analysis (NCA). NCA analyzes data using necessity logic. A necessary condition implies that if the condition is not in place, there will be guaranteed failure of the outcome. The opposite however is not true; if the condition is in place, success of the outcome is not guaranteed.

Sep 28th 2026
5-12 Weeks