Getting Started with Microsoft Big Data, Hive & HDInsight Jump Start
This is the first of a three-Jump Start series tailored for those interested in a demo-heavy learning experience introducing Microsoft’s Big Data solution set.
Live Event Details
17:00 BST Friday, 21 June 2013 END 22 Jun, 01:00
Microsoft Technical Evangelist Saptak Sen will start with setting up and loading data into Windows Azure storage and a Windows Azure HDInsight cluster. After covering Windows Azure Data Management concepts (e.g., SQL Machines, SQL Databases, Tables, Blobs), they will demonstrate using Hive to query Hadoop data using HiveQL commands and walk through how Hive leverages the entire Hadoop cluster.
Finally, they will explore ways to pull data from HDInsight and other sources into Excel using tools like PowerPivot, Data Explorer, Power View and Geoflow to visualize data models with self-service analysis.
Course Outline
- Windows Azure Storage
- Windows Azure HDInsight
- HDInsight Hive Console
- Create external table statements
- Table partitions
- Select statement syntax
- Hive ODBC driver for connecting to ODBC consumers like Excel
- Data Explorer Excel add-in
- Excel PowerPivot and Power View
- Windows Azure Marketplace, SQL Server and Windows Azure SQL Database
- Geoflow Excel add-in
For more details on Azure in Education see https://www.windowsazure.com/education