Virtual Training Classes at DPS 2021 (Pre-Cons: 8 & 9 Sep | Post-Cons: 20 & 21 Sep)
Training Classes are 8 hours, focused, deep-dive, demo-based virtual classroom training. Each class will run for eight hours in total, four hours each day, for two consecutive days. There will be three batches spread across three different time zones. Each batch will have four parallel classes. A bit confused? Click Here to learn about our global delivery model.
Each Training Class is designed to offer intermediate & advanced-level training on a specific topic/subject. These classes offer more knowledge, skills, and expertise beyond the summit content.
Apart from attending LIVE classes, you also get on-demand access to class recordings*, exclusive content from the instructor, and the participation certificate. It is a STEAL, grab it!
Dates & Delivery Model
Pre-Conference Training Classes : 8 & 9 Sep
Post-Conference Training Classes : 20 & 21 Sep
Class Duration: 8 hours (4 hours each day. Two consecutive days).
Benefit: Learning is spread across two days. Balance work & learning!
|
|
Most conducive to attend. Attend LIVE and get recordings too. |
|
|
Moderately conducive to attend. Attend LIVE and get recordings too. |
|
|
Least conducive to attend. Yet you can register and get the recordings. |
|
EDT (UTC-4, New York) CEST (UTC +2, Brussels) IST (UTC +5.30, Bengaluru) AEST (UTC +10, Sydney) |
Pre-Cons (8 & 9 Sep)
|
Batch 1 |
Batch 2 |
Batch 3 |
|
4 Pre-Cons |
4 Pre-Cons |
4 Pre-Cons |
|
EDT 03:00 AM to 07:00 AM |
EDT 10:00 AM to 02:00 PM |
EDT 03:00 PM to 07:00 PM |
|
CEST 09:00 AM to 01:00 PM |
CEST 04:00 PM to 08:00 PM |
CEST 09:00 PM to 01:00 AM(+1) |
|
IST 12:30 PM to 04:30 PM |
IST 07:30 PM to 11:30 PM |
IST 12:30 AM(+1) to 04:30 AM (+1) |
|
AEST 05:00 PM to 09:00 PM |
AEST 12:00 AM(+1) to 04:00 AM (+1) |
AEST 05:00 AM (+1) to 09:00 AM(+1) |
|
Pre-Con 1 |
Azure Synapse Analytics by Wolfgang Strasser Book Now |
Power BI Impactful Reporting by Reid Havens Book Now |
|
Pre-Con 2 |
Execution Plans In Depth by Hugo Kornelis Book Now |
Pre-Con 10 |
|
Pre-Con 3 |
Pre-Con 7 |
Pre-Con 11 |
|
Pre-Con 4 |
Pre-Con 8 |
Pre-Con 12 |
Post-Cons (20 & 21 Sep)
|
Batch 1 |
Batch 2 |
Batch 3 |
|
4 Post-Cons |
4 Post-Cons |
4 Post-Cons |
|
EDT 03:00 AM to 07:00 AM |
EDT 10:00 AM to 02:00 PM |
EDT 03:00 PM to 07:00 PM |
|
CEST 09:00 AM to 01:00 PM |
CEST 04:00 PM to 08:00 PM |
CEST 09:00 PM to 01:00 AM(+1) |
|
IST 12:30 PM to 04:30 PM |
IST 07:30 PM to 11:30 PM |
IST 12:30 AM(+1) to 04:30 AM (+1) |
|
AEST 05:00 PM to 09:00 PM |
AEST 12:00 AM(+1) to 04:00 AM (+1) |
AEST 05:00 AM (+1) to 09:00 AM(+1) |
|
SQL Server Big Data Clusters by Niels Berglund Book Now |
Azure Machine Learning by Niel Hambly Book Now |
Post-Con 9 |
|
Azure Data Pipeline implementation |
PowerShell For The DBA by Ben Miller Book Now |
Post-Con 10 |
|
Post-Con 3 |
Modern Data Platform Applications Deployment by Ben Weissman & Anthony Nocentino Book Now |
Post-Con 11 |
|
Post-Con 4 |
Post-Con 8 |
Post-Con 12 |
Training Class Details You Have Been Waiting For
Pre-Con Training Classes
Batch 1
Batch 2
Batch 3
Dates: 8 & 9 Sep 2021
Timings:
|
EDT 03:00 AM to 07:00 AM |
|
CEST 09:00 AM to 01:00 PM |
|
IST 12:30 PM to 04:30 PM |
|
AEST 05:00 PM to 09:00 PM |
|
Most conducive to attend. Attend LIVE and get recordings too. |
|
Moderately conducive to attend. Attend LIVE and get recordings too. |
|
Least conducive to attend. Yet you can register and get the recordings. |
Classes in Batch 1 To Be Announced Soon
Dates: 8 & 9 Sep 2021
Timings:
|
EDT 10:00 AM to 02:00 PM |
|
CEST 04:00 PM to 08:00 PM |
|
IST 07:30 PM to 11:30 PM |
|
AEST 12:00 AM(+1) to 04:00 AM (+1) |
|
Most conducive to attend. Attend LIVE and get recordings too. |
|
Moderately conducive to attend. Attend LIVE and get recordings too. |
|
Least conducive to attend. Yet you can register and get the recordings. |
Azure Synapse Analytics – From Data Ingestion To Visualization
Azure Synapse Analytics – From Data Ingestion To Visualization
|
Pre-Con Title |
Azure Synapse Analytics – From Data Ingestion To Visualization |
|
Track(s) |
Business Intelligence & Advanced Analytics |
|
Tags |
#AzureSynapse #Azure #Analytics #DataLake #DataFactory #Spark #SQL #BigData |
|
Level |
Intermediate |
|
Trainer/Speaker |
|
|
Abstract |
The world of data is getting more and more distributed. On-premises sources, cloud services and IoT data needs to be merged, integrated and brought under a single umbrella for a comprehensive analysis.
With Azure Synapse Analytics, Microsoft adds a player into the cloud analytics field to address and deal with diverse sources, varying structures of data and diverging analytic needs. Join this workshop to learn why Azure Synapse Analytics is needed to address current analytic needs. Get to know the different technologies that sum up into Azure Synapse. Learn best practices what to consider to execute successful Synapse projects. Create your own Synapse environment. Solve big data data tasks as well as traditional data warehousing question, and at the end of day have a feeling how Azure Synapse can help you in your future data platform/analytics projects. |
|
Modules/Topics |
1. Why is a new analytics player needed?
2. Data driven projects – Big data versus Data Warehousing 3. What is Azure Synapse Analytics? 4. Data Ingestion 5. Big Data Analytics 6. Solving Data Warehousing tasks 7. Management / Monitoring 8. Visualization / Data Models |
|
Attendee Pre-requisite (if any) |
Basic Azure knowledge is required. |
|
Is this class being recorded? |
Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
|
Additional Comments from Instructor/Speaker |
No special instructions/comments from the Speaker |
|
Additional Comments from the Organizers |
DPS 2021 Training Classes price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
|
More Questions? |
Visit FAQ page. |
|
BooK Now |
Execution Plans In Depth
Execution Plans In Depth
|
Pre-Con Title |
Execution Plans In Depth |
|
Track(s) |
Development |
|
Tags |
#ExecutionPlans, #QueryTuning, #Performance |
|
Level |
Advanced |
|
Trainer/Speaker |
|
|
Abstract |
For troubleshooting slow queries, looking at the execution plan is a good starting point. But sometimes, just looking at the plan does not help. Sometimes you need to dig deeper.
In this full-day workshop, you will learn everything you need to be take your understanding of execution plans to the next level. For most of the operators you’ll find in execution plans, we will look at the inner workings, and at properties that affect their behavior. We will also look at how the operators within a plan interact with each other. This will increase your understanding on why the optimizer picks a plan, and what you can do to make it pick a better plan. Aside from explaining most operators, we will also look at how these operators interact, which will help you understand which areas in complex execution plans can cause performance issues. If you have seen some execution plans but feel you need to bring your understanding to the next level, then this workshop is for you! |
|
Modules/Topics |
1. Common mistakes
2. Reading data 3. Combining data 4. Performance enhancements 5. Manipulating data 6. Ordering and grouping data 7. Parallelism 8. Changing data 9. Batch mode |
|
Attendee Pre-requisite (if any) |
Some prior experience in the area of performance tuning and execution plans is expected. This implies a fair understanding of T-SQL. |
|
Is this class being recorded? |
Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
|
Additional Comments from Instructor/Speaker |
No special instructions/comments from the Speaker |
|
Additional Comments from the Organizers |
DPS 2021 Training Classes price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
|
More Questions? |
Visit FAQ page. |
|
BooK Now |
Dates: 8 & 9 Sep 2021
Timings:
|
EDT 03:00 PM to 07:00 PM |
|
CEST 09:00 PM to 01:00 AM(+1) |
|
IST 12:30 AM(+1) to 04:30 AM (+1) |
|
AEST 05:00 AM (+1) to 09:00 AM(+1) |
|
Most conducive to attend. Attend LIVE and get recordings too. |
|
Moderately conducive to attend. Attend LIVE and get recordings too. |
|
Least conducive to attend. Yet you can register and get the recordings. |
Demystifying Design Principles And Building Impactful Reports In Power BI
Demystifying Design Principles And Building Impactful Reports In Power BI
|
Pre-Con Title |
Demystifying Design Principles And Building Impactful Reports In Power BI |
|
Track(s) |
Business Intelligence & Advanced Analytics |
|
Tags |
#powerbi #visualizations #design #reporting #dataviz #aesthetics |
|
Level |
Intermediate |
|
Trainer/Speaker |
|
|
Abstract |
This training is developed and delivered by Microsoft MVP Reid Havens, and covers many essential design principles (and how to apply them) to build impactful reports in Power BI Desktop. Students will learn about how to enhance report design by adding elements such as: drillthrough, bookmarks, report page tooltips, conditional formatting, custom visuals, and more.
There is coverage on best practices and recommendations that build upon the functions and features available in Power BI Desktop, providing you with a strong design foundation upon which you can create your reports. This course benefits both those new to Power BI and report design and those already familiar with Power BI. If you have a basic working knowledge of Power BI, this training will help fill in any gaps in your knowledge so you have a more complete set of skills. Regardless of your experience in building visually attractive reports, this course will show you what a stunning Power BI report looks like. Reid will share the many things he does to make his reports stand out from the crowd. When you apply what you learn to your own reports, you and your users are going to love the results. |
|
Modules/Topics |
1. Creating Reports
2. Designing Advanced Reports
3. Report Design Principles
|
|
Attendee Pre-requisite (if any) |
NA |
|
Is this class being recorded? |
Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
|
Additional Comments from Instructor/Speaker |
No special instructions/comments from the Speaker |
|
Additional Comments from the Organizers |
DPS 2021 Training Classes price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
|
More Questions? |
Visit FAQ page. |
|
BooK Now |
Post-Con Training Classes
Batch 1
Batch 2
Batch 3
Dates: 20 & 21 Sep 2021
Timings:
|
EDT 03:00 AM to 07:00 AM |
|
CEST 09:00 AM to 01:00 PM |
|
IST 12:30 PM to 04:30 PM |
|
AEST 05:00 PM to 09:00 PM |
|
Most conducive to attend. Attend LIVE and get recordings too. |
|
Moderately conducive to attend. Attend LIVE and get recordings too. |
|
Least conducive to attend. Yet you can register and get the recordings. |
Big Data & Analytics With SQL Server 2019 Big Data Cluster
Big Data & Analytics With SQL Server 2019 Big Data Cluster
|
Pre-Con Title |
Big Data & Analytics With SQL Server 2019 Big Data Cluster |
|
Track(s) |
Data Science (AI/ML) |
|
Tags |
#bigdatacluster #bigdata #sqlserver #hadoop #spark #azure #analytics |
|
Level |
Advanced |
|
Trainer/Speaker |
|
|
Abstract |
This training session covers big data, data virtualization and analytics in SQL Server 2019 Big Data cluster.
SQL Server 2019 Big Data Cluster, (BDC for short), is the evolution of SQL Server, and its goals are to be able to integrate, manage and analyze data in the peta byte range. The session starts with an overview of what the BDC is, to get everyone on the same page. After the overview, we look at data virtualization; how we can use the BDC as a data hub. We then drill down and look at how storage pools, and data pools works BDC . From there we look at how we can ingest data into the BDC, and how to analyze the data using the built-in Apache Spark engine. Part of this also looks at using Apache Kafka and Apache Spark together to ingest data into the BDC. We also see how we can “mount” external HDFS and Azure Data Lake sources in the Big Data Cluster. |
|
Modules/Topics |
1. Overview of SQL Server 2019 Big Data Cluster
2. Data Virtualization in the BDC 3. Storage Pools & Data Pools 4. Apache Spark 5. Data Ingestion into the BDC 6. Analytics with Apache Spark |
|
Attendee Pre-requisite (if any) |
NA |
|
Is this class being recorded? |
Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
|
Additional Comments from Instructor/Speaker |
No special instructions/comments from the Speaker |
|
Additional Comments from the Organizers |
DPS 2021 Training Classes price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
|
More Questions? |
Visit FAQ page. |
|
BooK Now |
Azure Data Pipeline Implementation – From Zero-To-Hero
Azure Data Pipeline Implementation – From Zero-To-Hero
|
Pre-Con Title |
Azure Data Pipeline Implementation – From Zero-To-Hero |
|
Track(s) |
Business Intelligence & Advanced Analytics |
|
Tags |
#AzureSynapse #PowerBI #Cloud #Azure #DataPipeline #ModernDatawarehouse #DataLake #DeltaLake |
|
Level |
Advanced |
|
Trainer/Speaker |
|
|
Abstract |
This is an end-to-end data pipeline implementation class done in Azure using mainly Azure Synapse data engines and Power BI enterprise features. Come and learn how to deploy scalable cloud data transformation and delivery. |
|
Modules/Topics |
1. Architecture overview
2. Implementing Data Ingestion 3. Implementing Data Transformations based on data lake 4. Implement Data Transformations based on data distributions 5. Get Data Ready for Delivery / Consumption |
|
Attendee Pre-requisite (if any) |
|
|
Is this class being recorded? |
Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
|
Additional Comments from Instructor/Speaker |
No special instructions/comments from the Speaker |
|
Additional Comments from the Organizers |
DPS 2021 Training Classes price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
|
More Questions? |
Visit FAQ page. |
|
BooK Now |
Dates: 20 & 21 Sep 2021
Timings:
|
EDT 10:00 AM to 02:00 PM |
|
CEST 04:00 PM to 08:00 PM |
|
IST 07:30 PM to 11:30 PM |
|
AEST 12:00 AM(+1) to 04:00 AM (+1) |
|
Most conducive to attend. Attend LIVE and get recordings too. |
|
Moderately conducive to attend. Attend LIVE and get recordings too. |
|
Least conducive to attend. Yet you can register and get the recordings. |
Mastering Azure Machine Learning Service
Mastering Azure Machine Learning Service
|
Pre-Con Title |
Mastering Azure Machine Learning Service |
|
Track(s) |
Data Science (AI/ML) |
|
Tags |
#Machinelearning #DataScience |
|
Level |
Advanced |
|
Trainer/Speaker |
|
|
Abstract |
Putting a successful Data Science project together is more than executing different tools and processes.
It requires multiple people working as a team, working through the phases in the right sequence, constantly evaluating and trying new techniques until we find the right For this we need a scalable environment with access to the range of Machine Learning resources that use to pin it all together. Using Azure Machine Learning Service to provide the tools and environment in which we can execute our experiments, integrate with other Microsoft resources like DevOps, Security and Visualizations. |
|
Modules/Topics |
1. Introduction to Azure Machine Learning Service.
2. Preparing data for Machine Learning. 3. Compute Resources. 4. Choosing Algorithms. 5. Using Designer for no-code solutions. 6. Using Python Notebooks. 7. Explaining Machine Learning Visuals. 8. Deploying Machine Learning pipelines |
|
Attendee Pre-requisite (if any) |
Prior experience of Machine Learning Service is recommended. DP-900 or DP-100 Course / Exam |
|
Is this class being recorded? |
Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
|
Additional Comments from Instructor/Speaker |
No special instructions/comments from the Speaker |
|
Additional Comments from the Organizers |
DPS 2021 Training Classes price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
|
More Questions? |
Visit FAQ page. |
|
BooK Now |
PowerShell For The DBA – Let’s Do It!
PowerShell For The DBA – Let’s Do It!
|
Pre-Con Title |
PowerShell For The DBA – Let’s Do It! |
|
Track(s) |
Data Administration |
|
Tags |
#PowerShell #SQLServer |
|
Level |
Intermediate |
|
Trainer/Speaker |
|
|
Abstract |
There are so many servers and so little time today. PowerShell for a DBA is a must in my book to enable you to get more done in less time and with much less clicking. Setup, configuration and management are at the heart of a DBAs work. PowerShell knowledge and know how are more important than ever. This class will give you the tools to get more done as well as enable you to advance in your work with techniques and keep you moving forward past the seemingly hard things of every day DBA work. I will show you how to get your environment set up and take you through remoting, parallel execution of tasks and all about the PowerShell modules that are out there to make your life great. Join me in the quest to become a PowerShell DBA. |
|
Modules/Topics |
1. Environment setup
2. PowerShell Module eco-system 3. DbaTools module 4. SqlServer module/05-ImportExcel module 6. SMO Primer 7. DBA work with PowerShell 8. Next Steps to maximize efficiency |
|
Attendee Pre-requisite (if any) |
Understanding of DBA work, easy huh? |
|
Is this class being recorded? |
Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
|
Additional Comments from Instructor/Speaker |
No special instructions/comments from the Speaker |
|
Additional Comments from the Organizers |
DPS 2021 Training Classes price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
|
More Questions? |
Visit FAQ page. |
|
BooK Now |
The Future Of Deployment For Modern Data Platform Applications
The Future Of Deployment For Modern Data Platform Applications
|
Pre-Con Title |
The Future Of Deployment For Modern Data Platform Applications |
|
Track(s) |
Architecture |
|
Tags |
#Arc #bdc #kubernetes #hybrid #dba |
|
Level |
Intermediate |
|
Trainer/Speaker |
|
|
Abstract |
First, we will cover the basics of Kubernetes: What is it, who can use it, what can it be used for, why is this different or better than old school deployments through virtual machines. We will then build a Kubernetes cluster and learn how to deploy applications into this cluster. Building on those Kubernetes deployment fundamentals, we will then deploy a SQL Server Big Data Cluster to showcase how we can deploy a complex stateful application in Kubernetes.
We will close the day by working our way through the next gamechanger for Deployments: Azure Arc Data Services, a solution that allows us to deploy managed Azure Data Service to any hardware running Kubernetes (including any cloud vendor) on-premises or in the cloud. You will leave with the knowledge, scripts, and tools to get started with Kubernetes and Kubernetes based applications today! |
|
Modules/Topics |
1. Kubernetes Fundamentals 2. SQL on Kubernetes 3. Big Data Clusters 4. Azure Arc enabled Data Services |
|
Attendee Pre-requisite (if any) |
NA |
|
Is this class being recorded? |
Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion. |
|
Additional Comments from Instructor/Speaker |
No special instructions/comments from the Speaker |
|
Additional Comments from the Organizers |
DPS 2021 Training Classes price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience. |
|
More Questions? |
Visit FAQ page. |
|
BooK Now |
Dates: 20 & 21 Sep 2021
Timings:
|
EDT 03:00 PM to 07:00 PM |
|
CEST 09:00 PM to 01:00 AM(+1) |
|
IST 12:30 AM(+1) to 04:30 AM (+1) |
|
AEST 05:00 AM (+1) to 09:00 AM(+1) |
|
Most conducive to attend. Attend LIVE and get recordings too. |
|
Moderately conducive to attend. Attend LIVE and get recordings too. |
|
Least conducive to attend. Yet you can register and get the recordings. |
