Acerca de este Curso

37,880 vistas recientes
Certificado para compartir
Obtén un certificado al finalizar
100 % en línea
Comienza de inmediato y aprende a tu propio ritmo.
Fechas límite flexibles
Restablece las fechas límite en función de tus horarios.
Nivel principiante
Aprox. 21 horas para completar
Inglés (English)

Qué aprenderás

  • 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

Habilidades que obtendrás

Data ManagementDistributed File SystemsCloud StorageBig DataSQL
Certificado para compartir
Obtén un certificado al finalizar
100 % en línea
Comienza de inmediato y aprende a tu propio ritmo.
Fechas límite flexibles
Restablece las fechas límite en función de tus horarios.
Nivel principiante
Aprox. 21 horas para completar
Inglés (English)

ofrecido por

Placeholder

Cloudera

Programa - Qué aprenderás en este curso

Semana
1

Semana 1

3 horas para completar

Orientation to Data in Clusters and Cloud Storage

3 horas para completar
7 videos (Total 56 minutos), 3 lecturas, 1 cuestionario
7 videos
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 lecturas
Review and Preparation30m
Instructions for Downloading and Installing the Exercise Environment30m
Troubleshooting the VM5m
1 ejercicio de práctica
Week 1 Graded Quiz30m
Semana
2

Semana 2

5 horas para completar

Defining Databases, Tables, and Columns

5 horas para completar
7 videos (Total 33 minutos), 12 lecturas, 2 cuestionarios
7 videos
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 lecturas
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 ejercicios de práctica
Week 2 Practice Quiz30m
Week 2 Graded Quiz30m
Semana
3

Semana 3

3 horas para completar

Data Types and File Types

3 horas para completar
5 videos (Total 14 minutos), 12 lecturas, 2 cuestionarios
5 videos
Overview of Data Types1m
Choosing the Right Data Types4m
Overview of File Types3m
Choosing the Right File Types3m
12 lecturas
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 ejercicios de práctica
Week 3 Practice Quiz20m
Week 3 Graded Quiz30m
Semana
4

Semana 4

5 horas para completar

Managing Datasets in Clusters and Cloud Storage

5 horas para completar
8 videos (Total 48 minutos), 13 lecturas, 3 cuestionarios
8 videos
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 lecturas
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 ejercicios de práctica
Week 4 Practice Quiz30m
Week 4 Graded Quiz30m

Reseñas

Principales reseñas sobre MANAGING BIG DATA IN CLUSTERS AND CLOUD STORAGE

Ver todas las reseñas

Acerca de Programa especializado: Modern Big Data Analysis with SQL

Modern Big Data Analysis with SQL

Preguntas Frecuentes

¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.