Eshant Garg
Data Engineer, Architect, Advisor
[Link]@[Link]
Expected Outcomes
• Microsoft Synapse Analytics Service
• Traditional vs Modern vs Synapse Architecture differences
• MPP, Partitioning, Sharding patterns, Distribution keys, etc.
• PolyBase, Data Migration, Security, etc
• Configuration, Backups, Pricing, Monitoring, etc.
• 100% syllabus covered for DP-200/201 certifications
What’s inside
• PPTs
• Demo Resources
• Imp Links
• Certification questions
• Assessment etc.
Intended Audience
• SQL Developers
• BI Developers
• DBAs
• Anyone who wants to start learning warehousing and Data Engineering in cloud
Prerequisites
• Basic T-SQL and Database concepts
• Azure Free trial Subscription
Course Overview
• What is Azure Synapse Analytics service
• Data Warehouse Crash course – at the end of course
• Why Data Warehousing in Cloud
• Traditional vs Modern vs Synapse DW Architecture
• Provision, Configure and Scale Synapse Service
• MPP, Table types, Partitioning, etc.
• Data Migration Techniques, PolyBase
• Security layers
• Configuration & Common tasks
• Backup and Restore
• Pricing, Managing Workloads, etc.
• Monitoring, Resource Health, Support, etc.
