Microsoft Analytics Platform System & Hive
Apache Hadoop 2.7
| Intermediate
- 17 videos | 1h 27m 39s
- Includes Assessment
- Earns a Badge
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 Systemspecify how to manage data using PolyBase and the various essential benefits provided by PolyBaseidentify the role of parallel data warehousing architecture in Microsoft Analytics Platform Systemrecall the various data exploration architectures that can be implemented using HDInsight and the Microsoft Analytics Platform Systemdescribe the role of Hive as a data warehouse system for Hadoopdescribe the architectural composition of Hive in HDInsightset up the development environment for Hive using the Azure HDInsight tool for VSCodeconnect and submit queries to HDInsight clusters using VSCodespecify 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 queriescreate a database, tables, and load data to Hive tables from the Azure Blob Storage and SQL Serverswork with partition tables and manage Hive data formatsdemonstrate how to install Hue and manage Hive queries from the Hue interfacedemonstrate the approaches involved in retrieving Hive data and creating visualization on Power BIwork with HIVE as an ETL toolcompare HBase and Hive from the data modeling perspectivecreate a Hive table and load data from an external SQL Server
IN THIS COURSE
-
7m 42s
-
4m 1s
-
5m 41s
-
3m 49s
-
4m 38s
-
4m 9s
-
8m 22s
-
4m 53s
-
3m
-
3m 42s
-
5m 46s
-
9m 20s
-
5m 35s
-
3m 43s
-
5m 15s
-
3m 42s
-
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.