Introduction To Azure Synapse Analytics

Important Note:

Please note that this is NOT a full course but Two module of the full-length course, and intended to cover very basic fundamental concepts for Azure Synapse Analytics.

This module is NOT GOOD for you if:

• You are already experienced in this technology

• You are looking for an intermediate or advance concepts

• You are looking for practical examples or demo

This module is GOOD for you if:

• You want to understand the basic fundamental concepts of hot technology Azure Synapse Analytics

This is a free module to help others. If you are not in the intended audience, I request you to please feel free to unenroll.

Where I can find a full-length course?

Please look at the bonus lecture in the end.

What will students 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

[Note]: This is the free version of this course. In case if  you are interested to learn below synapse topics further, you can look at my profile for the full version of this course.

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

Performance Tuning

• TABLE DISTRIBUTION

• TABLE PARTITIONS

• MATERIALIZED VIEW

• COPY COMMANDS

• RESULT SET CACHING

• RESOURCE CLASSES

• DYNAMIC MANAGEMENT VIEWS

• AZURE DATA SHARE

• DQP

• SQL ON DEMAND QUERY JSON_VALUE

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 Mordern 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

[Tags]

Microsoft SQL Server, Azure SQL Server, Azure SQL Data Warehouse, Data Factory, Data Lake, Azure Storage, Azure Synapse Analytics Service, PolyBase, Azure monitoring, Azure Security, Data Warehouse, SSIS

Are there any course requirements or prerequisites?

• Basic Database concepts

• Azure Free trial Subscription

Who this course is for:

• Beginners in Azure Platform

• Data Engineers

• Data Scientist

• Database and BI developers

• Database Administrators

• Data Analyst or similar profiles