|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/foundations-big-data-analysis-sql
课程评论：没有评论
课程名称：大数据分析基础与SQL 概述：在本课程中，您将获得使用SQL进行大数据分析的全貌，首先了解数据、数据库系统以及常见查询语言（SQL）的概念。随后，您将学习大数据的特征以及与大数据平台相关的SQL工具。此外，您还将安装一个练习环境（虚拟机），该环境将在整个专业课程中使用，并有机会在该环境中初步探索数据库和表。 课程结束时，您将能够： - 区分操作性数据库和分析性数据库，并理解它们在大数据中的应用； - 理解数据库和表设计如何为数据工作提供结构； - 认识到数据的量和多样性如何影响您选择合适的数据库系统； - 了解专为大数据系统存储和分析而设计的SQL方言的特征和优点； - 在大数据平台中探索数据库和表。 为使用本课程的实践环境，您需要下载并安装一个虚拟机及其运行所需的软件。在继续之前，请确保您有访问满足以下硬件和软件要求的计算机： - Windows、macOS或Linux操作系统（iPad和Android平板电脑无法使用） - 64位操作系统（32位操作系统无法使用） - 8 GB RAM或更高 - 25GB或更多的可用磁盘空间 - 启用Intel VT-x或AMD-V虚拟化支持（在带有Intel处理器的Mac计算机上，这通常是启用的；在Windows和Linux计算机上，您可能需要在BIOS中启用它） - 对于仅使用Windows XP的计算机：必须安装解压工具，如7-Zip或WinZip（Windows XP自带的解压工具无法使用） 大纲： - 数据和数据库：介绍本专业及课程1的概况，了解数据库系统及操作性数据库与分析性数据库之间的区别。 - 关系数据库与SQL - 大数据 - 用于大数据分析的SQL工具 - 实践环境简介
Name:Data and Databases
Description:In this week, you'll get an overview of this Specialization and of Course 1. Then you'll learn about database systems and the distinction between operational and analytic databases.
Name:Relational Databases and SQL
Description:
Name:Big Data
Description:
Name:SQL Tools for Big Data Analysis
Description:
Name:Introduction to the Hands-On Environment
Description:
In this course, you'll get a big-picture view of using SQL for big data, starting with an overview of data, database systems, and the common querying language (SQL). Then you'll learn the characteristics of big data and SQL tools for working on big data platforms. You'll also install an exercise environment (virtual machine) to be used through the specialization courses, and you'll have an opportunity to do some initial exploration of databases and tables in that environment. By the end of the course, you will be able to • distinguish operational from analytic databases, and understand how these are applied in big data; • understand how database and table design provides structures for working with data; • appreciate how differences in volume and variety of data affects your choice of an appropriate database system; • recognize the features and benefits of SQL dialects designed to work with big data systems for storage and analysis; and • explore databases and tables in a big data platform. To use the hands-on environment for this course, you need to download and install a virtual machine and the software on which to run it. Before continuing, be sure that you have access to a computer that meets the following hardware and software requirements: • Windows, macOS, or Linux operating system (iPads and Android tablets will not work) • 64-bit operating system (32-bit operating systems will not work) • 8 GB RAM or more • 25GB free disk space or more • Intel VT-x or AMD-V virtualization support enabled (on Mac computers with Intel processors, this is always enabled; on Windows and Linux computers, you might need to enable it in the BIOS) • For Windows XP computers only: You must have an unzip utility such as 7-Zip or WinZip installed (Windows XP’s built-in unzip utility will not work)
