|
所在平台: Coursera专项课程 课程类别: 其他类别 大学或机构: CourseraNew |
课程主页: https://www.coursera.org/specializations/cloudera-big-data-analysis-sql
课程评论：没有评论
**现代大数据分析与SQL专业简介** 本专业课程教授使用SQL处理大型数据的基本技能，适合无论是新手还是已有基础的学习者。现代数据的生成速度和体量日益增加，传统的关系数据库已无法满足存储需求，越来越多的数据被存储在分布式集群和云存储中，这些存储方式不仅具成本效益且具备无限扩展性。 为了能够查询这些庞大的数据集，学习者需要掌握分布式查询引擎，如Hive和Impala等开源SQL引擎。本专业特别关注这两个引擎，它们是当前使用最广泛的工具。本课程不仅提供理论知识，也为Cloudera认证合作伙伴（CCA）数据分析师认证考试做了良好准备，学员可以通过实际动手考试验证所学技能。 **课程大纲：** 1. **大数据分析基础与SQL** 提供大数据环境下使用SQL的全局视角，包括数据与数据库的概述。 [课程链接](https://www.coursera.org/learn/foundations-big-data-analysis-sql) 2. **使用SQL分析大数据** 深入探讨SQL SELECT语句及其主要子句，集中于大数据分析的应用。 [课程链接](https://www.coursera.org/learn/cloudera-big-data-analysis-sql-queries) 3. **在集群和云存储中管理大数据** 学习如何管理大数据集，及其在集群和云存储中的加载与管理。 [课程链接](https://www.coursera.org/learn/cloud-storage-big-data-analysis-sql) 通过本专业的学习，您将获得使用现代分布式SQL引擎进行大数据分析的实用技能。
Course Link: https://www.coursera.org/learn/foundations-big-data-analysis-sql
Name:Foundations for Big Data Analysis with SQL
Description:Offered by Cloudera. In this course, you'll get a big-picture view of using SQL for big data, starting with an overview of data, database ... Enroll for free.
Course Link: https://www.coursera.org/learn/cloudera-big-data-analysis-sql-queries
Name:Analyzing Big Data with SQL
Description:Offered by Cloudera. In this course, you'll get an in-depth look at the SQL SELECT statement and its main clauses. The course focuses on big ... Enroll for free.
Course Link: https://www.coursera.org/learn/cloud-storage-big-data-analysis-sql
Name:Managing Big Data in Clusters and Cloud Storage
Description:Offered by Cloudera. In this course, you'll learn how to manage big datasets, how to load them into clusters and cloud storage, and how to ... Enroll for free.
This Specialization teaches the essential skills for working with large-scale data using SQL. Maybe you are new to SQL and you want to learn the basics. Or maybe you already have some experience using SQL to query smaller-scale data with relational databases. Either way, if you are interested in gaining the skills necessary to query big data with modern distributed SQL engines, this Specialization is for you. Most courses that teach SQL focus on traditional relational databases, but today, more and more of the data that’s being generated is too big to be stored there, and it’s growing too quickly to be efficiently stored in commercial data warehouses. Instead, it’s increasingly stored in distributed clusters and cloud storage. These data stores are cost-efficient and infinitely scalable. To query these huge datasets in clusters and cloud storage, you need a newer breed of SQL engine: distributed query engines, like Hive, Impala, Presto, and Drill. These are open source SQL engines capable of querying enormous datasets. This Specialization focuses on Hive and Impala, the most widely deployed of these query engines. This Specialization is designed to provide excellent preparation for the Cloudera Certified Associate (CCA) Data Analyst certification exam. You can earn this certification credential by taking a hands-on practical exam using the same SQL engines that this Specialization teaches—Hive and Impala.
具有SQL专长的现代大数据分析：此专长教授使用SQL处理大型数据的基本技能。 也许您是SQL新手，并且想学习基础知识。也许您已经具有使用SQL查询关系数据库中较小规模数据的经验。无论哪种方式，如果您有兴趣获得使用现代分布式SQL引擎查询大数据所必需的技能，那么本专业将适合您。 大多数讲授SQL的课程都将重点放在传统的关系数据库上，但是如今，越来越多的生成数据太大而无法存储在其中，并且增长过快而无法有效地存储在商业数据仓库中。相反，它越来越多地存储在分布式集群和云存储中。这些数据存储具有成本效益且可无限扩展。 要查询集群和云存储中的这些庞大数据集，您需要使用更新的SQL引擎：分布式查询引擎，例如Hive，Impala，Presto和Drill。这些是能够查询大量数据集的开源SQL引擎。本专业专注于Hive和Impala，它们是这些查询引擎中部署最广泛的。 该专业旨在为Cloudera认证合作伙伴（CCA）数据分析师认证考试提供出色的准备。您可以通过使用本专业教授的相同SQL引擎（Hive和Impala）参加动手实践考试来获得此认证证书。