Introduction To Azure Synapse Analytics

About 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