Moving Data from MySQL to Hadoop with Sqoop Training Course

Course Code

sqoop

Duration

14 hours (usually 2 days including breaks)

Requirements

An understanding of big data concepts (HDFS, Hive, etc.)
An understanding of relational databases (MySQL, etc.)
Experience with the Linux command line

Overview

Sqoop is an open source software tool for transfering data between Hadoop and relational databases or mainframes. It can be used to import data from a relational database management system (RDBMS) such as MySQL or Oracle or a mainframe into the Hadoop Distributed File System (HDFS). Thereafter, the data can be transformed in Hadoop MapReduce, and then re-exported back into an RDBMS.

In this instructor-led, live training, participants will learn how to use Sqoop to import data from a traditional relational database to Hadoop storage such HDFS or Hive and vice versa.

By the end of this training, participants will be able to:

Install and configure Sqoop
Import data from MySQL to HDFS and Hive
Import data from HDFS and Hive to MySQL

Audience

System administrators
Data engineers

Format of the Course

Part lecture, part discussion, exercises and heavy hands-on practice

Note

To request a customized training for this course, please contact us to arrange.

Course Outline

Introduction

Moving data from legacy data stores to Hadoop

Installing and Configuring Sqoop

Overview of Sqoop Features and Architecture

Importing Data from MySQL to HDFS

Importing Data from MySQL to Hive

Transforming Data in Hadoop

Importing Data from HDFS to MySQL

Importing Data from Hive to MySQL

Importing Incrementally with Sqoop Jobs

Troubleshooting

Summary and Conclusion

Testimonials

★★★★★

★★★★★

What did you like the most about the training?: Detailed on each tool.

Amber Mehrotra - NIIT Limited

Course:Hadoop Administration

The fact that all the data and software was ready to use on an already prepared VM, provided by the trainer in external disks.

vyzVoice

Course:Hadoop for Developers and Administrators

I mostly liked the trainer giving real live Examples.

Simon Hahn

Course:Administrator Training for Apache Hadoop

I genuinely enjoyed the big competences of Trainer.

Grzegorz Gorski

Course:Administrator Training for Apache Hadoop

I genuinely enjoyed the many hands-on sessions.

Jacek Pieczątka

Course:Administrator Training for Apache Hadoop

It was very hands-on, we spent half the time actually doing things in Clouded/Hardtop, running different commands, checking the system, and so on. The extra materials (books, websites, etc. .) were really appreciated, we will have to continue to learn. The installations were quite fun, and very handy, the cluster setup from scratch was really good.

Ericsson

Course:Administrator Training for Apache Hadoop

Lot of hands-on exercises.

Ericsson

Course:Administrator Training for Apache Hadoop

Ambari management tool. Ability to discuss practical Hadoop experiences from other business case than telecom.

Ericsson

Course:Administrator Training for Apache Hadoop

The VM I liked very much The Teacher was very knowledgeable regarding the topic as well as other topics, he was very nice and friendly I liked the facility in Dubai.

Safar Alqahtani - Elm Information Security

Course:Big Data Analytics in Health

practical things of doing, also theory was served good by Ajay

Dominik Mazur - Capgemini Polska Sp. z o.o.

Course:Hadoop Administration on MapR

Exercises

Capgemini Polska Sp. z o.o.

Course:Hadoop Administration on MapR

I found the training good, very informative....but could have been spread over 4 or 5 days, allowing us to go into more details on different aspects.

Veterans Affairs Canada

Course:Hadoop Administration

I found this course gave a great overview and quickly touched some areas I wasn't even considering.

Veterans Affairs Canada

Course:Hadoop Administration

Related Categories

Related Courses

Course Discounts

WorkFusion RPA Express for Intelligent Automation

10/21/2019 - 09:30

Bayan Lepas, iDEAL

Read more

Cyber Defence (SOC) Analyst Foundation

11/06/2019 - 09:30

Bayan Lepas, iDEAL

Read more

Big Data Business Intelligence for Criminal Intelligence Analysis

12/02/2019 - 09:30

Bayan Lepas, iDEAL

Read more

Digital Marketing

12/25/2019 - 09:30

Kuala Lumpur KL Sentral

Read more

Chain Core: Issue Financial Assets on Permissioned Blockchain Infrastructure

02/03/2020 - 09:30

Bayan Lepas, iDEAL

Read more

Some of our clients

ibm business consulting services

jp morgan chase & co.

european organization for nuclear research (cern)

royal dutch shell

save the children

aviva commercial union

hewlett-packard

procter & gamble (p&g)

credit suisse group ag

santander consumer bank

avid technology

oracle corporation

reckitt benckiser group

european southern observatory (eso)

nintendo of europe

société générale

seagate technology

heathrow airport

universal mccann

lufthansa systems

ibm business consulting services

jp morgan chase & co.

european organization for nuclear research (cern)

royal dutch shell

save the children

aviva commercial union

hewlett-packard

procter & gamble (p&g)

credit suisse group ag

santander consumer bank

avid technology

oracle corporation

reckitt benckiser group

european southern observatory (eso)

nintendo of europe

société générale

seagate technology

heathrow airport

universal mccann

lufthansa systems

is growing fast!

We are looking to expand our presence in Malaysia!

As a Business Development Manager you will:

expand business in Malaysia
recruit local talent (sales, agents, trainers, consultants)
recruit local trainers and consultants

We offer:

Artificial Intelligence and Big Data systems to support your local operation
high-tech automation
continuously upgraded course catalogue and content
good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.