DP-3012 Implementing a Data Analytics Solution with Azure Synapse Analytics
5 Based on 213 reviews- 231,205 Learners
- 287 Courses
This is a single day Instructor Lead Course designed to give the learners instruction on the SQL dedicated and serverless Spark pools and providing instruction of data wrangling and the ELT process using Synapse Pipelines which is very similar to those familiar with Azure Data Factory (ADF) to move data into the Synapse dedicated pool database.
Request More InfoWho should attend DP-3012 Implementing a Data Analytics Solution with Azure Synapse Analytics Course
The Audience should have familiarity with notebooks that use different languages and a Spark engine, such as Databricks, Jupyter Notebooks, Zeppelin notebooks, and more. They should also have some experience with SQL, Python, and Azure tools, such as Data Factory.
Prerequisites for DP-3012 Implementing a Data Analytics Solution with Azure Synapse Analytics Course
DP-3012 Implementing a Data Analytics Solution with Azure Synapse Analytics Course Outline
- What is Azure Synapse Analytics
- How Azure Synapse Analytics works
- When to use Azure Synapse Analytics
- Understand Azure Synapse serverless SQL pool capabilities and use cases
- Query files using a serverless SQL pool
- Create external database objects
- Get to know Apache Spark
- Use Spark in Azure Synapse Analytics
- Analyze data with Spark
- Visualize data with Spark
- Understand Delta Lake
- Create Delta Lake tables
- Create catalog tables
- Use Delta Lake with streaming data
- Use Delta Lake in a SQL pool
- Design a data warehouse schema
- Create data warehouse tables
- Load data warehouse tables
- Query a data warehouse
- Understand pipelines in Azure Synapse Analytics
- Create a pipeline in Azure Synapse Studio
- Define data flows
- Run a pipeline
- Understand Azure Synapse serverless SQL pool capabilities and use cases
- Query files using a serverless SQL pool
- Create external database objects
- Transform data files with the CREATE EXTERNAL TABLE AS SELECT statement
- Encapsulate data transformations in a stored procedure
- Include a data transformation stored procedure in a pipeline
- Understand lake database concepts
- Explore database templates
- Create a lake database
- Use a lake database
- Choose an authentication method in Azure Synapse serverless SQL pools
- Manage users in Azure Synapse serverless SQL pools
- Manage user permissions in Azure Synapse serverless SQL pools
- Get to know Apache Spark
- Use Spark in Azure Synapse Analytics
- Analyze data with Spark
- Visualize data with Spark
- Modify and save dataframes
- Partition data files
- Transform data with SQL
- Understand Delta Lake
- Create Delta Lake tables
- Create catalog tables
- Use Delta Lake with streaming data
- Use Delta Lake in a SQL pool
- Design a data warehouse schema
- Create data warehouse tables
- Load data warehouse tables
- Query a data warehouse
- Load staging tables
- Load dimension tables
- Load time dimension tables
- Load slowly changing dimensions
- Load fact tables
- Perform post load optimization
- Scale compute resources in Azure Synapse Analytics
- Pause compute in Azure Synapse Analytics
- Manage workloads in Azure Synapse Analytics
- Use Azure Advisor to review recommendations
- Use dynamic management views to identify and troubleshoot query performance
- Understand network security options for Azure Synapse Analytics
- Configure Conditional Access
- Configure authentication
- Manage authorization through column and row level security
- Manage sensitive data with Dynamic Data Masking
- Implement encryption in Azure Synapse Analytics
- Understand pipelines in Azure Synapse Analytics
- Create a pipeline in Azure Synapse Studio
- Define data flows
- Run a pipeline
- Understand Synapse Notebooks and Pipelines
- Use a Synapse notebook activity in a pipeline
- Use parameters in a notebook
Resources
FAQs on DP-3012 Implementing a Data Analytics Solution with Azure Synapse Analytics
Participants should be familiar with notebooks using different languages and a Spark engine (e.g., Databricks, Jupyter, Zeppelin), and have experience with SQL, Python, and Azure tools like Data Factory.
This course is designed for data professionals with experience in Spark-based notebooks, SQL, Python, and Azure tools who want to build data analytics solutions using Azure Synapse Analytics.
The course covers Azure Synapse Analytics fundamentals, querying data lakes with serverless SQL pools, analyzing data with Apache Spark, using Delta Lake, building relational data warehouses, and creating data pipelines.
You will learn to query and analyze data using serverless SQL pools and Spark, implement Delta Lake for data storage, design and query relational data warehouses, and build data pipelines within Azure Synapse Analytics.
Yes, the course includes a dedicated module on building data pipelines in Azure Synapse Analytics, providing practical experience in orchestrating data workflows.