Course Overview:

Azure Synapse Analytics, Microsoft’s unified platform for data integration, data warehousing, and big data analytics, is used in the DP-3012 course to assist data professionals in developing and implementing end-to-end analytics solutions. 
 
This course offers comprehensive instruction on the design, development, and implementation of scalable analytics solutions that effectively manage enormous data volumes. Key Synapse components, including dedicated and serverless SQL pools, pipelines, Power BI connectivity, and Apache Spark interaction, will be covered. This is a one-day instructor-led course that teaches students about SQL dedicated and serverless Spark pools, data wrangling, and the ELT process using Synapse Pipelines, which is very similar to those who know how to move data into the Synapse dedicated pool database using Azure Data Factory (ADF). 

After completing this course, students will be able to:

  • Design and implement modern data warehouse and lakehouse architectures using Azure Synapse Analytics.
  • Ingest, transform, and orchestrate data workflows with Synapse pipelines and integration runtimes.
  • Leverage Apache Spark and SQL pools (dedicated and serverless) to analyze structured and unstructured data at scale.
  • Optimize performance and manage resource usage and costs within Synapse Analytics.

Upcoming Batches

Loading Dates...

Key Features:

  • Comprehensive Coverage: Learn about Azure Synapse Analytics from beginning to end, including data intake and transformation, warehousing, security, and connection with Power BI and other tools. 

  • Hands-on Practical Exercises: Practical labs and supervised exercises that mimic typical situations utilizing Spark, SQL pools, Synapse pipelines, and Azure Data Lake will help you solidify your understanding. 

  • Focus on role-based learning: The content is specifically designed for data professionals, guaranteeing that it is in line with the practical duties and responsibilities needed in contemporary data engineering and analytics positions. 

  • Career Advancement: Azure credentials and practical abilities, which are highly sought after by organizations seeking to modernize their data systems, will help you elevate your professional profile. 

Who should Attend?

  • Data Engineers looking to build scalable data pipelines and analytics solutions in Azure Synapse.
  • Data Analysts and BI Professionals seeking to enhance their understanding of integrating Synapse with Power BI and other reporting tools.
  • Database Administrators interested in expanding into cloud-based data warehousing and big data analytics.
  • Solution Architects design end-to-end data solutions involving data lakes, warehouses, and real-time analytics.
  • Developers and Technical Specialists working with SQL, Python, Spark, and Azure tools who want to deepen their cloud data expertise

