Azure Synapse Analytics Online Training

Duration35 Days
Mode of TrainingOnline
LevelAdvanced
What is Azure Synapse Analytics?

Azure Synapse Analytics is an enterprise analytics service that accelerates time to insight across data warehouses and big data systems. It brings together the best of SQL technologies used in enterprise data warehousing, Apache Spark technologies for big data, and Azure Data Explorer for log and time series analytics.

What is Azure Synapse and Databricks?

Azure Synapse and Databricks are two of the most popular data warehouse platforms that offer features of ETL pipelines, machine learning, and enterprise data warehousing.

Live Instructor LED Online Training

  • Learn from Certified Experts
  • 100% Real-Time Projects & Use-cases
  • Latest Industry Trend Curriculum
  • Live Projects Implementation
  • Daily Recorded Videos
  • Interview Tips
    • devopssesion

    You may also see course CurriculumAzure Synapse Analytics Course Curriculum

    • Introduction to Azure Synapse Analytics
    • Create Azure Synapse Analytics Workspace
    • Basic Concepts in Azure Synapse Analytics
    • Analyze data with a server less SQL pool and dedicated SQL Pool
    • Analyze data with Server less Spark Pool
    • Analyze data in Storage Account in Azure Synapse Analytics
    • Integrate Pipelines in Azure Synapse Analytics
    • Monitor your Azure Synapse Analytics Workspace
    • Add an Administrator to your Azure Synapse Workspace
    • Azure Synapse SQL Architecture
    • Distributions(Hash, Round Robbin & Replicate)
    • Server less SQL Pool Overview
    • Create External Data source
    • Create External File Format
    • CETAS with Synapse SQL
    • CTAS with Synapse SQL
    • External Tables with Synapse SQL
    • Create and query external tables from a file in ADLS
    • Types of External Tables(Hadoop & Native) in Synapse SQL
    • Administrative accounts in Synapse SQL
    • Create Login and User for Server less SQL Pool
    • Create Login and User for Dedicated SQL Pool
    • Temporary Tables in Synapse SQL
    • Using IDENTITY to create surrogate keys using dedicated SQL pool
    • OPENROWSET() function in Synapse SQL
    • Apache Spark in Azure Synapse Analytics
    • Create a Spark Pool with Azure Portal
    • Create a Notebook in Azure Synapse Analytics
    • Pandas to read/write Azure Data Lake Storage Gen2 data in Apache Spark pool in Synapse Analytics
    • Use FSSPEC to read/write ADLS Gen2 data in Apache Spark pool in Synapse Analytics
    • Different ways to Create Notebooks in Azure Synapse Analytics
    • Use multiple languages in Synapse notebook using magic commands
    • Azure Data Engineering hands-on training
    • Use temp tables to reference data across languages in Synapse
    • notebooks in Azure Synapse
    • %run command to reference another notebook with in current notebook
    • Parameterize Synapse notebook in Azure Synapse Analytics
    • Run Synapse notebook from pipeline | Pass values to Notebook
    • parameters from pipeline in Synapse
    • IPython Widgets in Synapse Notebook in Azure Synapse Analytics