A modern data warehouse lets you bring together all your data at any scale easily, and means you can get insights through analytical dashboards, operational reports, or advanced analytics for all your users. In this workshop you will understand performance issues related to tables, understand table distribution design. We will optimize warehouse query in Azure Synapse Analytics.

The session will focus on Azure services and related products like Azure Synapse Analytics ,Polybase, Azure Synapse Serverless SQL pool & Azure Synapse Dedicated SQL pool. You will use indexes, materialized views & create statistics to improve query performance. Use read committed snapshot for data consistency & optimize common queries with result-set caching.

Further Learning : https://aka.ms/DataQuery-LM

Speaker Info- Jigar pathak

Speaker BIO- Jigar is a Partner & Sr. Solutions Architect with TechScalable has 16+ years’ experience. He has trained more than 2500+ IT professionals across the globe via classroom & virtual session. Professionals trained includes Microsoft Russia, Microsoft Global partners, Infosys, Accenture, Wipro, TCS etc. Delivered Azure certification training under women empowerment program at Saudi Arabia.
Being a Multi-cloud solution architect, he has successfully completed certifications from Microsoft which includes MCSE: Cloud Platform and Infrastructure, MCSA: Cloud Platform Microsoft Certified Solutions Associate, MCT: Microsoft Certified Trainer.

Social Handle-

Facebook- https://facebook.com/jigarshr
LinkedIn- https://www.linkedin.com/in/jigarpathak/
Twitter- https://twitter.com/jigarshr