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:
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
Performance Tuning
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
Intended Audience
Data Engineers
Big data Developer
Data Scientist
Solution Architect
Database Developer
SQL Developer
Azure Cloud Engineer
Language
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
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?
Who this course is for:
Beginners in Azure Platform
Data Engineers
Data Scientist
Database and BI developers
Database Administrators
Data Analyst or similar profiles
