Azure Synapse is a scalable analytics service that brings together enterprise data warehousing and Big Data analytics. This deep dive shows you how to perform data engineering and exploration, build automated data integration pipelines, run interactive queries using serverless SQL pools, and optimize a data warehouse with dedicated SQL pools. Finally, you will learn the end-to-end Azure Machine Learning and Azure Cognitive experience in Azure Synapse Analytics.
- Configure workload management to prioritize large-scale data loading
- Load data into a dedicated SQL pool using a copy activity in a pipeline
- Load and transform poorly-formatted files with mapping data flows
- Load, transform, and join NoSQL and flat files into a dedicated SQL pool and data lake
- Orchestrate code-free data transformations and Apache Spark-based transformations in a pipeline