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