Prerequisites:

  • Familiarity with notebook-based development environments that utilize Spark engines, such as Databricks, Jupyter Notebooks, Zeppelin, or similar platforms.
  • Basic to intermediate experience with programming languages commonly used in data analytics, particularly SQL and Python.
    • Working knowledge of Azure data services, especially tools like Azure Data Factory, and general experience with the Azure portal.

    Why choose CloudThat as your training partner?

    • Expert Instructors: CloudThat’s instructors are highly experienced and certified professionals with in-depth knowledge of Azure Synapse Analytics and data engineering principles. They provide top-notch training and guidance throughout the preparation process.
    • Comprehensive Course Content: CloudThat offers a well-structured and comprehensive course curriculum that covers all the essential topics needed to excel in Azure Synapse Analytics.
    • Hands-on Labs: CloudThat emphasizes hands-on learning through practical exercises and real-world scenarios, allowing candidates to gain practical experience working with Azure Synapse Analytics.
    • Flexibility: CloudThat offers flexible training options, including online and in-person classes, allowing candidates to choose the mode of learning that suits their schedule and preferences.
    • Track Record: CloudThat has a proven track record of success in training and preparing candidates for various cloud and data certifications, including Data Analytics Solution with Azure Synapse Analytics.

    Learning objectives of the course

    • Understand Azure Synapse Analytics Architecture: Learn about the fundamental elements and features of Azure Synapse Analytics, such as its architecture and how it solves different business issues.
    • Query Data Using Serverless SQL Pools: To construct external database objects and query files in a data lake that support CSV, JSON, and Parquet formats, use Azure Synapse serverless SQL pools.
    • Analyze Data with Apache Spark: Use Spark notebooks to load, examine, and display data by utilizing Apache Spark in Azure Synapse Analytics.
    • Implement Delta Lake: Learn how to create Delta Lake tables, handle streaming data, and query Delta Lake tables from SQL pools, among other Azure Synapse Analytics features.
    • Design and Query Relational Data Warehouses: Create fact and dimension tables, import data, design relational data warehouse structures, and run SQL queries.
    • Build Data Pipelines: To coordinate data transportation and transformation, create and manage data pipelines in Azure Synapse Studio, specify data flows, and execute pipelines.

    Course Outline Download Course Outline

    Introduction to Azure Synapse Analytics

    • What is Azure Synapse Analytics
    • How Azure Synapse Analytics works
    • When to use Azure Synapse Analytics
    • Lab - Explore Azure Synapse Analytics

    Use Azure Synapse serverless SQL pool to query files in a data lake

    • Understand Azure Synapse serverless SQL pool capabilities and use cases
    • Query files using a serverless SQL pool
    • Create external database objects
    • Lab - Query files using a serverless SQL pool

    Analyze data with Apache Spark in Azure Synapse Analytics

    • Get to know Apache Spark
    • Use Spark in Azure Synapse Analytics
    • Analyze data with Spark
    • Visualize data with Spark
    • Lab - Analyze data with Spark

    Use Delta Lake in Azure Synapse Analytics

    • Understand Delta Lake
    • Create Delta Lake tables
    • Create catalog tables
    • Use Delta Lake with streaming data
    • Use Delta Lake in a SQL pool
    • Lab - Use Delta Lake in Azure Synapse Analytics

    Analyze data in a relational data warehouse

    • Design a data warehouse schema
    • Create data warehouse tables
    • Load data warehouse tables
    • Query a data warehouse
    • Lab - Explore a data warehouse

    Build a data pipeline in Azure Synapse Analytics

    • Understand pipelines in Azure Synapse Analytics
    • Create a pipeline in Azure Synapse Studio
    • Define data flows
    • Run a pipeline
    • Lab - Build a data pipeline in Azure Synapse Analytics

    Use Azure Synapse serverless SQL pool to query files in a data lake

    • Understand Azure Synapse serverless SQL pool capabilities and use cases
    • Query files using a serverless SQL pool
    • Create external database objects
    • Lab - Query files using a serverless SQL pool

    Use Azure Synapse serverless SQL pools to transform data in a data lake

    • 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
    • Lab - Transform files using a serverless SQL pool

    Create a lake database in Azure Synapse Analytics

    • Understand lake database concepts
    • Explore database templates
    • Create a lake database
    • Use a lake database
    • Lab - Analyze data in a lake database

    Secure data and manage users in Azure Synapse serverless SQL pools

    • 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

    Analyze data with Apache Spark in Azure Synapse Analytics

    • Get to know Apache Spark
    • Use Spark in Azure Synapse Analytics
    • Analyze data with Spark
    • Visualize data with Spark
    • Lab - Analyze data with Spark

    Transform data with Spark in Azure Synapse Analytics

    • Modify and save dataframes
    • Partition data files
    • Transform data with SQL
    • Lab: Transform data with Spark in Azure Synapse Analytics

    Use Delta Lake in Azure Synapse Analytics

    • Understand Delta Lake
    • Create Delta Lake tables
    • Create catalog tables
    • Use Delta Lake with streaming data
    • Use Delta Lake in a SQL pool
    • Lab - Use Delta Lake in Azure Synapse Analytics

    Analyze data in a relational data warehouse

    • Design a data warehouse schema
    • Create data warehouse tables
    • Load data warehouse tables
    • Query a data warehouse

    Load data into a relational data warehouse

    • Load staging tables
    • Load dimension tables
    • Load time dimension tables
    • Load slowly changing dimensions
    • Load fact tables
    • Perform post load optimization
    • Lab - load data into a relational data warehouse

    Manage and monitor data warehouse activities in Azure Synapse Analytics

    • 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

    Secure a data warehouse in Azure Synapse Analytics

    • Understand network security options for Azure Synapse Analytics
    • Configure Conditional Access
    • Configure authentication
    • Manage authorization through column and row level security
    • Exercise - Manage authorization through column and row level security
    • Manage sensitive data with Dynamic Data Masking
    • Implement encryption in Azure Synapse Analytics

    Build a data pipeline in Azure Synapse Analytics

    • Understand pipelines in Azure Synapse Analytics
    • Create a pipeline in Azure Synapse Studio
    • Define data flows
    • Run a pipeline
    • Lab- Build a data pipeline in Azure Synapse Analytics

    Use Spark Notebooks in an Azure Synapse Pipeline

    • Understand Synapse Notebooks and Pipelines
    • Use a Synapse notebook activity in a pipeline
    • Use parameters in a notebook
    • Lab - Use an Apache Spark notebook in a pipeline.

    Certification details:

    • Candidates who successfully complete the DP-3012 Microsoft Azure Applied Skills training are awarded a certificate of course completion.
    • Earning the Microsoft Azure DP-3012 Applied Skill Credential validates your ability to implement real-time analytics solutions using Azure Stream Analytics.
    • In the DP-3012 Applied Skills course, you will learn how to ingest, process, and analyze streaming data with Azure Stream Analytics and related Azure services.
    • Applied Skills credentials can serve as a foundation to prepare for more specialized or role-based Azure certifications.
    • Candidates also receive an official Microsoft credential upon passing the Microsoft Azure DP-3012 Applied Skills assessment.

    Click to Zoom

    Select Course date

    Loading Dates...
    Add to Wishlist

    Course ID: 25164

    Course Price at

    Loading price info...
    Enroll Now

    FAQs :

    The DP-3012: Implementing a Data Analytics Solution with Azure Synapse Analytics course is a one-day, instructor-led Microsoft training designed to teach data professionals how to build, manage, and optimize analytics solutions using Azure Synapse Analytics.

    This course is ideal for: Data Engineers Data Analysts Data Scientists

    Familiarity with notebook-based development environments that utilize Spark engines. Basic to intermediate experience with programming languages. Working knowledge of Azure data services.

    Data professionals can gain practical experience developing end-to-end analytics solutions with Azure Synapse by enrolling in the DP-3012: Implementing a Data Analytics Solution with Azure Synapse Analytics course. By the end of the course, students will be able to use serverless SQL pools to query data in a data lake and comprehend the architecture and essential elements of Azure Synapse Analytics. They will have hands-on experience utilizing Apache Spark notebooks for data transformation and analysis.

    No, you do not need your own Azure subscription to attend the DP-3012: Implementing a Data Analytics Solution with Azure Synapse Analytics course. However, if you're taking the course through a provider that does not offer labs, or you're studying the material on your own, then having access to an Azure subscription (either a free trial or a pay-as-you-go account) would be beneficial for practice.

    No, the DP-3012 course is an applied skills training and does not have an associated Microsoft certification exam.

    The DP-3012 course covers the following key areas: Understanding Azure Synapse Analytics architecture and core capabilities Querying data using serverless SQL pools Analyzing data with Apache Spark Implementing Delta Lake for data lakehouse architecture Designing and querying relational data warehouses Building and managing data pipelines using Synapse Pipelines

    Enquire Now