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

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
SQL: A Practical Introduction for Querying Databases (Coursera) Coursera
IBM

SQL: A Practical Introduction for Querying Databases (Coursera)

Much of the world's data lives in databases. SQL (or Structured Query Language) is a powerful programming language that is used for communicating with and manipulating data in databases. A working knowledge of databases and SQL is a must for anyone who wants to start a career in Data Engineering, Data Warehousing, Data Analytics, Data Science or Business Intelligence. The purpose of this course is to help you learn and apply foundational and intermediate knowledge of the SQL language, and become familiar with many relational database (RDBMS) concepts along the way.

Nov 16th 2026
5-12 Weeks
Statistics and Data Analysis with Excel, Part 1 (Coursera) Coursera
University of Colorado Boulder

Statistics and Data Analysis with Excel, Part 1 (Coursera)

Designed for students with no prior statistics knowledge, this course will provide a foundation for further study in data science, data analytics, or machine learning. Topics include descriptive statistics, probability, and discrete and continuous probability distributions. Assignments are conducted in Microsoft Excel (Windows or Mac versions). Designed to be taken with the follow-up course, “Statistics and Data Analysis with Excel, Part 2.”

Nov 23rd 2026
5-12 Weeks
Big Data Analysis Deep Dive (Coursera) Coursera
Alibaba Cloud Academy

Big Data Analysis Deep Dive (Coursera)

The job market for architects, engineers, and analytics professionals with Big Data expertise continues to increase. The Academy’s Big Data Career path focuses on the fundamental tools and techniques needed to pursue a career in Big Data. This course includes: data processing with python, writing and reading SQL queries, transmitting data with MaxCompute, analyzing data with Quick BI, using Hive, Hadoop, and spark on E-MapReduce, and how to visualize data with data dashboards. Work through our course material, learn different aspects of the Big Data field, and get certified as a Big Data Professional!

Nov 23rd 2026
5-12 Weeks
HI-FIVE: Health Informatics For Innovation, Value & Enrichment (Administrative/IT Perspective) (Coursera) Coursera
Columbia University

HI-FIVE: Health Informatics For Innovation, Value & Enrichment (Administrative/IT Perspective) (Coursera)

HI-FIVE (Health Informatics For Innovation, Value & Enrichment) Training is an approximately 10-hour online course designed by Columbia University in 2016, with sponsorship from the Office of the National Coordinator for Health Information Technology (ONC). The training is role-based and uses case scenarios. No additional hardware or software are required for this course. Our nation’s healthcare system is changing at a rapid pace.

Nov 23rd 2026
4 Weeks
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
Case studies in business analytics with ACCENTURE (Coursera) Coursera
ESSEC Business School

Case studies in business analytics with ACCENTURE (Coursera)

This course is RESTRICTED TO LEARNERS ENROLLED IN Strategic Business Analytics SPECIALIZATION as a preparation to the capstone project. During the first two MOOCs, we focused on specific techniques for specific applications. Instead, with this third MOOC, we provide you with different examples to open your mind to different applications from different industries and sectors. The objective is to give you an helicopter overview on what's happening in this field. You will see how the tools presented in the two previous courses of the Specialization are used in real life projects.

Nov 16th 2026
3 Weeks
Statistical Thinking for Industrial Problem Solving, presented by JMP (Coursera) Coursera
SAS

Statistical Thinking for Industrial Problem Solving, presented by JMP (Coursera)

Statistical Thinking for Industrial Problem Solving is an applied statistics course for scientists and engineers offered by JMP, a division of SAS. By completing this course, students will understand the importance of statistical thinking, and will be able to use data and basic statistical methods to solve many real-world problems.

Nov 16th 2026
5-12 Weeks
Analyzing and Visualizing Data in Looker (Coursera) Coursera
Google Cloud

Analyzing and Visualizing Data in Looker (Coursera)

In this course, you learn how to do the kind of data exploration and analysis in Looker that would formerly be done primarily by SQL developers or analysts. Upon completion of this course, you will be able to leverage Looker's modern analytics platform to find and explore relevant content in your organization’s Looker instance, ask questions of your data, create new metrics as needed, and build and share visualizations and dashboards to facilitate data-driven decision making.

Nov 23rd 2026
2 Weeks