Register
Plans
Register
Plans

Azure Synapse Analytics Unleased for SQL Pool

Navigate to Course
Rate and Review

You can share it with others

Azure Synapse AnalyticsThis course has free componentsCovers:-Azure Synapse Analytics from end to end perspectiveTotal Time:- 3 HoursSession:- RecordedThe course covers:-1. Introduction to Azure Synap......
View More
Azure Synapse Analytics Unleased for SQL Pool

Azure Synapse AnalyticsThis course has free componentsCovers:-Azure Synapse Analytics from end to end perspectiveTotal Time:- 3 HoursSession:- RecordedThe course covers:-1. Introduction to Azure Synapse Analytics and get you started with you first azure synapse analytics workspace2. Data Distribution Strategy and Best Practices3. Index Option, Columnstore Index, Best PracticesDownload Course catalogue.** Completely voluntary, based on the interview and  performance in the course

Close
    Recorded

FREE

Navigate to Course
Welcome
##login_user##

You have requested to attent Azure Synapse Analytics Unleased for SQL Pool.

Attend

Or Register below by entering your details:-


To raise question, join our telgram channel now.
By Registering You Agree To Our Terms , Condition and Disclaimer.

  • Introduction and Getting Started with Azure Synapse Analytics
    Price : Free
    Self Paced
    Launched on
    Saturday, 01 May 2021

    Speaker : Arshad Ali

    View Description

    Introduction and Getting Started with Azure Synapse Analytics

    1.Introduction and need for modern data warehouse
    2.Azure Synapse Analytics - Introduction
    3.Azure Synapse Analytics - Architecture and its components
    4.SMP (Symmetric Multiprocessing) vs MPP (Massively Parallel Processing)
    5.Azure Synapse Analytics - SQL pool architectural components
    6.Azure Synapse Analytics - Getting Started
    7.Serverless SQL pool and dedicated SQL pool
    8.Connecting to your SQL pool from SQL Server Management Studio
    9.Deploy Sample Databases
    10.Connecting to your SQL pool from Azure Data Studio
    11.Walkthrough of Synapse Studio and connecting to SQL pool

    Close

  • Data Distribution Strategy and Best Practices
    Price : Free
    Self Paced
    Launched on
    Sunday, 02 May 2021

    Speaker : Arshad Ali

    View Description

    Data Distribution Strategy and Best Practices

    1.Introduction of distributed system and data distribution
    2.Table types in SQL pools
    3.Round Robin Distribution - Introduction
    4.Hash Distribution - Introduction
    5.Concept of distribution and how it maps to compute nodes
    6.Round Robin Vs Hash - Example and performance differences
    7.Round Robin Vs Hash - Analyze execution plans
    8.Round Robin Vs Hash - Join Compatibility
    9.Hash Distribution - Data skewness
    10.Round Robin - Best Practices and Guidelines
    11.Hash Distributed - Best Practices and Guidelines
    12.Replicated Table - Introduction, Best Practices and Guidelines
    13.Replicated Table - Example

    Close

  • Index Options | Column store Index | Best Practices
    Price : Free
    Self Paced
    Launched on
    Monday, 03 May 2021

    Speaker : Arshad Ali

    View Description

    Index Options | Column store Index | Best Practices

    1.Introduction
    2.Rowstore indexes vs Columnstore index
    3.Heap and when to use it
    4.Clustered and Non-clustered Index and when to use it
    5.Columnstore index - design and storage
    6.Practical example of creating these types of indexes
    7.Columnstore deep dive
    8.Practical example of columnstore index storage
    9.Columnstore index - updates of data
    10.Practical example of making data updates to clustered columnstore index table
    11.Guidelines for choosing right type of indexes
    Index Options | Columnstore Index | Best Practices

    Close

  • Azure Synapse Analytics | Table Partition | Best Practices
    Price : Free
    Self Paced
    Launched on
    Tuesday, 27 July 2021

    Speaker : Arshad Ali

    View Description

    Azure Synapse Analytics | Table Partition | Best Practices

    Table partitioning is a powerful feature to optimize the performance of data load and data querying. This feature is available with almost all the data platform technologies we have available today and Azure Synapse Analytics – SQL pool is no exception here.

    In this video, you will learn about Table partition, how it works and how it helps in both data load (or data lifecycle management) and data querying and finally what are important considerations for using this feature in SQL pool, in particular.

    1.Table Partition - Introduction
    2. Data Lifecycle Management with Partition Switch-In and Switch Out
    3. Range Partitioning - Right Range vs Left Range
    4.Demo - Table Partition
    5.Demo - Data Load, Data Archival, and Partition Split
    6. Demo - SQL pool considerations
    7.Table Partition - Guidelines and Best Practices for dedicated SQL pool

    Thank you for watching, in my next video, I am going to talk in detail about workload management and concurrency – an important concept and consideration when working with SQL pool. Stay tuned.

    Close

  • Azure Synapse Analytics | Workload Management and Concurrency
    Price : Free
    Self Paced
    Launched on
    Wednesday, 28 July 2021

    Speaker : Arshad Ali

    View Description

    Azure Synapse Analytics | Workload Management and Concurrency

    In any data warehouse system, there are different types of workloads – in broad categories, we can say there is one to load and process data, and there is another one for data querying. Even within these broad categories, there might be few requests which require high importance and more resources than others. For example, there might be critical data load which needs to be completed within tight SLA with high priority, yet there might be other data load which can wait or okay to take longer. Likewise, there might be some queries which have higher priority than others, for example the ones which are coming from your leadership teams for timely decision making than day to day operational reports.

    In this video, you will learn about workload management, what it is, what are options and how it works in dedicated SQL pool.

    1. Workload Management - Introduction
    2.Resource Classes - Static vs Dynamic Resource Classes
    3.Workload Management - New Feature
    4.Workload Management - Isolation
    5.Workload Management - Classification
    6.Workload Management - Importance
    7.Demo - Resource Classes
    8.Demo - Workload Management (Isolation, Importance and Classification)

    Thank you for watching, in my next video, I am going to talk in detail about different data ingestion patterns and options available when working with SQL pool. Stay tuned.

    Close

  • Azure Synapse Analytics | Data Ingestion Patterns, Polybase
    Price : Free
    Self Paced
    Launched on
    Thursday, 29 July 2021

    Speaker : Arshad Ali

    View Description

    Azure Synapse Analytics | Data Ingestion Patterns, Polybase

    Having right data ingestion framework and patterns are important considerations to have consistent data ready for analytics in timely manner, especially when you are dealing with large data volume and expect your data to grow every day.

    In this video, you will learn about different data ingestion patterns and options available with Azure Synapse Analytics - dedicated SQL pool.

    Introduction
    ELT (Extract Transform and Load) vs ELT (Extract Load and Transform)
    Single Gated Bulk Data Load
    Parallel Data Load
    Parallel Data Load - Polybase
    Data Import - with CTAS
    Data Export - with CETAS
    Parallel Data Load - Copy Command
    Demo - Bulk Data Load with bcp
    Demo - Bulk Data Load with Polybase
    Demo - Data Import (CTAS) vs. Data Export (CETAS)
    Demo - Bulk Data Load with Copy Command
    Demo - Incremental Data Refresh
    Demo - Monitor Data Load Operations

    Thank you for watching, in my next video, I am going to talk in detail about multi-layer security architecture available with Azure Synapse and how you can build modern data warehouse with confidence in Azure Synapse. Stay tuned.

    Close

View Profile
https://www.linkedin.com/in/arshad0384/Seasoned technical architect with deep experience in architec

Arshad Ali

Who is this Azure Synapse Analytics Unleased for SQL Pool for?

synapse analytics data azure datawarehouse dwh arshad
Benefits Of Joining Our Events And Sessions
Our Integrated Approach To Open Learning, Elevated Branding And Hiring
Upcoming Events