MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 58 lectures (2 hour, 23 mins) | Size: 772 MB

What will students learn in this course?

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

Bners

Intended Audience

Data Eeers

Big data Developer

Data Scientist

Solution Architect

Database Developer

SQL Developer

Azure Cloud Eeer

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 Bner 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 Run

How to use Manage Access control

How to use Manage Integration Run

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:

Bners in Azure Platform

Data Eeers

Data Scientist

Database and BI developers

Database Administrators

Data Analyst or similar profiles

Who this course is for:

Data Eeer

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 eeer

SQL Developer

Big data Solution Architect

Big Data application support team member

Devops Team members



DOWNLOAD
uploadgig