Azure Synapse Analytics Unleased for SQL Pool by Arshad Ali.Enrol now for this short course with certificate only on #5thir by #multicloud4u

Azure Synapse Analytics Unleased for SQL Pool

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

FREE

Navigate to Course

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