Session room

The Agenda

Agenda Home
SQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.

MPP: Data Warehousing at Scale with SQLDW & APS

Description

Massively Parallel Processing (MPP) database systems are designed to deliver performance at scale. This one day session will give you an excellent foundation in the concepts underpinning MPP. It will also accelerate your development skills and practical experience using Azure SQL Data Warehouse and APS.

This pre-con will contain a number of lab exercises that you will be able to work do both on site and complete at home at your leisure.

JRJ is a Principal Program Manager for Microsoft. His focus and passion is MPP. He developed the APS training course material and co-authored many topics on azure for Azure SQL Data Warehouse.

Topics covered in the days session will include:
  • Conceptual introduction to massively parallel processing (MPP)
  • Data warehouse design
  • Query execution and optimisation
  • Data migration strategies
  • Data integration options and considerations
Technologies covered during the day will include:
  • Analytics Platform System
  • Azure SQL Data Warehouse
  • PolyBase
  • Azure Data Factory
  • Power BI

Learning Objectives

Previous Experience

Tech Covered

performance, Azure, data warehousing, APS, Synapse Analytics