Azure Synapse Analytics Beginner Guide



Advertisements   
   

Azure Synapse Analytics Beginner Guide   Free Tutorial Download

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
Read more course:  The Ins and Outs of ArcGIS Data Analysis

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  Azure Synapse Analytics Beginner Guide  Free

Go to Download Tutorials Page

Password : freetuts.download


Advertisements

Related Courses

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.