UC Irvine - The Nature of Data and Relational Database Design
- Offered byCoursera
- Public/Government Institute
The Nature of Data and Relational Database Design at Coursera Overview
Duration | 7 hours |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
The Nature of Data and Relational Database Design at Coursera Highlights
- Earn a Certificate upon completion
- Course 1 of 3 in the Database Design and Operational Business Intelligence Specialization
- Financial aid available
The Nature of Data and Relational Database Design at Coursera Course details
- 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
- 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
- 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
The Nature of Data and Relational Database Design at Coursera Curriculum
Overview of Business Intelligence
Business Intelligence, Business Analytics, and Data Science
Decision Support Systems (DSS)
BI and Analytics Drivers
A Simple Taxonomy for Analytics
OLTP versus OLAP
Data Warehousing for BI
Supplemental Resources
Module 1 Knowledge Check
Nature of Data & Descriptive Statistics
Excel ToolPak
Types of Data
The Process of Data Preparation
Statistics
Supplemental Resources
Module 2 Knowledge Check
Module 3: Relational Database Design (ERD and Normalization)
Defining Relational Databases
Entity-Relationship Diagram (ERD)
Normalization and Denormalization
Supplemental Resources
Module 3 Knowledge Check
Module 4: Structured Query Language (SQL) Overview
Module 4: SQL Overview and Demo
Supplemental Resources
Module 4 Knowledge Check
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?