Azure SQL Data Warehouse Training

On-site, Instructor Led Training

This hands-on, instructor-led training at your facility helps data warehouse developers and administrators adopt the MPP architecture found in Azure SQL Data Warehouse for scalable, high-performance analytics in the cloud.  Up to ten attendees will receive expert-led guidance through a complete set of hands-on labs and training modules.  After the training, attendees will be able to accurately plan for data warehouse migrations from on-premises to Azure SQL Data Warehouse, effectively write D-SQL queries that are fully distribution compatible, and expertly administer the environment to ensure that your data warehouse is running at peak performance no matter what size it grows to.

 TRAINING OBJECTIVES

  • How do I load data into Azure SQL DW?
  • How do I ensure that my Azure SQL DW is running efficiently?
  • How do I design my Azure SQL DW to optimize parallel processing performance?
  • How do I move my existing data warehouse on SQL Server to a distributed, cloud architecture in Azure SQL DW?

 TRAINING SUMMARY

  • Fixed cost for the 4 day training which includes all travel, materials, on-site sessions, and a hosted database for each attendee.
  • Training materials is intended for data warehouse developers, application developers who interact closely with the data warehouse through queries, and data warehouse administrators.
  • Training is limited to 10 attendees per session and will be conducted on-site at the client’s facility.

Day 1: Introduction

Learn about massively parallel processing (MPP) architecture. Glance under the hood of Azure SQL DW and understand how it’s put together. Explore table geometry including Distributions, Partitions, and more.  Configure development environment and work through hands-on labs.

Day 2: Development Patterns

Learn common development techniques used with Distributed SQL (DSQL) and Azure SQL DW. Load data into the environment using Polybase. Explore how to migrate existing databases to Azure SQL DW. Work through basic query tuning exercises.

Day 3: Administration

Scale performance of your Azure SQL DW with Data Warehouse Units (DWUs).  Explore concurrency options and the ability to control how many users are able to work at the same time. Monitor performance with graphical interfaces and non-graphical interfaces with DSQL. Take codes samples of basic database maintenance back to your office.

Day 4: Kickstart your Data Warehouse

Learn how to migrate existing ETL to Azure SQL DW compliant development patterns. Explore additional Azure tools and how they integrate with Azure SQL DW. Fire up Power BI and explore data visualization and reporting against massive data. Finish with a facilitate session that can include a look at how your own data will look in Azure SQL DW, or a planning session for migrating a larger solution to Azure. 

WANT TO LEARN MORE ABOUT THIS TRAINING OFFER? 

CONTACT US TODAY!

BLUEGRANITE HANDS-ON LABS

Utilities

Energy

Energy

How much energy should we generate next quarter to meet demand?

Water

Water

Based on previous usage history at this location, how many gallons of water with a new customer will likely use per month?

Fuel

Fuel

How will a cold Winter affect natural gas usage compared to the past few years?

demand-forecasting-icon-retail.png

Retail

Stock

Stock

How many of this item do I expect to sell this month?

Delievry

Delivery

Given that it takes a while to get a delivery, how much of each item should I order?

Customer Traffic

Customer Traffic

How many workers should I schedule based on projected customer traffic today?

demand-forecasting-icon-information-technology.png

Information Technology

Infastructure Utilization

Infastructure Utilization

What level of bandwidth utilization should we expect each day this month?

System Outages

System Outages

Given past history of outages, when is the next outage likely to occur?

Personnel Support

Personnel Support

Given the current trending numbers of employees, how many do we suspect we will have to support next year?