Azure Synapse Analytics Beginner Guide

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