kr2,624.75

A Data Engineer's Guide to Azure SQL Data Warehouse with Simon Whiteley & T...

Event Information

Share this event

Date and Time

Location

Location

EVRY

Snarøyveien 30A

1320 Fornebu

Norway

View Map

Refund Policy

Refund Policy

No Refunds

Event description

Description

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.

Share with friends

Date and Time

Location

EVRY

Snarøyveien 30A

1320 Fornebu

Norway

View Map

Refund Policy

No Refunds

Save This Event

Event Saved