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

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.

Jul 6th 2026
5-12 Weeks
Programming Python Databases
Details
IBM Data Analyst Capstone Project (Coursera) Coursera
IBM

IBM Data Analyst Capstone Project (Coursera)

Statistics & Data Analysis Data Science

In this course you will apply various Data Analytics skills and techniques that you have learned as part of the previous courses in the IBM Data Analyst Professional Certificate. You will assume the role of an Associate Data Analyst who has recently joined the organization and be presented with a business challenge that requires data analysis to be performed on real-world datasets. You will undertake the tasks of collecting data from multiple sources, performing exploratory data analysis, data wrangling and preparation, statistical analysis and mining the data, creating charts and plots to visualize data, and building an interactive dashboard.

Jul 6th 2026
5-12 Weeks
SQL Data Analysis Microsoft Excel
Details
Grow to Greatness: Smart Growth for Private Businesses, Part I (Coursera) Coursera
University of Virginia

Grow to Greatness: Smart Growth for Private Businesses, Part I (Coursera)

Management & Leadership Business

This course focuses on the common growth challenges faced by existing private businesses when they attempt to grow substantially. What you will learn: common myths and truths about growth in business; growth readiness assessment; the 4 P's of growing a business: planning, prioritization, pace and process; four ways to grow your business: scale and CVP, innovating, outsourcing and strategic acquisitions.

Jul 6th 2026
5-12 Weeks
Planning Business Management
Details
Health Information Technology Fundamentals (Coursera) Coursera
Johns Hopkins University

Health Information Technology Fundamentals (Coursera)

Health & Society

In this course you will receive an overview of the health IT ecosystem and the types of technologies IT support staff interact with the most. You will be introduced to the role of electronic health records (EHRs), clinical decision support, telemedicine, patient portals, and medical devices. We’ll cover common examples of how disruptions in these technologies can impact ongoing operations and routine clinical workflow. Although there is an interconnectedness to some aspects of healthcare, there are also limitations in data sharing. We want you to walk away from this course with an understanding of the family of technologies and tools that are critical in healthcare operations.

Jul 6th 2026
4 Weeks
Health Healthcare Databases
Details
Exploiting and Securing Vulnerabilities in Java Applications (Coursera) Coursera
University of California, Davis

Exploiting and Securing Vulnerabilities in Java Applications (Coursera)

Security & Networking

In this course, we will wear many hats. With our Attacker Hats on, we will exploit Injection issues that allow us to steal data, exploit Cross Site Scripting issues to compromise a users browser, break authentication to gain access to data and functionality reserved for the ‘Admins’, and even exploit vulnerable components to run our code on a remote server and access some secrets.

Jul 6th 2026
4 Weeks
Programming Java Security
Details
Foundations for Big Data Analysis with SQL (Coursera) Coursera
Cloudera

Foundations for Big Data Analysis with SQL (Coursera)

Statistics & Data Analysis Data Science

In this course, you'll get a big-picture view of using SQL for big data, starting with an overview of data, database systems, and the common querying language (SQL). Then you'll learn the characteristics of big data and SQL tools for working on big data platforms. You'll also install an exercise environment (virtual machine) to be used through the specialization courses, and you'll have an opportunity to do some initial exploration of databases and tables in that environment.

Jul 6th 2026
5-12 Weeks
Databases 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.

Jul 6th 2026
5-12 Weeks
Data Analysis Decision Making Business Intelligence
Details
Introduction to Data Engineering (Coursera) Coursera
IBM

Introduction to Data Engineering (Coursera)

CS: Information & Technology

This course introduces you to the core concepts, processes, and tools you need to know in order to get a foundational knowledge of data engineering. You will gain an understanding of the modern data ecosystem and the role Data Engineers, Data Scientists, and Data Analysts play in this ecosystem. The Data Engineering Ecosystem includes several different components. It includes disparate data types, formats, and sources of data.

Jul 6th 2026
4 Weeks
Databases NoSQL SQL
Details
La recherche documentaire (Coursera) Coursera
École Polytechnique

La recherche documentaire (Coursera)

Personal and Professional Development

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.

Jul 6th 2026
3 Weeks
Databases Literature Search Document Search
Details