К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Managing Big Data in Clusters and Cloud Storage · LearnSpace
Назад в каталог
courseraАнализ данных

Managing Big Data in Clusters and Cloud Storage

Курс от Cloudera
Начальный≈ 21 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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. By the end of the course, you will be able to • 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; and • describe and choose among different data types and file formats for big data systems. 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)

Навыки, которые вы освоите

Database ManagementApache HiveData ManagementAmazon S3Data Import/ExportData StorageSQLApache HadoopDatabase SystemsFile SystemsDatabase Management SystemsExtract, Transform, LoadQuery LanguagesData Storage TechnologiesBig DataDatabasesFile ManagementCloud StoragePerformance TuningAmazon Web Services

Программа курса

5 модулей · 108 учебных материалов

01Orientation to Data in Clusters and Cloud Storage12 материалов

Introduction

Welcome to the CourseВидеоReview and PreparationЧтениеInstructions for Downloading and Installing the Exercise EnvironmentЧтениеTroubleshooting the VMЧтение

Учитесь у экспертов

Ian Cook

Staff Curriculum Developer

Glynn Durham

Senior Instructor

Managing Big Data in Clusters and Cloud Storage
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 21 ч

5 модулей

Язык: Английский

Субтитры: Арабский, Французский, Бенгальский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Вьетнамский, Нидерландский, Корейский, Немецкий, Пушту, Урду, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Дари, Хинди, Японский, Казахский, Венгерский, Польский

Часть программы вашего университета
Introduce YourselfОбсуждение

Browsing Tables in the Metastore

Browsing Tables with HueВидеоBrowsing Tables with SQL Utility StatementsВидео

Browsing Files in HDFS

Browsing HDFS with the Hue File BrowserВидеоBrowsing HDFS from the Command LineВидео

Browsing Files in S3

Understanding S3 and Other Cloud Storage PlatformsВидеоBrowsing S3 Buckets from the Command LineВидео

Quiz

Week 1 Graded QuizЗадание
02Defining Databases, Tables, and Columns22 материалов

Introduction

Week 2 IntroductionВидео

Creating Databases and Tables

Creating Databases and Tables with HueЧтениеCreating Databases and Tables with SQLЧтениеPermissions to Create Databases and TablesЧтение

The CREATE TABLE Statement

Introduction to the CREATE TABLE StatementВидеоThe ROW FORMAT ClauseЧтениеThe STORED AS ClauseЧтениеThe LOCATION ClauseЧтениеCREATE TABLE ShortcutsЧтениеUsing Different Schemas on the Same DataВидео

Advanced CREATE TABLE Techniques

Specifying TBLPROPERTIESВидеоUsing Hive SerDesЧтениеWorking with Unstructured and Semi-Structured DataЧтениеMost Difficult to UnderstandОбсуждение

Managing Existing Tables

Examining, Modifying, and Removing TablesВидеоExamining Table StructureЧтениеDropping Databases and TablesЧтениеModifying Existing TablesЧтение

Apache Hive and Apache Impala Interoperability

Hive and Impala InteroperabilityВидеоImpala Metadata RefreshВидео

Quizzes

Week 2 Practice QuizЗаданиеWeek 2 Graded QuizЗадание
03Data Types and File Types20 материалов

Introduction

Week 3 IntroductionВидео

Data Types

Overview of Data TypesВидеоInteger Data TypesЧтениеDecimal Data TypesЧтениеCharacter String Data TypesЧтениеOther Data TypesЧтение

Working with Data Types

Choosing the Right Data TypesВидеоExamining Data TypesЧтениеOut-of-Range ValuesЧтение

File Types

Overview of File TypesВидеоText FilesЧтениеAvro FilesЧтениеParquet FilesЧтениеORC FilesЧтениеOther File TypesЧтение

Working with File Types

Choosing the Right File TypesВидеоCreating Tables with Avro and Parquet FilesЧтениеWhat's Your TypeОбсуждение

Quizzes

Week 3 Practice QuizЗаданиеWeek 3 Graded QuizЗадание
04Managing Datasets in Clusters and Cloud Storage25 материалов

Introduction

Week 4 IntroductionВидеоRefresh Impala's Metadata Cache after Loading DataВидео

Loading Files into HDFS

Loading Files into HDFS with Hue's Table BrowserВидеоLoading Files into HDFS with Hue's File BrowserВидеоLoading Files into HDFS from the Command LineВидеоMore about HDFS Shell CommandsЧтениеChaining and Scripting with HDFS CommandsЧтениеHDFS PermissionsЧтение

Loading Data into Cloud Storage

Loading Files into S3 from the Command LineВидеоOther Ways to Load Files into S3ЧтениеS3 PermissionsЧтениеMissing ValuesЧтениеCharacter SetsЧтение

Using Sqoop to Load Data from Relational Databases

Using Sqoop to Import DataЧтениеMore Sqoop Import OptionsЧтениеUsing Sqoop to Export DataЧтение

Using Hive and Impala to Load Data into Tables

Using Hive and Impala to Load Data into TablesВидеоSQL LOAD DATA StatementsЧтениеSQL INSERT StatementsЧтениеSQL INSERT ... SELECT and CTAS StatementsЧтениеGet a Load of ThisОбсуждение

Quizzes, Peer-Graded Assignment, and Conclusion

Week 4 Practice QuizЗаданиеWeek 4 Graded QuizЗаданиеData ManagementВзаимная проверкаConclusionВидео
05Optimizing Hive and Impala (Honors)29 материалов

Introduction

Week 5 IntroductionВидеоQuestions?Обсуждение

Simplifying Queries with Views

What to Do When Queries Are Too ComplexВидеоCreating and Querying ViewsЧтениеModifying and Removing ViewsЧтениеMaterialized and Non-Materialized ViewsЧтениеThe ORDER BY Clause in ViewsЧтение

Improving Query Performance

What to Do When Queries Take Too LongВидеоChoosing Which Query Engine to UseЧтениеUnderstanding Map Tasks and Reduce TasksЧтениеHive Query Performance PatternsЧтениеUnderstanding Execution PlansЧтениеTable and Column StatisticsЧтение

Table Partitioning

When to Use Table PartitioningВидеоCreating Partitioned TablesЧтениеLoading Data with Dynamic PartitionЧтениеLoading Data with Static PartitioningЧтениеRisks of Using PartitioningЧтение

Complex Data and Denormalization

When to Use Complex ColumnsВидеоComplex Data TypesЧтениеCreating Tables with Complex DataЧтениеQuerying Complex Data with HiveЧтениеQuerying Complex Data with ImpalaЧтениеComplex Data in PracticeЧтение

Storage Engines

File Systems versus Storage EnginesВидеоOverview of Apache KuduЧтение

Quizzes

Week 5 Practice QuizЗаданиеWeek 5 Graded QuizЗадание
Other Strategies for Query OptimizationЧтение