Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
IT & Software Other IT & Software Microsoft Azure

Azure Synapse Analytics Beginner Guide

You will learn how to use Azure synapse Analytics ,synapse studio,synapse Analytical functions,Sql spool and Spark
Rating: 3.4 out of 53.4 (14 ratings)
3,777 students
Created by Ripan Roy
Last updated 7/2020
English
English [Auto]
30-Day Money-Back Guarantee

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

Course content

6 sections • 58 lectures • 2h 39m total length

  • Preview02:35
  • Preview03:22
  • Azure Synapse Integration
    02:18
  • Azure Synapse Advantage and Limitation
    02:47
  • Mordern Datawarehouse Architecture
    03:05
  • Preview02:04
  • Synapse SQL Pool
    03:08
  • Practical Demo:Synapse Workspace Creation
    03:55

  • Synapse Analytical Studio Features
    02:18
  • Synapse Studio Activity Hub
    02:04
  • Preview02:33
  • Synapse Studio Data Hub
    04:21
  • Synapse Studio and Power Bi Integration
    02:46
  • Summary
    02:10
  • Synapse Advantage
    2 questions

  • Introduction
    01:24
  • Manage Linked service
    02:56
  • Synapse_Studio_Manage Hub
    02:33
  • Manage Access Control
    04:19
  • Preview02:03
  • Synapse Data Movement
    02:43
  • Synapse Pipeline
    03:31
  • Synapse Trigger
    02:09
  • How to create Linked Services
    02:18
  • Practical Demo : How to Create ADF(Azure Data Factory)
    02:26
  • Summary
    01:37
  • Trigger
    2 questions

  • Introduction
    02:44
  • Lag And Lead Functions
    01:57
  • First_Value and Last_Value
    02:14
  • Preview02:07
  • Percentile Disc
    02:40
  • Approx_Count_Distinct functions
    02:13
  • Percentile_Cont Functions
    02:46
  • Percent_Rank Functions
    02:10
  • Group_By_Rollup Functions
    01:42
  • Snapshot Isolation
    03:24
  • Json Read Update Insert
    05:55
  • Synapse Stored Procedure
    01:55
  • Summary
    01:45
  • Json format
    2 questions

  • Introduction
    01:36
  • Machine Learning Enable Data warehouse
    02:09
  • Preview04:25
  • Azure Data Share
    02:33
  • DQP
    02:09
  • SQL on Demand
    03:05
  • SQL ON Demand CSV Files
    03:28
  • Preview02:33
  • Practical Demo: How To Create SQLDatawarhouse in Azure Synapse
    02:39
  • Summary
    01:32
  • Azure Data Share
    2 questions

  • Introduction
    02:30
  • Synapse Spark Architecture
    05:11
  • Spark Spool
    03:12
  • Polybase In Spark
    03:22
  • Create Notebook In File Storage
    04:15
  • Python Library Management
    02:23
  • Power-Bi and Synapse Performance Analysis
    02:45
  • External Table Select Statement
    02:32
  • Practical Demo: How To Create HDinsight Cluster in Spark
    03:51
  • Summary
    02:00
  • Polybase In Spark
    2 questions

Instructor

Ripan Roy
Azure Data Architect | Big Data Architect
Ripan Roy
  • 3.4 Instructor Rating
  • 31 Reviews
  • 5,611 Students
  • 2 Courses

CERTIFICATIONS


- Microsoft Certified solution architect (AZ300)

- Information Technology Infrastructure Library (ITIL V3) Certified

SPECIALITY


Azure : Data Lake, Data Factory, Synapse Analytics Service(DW)

Big Data Tech : HDInsgiht, Databricks, Hadoop, Spark, PySpark, Hive, Sqoop

Hadoop Technology : Cloudera and Hortronworks Working knowledge

Database versions : Microsoft SQL Server 2005-2016, NoSQL


Languages : T-SQL, USQL, Python,   PySpark


BI Tools :  Power BI


ETL : Inforamtica/BODS


I have been working data warehousing ,Data warehousing and Azure synapse for around more than 12 years industry experience. I love to Cloud technologies, performance tuning, and optimization, Database design, modeling and Azure database and analytics technologies.

I helped multiple client  End to End Implementations of many Big data projects and Cloud computing projects, requirements gathering, specification documentation, functional/technical design, Data modeling & solution architecture.



  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.