University of California, Irvine
The Nature of Data and Relational Database Design
University of California, Irvine

The Nature of Data and Relational Database Design

This course is part of Database Design and Operational Business Intelligence Specialization

Taught in English

Some content may not be translated

Tim Carrington

Instructor: Tim Carrington

4,639 already enrolled

Included with Coursera Plus

Course

Gain insight into a topic and learn the fundamentals

4.5

(94 reviews)

Beginner level

Recommended experience

6 hours (approximately)
Flexible schedule
Learn at your own pace

What you'll 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

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

4 quizzes

Course

Gain insight into a topic and learn the fundamentals

4.5

(94 reviews)

Beginner level

Recommended experience

6 hours (approximately)
Flexible schedule
Learn at your own pace

See how employees at top companies are mastering in-demand skills

Placeholder

Build your subject-matter expertise

This course is part of the Database Design and Operational Business Intelligence Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 4 modules in this course

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.

What's included

7 readings1 quiz1 discussion prompt

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.

What's included

1 video4 readings1 quiz1 discussion prompt

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.

What's included

4 readings1 quiz1 discussion prompt

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.

What's included

1 video1 reading1 quiz1 discussion prompt

Instructor

Instructor ratings
4.6 (27 ratings)
Tim Carrington
University of California, Irvine
6 Courses22,792 learners

Offered by

Recommended if you're interested in Data Management

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

Showing 3 of 94

4.5

94 reviews

  • 5 stars

    72.63%

  • 4 stars

    14.73%

  • 3 stars

    5.26%

  • 2 stars

    4.21%

  • 1 star

    3.15%

DB
5

Reviewed on Feb 11, 2022

CN
5

Reviewed on Mar 26, 2023

New to Data Management? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions