Azure Synapse Analytics Beginner Guide
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 772 MB
Genre: eLearning Video | Duration: 58 lectures (2 hour, 39 mins) | Language: English
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
Download link:
Só visivel para registados e com resposta ao tópico.Only visible to registered and with a reply to the topic.Links are Interchangeable - No Password - Single Extraction
Cantinho Satkeys
