Introduction To Azure Synapse Analytics

You will learn how to use Azure synapse Analytics ,synapse studio,synapse Analytical functions and many more

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