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.
Monthly Subscription Starting at AED 99 + VAT
- Level Foundation
- Duration 7 hours
- Course by University of California, Irvine
-
Offered by
About
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.Modules
Overview of Business Intelligence
-
7
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Module 1 Knowledge Check
1
Discussions
- Activity
7
Readings
- 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
Nature of Data & Descriptive Statistics
-
1
Videos
-
4
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Module 2 Knowledge Check
1
Discussions
- Activity
1
Videos
- Excel ToolPak
4
Readings
- Types of Data
- The Process of Data Preparation
- Statistics
- Supplemental Resources
Module 3: Relational Database Design (ERD and Normalization)
-
4
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Module 3 Knowledge Check
1
Discussions
- Activity
4
Readings
- Defining Relational Databases
- Entity-Relationship Diagram (ERD)
- Normalization and Denormalization
- Supplemental Resources
Module 4: Structured Query Language (SQL) Overview
-
1
Videos
-
1
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Module 4 Knowledge Check
1
Discussions
- Activity
1
Videos
- Module 4: SQL Overview and Demo
1
Readings
- Supplemental Resources
Auto Summary
Explore the essentials of data and relational database design with this foundational IT & Computer Science course on Coursera. Learn about data types, database design, SQL, and business intelligence. Gain skills in statistical analysis, normalization, ETL processes, and SQL scripting. Perfect for beginners, this 420-minute course offers Starter and Professional subscription options.
Tim Carrington