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

Redes Ecológicas (Coursera) Coursera
Universidade de São Paulo, Brasil

Redes Ecológicas (Coursera)

Todos os seres vivos estão conectados entre si por interações ecológicas, formando a “colina emaranhada” de Darwin, metáfora inspirada pela “teia da vida” de Humboldt. Desemaranhar essa complexidade é uma tarefa desafiadora, mas factível, desde que você use ferramentas adequadas. A ciência de redes nos ajuda com excelentes ferramentas conceituais e operacionais.

Aug 17th 2026
4 Weeks
Data-Driven Decisions with Power BI (Coursera) Coursera
Knowledge Accelerators

Data-Driven Decisions with Power BI (Coursera)

New Power BI users will begin the course by gaining a conceptual understanding of the Power BI desktop application and the Power BI service. Learners will explore the Power BI interface while learning how to manage pages and understand the basics of visualizations. Learners will engage in numerous hands-on experiences to discover how to import, connect, clean, transform, and model their own data in the Power BI desktop application.

Aug 17th 2026
5-12 Weeks
Business Statistics and Analysis Capstone (Coursera) Coursera
Rice University

Business Statistics and Analysis Capstone (Coursera)

The Business Statistics and Analysis Capstone is an opportunity to apply various skills developed across the four courses in the specialization to a real life data. The Capstone, in collaboration with an industry partner uses publicly available ‘Housing Data’ to pose various questions typically a client would pose to a data analyst. Your job is to do the relevant statistical analysis and report your findings in response to the questions in a way that anyone can understand.

Aug 17th 2026
4 Weeks
Web Application Development: Basic Concepts (Coursera) Coursera
University of New Mexico

Web Application Development: Basic Concepts (Coursera)

This is the first course in a Coursera Specialization track involving Web Application Architectures. This course will give you the basic background, terminology and fundamental concepts that you need to understand in order to build modern full stack web applications. A full stack web developer is familiar with each "layer" of the software technologies involved in a web application, including data modeling and database technologies, the web server environment and middleware components, network protocols, the user interface and basic visual design and user interaction concepts.

Aug 17th 2026
5-12 Weeks
Julia Scientific Programming (Coursera) Coursera
University of Cape Town

Julia Scientific Programming (Coursera)

This four-module course introduces users to Julia as a first language. Julia is a high-level, high-performance dynamic programming language developed specifically for scientific computing. This language will be particularly useful for applications in physics, chemistry, astronomy, engineering, data science, bioinformatics and many more.

Aug 17th 2026
4 Weeks
Healthcare Data Management and Information Systems (Coursera) Coursera
Northeastern University

Healthcare Data Management and Information Systems (Coursera)

This course is the continuation of the Health Informatics for Healthcare Professionals course. If you have not yet taken the introductory course, it is recommend that you complete that course prior to this course. The foundational knowledge from the introduction is carried through in this deeper dive into informatics in healthcare.

Aug 17th 2026
4 Weeks
Accounting Data Analytics with Python (Coursera) Coursera
University of Illinois at Urbana-Champaign

Accounting Data Analytics with Python (Coursera)

This course focuses on developing Python skills for assembling business data. It will cover some of the same material from Introduction to Accounting Data Analytics and Visualization, but in a more general purpose programming environment (Jupyter Notebook for Python), rather than in Excel and the Visual Basic Editor. These concepts are taught within the context of one or more accounting data domains (e.g., financial statement data from EDGAR, stock data, loan data, point-of-sale data).

Aug 17th 2026
5-12 Weeks
Advanced Reproducibility in Cancer Informatics (Coursera) Coursera
Johns Hopkins University

Advanced Reproducibility in Cancer Informatics (Coursera)

This course introduces tools that help enhance reproducibility and replicability in the context of cancer informatics. It uses hands-on exercises to demonstrate in practical terms how to get acquainted with these tools but is by no means meant to be a comprehensive dive into these tools. The course introduces tools and their concepts such as git and GitHub, code review, Docker, and GitHub actions.

Aug 17th 2026
5-12 Weeks