|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/cloudera-big-data-analysis-sql-queries
课程评论：没有评论
课程名称：用 SQL 分析大数据 课程概述：在本课程中，您将在 SQL SELECT 语句及其主要子句方面获得深入了解。课程主要集中于大数据 SQL 引擎 Apache Hive 和 Apache Impala，但大部分信息同样适用于传统 RDBMS 的 SQL。讲师还会明确说明 MySQL 和 PostgreSQL 之间的差异。 课程结束时，您将能够： - 使用不同工具探索和导航数据库和表； - 理解 SELECT 语句的基本知识； - 理解如何以及为何过滤结果； - 探索分组和聚合以回答分析性问题； - 处理排序和限制结果； - 以不同方式组合多个表。 课程参与者需下载并安装虚拟机和相关软件以使用动手实践环境。在继续之前，请确保您有一台满足以下硬件和软件要求的计算机： - Windows、macOS 或 Linux 操作系统（iPad 和 Android 平板不适用） - 64 位操作系统（不支持 32 位操作系统） - 8GB RAM 或更多 - 25GB 可用磁盘空间或更多 - 启用 Intel VT-x 或 AMD-V 虚拟化支持（在配备 Intel 处理器的 Mac 电脑上，这通常已启用；在 Windows 和 Linux 电脑上，您可能需要在 BIOS 中启用） - 仅限 Windows XP 电脑：必须安装如 7-Zip 或 WinZip 的解压缩工具（Windows XP 自带的解压缩工具无法使用） 课程大纲： 1. SQL 在大数据中的简介 2. SQL SELECT 基础 3. 过滤数据 4. 数据分组和聚合 5. 数据排序和限制 6. 组合数据
Name:Orientation to SQL on Big Data
Description:
Name:SQL SELECT Essentials
Description:
Name:Filtering Data
Description:
Name:Grouping and Aggregating Data
Description:
Name:Sorting and Limiting Data
Description:
Name:Combining Data
Description:
In this course, you'll get an in-depth look at the SQL SELECT statement and its main clauses. The course focuses on big data SQL engines Apache Hive and Apache Impala, but most of the information is applicable to SQL with traditional RDBMs as well; the instructor explicitly addresses differences for MySQL and PostgreSQL. By the end of the course, you will be able to • explore and navigate databases and tables using different tools; • understand the basics of SELECT statements; • understand how and why to filter results; • explore grouping and aggregation to answer analytic questions; • work with sorting and limiting results; and • combine multiple tables in different ways. 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)
