Microsoft Analytics Platform System & Hive

Apache Hadoop    |    Intermediate
  • 17 videos | 1h 27m 39s
  • Includes Assessment
  • Earns a Badge
Rating 4.8 of 5 users Rating 4.8 of 5 users (5)
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
    After completing this video, you will be able to illustrate the capabilities, features, and objectives of the Microsoft Analytics Platform System. FREE ACCESS
  • 4m 1s
    Upon completion of this video, you will be able to specify how to manage data using PolyBase and the various essential benefits provided by PolyBase. FREE ACCESS
  • Locked
    3.  Parallel Data Warehouse Architecture
    5m 41s
    In this video, you will identify the role of parallel data warehousing architecture in Microsoft Analytics Platform System. FREE ACCESS
  • Locked
    4.  Data Exploration Architectures
    3m 49s
    After completing this video, you will be able to recall the various data exploration architectures that can be implemented using HDInsight and Microsoft's Analytics Platform System. FREE ACCESS
  • Locked
    5.  Hive Introduction
    4m 38s
    After completing this video, you will be able to describe the role of Hive as a data warehouse system for Hadoop. FREE ACCESS
  • Locked
    6.  Hive Architecture in HDInsight
    4m 9s
    Upon completion of this video, you will be able to describe the architectural composition of Hive in HDInsight. FREE ACCESS
  • Locked
    7.  Setting up the Development Environment for Hive
    8m 22s
    In this video, you will set up the development environment for Hive using the Azure HDInsight tool for Visual Studio Code. FREE ACCESS
  • Locked
    8.  Connect and Submit Queries
    4m 53s
    In this video, you will learn how to connect and submit queries to HDInsight clusters using VSCode. FREE ACCESS
  • Locked
    9.  Hive QL
    3m
    Upon completion of this video, you will be able to specify the various clauses that can be used in the Hive Query Language to manage objects and query data. FREE ACCESS
  • Locked
    10.  Using Azure PowerShell and Beeline
    3m 42s
    In this video, learn how to work with Azure PowerShell and Beeline to execute Hive Query Language queries. FREE ACCESS
  • Locked
    11.  Creating a Database and Tables and Loading Data
    5m 46s
    During this video, you will learn how to create a database, tables, and load data into Hive tables from the Azure Blob Storage and SQL Servers. FREE ACCESS
  • Locked
    12.  Partition Tables and Data Formats
    9m 20s
    In this video, you will work with partition tables and manage data formats in Hive. FREE ACCESS
  • Locked
    13.  Hue Installation and Hive Query Management
    5m 35s
    In this video, you will learn how to install Hue and manage Hive queries from the Hue interface. FREE ACCESS
  • Locked
    14.  Using Microsoft BI and Hive
    3m 43s
    In this video, you will learn how to retrieve Hive data and create visualizations on Power BI. FREE ACCESS
  • Locked
    15.  Hive as ETL
    5m 15s
    In this video, find out how to use HIVE as an ETL tool. FREE ACCESS
  • Locked
    16.  HBase and Hive
    3m 42s
    In this video, find out how to compare HBase and Hive from a data modeling perspective. FREE ACCESS
  • Locked
    17.  Exercise: Creating and Loading Data into Hive Tables
    4m 20s
    Learn how to create a Hive table and load data from an external SQL Server. 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 Data Warehousing
Rating 3.0 of 1 users Rating 3.0 of 1 users (1)
Channel SAS
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Channel Apache Hadoop
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)