Azure Synapse Analytics Beginner Guide

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

What you'll learn

You will learn how to create Synapse Workspace
You will learn how to use Develop Hub in Azure Synapse
You will learn how to create SQL pool for Sql and Spark application
You will learn SQL Analytical functions
you will learn how to Load data in Parquets and CSV files

Requirements

Free Azure Subscription
Basic database concepts

Description

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


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

[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

Who this course is for:

Data Engineer
Data Scientist
Data Analyst or similar profiles
Data Warehouse developers
Anyone who want to learn how to implement these technologies in Azure Cloud
Azure Data engineer
SQL Developer
Big data Solution Architect
Big Data application support team member
Devops Team members