Microsoft Analytics Platform System & Hive

Apache Hadoop 2.7    |    Intermediate
  • 17 videos | 1h 27m 39s
  • Includes Assessment
  • Earns a Badge
Likes 7 Likes 7
Explore the Microsoft Analytics Platform System and using Hive to manage data from a data warehouse perspective.

WHAT YOU WILL LEARN

  • illustrate capabilities, features, and objectives of the Microsoft Analytics Platform System
    specify how to manage data using PolyBase and the various essential benefits provided by PolyBase
    identify the role of parallel data warehousing architecture in Microsoft Analytics Platform System
    recall the various data exploration architectures that can be implemented using HDInsight and the Microsoft Analytics Platform System
    describe the role of Hive as a data warehouse system for Hadoop
    describe the architectural composition of Hive in HDInsight
    set up the development environment for Hive using the Azure HDInsight tool for VSCode
    connect and submit queries to HDInsight clusters using VSCode
    specify the various clauses that can be used in Hive Query Language to manage objects and query data
  • work with Azure PowerShell and Beeline to execute Hive Query Language queries
    create a database, tables, and load data to Hive tables from the Azure Blob Storage and SQL Servers
    work with partition tables and manage Hive data formats
    demonstrate how to install Hue and manage Hive queries from the Hue interface
    demonstrate the approaches involved in retrieving Hive data and creating visualization on Power BI
    work with HIVE as an ETL tool
    compare HBase and Hive from the data modeling perspective
    create a Hive table and load data from an external SQL Server

IN THIS COURSE

  • 7m 42s
  • 4m 1s
  • Locked
    3.  Parallel Data Warehouse Architecture
    5m 41s
  • Locked
    4.  Data Exploration Architectures
    3m 49s
  • Locked
    5.  Hive Introduction
    4m 38s
  • Locked
    6.  Hive Architecture in HDInsight
    4m 9s
  • Locked
    7.  Setting up the Development Environment for Hive
    8m 22s
  • Locked
    8.  Connect and Submit Queries
    4m 53s
  • Locked
    9.  Hive QL
    3m
  • Locked
    10.  Using Azure PowerShell and Beeline
    3m 42s
  • Locked
    11.  Creating a Database and Tables and Loading Data
    5m 46s
  • Locked
    12.  Partition Tables and Data Formats
    9m 20s
  • Locked
    13.  Hue Installation and Hive Query Management
    5m 35s
  • Locked
    14.  Using Microsoft BI and Hive
    3m 43s
  • Locked
    15.  Hive as ETL
    5m 15s
  • Locked
    16.  HBase and Hive
    3m 42s
  • Locked
    17.  Exercise: Creating and Loading Data into Hive Tables
    4m 20s

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 TIBCO Spotfire
Likes 55 Likes 55  
Channel Apache Hadoop
Likes 179 Likes 179  
Channel IBM BigInsights
Likes 12 Likes 12  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Working with Spark Using HDInsight & Cluster Management
Likes 4 Likes 4  
Course Viewing & Querying Complex Data with Hive
Likes 41 Likes 41  
Course Traditional Data Architectures: Data Warehousing and ETL Systems
Likes 97 Likes 97