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

The Nature of Data and Relational Database Design

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.

Status: Database Systems
Status: Database Theory
BeginnerCourse7 hours

Featured reviews

CN

Reviewed Mar 26, 2023

It is a great course for a non-tech person. I would recommend this course to people want to advance their skills and change careers into Data

All reviews

Showing: 18 of 18

Deannver
Reviewed Feb 12, 2022
Hany
Reviewed Jul 31, 2022
Michel
Reviewed Aug 2, 2022
Nikos
Reviewed May 1, 2023
Chi
Reviewed Mar 27, 2023
Wai
Reviewed Jan 16, 2022
HASSAN
Reviewed Jan 22, 2023
Jenn
Reviewed Nov 24, 2021
Tessa
Reviewed Jan 23, 2022
Francis
Reviewed Dec 31, 2023
Ван
Reviewed Nov 29, 2023
Deleted
Reviewed Sep 22, 2022
Patrick
Reviewed May 25, 2022
ELMER
Reviewed Nov 13, 2022
Alejandro
Reviewed Jan 26, 2024
Henrique
Reviewed Jun 22, 2022
MUSKAN
Reviewed Jan 27, 2022
AS
Reviewed Jun 10, 2022