|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/nature-of-data-relational-database-design
课程评论：没有评论
课程名称：数据的本质与关系数据库设计 课程概述：本课程全面介绍了数据的概念、各种数据类型、用于数据存储的数据库设计以及使用SQL创建和操作数据库中的数据。课程结束时，学生将能够描述商业智能的定义，并将其与商业分析和数据科学区分开来，进行基本的描述性统计分析并阐述发现，以区分不同类型的统计数据。同时，学生还将能够定义规范化和ETL，创建展示从概念设计到逻辑设计再到物理设计的ERD，定义DDL、DML、DCL和TCL，并编写SQL脚本以创建数据库及相关表格。 课程大纲： 1. 模块1：商业智能概述 - 本模块将定义商业智能并将其与商业分析和数据科学区分开来。我们还将概述决策支持系统并通过活动练习进行实际操作，最后通过小测验区分OTLP和OLAP，并识别商业智能的目标。 2. 模块2：数据的本质与描述性统计 - 本模块将探讨数据类型、数据准备过程以及描述性和推断统计。我们将区分描述性统计与推断统计，以及结构化数据和非结构化数据，最后使用Microsoft Excel的Data Analysis Toolpak进行基本的描述性统计分析并分享结果。 3. 模块3：关系数据库设计（ERD和规范化） - 本模块将定义关系数据库并概述数据库设计过程。我们将区分概念设计、逻辑设计和物理设计，并通过短测验进行巩固。在活动中，我们将创建一个展示从概念到逻辑再到物理设计的ERD。 4. 模块4：结构化查询语言（SQL）概述 - 本模块将概述SQL，并定义数据定义语言（DDL）和数据操作语言（DML）。通过小测验，我们将定义DDL、DML、DCL和TCL，并区分MySQL的各种关键字和数据类型。在最后的活动中，我们将编写SQL脚本以创建数据库及相关表格，并提取和阐述有用的信息与同学分享。
Name:Overview of Business Intelligence
Description: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.
Name:Nature of Data & Descriptive Statistics
Description: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.
Name:Module 3: Relational Database Design (ERD and Normalization)
Description: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.
Name:Module 4: Structured Query Language (SQL) Overview
Description: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.
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.
