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

4.4
stars
74 ratings

Tim Carrington

3,076 already enrolled

Offered By

Database Design and Operational Business Intelligence SpecializationUniversity of California, Irvine

About this Course

4,043 recent views

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.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 1 of 3 in the

Database Design and Operational Business Intelligence Specialization

Beginner Level

No experience in BI or database needed. Experience with at least one programming language is recommended.

Approx. 6 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

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

Skills you will gain

SQL Overview
Statistical Analysis
Relational Database
Business Intelligence
Basic Descriptive Statistics

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 1 of 3 in the

Database Design and Operational Business Intelligence Specialization

Beginner Level

No experience in BI or database needed. Experience with at least one programming language is recommended.

Approx. 6 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Instructor rating

4.5/5 (23 Ratings)

Tim Carrington

13,614 Learners

6 Courses

Offered by

University of California, Irvine

Since 1965, the University of California, Irvine has combined the strengths of a major research university with the bounty of an incomparable Southern California location. UCI’s unyielding commitment to rigorous academics, cutting-edge research, and leadership and character development makes the campus a driving force for innovation and discovery that serves our local, national and global communities in many ways.

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

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Week1

Week 1

2 hours to complete

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.

2 hours to complete

7 readings

Week2

Week 2

2 hours to complete

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.

2 hours to complete

1 video (Total 7 min), 4 readings, 1 quiz

Week3

Week 3

2 hours to complete

Module 3: Relational Database Design (ERD and Normalization)

2 hours to complete

4 readings

Week4

Week 4

2 hours to complete

Module 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.

2 hours to complete

1 video (Total 20 min), 1 reading, 1 quiz

Reviews

4.4

14 reviews

5 stars
70.66%
4 stars
13.33%
3 stars
6.66%
2 stars
5.33%
1 star
4%

TOP REVIEWS FROM THE NATURE OF DATA AND RELATIONAL DATABASE DESIGN

by DBFeb 11, 2022

The topics are very interesting and I really want to use the things that I have learned from here.

View all reviews

About the Database Design and Operational Business Intelligence Specialization

The goal of this specialization is to provide a comprehensive and holistic view of business intelligence and its enabling technologies, including relational databases, data warehousing, descriptive statistics, data mining, and visual analytics. Through this series of courses, you will explore relational database design, data manipulation through Extract/Transform/Load (ETL), gaining actionable insight through data analytics, data-based decision support, data visualization, and practical, hands-on experience with real-world business intelligence tools.

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

The Nature of Data and Relational Database Design

About this Course

What you will learn

Skills you will gain