by | Released January 2016 | ISBN: 9781771374774

In this Mastering Apache Sqoop training course, expert author David Yahalom teaches you everything you need to know about Apache Sqoop. This course is designed for the absolute beginner, meaning no previous experience with Sqoop is required.You will start by learning what Sqoop is used for, including data analysis, data archival, and data consolidation. From there, David will teach you how to import data to Hadoop from a relational database. This video tutorial also covers how to export data from Hadoop to a relational database. Finally, you will cover advanced Sqoop topics. Once you have completed this computer based training course, you will have learned everything you need to know about Apache Sqoop. Show and hide more Publisher resources View/Submit Errata

1. Introduction to Sqoop
   • Introduction 00:03:45
   • About The Author 00:00:48
   • Use Case #1: ELT 00:05:32
   • Use Case #2: ETL From DWH 00:03:04
   • Use Case #3: Data Analysis 00:03:38
   • Use Case #4: Data Archival 00:02:02
   • Use Case #5: Move Reports To Hadoop 00:05:26
   • Use Case #6: Data Consolidation 00:02:54
2. Importing Data To Hadoop From A Relational Database
   • Command Line Basics: Importing Data Using Sqoop 00:09:13
   • Importing Data With Column Filters, Row Filters, And Free Text Queries 00:06:12
   • Parallel Imports 00:04:33
   • Import Data Directory To HIVE Tables 00:07:25
   • Incremental Data Import Overview 00:06:00
   • Incremental Data Import And Using Sqoop Stored Jobs 00:11:05
3. Sqoop Hands-On: Exporting Data From Hadoop To A Relational Database
   • Exporting Data Back To A Relational Database Using Sqoop 00:05:42
   • Exporting data from Hadoop back to RDBMS 00:01:57
4. Advanced topics
   • Introduction to Sqoop2 Server 00:04:18
5. Course summary
   • Wrap Up 00:04:07
Show and hide more