Highlights
- Query data in the lake
- Create metadata objects
- Secure data and manage users
- Understand big data engineering
- Transform data with DataFrames in Apache Spark pools with Databricks
- Integrate SQL and Apache Spark pools within Azure Synapse Analytics and Databricks
- Use data loading best practice
- Petabyte-scale ingestion with Azure Data Factory or Azure Synapse Pipelines
- Data integration
- Code-free transformation at scale
- Orchestrate data movement and transformation
- Secure a data warehouse in Azure Synapse Analytics
- Implement compliance controls for sensitive data
- Design hybrid transactional and analytical processing
- Configure Azure Synapse Link with Azure Cosmos DB
- Query Azure Cosmos DB
Course Details
- Introduction to Azure Synapse Analytics
- Explore Azure Synapse serverless SQL pools capabilities
- Query data in the lake using Azure Synapse serverless SQL pools
- Create metadata objects in Azure Synapse serverless SQL pools
- Secure data and manage users in Azure Synapse serverless SQL pools
- Understand big data engineering with Apache Spark in Azure Synapse Analytics
- Ingest data with Apache Spark notebooks in Azure Synapse Analytics
- Transform data with DataFrames in Apache Spark Pools in Azure Synapse Analytics (databricks)
- Integrate SQL and Apache Spark pools in Azure Synapse Analytics (databricks)
- Use data loading best practices in Azure Synapse Analytics
- Petabyte-scale ingestion with Azure Data Factory or Azure Synapse Pipelines
- Data integration with Azure Data Factory or Azure Synapse Pipelines
- Code-free transformation at scale with Azure Data Factory or Azure Synapse Pipelines
- Orchestrate data movement and transformation in Azure Data Factory or Azure Synapse Pipelines
- Secure a data warehouse in Azure Synapse Analytics
- Implement compliance controls for sensitive data
- Design hybrid transactional and analytical processing using Azure Synapse Analytics
- Configure Azure Synapse Link with Azure Cosmos DB
- Query Azure Cosmos DB with Apache Spark for Azure Synapse Analytics
- Query Azure Cosmos DB with SQL serverless for Azure Synapse Analytics
Who should attend
Data and Analytics professionals who need to use Azure Synapse to accelerate time to insight across data warehouses and big data systems.
Feedback
4.8 out of 5 average
“I liked the theory element of the course which gave me a good understanding of the role of databricks and a data factory and how they could be useful on my projects.”
JS, Data analyst
“It was a very useful two days introduction to Azure and I thought the labs were really helpful to get some hands on experience using the tools. The trainer was very helpful and patient in helping with issues arising with the lab exercises.”
JM, Insights analyst
