Data Repository with Sqoop

Apache Hadoop    |    Intermediate
  • 16 videos | 1h 11m 10s
  • Earns a Badge
Rating 4.0 of 13 users Rating 4.0 of 13 users (13)
Sqoop is a tool for transferring structured data between Hadoop and a RDBMS. Explore the architecture and installation of Sqoop, how to perform imports and exports, Hive SQL statements, and more.

WHAT YOU WILL LEARN

  • Describe mysql
    Install mysql
    Create a database in mysql
    Create mysql tables and load data
    Describe sqoop
    Describe sqoop's architecture
    Recall the dependencies for sqoop installation
    Install sqoop
  • Recall why it's important for the primary key to be numeric
    Perform a sqoop import from mysql into hdfs
    Recall what concerns the developers should be aware of
    Perform a sqoop export from hdfs into mysql
    Recall that you must execute a sqoop import statement for each data element
    Perform a sqoop import from mysql into hbase
    Recall how to use chain troubleshooting to resolve sqoop issues
    Use the log files to identify common sqoop errors and their resolutions

IN THIS COURSE

  • 2m 49s
    Upon completion of this video, you will be able to describe MySQL. FREE ACCESS
  • 5m 58s
    In this video, you will learn how to install MySQL. FREE ACCESS
  • Locked
    3.  Creating a Database
    4m 1s
    In this video, you will learn how to create a database in MySQL. FREE ACCESS
  • Locked
    4.  Loading Data into MySQL Tables
    3m 20s
    Find out how to create MySQL tables and load data. FREE ACCESS
  • Locked
    5.  Overviewing Sqoop
    1m 39s
    After completing this video, you will be able to describe Sqoop. FREE ACCESS
  • Locked
    6.  Architecture of Sqoop
    2m 13s
    Upon completion of this video, you will be able to describe Sqoop's architecture. FREE ACCESS
  • Locked
    7.  Overview of Sqoop Configuration
    37s
    Upon completion of this video, you will be able to recall the dependencies for Sqoop installation. FREE ACCESS
  • Locked
    8.  Installing Sqoop
    5m 49s
    Find out how to install Sqoop. FREE ACCESS
  • Locked
    9.  Overview of Importing with Sqoop
    6m 1s
    Upon completion of this video, you will be able to recall why it is important for the primary key to be numeric. FREE ACCESS
  • Locked
    10.  Performing a Sqoop Import
    5m 45s
    In this video, you will perform a Sqoop import from MySQL into Hadoop Distributed File System. FREE ACCESS
  • Locked
    11.  Overview of Exporting with Sqoop
    2m 58s
    After completing this video, you will be able to recall what the developers should be aware of. FREE ACCESS
  • Locked
    12.  Performing a Sqoop Export
    5m 59s
    In this video, you will learn how to perform a Sqoop export from MySQL into HDFS. FREE ACCESS
  • Locked
    13.  Sqoop and HBase
    4m 53s
    After completing this video, you will be able to recall that you must execute a Sqoop import statement for each data element. FREE ACCESS
  • Locked
    14.  Exporting into HBase
    6m 31s
    In this video, learn how to perform a Sqoop import from MySQL into HBase. FREE ACCESS
  • Locked
    15.  Sqoop Troubleshooting
    4m 59s
    Upon completion of this video, you will be able to recall how to use chain troubleshooting to resolve Sqoop issues. FREE ACCESS
  • Locked
    16.  Correcting a Database Connect Failure
    7m 37s
    In this video, you will learn how to use log files to identify common Sqoop errors and their resolutions. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel Wintellect Apache Hadoop
Course Azure Data Fundamentals: Modern Data Warehousing
Rating 4.3 of 63 users Rating 4.3 of 63 users (63)
Channel Introduction to SQL with MySQL and Workbench
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)