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 I (Coursera) Coursera
University of Toronto

Bioinformatic Methods I (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.

Nov 16th 2026
5-12 Weeks
La recherche documentaire (Coursera) Coursera
École Polytechnique

La recherche documentaire (Coursera)

Ce cours vise principalement à permettre aux étudiants d’identifier les sources pertinentes dans un domaine donné, leur apprendre à construire un état de l’art et à évaluer les sources, en particulier celles en accès libre sur Internet. Il cherche également à optimiser la recherche documentaire en incitant les étudiants à tirer le meilleur parti des outils et requêtes d’interrogation des bases de données. A l'issue de ce cours, ils devront être capables de construire et alimenter une bibliographie ordonnée, ainsi que de citer convenablement leurs sources pour éviter le plagiat.

Nov 23rd 2026
3 Weeks
Construção de Relacionamentos em Vendas Orientada a Dados (Coursera) Coursera
FIA Business School

Construção de Relacionamentos em Vendas Orientada a Dados (Coursera)

Nossas boas-vindas ao Curso Construção de Relacionamento em Vendas Orientada a Dados. Neste curso, você aprenderá métodos sobre data analytics para o ambiente dos profissionais de vendas. Ao final deste curso, você será capaz de avaliar relacionamentos entre o desempenho de vendas e os gastos relacionados; agrupar por semelhança itens, produtos ou serviços e, por fim, realizar recomendações de produtos para clientes sob características preestabelecidas.

Nov 23rd 2026
4 Weeks
Serverless Data Processing with Dataflow: Develop Pipelines (Coursera) Coursera
Google Cloud

Serverless Data Processing with Dataflow: Develop Pipelines (Coursera)

In this second installment of the Dataflow course series, we are going to be diving deeper on developing pipelines using the Beam SDK. We start with a review of Apache Beam concepts. Next, we discuss processing streaming data using windows, watermarks and triggers. We then cover options for sources and sinks in your pipelines, schemas to express your structured data, and how to do stateful transformations using State and Timer APIs.

Nov 16th 2026
3 Weeks
Gestión del análisis de datos (Coursera) Coursera
Johns Hopkins University

Gestión del análisis de datos (Coursera)

This one-week course describes the process of analyzing data and how to manage that process. We describe the iterative nature of data analysis and the role of stating a sharp question, exploratory data analysis, inference, formal statistical modeling, interpretation, and communication. In addition, we will describe how to direct analytic activities within a team and to drive the data analysis process towards coherent and useful results.

Nov 16th 2026
1 Week
A Scientific Approach to Innovation Management (Coursera) Coursera
Università Bocconi

A Scientific Approach to Innovation Management (Coursera)

How can innovators understand if their idea is worth developing and pursuing? In this course, we lay out a systematic process to make strategic decisions about innovative product or services that will help entrepreneurs, managers and innovators to avoid common pitfalls. We teach students to assess the feasibility of an innovative idea through problem-framing techniques and rigorous data analysis labelled ‘a scientific approach’.

Nov 16th 2026
5-12 Weeks
Build a Data Warehouse Using BigQuery (Coursera) Coursera
Starweaver

Build a Data Warehouse Using BigQuery (Coursera)

Unlock the power of Google BigQuery as you embark on a journey to become proficient in data warehouse building and advanced querying. In this comprehensive course, you'll learn to harness the capabilities of BigQuery, from setting up and accessing the platform to creating data warehouses using both the user interface and Python. Through hands-on lessons and practical applications, you'll develop the fundamental skills needed to manage, query, and optimize your data in this powerful cloud-based platform.

Nov 23rd 2026
1 Week
Gender Foundations in Health Data: A Data for Health Course (Coursera) Coursera
Johns Hopkins University

Gender Foundations in Health Data: A Data for Health Course (Coursera)

Welcome to Gender Foundations in Health Data: A Data for Health course. This course was developed from an online seminar series of the same name, that was hosted by Johns Hopkins University Bloomberg School of Health in 2021-22. The course instructors are Drs. Michelle Kaufman and Tahilin Sanchez Karver. This course will raise learners' awareness of the necessity of utilizing a gender lens in global public health data, policy, and practice, feature how-tos and key examples of integration of gender in data collection, analysis, and use from Data for Health partners.

Nov 23rd 2026
1 Week
Data Processing Using Python (Coursera) Coursera
Nanjing University

Data Processing Using Python (Coursera)

This course is mainly for non-computer majors. It starts with the basic syntax of Python, to how to acquire data in Python locally and from network, to how to present data, then to how to conduct basic and advanced statistic analysis and visualization of data, and finally to how to design a simple GUI to present and process data, advancing level by level.

Nov 23rd 2026
5-12 Weeks
Process Mining: Data science in Action (Coursera) Coursera
Eindhoven University of Technology

Process Mining: Data science in Action (Coursera)

Process mining is the missing link between model-based process analysis and data-oriented analysis techniques. Through concrete data sets and easy to use software the course provides data science knowledge that can be applied directly to analyze and improve processes in a variety of domains. Data science is the profession of the future, because organizations that are unable to use (big) data in a smart way will not survive. It is not sufficient to focus on data storage and data analysis. The data scientist also needs to relate data to process analysis.

Nov 16th 2026
5-12 Weeks