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+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native 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 Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing 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
Teaching & Academics Online Education Microsoft Azure

Introduction To Azure Synapse Analytics

You will learn how to use Azure synapse Analytics ,synapse studio,synapse Analytical functions and many more
Rating: 3.6 out of 53.6 (14 ratings)
2,437 students
Created by Ripan Roy
Last updated 8/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

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:

  • You want to understand the basic fundamental concepts of hot technology Azure Synapse Analytics

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

  • 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

Performance Tuning

  • TABLE DISTRIBUTION

  • TABLE PARTITIONS

  • MATERIALIZED VIEW

  • COPY COMMANDS

  • RESULT SET CACHING

  • RESOURCE CLASSES

  • DYNAMIC MANAGEMENT VIEWS

  • AZURE DATA SHARE

  • DQP

  • SQL ON DEMAND QUERY JSON_VALUE

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 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

  • 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

3 sections • 16 lectures • 39m total length

  • Preview02:35
  • What will be Covered in this Module
    00:26
  • Preview03:22
  • Preview02:18
  • Preview02:47
  • Mordern Datawarehouse Architecture
    03:05
  • Synapse Workspace
    02: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
  • Synapse Studio Manage Hub
    02:33
  • Synapse Studio Data Hub
    04:21
  • Synapse Studio and Power Bi Integration
    02:00
  • Summary
    02:10
  • Azure Synapse Advantages
    2 questions

  • Bonus Lecture
    00:14

Instructor

Ripan Roy
Azure Data Architect | Big Data Architect
Ripan Roy
  • 3.5 Instructor Rating
  • 28 Reviews
  • 5,603 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.