Coursera

The Nature of Data and Relational Database Design (Coursera)

Offered by University of California, Irvine,
The Nature of Data and Relational Database Design (Coursera)

This course provides a comprehensive overview of data, various data types, design of databases for storage of data, and creation and manipulation of data in databases using SQL. By the end of this course, students will be able to describe what business intelligence is and how it’s different from business analytics and data science, conduct a basic descriptive statistical analysis and articulate the findings, and differentiate between types of statistics. They will also be able to define normalization and ETL, create an ERD that shows progression from conceptual to logical to physical design, define DDL, DML, DCL, and TCL, and write SQL scripts to create a database and associated tables.

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

What You Will Learn

  • Create an ERD that shows progression from conceptual to logical to physical design
  • Conduct a basic descriptive statistical analysis and articulate the findings
  • Write SQL scripts to create a database and associated tables

Course 1 of 3 in the Database Design and Operational Business Intelligence Specialization.

Syllabus

WEEK 1
Overview of Business Intelligence
Welcome to Module 1: Overview of Business Intelligence! In our first module, we will define business intelligence and differentiate it from business analytics and data science. We will also overview decision support systems and practice working with them through our activity. Finally, we will differentiate between OTLP and OLAP as well as identify the goals of business intelligence through a short quiz.

WEEK 2
Nature of Data & Descriptive Statistics
Welcome to Module 2: Nature of Data & Descriptive Statistics. In this module, we will dive into the types of data, the process of data preparation and descriptive and inferential statistics. We will differentiate between descriptive and inferential statistics as well as structured and unstructured data with a short quiz. Finally, we will use Microsoft Excel Data Analysis Toolpak to conduct a basic descriptive statistical analysis and share our findings.

WEEK 3
Relational Database Design (ERD and Normalization)
Welcome to Module 3: Relational Database Design (ERD and Normalization). In this module, we will define relational databases and overview the process of designing databases. We will differentiate between conceptual, logical and physical design with a short quiz. In addition, we will create an ERD that shows progression from conceptual to logical to physical design through our activity.

WEEK 4
Structured Query Language (SQL) Overview
Welcome Module 4: Structured Query Language (SQL) Overview. In our final module, we will overview SQL as well as define Data Definition Language (DDL) and Data Manipulation Language (DML). Through a short quiz, we will define DDL, DML, DCL, and TCL, as well as differentiate between varying MySQL keywords and data types. In our final activity, we will write SQL scripts to create a database and some associated tables. We will then extract and articulate useful information from the data that we can share with fellow students.

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

Related Courses

Introduction to Structured Query Language (SQL) (Coursera) Coursera
University of Michigan

Introduction to Structured Query Language (SQL) (Coursera)

CS: Software Engineering CS: Programming

In this course, you'll walk through installation steps for installing a text editor, installing MAMP or XAMPP (or equivalent) and creating a MySql Database. You'll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation. Lastly, you'll learn to model many-to-many relationships like those needed to represent users, roles, and courses.

Oct 12th 2026
4 Weeks
SQL PHP MySQL
Details
Managing Big Data with MySQL (Coursera) Coursera
Duke University

Managing Big Data with MySQL (Coursera)

Statistics & Data Analysis Data Science

This course is an introduction to how to use relational databases in business analysis. You will learn how relational databases work, and how to use entity-relationship diagrams to display the structure of the data held within them. This knowledge will help you understand how data needs to be collected in business contexts, and help you identify features you want to consider if you are involved in implementing new data collection efforts.

Oct 12th 2026
5-12 Weeks
Databases SQL Big Data
Details
AWS Database Specialty Certification (Coursera) Coursera
EDUCBA

AWS Database Specialty Certification (Coursera)

CS: Information & Technology

This course offers a comprehensive journey through the world of databases and their management on the AWS cloud platform. From understanding the core concepts of databases to mastering advanced topics like migration, automation, and security, participants will gain a solid foundation in database design, deployment, and management using AWS services.

Oct 26th 2026
5-12 Weeks
Security Databases Migration
Details
Relational Database Support for Data Warehouses (Coursera) Coursera
University of Colorado System

Relational Database Support for Data Warehouses (Coursera)

Statistics & Data Analysis Data Science

Relational Database Support for Data Warehouses is the third course in the Data Warehousing for Business Intelligence specialization. In this course, you'll use analytical elements of SQL for answering business intelligence questions. You'll learn features of relational database management systems for managing summary data commonly used in business intelligence reporting. Because of the importance and difficulty of managing implementations of data warehouses, we'll also delve into storage architectures, scalable parallel processing, data governance, and big data impacts. In the assignments in this course, you can use either Oracle or PostgreSQL.

Oct 12th 2026
5-12 Weeks
Databases SQL Big Data
Details
Big Data Analysis Deep Dive (Coursera) Coursera
Alibaba Cloud Academy

Big Data Analysis Deep Dive (Coursera)

CS: Information & Technology

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!

Oct 26th 2026
5-12 Weeks
Python SQL Big Data
Details
Business Intelligence Concepts, Tools, and Applications (Coursera) Coursera
University of Colorado System

Business Intelligence Concepts, Tools, and Applications (Coursera)

Statistics & Data Analysis Data Science

This is the fourth course in the Data Warehouse for Business Intelligence specialization. Ideally, the courses should be taken in sequence. In this course, you will gain the knowledge and skills for using data warehouses for business intelligence purposes and for working as a business intelligence developer. You’ll have the opportunity to work with large data sets in a data warehouse environment and will learn the use of MicroStrategy's Online Analytical Processing (OLAP) and Visualization capabilities to create visualizations and dashboards.

Oct 12th 2026
5-12 Weeks
Data Analysis Decision Making Business Intelligence
Details
Data Visualization with Advanced Excel (Coursera) Coursera
PwC

Data Visualization with Advanced Excel (Coursera)

Statistics & Data Analysis Data Science

In this course, you will get hands-on instruction of advanced Excel 2013 functions. You’ll learn to use PowerPivot to build databases and data models. We’ll show you how to perform different types of scenario and simulation analysis and you’ll have an opportunity to practice these skills by leveraging some of Excel's built in tools including, solver, data tables, scenario manager and goal seek.

Oct 12th 2026
4 Weeks
Databases Excel Data Analysis
Details
Business Intelligence and Competitive Analysis (Coursera) Coursera
Rutgers University

Business Intelligence and Competitive Analysis (Coursera)

Business

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.

Oct 26th 2026
4 Weeks
Data Analysis Business Intelligence Benchmarking
Details
Using Databases with Python (Coursera) Coursera
University of Michigan

Using Databases with Python (Coursera)

CS: Software Engineering

This course will introduce students to the basics of the Structured Query Language (SQL) as well as basic database design for storing data as part of a multi-step data gathering, analysis, and processing effort. The course will use SQLite3 as its database. We will also build web crawlers and multi-step data gathering and visualization processes. We will use the D3.js library to do basic data visualization.

Oct 19th 2026
5-12 Weeks
Programming Python Databases
Details