In this course, you'll learn how to manage big datasets, how to load them into clusters and cloud storage, and how to apply structure to the data so that you can run queries on it using distributed SQL engines like Apache Hive and Apache Impala. You’ll learn how to choose the right data types, storage systems, and file formats based on which tools you’ll use and what performance you need.
이 강좌는 Modern Big Data Analysis with SQL 전문 분야의 일부입니다.
Managing Big Data in Clusters and Cloud Storage
제공자:
About this Course
최근 조회 23,985회
배울 내용
Use different tools to browse existing databases and tables in big data systems
Use different tools to explore files in distributed big data filesystems and cloud storage
Create and manage big data databases and tables using Apache Hive and Apache Impala
Describe and choose among different data types and file formats for big data systems
귀하가 습득할 기술
Data ManagementDistributed File SystemsCloud StorageBig DataSQL
공유 가능한 수료증
완료 시 수료증 획득
100% 온라인
지금 바로 시작해 나만의 일정에 따라 학습을 진행하세요.
다음 전문 분야의 3개 강좌 중 3번째 강좌:
유동적 마감일
일정에 따라 마감일을 재설정합니다.
초급 단계
완료하는 데 약 24시간 필요
영어
자막: 영어
제공자:
Cloudera
At Cloudera, we believe that data can make what is impossible today, possible tomorrow. We empower people to transform complex data into clear and actionable insights. Cloudera delivers an enterprise data cloud for any data, anywhere, from the Edge to AI. Powered by the relentless innovation of the open source community, Cloudera advances digital transformation for the world’s largest enterprises.
강의 계획 - 이 강좌에서 배울 내용
완료하는 데 3시간 필요
Orientation to Data in Clusters and Cloud Storage
완료하는 데 3시간 필요
7개 동영상 (총 56분), 3 readings, 1 quiz
7개의 동영상
Browsing Tables with Hue7m
Browsing Tables with SQL Utility Statements6m
Browsing HDFS with the Hue File Browser13m
Browsing HDFS from the Command Line9m
Understanding S3 and Other Cloud Storage Platforms6m
Browsing S3 Buckets from the Command Line8m
3개의 읽기 자료
Review and Preparation30m
Instructions for Downloading and Installing the Exercise Environment30m
Troubleshooting the VM5m
1개 연습문제
Week 1 Graded Quiz30m
완료하는 데 5시간 필요
Defining Databases, Tables, and Columns
완료하는 데 5시간 필요
7개 동영상 (총 33분), 12 readings, 2 quizzes
7개의 동영상
Introduction to the CREATE TABLE Statement5m
Using Different Schemas on the Same Data12m
Specifying TBLPROPERTIES2m
Examining, Modifying, and Removing Tables1m
Hive and Impala Interoperability2m
Impala Metadata Refresh3m
12개의 읽기 자료
Creating Databases and Tables with Hue30m
Creating Databases and Tables with SQL15m
Permissions to Create Databases and Tables5m
The ROW FORMAT Clause25m
The STORED AS Clause15m
The LOCATION Clause20m
CREATE TABLE Shortcuts10m
Using Hive SerDes15m
Working with Unstructured and Semi-Structured Data15m
Examining Table Structure10m
Dropping Databases and Tables5m
Modifying Existing Tables35m
2개 연습문제
Week 2 Practice Quiz20m
Week 2 Graded Quiz30m
완료하는 데 3시간 필요
Data Types and File Types
완료하는 데 3시간 필요
5개 동영상 (총 14분), 12 readings, 2 quizzes
5개의 동영상
Overview of Data Types1m
Choosing the Right Data Types4m
Overview of File Types3m
Choosing the Right File Types3m
12개의 읽기 자료
Integer Data Types5m
Decimal Data Types10m
Character String Data Types10m
Other Data Types5m
Examining Data Types10m
Out-of-Range Values5m
Text Files5m
Avro Files5m
Parquet Files5m
ORC Files5m
Other File Types5m
Creating Tables with Avro and Parquet Files20m
2개 연습문제
Week 3 Practice Quiz20m
Week 3 Graded Quiz30m
완료하는 데 5시간 필요
Managing Datasets in Clusters and Cloud Storage
완료하는 데 5시간 필요
8개 동영상 (총 48분), 13 readings, 3 quizzes
8개의 동영상
Refresh Impala's Metadata Cache after Loading Data2m
Loading Files into HDFS with Hue's Table Browser10m
Loading Files into HDFS with Hue's File Browser6m
Loading Files into HDFS from the Command Line8m
Loading Files into S3 from the Command Line10m
Using Hive and Impala to Load Data into Tables3m
Conclusion2m
13개의 읽기 자료
More about HDFS Shell Commands10m
Chaining and Scripting with HDFS Commands5m
HDFS Permissions5m
Other Ways to Load Files into S35m
S3 Permissions10m
Missing Values15m
Character Sets5m
Using Sqoop to Import Data15m
More Sqoop Import Options5m
Using Sqoop to Export Data5m
SQL LOAD DATA Statements10m
SQL INSERT Statements10m
SQL INSERT ... SELECT and CTAS Statements15m
2개 연습문제
Week 4 Practice Quiz20m
Week 4 Graded Quiz30m
4.7
15개의 리뷰Managing Big Data in Clusters and Cloud Storage의 최상위 리뷰
This is Very good course for a beginners, it gives you lots of exercises to practice in vm and course material is Really really good but only thing is you have to read a lot ,
It would have been nice if videos would have been present instead of reading. Also a more deep diving would have been done in concepts like bucketing and indexing.
Modern Big Data Analysis with SQL 전문 분야 정보
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.
자주 묻는 질문
강의 및 과제를 언제 이용할 수 있게 되나요?
강좌에 등록하면 바로 모든 비디오, 테스트 및 프로그래밍 과제(해당하는 경우)에 접근할 수 있습니다. 상호 첨삭 과제는 이 세션이 시작된 경우에만 제출하고 검토할 수 있습니다. 강좌를 구매하지 않고 살펴보기만 하면 특정 과제에 접근하지 못할 수 있습니다.
이 전문 분야를 구독하면 무엇을 이용할 수 있나요?
강좌를 등록하면 전문 분야의 모든 강좌에 접근할 수 있고 강좌를 완료하면 수료증을 취득할 수 있습니다. 전자 수료증이 성취도 페이지에 추가되며 해당 페이지에서 수료증을 인쇄하거나 LinkedIn 프로필에 수료증을 추가할 수 있습니다. 강좌 내용만 읽고 살펴보려면 해당 강좌를 무료로 청강할 수 있습니다.
환불 규정은 어떻게 되나요?
재정 지원을 받을 수 있나요?
What are the hardware and software requirements for the exercise environment?
• 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)
궁금한 점이 더 있으신가요? 학습자 도움말 센터를 방문해 보세요.