Azure SQL Data Warehouse: 4-Day Workshop

BlueGranite

This hands-on, instructor-led training helps data warehouse developers and administrators adopt the MPP architecture found in Azure SQL DW for scalable, high-performance analytics in the cloud.

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 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. 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 and explore how to migrate existing databases to Azure SQL DW.

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.