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
-
1.Microsoft Analytics Platform System7m 42sUP NEXT
-
2.Understanding PolyBase4m 1s
-
3.Parallel Data Warehouse Architecture5m 41s
-
4.Data Exploration Architectures3m 49s
-
5.Hive Introduction4m 38s
-
6.Hive Architecture in HDInsight4m 9s
-
7.Setting up the Development Environment for Hive8m 22s
-
8.Connect and Submit Queries4m 53s
-
9.Hive QL3m
-
10.Using Azure PowerShell and Beeline3m 42s
-
11.Creating a Database and Tables and Loading Data5m 46s
-
12.Partition Tables and Data Formats9m 20s
-
13.Hue Installation and Hive Query Management5m 35s
-
14.Using Microsoft BI and Hive3m 43s
-
15.Hive as ETL5m 15s
-
16.HBase and Hive3m 42s
-
17.Exercise: Creating and Loading Data into Hive Tables4m 20s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.