Data Warehousing with Hadoop E-Learning

Data Warehousing with Hadoop E-Learning

Order this unique E-Learning course Data Warehousing with Hadoop online, 1 year 24/7 access to rich interactive videos, speech, progress monitoring through reports and tests per chapter to test the knowledge directly.

Course content

Data Warehousing with Hadoop: Managing Big Data Using HDInsight Hadoop

Course: 1 Hour, 6 Minutes

Features of HDInsight
Fundamentals and Types of Clusters in HDInsight
Essential Opensource Components of HDInsight
Setting Up Hadoop Clusters on Azure HDInsight
HDInsight Clusters with Resource Manager Template
HDInsight Services and Storage Types
Azure Management Console
Creating and Managing HDInsight Clusters
Setting Up HDInsight Emulator
Programming in HDInsight
Developing and Executing MapReduce Program
Exercise: Working with HDInsight and MapReduce

Data Warehousing with Hadoop: Microsoft Analytics Platform System and Hive

Course: 1 Hour, 29 Minutes

Microsoft Analytics Platform System
Understanding PolyBase
Parallel Data Warehouse Architecture
Data Exploration Architectures
Hive Introduction
Hive Architecture in HDInsight
Setting up the Development Environment for Hive
Connect and Submit Queries
Hive QL
Using Azure PowerShell and Beeline
Creating a Database and Tables and Loading Data
Partition Tables and Data Formats
Hue Installation and Hive Query Management
Using Microsoft BI and Hive
Hive as ETL
HBase and Hive
Exercise: Creating and Loading Data into Hive Tables

Data Warehousing with Hadoop: HDInsight and Retail Sales Implementation Using Hive

Course: 46 Minutes

Data Modeling
Dimensional Design Process
Dimensional Design Steps
Retail Business Use Cases
Dimension Tables
Fact tables
Data Loading in Dimension and Fact Tables
Essential Queries
Creating and Executing Queries
Hive and Power BI for Visualization

Data Warehousing with Hadoop: Spark, HDInsight and Cluster Management

Course: 56 Minutes

Spark Introduction
Data Representation in Spark
Create Spark Clusters Using PowerShell
Spark SQL and Hive
Spark SQL Data Sources and DataFrames
Customizing HDInsight Cluster
Application Installation on HDInsight
Ambari User Management
HDInsight Management Using Azure CLI
Troubleshooting HDInsight
Monitoring HDInsight Hadoop
Exercise: Working with Spark and Ambari