Instructor-led training

Hadoop for Business Users Training in De Pere, Wisconsin

Request a Training Proposal View Course Outline

What you'll learn

This course enables participants to understand from a Business Users perspective what the Hadoop platform is and provides hands-on lab exercises to apply the concepts, plan, run, and use the platform. Apache Hadoop is the most popular framework for processing Big Data. Hadoop provides rich and deep analytics capability, and it is making in-roads into the traditional BI analytics world. This course will introduce the participant to the core components of the Hadoop Eco System and its analytics, as well as planning, running, and administering a Hadoop Cluster. It will emphasize the use cases of Hadoop and Data Warehousing, and provide best practices and guidelines on combining the two.

Prerequisites

Participants should be able to navigate the Linux command-line interface and have a basic knowledge of Linux editors, such as vi or nano. Also, basic knowledge of Java and understanding ETL are required.

Course Outline

Course Topics

• Hadoop Eco System Overview

• HDFS

• MapReduce

• Hive

• Pig

• Data Access, Integration

• Transformation, Aggregation

• Feature Generation

• Join various Data Sources

• Filter, Search, Transpose

• Binning and Smoothing

Course Objectives

Upon completion of this course, participants will be able to:

• Describe what the Hadoop platform is and its purpose.

• Describe the core components of the Hadoop Eco System.

• Plan, run, and use a Hadoop Cluster.

I. Hadoop Eco System Overview

A. Eco System Review

B. High-level Architecture

II. Hadoop Distributed File System (HDFS)

A. Concepts

B. Overview

C. Labs

III. MapReduce

A. Concepts

B. Overview

C. Labs

IV. Hive

A. Concepts and Architecture

B. Data Types

C. Meta Data Management

D. Joins, Partitions, Indexes, Bucketing

E. Text Analysis with Hive

F. Labs

V. Pig

A. Pig versus Java Map Reduce

B. Pig Latin Language Introduction

C. Understanding Pig Job Flow

D. Basic Data Analysis with Pig

E. Complex Data Analysis with Pig

F. Advanced Concepts

a. User-Defined Functions

b. Best Practices

D. Complex transformations using Pig that HIVE could not do gracefully

G. Labs

VI. Introduction

A. Data Access, Integration

a. Navigate in Hadoop

b. Access Data and Files in HDFS and Tables

B. Transformation, Aggregation

a. Consume large datasets/tables

b. Working with Dates/timestamps, Arrays,

c. Use group by and summarize various attributes

d. Converting strings to date/time, numbers

e. Concatenating columns

f. Parsing semi-structured data

C. Feature Generation

a. Create new attributes, mathematical calculations, windowing functions

b. Use Character and string functions

D. Join Various data sources

a. Join multiple files/tables, in an optimized way

E. Filter, Search, Transpose

a. Ways to limit the data use various predicate methods

b. Pivot the data in different ways wide to long and vice versa

c. Find missing values

F. Binning and Smoothing

a. Create buckets and groups for categorization

Training locations

Hadoop for Business Users training across the U.S. and beyond.

We provide Hadoop for Business Users training onsite and live online for organizations throughout the United States and internationally.

View all Hadoop for Business Users training locations

Ready to train your team?

Let's customize this training for your organization.

Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.

Request a Training Proposal

or call 303.377.6176