Azure Synapse Analytics - A Data Lakehouse

Overview

Explore Azure Synapse Analytics, a unified service combining data warehousing and Big Data analytics. Learn about its features, scalability, and integration in modern data warehouses through demonstrations.

Syllabus

• Introduction to Azure Synapse Analytics
Overview of Azure Synapse Analytics
Key features and capabilities
Understanding the Data Lakehouse concept
• Architecture and Components
Synapse SQL (serverless and provisioned)
Apache Spark for Synapse
Synapse Pipelines
Synapse Studio
• Data Integration
Data ingestion with Synapse Pipelines
Integration with Azure Data Lake Storage
Working with external data sources
• Data Processing and Management
Querying data with Serverless SQL
Running Big Data transformations with Apache Spark
Managing data with Synapse Workspace
• Scalability and Performance
Data distribution and partitioning
Optimizing query performance
Utilizing Synapse Analytics' scalability features
• Data Security and Compliance
Implementing role-based access control
Data encryption strategies
Monitoring and managing access logs
• Demonstrations and Hands-On Activities
Setting up a Synapse Workspace
Creating and executing SQL queries
Building a data pipeline
Analyzing data with Apache Spark notebooks
• Integration with Modern Data Warehouses
Connecting Synapse with Power BI for visualization
Integrating with Azure Machine Learning
Understanding the role of Synapse in a modern data architecture
• Case Studies and Industry Applications
Real-world examples of Synapse Analytics implementations
Industry-specific use cases
• Final Project
Designing and implementing a data solution using Azure Synapse Analytics
Presentation and evaluation of the data solution
• Course Summary and Next Steps
Recap of key learning points
Resources for further learning and certification preparation

Subjects

Conference Talks