Azure Synapse Analytics Beginner Guide

Azure Synapse Analytics Beginner Guide

You will learn how to use Azure synapse Analytics ,synapse studio, synapse Analytical functions, Sql spool and Spark.

What will you learn in this course?

  • What is Synapse Analytics
  • Azure Synapse Integrity With Azure Ecosystem
  • Azure Synapse Advantage and Limitations
  • Modern Data warehouse Architecture
  • How to Create Azure Synapse Workspace
  • Create SQL Pool Azure Synapse Workspace
  • Azure Synapse Analytics Studio
  • Synapse Studio Activity Hub Details
  • Synapse Studio Data Hub
  • Develop Hub- Power BI

Analytical functions

  • LAG
  • LEAD
  • FIRST_VALUE
  • LAST_VALUE
  • CUME_DIST
  • PERCENTILE_COUNT
  • PERCENTILE_DISC
  • PERCENTILE_RANK
  • SNAPSHOT ISOLATION
  • READ/WRITE/MODIFY JASON DATA
  • STORED PROCEDURES
  • INDEXES
  • COLUMNSTORE INDEXES

Synapse Analytics : SQL on demand

  • Machine Learning Enable DW
  • Data Lake integration
  • Azure Data Share
  • DQP
  • SQL On Demand
  • SQL On Demand CSV Files
  • SQL Query Json Files

Azure Synapse Analytics -Architecture overview in Spark

  • Synapse Job service
  • Synapse Spark Instance workflow
  • Creating Spark Pool
  • JDBC and Polybase
  • Create Notebook on files storage
  • Library Management-Python

Level

  • Beginners

Intended Audience

Data Engineers

Big data Developer

Data Scientist

Solution Architect

Database Developer

SQL Developer

Azure Cloud Engineer

Language

  • English
  • If you are not comfortable in English, please do not take a course, captions are not good enough to understand the course.

Expected Outcomes

In this course

  • You will learn Azure synapse Analytics basic feature  advantage and limitation
  • You will learn Modern data warehouse architecture
  • You will learn how to create the Syanpse workspace
  • You will learn how to use SQL Pool in azure Synapse
  • You will learn how to use Synapse Studio
  • You will learn how to use Synapse Activity Hub
  • You will learn how to use Synapse Data Hub

Prerequisites

  • Basic  Database concepts
  • Azure Free trial Subscription

Course In Detail

Azure Synapse Analytics  Beginner guide Full module

  • You will learn the Azure synapse basic details and Synapse Studio details
  • How use Synapse studio Activity Hub
  • How to use Synapse Studio Data Hub
  • How can use Synapse data hub for Storage account
  • Synapse Developer hub benefits
  • How to use developer Hub notebook
  • How to use Developer hub Dataflow
  • Tunning the Develop Hub -Data Flows Optimize
  • Synapse Studio –Monitor Hub
  • How to use Manage Linked Service
  • How to is use Manage Integration Runtime
  • How to use Manage Access control
  • How to use Manage Integration Run time
  • Data Movement
  • Sql Analytics Functions
  • LAG

    LEAD

    FIRST_VALUE

    LAST_VALUE

    CUME_DIST

    PERCENTILE_COUNT

    PERCENTILE_DISC

    PERCENTILE_RANK

    SNAPSHOT ISOLATION

    READ/WRITE/MODIFY JASON DATA

    STORED PROCEDURES

    INDEXES

    COLUMNSTORE INDEXES

  • Synapse Job service
  • Synapse Spark Instance workflow
  • Creating Spark Pool
  • JDBC and Polybase
  • Create Notebook on files storage
  • Library Management-Python

[100% OFF Limited Time!]

Udemy Coupon Code : https://www.udemy.com/course/azure-synapse-analytics-beginner-guide/?couponCode=AZURE_SYNAPSE_FREE