A Data Engineer's Guide to Azure SQL Data Warehouse

with Simon Whiteley & Terry McCann

Description
Level 300 - Advanced

Azure SQL Data Warehouse, Microsoft’s scale out database engine for SQL analytics in the cloud, provides a blazing fast, petabyte-scale system that can handle your most demanding analytical workloads with ease. SQL Data Warehouse takes advantage of the latest Azure hardware technology delivering up to 100x performance boosts on customer workloads. In short, Azure SQL Data Warehouse is a SQL analytics beast!
We have built this all-day pre-con to help you, the data engineer, make the most of all this power that is now at your disposal!
We’ll be bringing you in-depth technical knowledge combined with hands-on implementation experience to help you get the most from the scale out architecture and accelerate the delivery of your projects. We’ll be arming you with theoretical knowledge, hands-on knowledge, best practices, hints and scripts to ensure you leave this training with all the tools you need to be successful.

Agenda:
The day will be broken down into the following modules:

Service Architecture -Discussing the engine itself, core concepts and the basics of using the service
Designing Tables - Best practice data modelling using distributions, partitioning and performance patterns
Loading Data - Patterns for different data loading scenarios and how to optimise them
Querying Data - Deep dive into query performance, execution plans & how to avoid common performance pitfalls
Architecture Patterns - Integration techniques with other Azure components to build SQLDW into a complete architecture

Learn directly from two Data Platform MVPs in a course designed in collaboration with the SQLDW Product Group.
This pre-con will be delivered by Simon Whiteley & Terry McCann from Adatis Consulting. Simon and Terry have delivered several large-scale, real-world SQLDW projects for some of the UK’s largest Azure users to give you additional real world insights that can only be gained through extensive industry experience.

Prerequisites

A prior knowledge of traditional data warehousing is assumed, but not strictly necessary

Terry McCann and Simon Whiteley

Speakers

Terry and Simon are two veteran advanced analytics consultants and are Microsoft MVPs in the Data Platform space. Together they have delivered several large-scale, real-world SQLDW projects for some of the UK’s largest Azure users to give you additional real world insights that can only be gained through extensive industry experience.

Additional information
Lunch, snacks and printed workshop material is included. Registration for the free SQLSaturday event on September 1st must be done through the SQLSaturday #746 Oslo website.

A Data Engineer's Guide to Azure SQL Data Warehouse with Simon Whiteley & Terry McCann

Follow this organizer to stay informed on future events

Events you might like

PQC migration in practicePQC migration in practice

PQC migration in practicePQC migration in practice

PQC migration in practice

PQC migration in practice