Training Classes (Pre-Cons & Post-Cons)

Virtual Training Classes at DPS 2020 (Pre-Cons. Nov 30 & Dec 1. Post-Cons. Dec 7 & 8)

Pre-Cons & Post-Cons are collectively called as Training Classes. These are 8 hours, focused, deep-dive, demo-based virtual classroom training. DPS 2020 will have sixteen Pre-Cons & sixteen Post-Cons – a total of thirty two classes. Each class will run for eight hours in total, but four hours each day, for two consecutive days. Just like the summit, Training Classes will also run round-the-clock, continuously. There will be four batches spread across four 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: Nov 30 & Dec 1.
Post-Conference Training Classes: Dec 7 & 8.
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.

EST (UTC-5, New York)

CET (UTC +1, Brussels)

IST (UTC +5.30, Bengaluru)

AEDT (UTC +11, Sydney)

Pre-Cons (Nov 30 & Dec 1) (Expand the toggles below to see all the classes)

Batch 1

Batch 2

Batch 3

Batch 4

EST 1.00 am to 5.00 am

EST 7.00 am to 11.00 am

EST 12 noon to 4.00 pm

EST 5.00 pm to 9 pm

CET 7.00 am to 11.00 am

CET 1.00 pm to 5.00 pm

CET 6.00 pm to 10.00 pm

CET 11.00 pm to 3.00 am (+1)

IST 11.30 am to 3.30 pm

IST 5.30 pm to 9.30 pm

IST 10.30 pm to 2.30 am (+1)

IST 3.30 am (+1) to 7.30 am (+1)

AEDT 5.00 pm to 9.00 pm

AEDT 11.00 pm to 3.00 am (+1)

AEDT 4.00 am to 8.00 am (+1)

AEDT 9.00 am (+1) to 1.00 pm (+1)

Enterprise Power BI

by Dr. Greg Low

Azure SQL

by Bob Ward & Anna Hoffman

Docker Containers

by Edwin Sarmiento

Power BI Data Modeling

by Peter Myers

Performance-centric T-SQL

by Itzik Ben-Gan

Mastering T-SQL Querying

by Itzik Ben-Gan

Azure Data Factory

by Andy Leonard

Kubernetes

by Anthony Nocentino

Database DevOps

by Alex Yates

TBD

Azure Synapse Analytics

by Warner Chaves

TBD

SQL in Azure VM

by Microsoft

TBD

TBD

TBD

Post-Cons (Dec 7 & 8) (Expand the toggles below to see all the classes)

Batch 1

Batch 2

Batch 3

Batch 4

EST 1.00 am to 5.00 am

EST 7.00 am to 11.00 am

EST 12 noon to 4.00 pm

EST 5.00 pm to 9 pm

CET 7.00 am to 11.00 am

CET 1.00 pm to 5.00 pm

CET 6.00 pm to 10.00 pm

CET 11.00 pm to 3.00 am (+1)

IST 11.30 am to 3.30 pm

IST 5.30 pm to 9.30 pm

IST 10.30 pm to 2.30 am (+1)

IST 3.30 am (+1) to 7.30 am (+1)

AEDT 5.00 pm to 9.00 pm

AEDT 11.00 pm to 3.00 am (+1)

AEDT 4.00 am to 8.00 am (+1)

AEDT 9.00 am (+1) to 1.00 pm (+1)

SQL Server Optimization

by Uwe Ricken

Big Data Clusters

by Ben Weissman

Query Tuning

by Erik Darling

Machine Learning

by Anupama Natarajan

Data Science Algorithms

by Dejan Sarka

PowerShell & SQL Server

by Rob Sewell

Data Analysis in Python and SQL

by Kevin Feasel

Azure SQL DB Security

by Martin Cairney

TBD

TBD

Cosmos DB

by Hasan Savran

SQL Server Performance Tuning

by Amit Bansal

TBD

TBD

TBD

TBD

Pro Tip: You can register for multiple classes even if you are not able to attend them – no worries, you get the recordings*!
Pro Tip: A few more classes may be added to the existing list. You can later change your choices or make additional purchase.

*It may happen that out of thirty two classes, one or two classes may not be recorded, so be sure to check that out in the details section of each class.

Training Class Details You Have Been Waiting For

Batch 1

Batch 2

Batch 3

Batch 4

Dates: Nov 30 & Dec 1 2020

Timings:

EST 1.00 am to 5.00 am (UTC-5, New York)

CET 7.00 am to 11.00 am (UTC +1, Brussels)

IST 11.30 am to 3.30 pm (UTC +5.30, Bengaluru)

AEDT 5.00 pm to 9.00 pm (UTC +11, Sydney)

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.

An Enterprise-Friendly Framework For Implementing Power BI Projects (What Comes After The 5 Minutes To Wow For An Enterprise)

Pre-Con Title

An Enterprise-Friendly Framework For Implementing Power BI Projects (What Comes After The 5 Minutes To Wow For An Enterprise)

Track(s)

Business Intelligence & Advanced Analytics

Tags

#powerbi #analysisservices #enterprise #datamodeling

Level

Intermediate

Trainer/Speaker

Dr. Greg Low

Abstract

Power BI was introduced with a motto of “”5 minutes to Wow””, and that has been very successful. Users get started with the tools quickly and are ususally very impressed.

Once they get past the initial Wow though, enterprises are often left wondering how they can implement a Microsoft BI stack using Power BI, at least in a way that is enterprise-friendly.

In this min-course, Greg will take you through the techniques that he and his company have been using very successfully to implement these projects.

Modules/Topics

First session

  1. The end game – what we’re aiming for and how it all fits together for a great result2.No
  2. shortcuts: Creating an appropriate underlying data model

Second session

  1. Identity is critical: Implementing identity management including hybrid identity
  2. Keeping control: Tools and processes for managing Microsoft BI projects
  3. Who can see this: Applying appropriate security and in the right place

Attendee Pre-requisite (if any)

Basic understanding of databases, data modeling, Power BI

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

Performance-centric T-SQL

Pre-Con Title

Performance-Centric T-SQL

Track(s)

Database Development

Tags

#TSQL #Performance #Optimization #QueryRewrites #WindowFunctions #QueryTuning #T-SQL

Level

Advanced

Trainer/Speaker

Itzik Ben-Gan

Abstract

This seminar covers advanced aspects of T-SQL with a performance-centric focus. The seminar demonstrates practical uses of T-SQL features, with optimized and polished solutions, many of which were developed by the speaker. You will learn about features like the APPLY operator, window functions, the OFFSET-FETCH filter, and how to use them creatively to solve common T-SQL tasks elegantly and efficiently. You will learn about optimization thresholds and understand how the query optimizer tends to choose between different algorithms, and how new intelligent/adaptive query processing capabilities enable SQL Server to make such choices dynamically during query execution. You will learn about the performance aspects of the Top N per group task, string splitting and concatenation with the STRING_SPLIT and STRING_AGG functions, batch mode over row store, adaptive joins, interleaved execution, deferred compilation, memory grant feedback, improvements in user-defined functions and more.

Modules/Topics

  • Window functions
  • APPLY
  • OFFSET-FETCH
  • Optimization thresholds
  • Query rewrites
  • Intelligent QP / Adaptive QP
  • Approximate QP
  • String splitting and concatenation

Attendee Pre-requisite (if any)

One year of experience writing T-SQL code and optimizing queries

Is this class being recorded?

No, this class will not be recorded. Therefore, no recordings will be available.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

DPS 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

Build your own database deployment pipeline with Octopus Deploy and either SSDT or Redgate SQL Change Automation

Pre-Con Title

Build Your Own Database Deployment Pipeline With Octopus Deploy And Either SSDT Or Redgate SQL Change Automation

Track(s)

Data Administration

Tags

#DevOps #Deployment

Level

Intermediate

Trainer/Speaker

Alex Yates

Abstract

Automated deployments enable teams to deliver value faster, more reliably and for less money. If your database deployments are still slow, manual and error prone, and your business wants to remain competitive, building an automated database deployment pipeline should be a high priority.

However, this can be difficult because it requires a working knowledge of various technologies, as well as an understanding about how to glue them all together. For example, folks need to understand database technologies, scripting languages, source control tools and CI/CD architectures, as well as all the necessary networking. To create a truly successful deployment pipeline it often requires collaboration between multiple specialists with a generalist to guide them.

This session is both for the aspiring generalists who wants to understand the big picture and for the specialist who wants to learn to better collaborate with their colleagues. We will focus on the high-level outcomes, without going too deep on any specific technology. Therefore, this session should be accessible to anyone, regardless of speciality or experience.

Attendees will create their own end to end deployment pipelines for SQL Server using GitHub, Octopus Deploy and AWS. While attendees tool choices and hosting providers might vary, this session will focus on universal concepts and should be valuable to folks even if they use different tools, such as Jenkins, Azure DevOps or Azure. Folks will be using their own software and licences with 100% free / trial software/services and will be able to host their infrastucture using their own AWS account, on free tier eligible VMs. The cost of running the infrastructure will be no more than a few cents per hour.

By the end of this class, all attendees will understand how to create an end to end database deployment pipeline, and they will take away their own hosted pipeline which they’ll be able to spin up and tear down whenever they like.

Modules/Topics

Day 1:

  • Cloning a Git repo in GitHub
  • Introducing Octopus Deploy, and configuring the hand-off from GitHub Actions

Day 2:

  • Exploring database source code and understanding how it gets deployed
  • Configuring Octopus Projects to deploy database updates
  • Further extensions (various options, depending on time available.)

Attendee Pre-requisite (if any)

(Required)

Create a free account in advance for the following services:

  • AWS
  • GitHub
  • Octopus Deploy (Cloud edition)

(Optional)

  • If you would like to run the code locally (optional) install the following on your dev machine:
  • SQL Server Developer Edition (Either a full instance or using Docker is fine)
  • (If using SSDT) Visual Studio (Community edition is fine)
  • (If using Redgate) Redgate SQL Change Automation PowerShell cmdlets
  • PowerShell
  • Your prefered IDE for working with SQL Server (SSMS, Azure Data Studio etc)
  • Git

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

SQL Server: Advanced Training for Azure VM Deployments

Pre-Con Title

SQL Server: Advanced Training for Azure VM Deployments

Track(s)

Data Administration

Tags

#SQLServer #SQL2019 #Azure #IaaS #Migration #BestPractices #Sizing #Performance #Optimization #Licensing #HighAvailability #AlwaysOn #Clustering #Windows #Linux #Virtualization #AzureVM #SQLVM

Level

Intermediate

Trainer/Speaker

David Pless , Pam Lahoud , Amit Khandelwal , Tejas Shah, Aditya Badramraju

Abstract

SQL Server: Advanced Skilling for Azure VM Deployments

Many customers are looking to migrate their SQL Server instances and SQL based applications to the cloud to take advantage of scalability, flexibility, advanced high availability and disaster recovery options, optimized licensing scenarios, access to Azure monitoring & Azure advisory technologies, and other marketplace tools & capabilities in the Azure fabric.

The decision has been made to bring your solution to the cloud, but then the challenge many customers experience is knowing how to properly size their environments, understanding the best strategy for availability, and how to start their migration journey.

In this workshop we will address all of these key challenges and the best practices on migrating your SQL Server workloads to Azure virtual machines.

We will cover migration strategies starting with assessing the state of your current environment. We will then target our evaluation results to a destination platform in Azure. We will learn about proper virtual machine sizing and the VM classes, proper tuning for Windows and Linux platforms, and how to take best advantage of licensing practices in Azure.

We will then focus on high availability and disaster recovery options, best practices, monitoring and management. We will address modern HADR approaches for SQL Server including Always On Availability Groups, Failover Cluster Instances (FCI), Log Shipping, and supported replication models. We will also cover virtual machine optimization best practices and deployment considerations for hybrid configurations.

This workshop will be an engaging, real-world examination of modernizing your most critical SQL based platforms.

We look forward to seeing you there!

Modules/Topics

SQL Server 2019: Advanced Skilling for Azure IaaS Deployments

Module Overview:

Module 1 – SQL Server 2019 Overview

  • Topic 1: Features and Capabilities
  • Topic 2: Opportunities in Azure

Module 2 – SQL Server Migration strategies for IaaS

  • Topic 1: Assessing the source environment
  • Topic 2: Migrating data and SQL objects to the cloud

Module 3: SQL Server best practices for common workloads on IaaS (90 min.)

  • Topic 1: Sizing and VM types
  • Topic 2: Performance Guidelines
  • Topic 3: Resource Provider Benefits
  • Topic 4: Demystifying licensing in SQL Server 2019

Module 4: Modern HADR Approaches for SQL in IaaS (90 min.)

  • Topic 1: Always On Availability Groups
  • Topic 2: Fail over Cluster Instances (FCI) in Azure
  • Topic 3: Log Shipping
  • Topic 4: Supported Replication Models
  • Topic 5: HADR hybrid configurations
  • Topic 6: Azure HADR options

Module 5: SQL Server on IaaS – (Monitoring and Management)

  • Topic 1: Managing SQL Server on IaaS both for Windows and Linux
  • Topic 2: Comparing on-prem virtualization to Azure

Module 6: IaaS/PaaS hybrid deployments for scalability

  • Topic 1: Application scenarios
  • Topic 2: Business Intelligence scenarios

Attendee Pre-requisite (if any)

Pre-requisite: There are no pre-requisites though familiarity with SQL Server 2016+ and virtualization is helpful.

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

Dates: Nov 30 & Dec 1 2020

Timings:

EST 7.00 am to 11.00 am (UTC-5, New York)

CET 1.00 pm to 5.00 pm (UTC +1, Brussels)

IST 5.30 pm to 9.30 pm (UTC +5.30, Bengaluru)

AEDT 11.00 pm to 3.00 am (+1) (UTC +11, Sydney)

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.

The Azure SQL Workshop

Pre-Con Title

The Azure SQL Workshop

Track(s)

Data Administration

Tags

#AzureSQL #Azure #SQLServer #MeatAndPotatoes #Security #Performance #Availability

Level

Intermediate

Trainer/Speaker

Bob-Ward, Anna-hoffman

Abstract

In this one day, hands-on, scenario-driven workshop, members of the SQL engineering team will help you translate your existing SQL Server expertise to Azure SQL including Azure SQL Database and Azure SQL managed instance. At the end of the day, you should have a foundational knowledge of what to use when, as well as how to configure, monitor, and troubleshoot the “meat and potatoes” of SQL Server in Azure: security, performance, and availability. You will learn about not only the “what”, but also the “how” and the “why”. You’ll also walk away with resources and tools so you can go as deep as your scenario requires.

After the workshop, you should be able to:

  • Determine which Azure SQL deployment option (virtual machines, single databases, serverless databases, elastic pools of databases, hyperscale databases, and managed instances) and service tier should be used for scenarios that meet the needs of your application.
  • Deploy, configure, monitor, and troubleshoot security, performance, and availability scenarios in Azure SQL using both familiar and new tools and techniques.
  • Harness the “power of the cloud” including automation and intelligent capabilities of Azure SQL.
  • Translate your existing SQL Server expertise to Azure SQL expertise.

Modules/Topics

  • Introduction to Azure SQL
  • Deploy and Configure
  • Security
  • Performance
  • Availability
  • Putting it all together

Attendee Pre-requisite (if any)

The Instructor/Trainer has not specified any pre-requisites.

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

Mastering T-SQL Querying Fundamentals

Pre-Con Title

Mastering T-SQL Querying Fundamentals

Track(s)

Database Development

Tags

#TSQL #Querying #QueryProcessing #QueryTuning #T-SQL

Level

Advanced

Trainer/Speaker

Itzik Ben-Gan

Abstract

Does your work involve interacting with Microsoft SQL Server or Azure SQL Database? If so, writing T-SQL code is probably an integral part of your work. As a developer, DBA, analyst, BI pro, data scientist, or power user, a strong mastery of T-SQL querying and its foundations makes you better at what you do. This full-day seminar provides you with such strong foundations.

You will learn about interesting, nonobvious, aspects of T-SQL querying tools like joins, subqueries, table expressions, recursive queries, APPLY, set operators and many others. You will learn about logical query processing, which defines the conceptual interpretation of queries, unveiling many surprising things about T-SQL. You will also learn about common bugs, pitfalls, and best practices. As time permits, the seminar will also cover some of the more sophisticated querying tools like pivoting and unpivoting, window functions and grouping sets.

This seminar will help you write correct and robust T-SQL code, avoid bugs, follow best practices, think in set-based/relational terms, and get a better mastery of T-SQL querying.

Modules/Topics

  • Logical Query Processing
  • Joins
  • Subqueries
  • Table Expressions
  • Set Operators
  • Recent T-SQL Additions
  • Beyond the Fundamentals (window functions, pivoting, unpivoting, grouping sets, as time permits)

Attendee Pre-requisite (if any)

Basic experience writing T-SQL queries

Is this class being recorded?

No, this class will not be recorded. Therefore, no recordings will be available.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

DPS 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

Dates: Nov 30 & Dec 1 2020

Timings:

EST 12 noon to 4.00 pm (UTC-5, New York)

CET 6.00 pm to 10.00 pm (UTC +1, Brussels)

IST 10.30 pm to 2.30 am (+1) (UTC +5.30, Bengaluru)

AEDT 4.00 am to 8.00 am (+1) (UTC +11, Sydney)

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.

The SQL Server DBA’s Guide to Docker Containers

Pre-Con Title

The SQL Server DBA’s Guide To Docker Containers

Track(s)

Architecture

Tags

#SQLServer #Docker #Containers #DevOps #Linux

Level

Intermediate

Trainer/Speaker

Edwin M Sarmiento

Abstract

Your role as a SQL Server DBA is evolving and you are now responsible for automating deployment, scaling and management of containerized applications – not just SQL Server databases. You don’t have a clue where and how to start. You are confused about this whole DevOps buzzword being thrown around and you are wasting a lot of time figuring things out on your own. What’s worse, you end up being a stressed, overworked engineer who wished you could focus on the “cool stuff”, but are instead stuck in firefighting mode while juggling the additional workload.

This session is specifically for you. This whole-day workshop is specifically designed for senior SQL Server database administrators and systems engineers responsible for automating deployment, scaling and management of containerized applications.

Modules/Topics

  • Overview of DevOps for the SQL Server DBA
  • Architecture of Container Ecosystem
  • Deploying SQL Server on Docker Containers
  • Managing and persisting SQL Server data in Docker containers
  • Creating and deploying custom SQL Server container images

Attendee Pre-requisite (if any)

Intermediate to senior SQL Server DBA with familiarity with scripting and automation. Familiarity with the Linux operating system would be helpful.

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

Getting Started with Azure Data Factory

Pre-Con Title

Getting Started with Azure Data Factory

Track(s)

Business Intelligence & Advanced Analytics

Tags

#AzureDataFactory #ADF #AzureSSIS

Level

Intermediate

Trainer/Speaker

Andy Leonard

Abstract

Azure Data Factory, or ADF, is an Azure PaaS (Platform-as-a-Service) that provides hybrid data integration at global scale. Use ADF to build fully managed ETL in the cloud – including SSIS. Join Andy Leonard – Microsoft Data Platform MVP, author, blogger, and Chief Data Engineer at Enterprise Data & Analytics – as he demonstrates Azure Data Factory in action.

In this course, you’ll learn:

  1. Provision a Data Factory
  2. Basic Data Movement
  3. Pipeline Orchestration
  4. Monitoring
  5. Azure-SSIS
  6. Enterprise ADF Execution Patterns
  7. Introduction to Mapping Data Flows

Modules/Topics

  • Introduction
  • Provision a Data Factory
  • Basic Data Movement
  • Pipeline Orchestration
  • Monitoring
  • Azure-SSIS
  • Enterprise ADF Execution Patterns
  • Introduction to Mapping Data Flows

Attendee Pre-requisite (if any)

The Instructor/Trainer has not specified any pre-requisites.

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

Practical Data Engineering with Azure Synapse Analytics

Pre-Con Title

Practical Data Engineering With Azure Synapse Analytics

Track(s)

Business Intelligence & Advanced Analytics

Tags

#Synapse #Analytics #BigData #DataWarehousing

Level

Intermediate

Trainer/Speaker

Warner Chaves

Abstract

What started as Azure SQL Data Warehouse, has now evolved into an all-encompassing analytics development service. Microsoft took the power of the MPP database engine of SQL DW and added more powerful capabilities, full big data integration through Spark, an integrated authoring experience and more.

Whether you are an administrator or a developer, Synapse now provides tools that any data professional can use to engineer their own data solution. To enable all these new capabilities, Microsoft has introduced new concepts like SQL and Big Data pools, Azure Data Lake Gen 2 integrated catalogs and more. All these new features and concepts can be easily understood and adopted by current data professionals to bring their careers into the warehousing and analytics space.

In this demo-heavy class we will go over the main concepts behind Synapse, go through all the major features and the new workspace experience.The class will leverage all the in-field experience of the trainer from best practices to lessons learned and pitfalls on how to build your data platform with Synapse Analytics.

Modules/Topics

  • Synapse Fundamentals
  • Synapse Workspace
  • Sql Engines
  • Spark Engine
  • Import and Export Data
  • Building Data Flows
  • Visualizing Data
  • Workspace Security and Monitoring

Attendee Pre-requisite (if any)

Basic knowledge of databases and basic experience with Business Intelligence systems and tools

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

Dates: Nov 30 & Dec 1 2020

Timings:

EST 5.00 pm to 9 pm (UTC-5, New York)

CET 11.00 pm to 3.00 am (+1) (UTC +1, Brussels)

IST 3.30 am (+1) to 7.30 am (+1) (UTC +5.30, Bengaluru)

AEDT 9.00 am (+1) to 1.00 pm (+1) (UTC +11, Sydney)

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.

Power BI Desktop Data Modeling End-to-End

Pre-Con Title

Power BI Desktop Data Modeling End-To-End

Track(s)

Business Intelligence & Advanced Analytics

Tags

#powerbi #dataanalytics #datamodeling #powerbidesktop

Level

Intermediate

Trainer/Speaker

Peter Myers

Abstract

In this presentation you will learn how to develop Power BI Desktop data models. The session will describe data modeling fundamentals together with a development methodology covering how to create model tables with Power Query, how to create and configure appropriate model relationships, how to improve and enrich the data model design with usability features and calculations, and how to enforce row-level security (RLS) by defining and testing roles.

This session introduces foundational theory and builds upon it by describing best practices and tips.

This session will appeal to those new to Power BI Desktop data modeling, and also for those already developing data models (this session will be ideal for filing in any gaps in your knowledge).

Modules/Topic

  • Power BI Desktop data modeling
  • “Getting Data” with Power Query
  • Creating data model relationships
  • Enhancing data model design with usability features
  • Introduction to DAX for defining data model calculations
  • Security data models with row-level security

Attendee Pre-requisite (if any)

The Instructor/Trainer has not specified any pre-requisites.

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

Kubernetes Zero to Hero – Installation, Configuration, and Application Deployment

Pre-Con Title

Kubernetes Zero To Hero – Installation, Configuration, And Application Deployment

Track(s)

Architecture

Tags

Kubernetes Linux SQL Server Containers

Level

Intermediate

Trainer/Speaker

Anthony Nocentino

Abstract

Modern application deployment needs to be fast and consistent to keep up with business objectives and Kubernetes is quickly becoming the standard for deploying container-based applications, fast. In this day-long session, we will start container fundamentals and then get into Kubernetes with an architectural overview of and how it manages application state. Then you will learn how to build a cluster. With our cluster up and running, you will learn how to interact with our cluster, common administrative tasks, then wrap up with how to deploy applications and SQL Server. At the end of the session, you will know how to set up a Kubernetes cluster, manage a cluster, deploy applications and databases, and how to keep everything up and running.

Modules/Topics

  • Container Fundamentals
  • Introduce Kubernetes Cluster Components
  • Introduce Kubernetes API Objects and Controllers
  • Installing Kubernetes
  • Interacting with your cluster
  • Storing persistent data in Kubernetes
  • Deploying Applications in Kubernetes
  • Deploying SQL Server in Kubernetes

Attendee Pre-requisite (if any)

All examples will be executed at the command line, so proficiency at a command line is required. Platform dependent (Linux/Windows,Cloud CLIs) configurations and commands will be introduced and discussed in the workshop.

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

Batch 1

Batch 2

Batch 3

Batch 4

Dates: Dec 7 & 8 2020

Timings:

EST 1.00 am to 5.00 am (UTC-5, New York)

CET 7.00 am to 11.00 am (UTC +1, Brussels)

IST 11.30 am to 3.30 pm (UTC +5.30, Bengaluru)

AEDT 5.00 pm to 9.00 pm (UTC +11, Sydney)

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.

Analyze and Optimize your SQL Server

Pre-Con Title

Analyze And Optimize Your SQL Server

Track(s)

Architecture

Tags

#SQLServer #Configuration #Installation

Level

Intermediate

Trainer/Speaker

Uwe Ricken

Abstract

The day-to-day business of a DBA as well as consultants who are on the move in terms of “”Microsoft SQL Server”” include careful analysis of SQL Server systems when the business or the customer reports performance problems. In the “”Analysis of SQL Server”” workshop, a specific example is used to test a Microsoft SQL Server for various problem cases that lead to bottlenecks if they are not set correctly.

In the workshop, the various problem analyzes are demonstrated by examples with explanations of the possible effects. At the same time, a solution plan is drawn up in which the participant can work through the correct settings in the operating system to the configuration settings in Microsoft SQL Server. Finally, solutions are shown if the performance within a single database is assessed as insufficient. All possible performance bottlenecks are simulated and evaluated on an installed Microsoft SQL Server using scripts. The following analysis steps are covered during the workshop:

  • Check and evaluate settings in the operating system
  • Analysis of the databases for configuration, usage and system utilization
  • Configuration and analysis of TEMPDB
  • Waits and Latches: What is Microsoft SQL Server waiting for and what influence do the various waiting processes have on the performance of the applications.
  • Index maintenance – how are indexes used, which indexes are missing, how is the physical condition of indexes to be assessed.
  • At the end of the evaluations, a template is presented in which the results of the investigation.
Modules/Topics
  • Understanding the process route of Microsoft SQL Server
  • Important settings for the OS
  • Important settings for SQL Server
  • Analyse the database configuration
  • Analyze Wait Stats
  • Best practice configuration
  • Reporting of found issues

Attendee Pre-requisite (if any)

The Instructor/Trainer has not specified any pre-requisites.

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

Data Science Algorithms

Pre-Con Title

Data Science Algorithms

Track(s)

Data Science (AI/ML)

Tags

#datascience #machinelearning #datamining #statistics

Level

Expert

Trainer/Speaker

Dejan Sarka

Abstract

Advanced data analysis techniques are gaining popularity. With modern statistics / data mining / machine learning engines, products and packages, data science has become a black box. It is possible to use data science without knowing how it works. However, not knowing how the algorithms work might lead to many problems, including using the wrong algorithm for a task, misinterpretation of the results, and more. This seminar explains how the most popular data mining algorithms work, when to use which algorithm, and advantages and drawbacks of each algorithm as well. Demonstrations and labs show the algorithms usage in T-SQL, R, and Python languages.

Algorithms explained include Naïve Bayes, Decision Trees, Neural Networks, Logistic Regression, Perceptron Model, Linear Regression, Regression Trees, Ordinal Regression, Poisson Regression, Principal Component Analysis, Support Vector Machines, Hierarchical Clustering, K-Means Clustering, Expectation-Maximization Clustering, Association Rules, Sequence Clustering, Auto-Regressive Trees with Cross-Prediction (ARTXP), Auto-Regressive Integrated Moving Average (ARIMA), and Time Series.

The seminar also includes the explanation of the introductory statistics, including descriptive statistics, correlations and linear associations. Even the information theory is touched briefly. All of these methods are useful for gathering understanding of the data used for later analysis and advanced data profiling. Mining unstructured data, specifically texts, is covered in the course as well.

Modules/Topics

  • Introduction to data mining and / or machine learning
  • Descriptive statistics for data overview
  • Classification, prediction and estimation algorithms
  • Forecasting, unsupervised algorithms, and text mining

Attendee Pre-requisite (if any)

The Instructor/Trainer has not specified any pre-requisites.

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

Dates: Dec 7 & 8 2020

Timings:

EST 7.00 am to 11.00 am (UTC-5, New York)

CET 1.00 pm to 5.00 pm (UTC +1, Brussels)

IST 5.30 pm to 9.30 pm (UTC +5.30, Bengaluru)

AEDT 11.00 pm to 3.00 am (+1) (UTC +11, Sydney)

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.

SQL Server 2019 Big Data Clusters in a Day

Pre-Con Title

SQL Server 2019 Big Data Clusters In A Day

Track(s)

Business Intelligence & Advanced Analytics

Tags

#BigDataClusters #SQLServer #Hadoop #Kubernetes

Level

Intermediate

Trainer/Speaker

Ben Weissman

Abstract

Abstract (required)

With SQL Server 2019, Microsoft introduced a game changer for Big Data and Analytics Workloads: Big Data Clusters

This feature set combines solutions for Data Virtualization, Data Mart Scale Out using traditional SQL Server tables, non relational and file based data as well as Machine Learning and AI.

In this session we are going to explore the capabilities of the exciting new feature. Ben Weissman will walk you through the different aspects and use cases of Big Data Clusters, demo them and eventually show you how to deploy and push data to your own Big Data Cluster so you can start using them right away!

Modules/Topics

Modules/Topics (required)

  • What’s a BDC
  • What do I need to build a BDC
  • How do I deploy a BDC
  • How do I work with a BDCz
  • How do I manage a BDC

Attendee Pre-requisite (if any)

T-SQL or python for data analysis

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

PowerShell and SQL Server with dbatools with Rob Sewell

Pre-Con Title

PowerShell And SQL Server With DBATools

Track(s)

Data Administration

Tags

#PowerShell #dbatools #sqlserver

Level

Basic

Trainer/Speaker

Rob Sewell

Abstract

The SQL Server Collaborative organisation have created the free, open source PowerShell module dbatools lead by Chrissy LeMaire and with over 100 contributors to extend PowerShell support for SQL Server even further

Join Cloud and Data Center MVP and dbatools evangelist Rob Sewell to learn how to you can make use of both of these modules to simplify and automate your DBA needs.

You will be shown how you can accomplish many routine DBA tasks easily and simply with one line of PowerShell code

  • Migrate an entire instance with one line of code – databases, users, jobs, schedules, credentials ,proxies, operators (The list goes on, it’s pretty much everything)
  • Restore an entire instance from a backup directory
  • Test your restores every day
  • Simply and easily find a stored procedure, trigger, view in a database even if you don’t know which instance it is on
  • Show who changed my database and what they did
  • Display the last time a successful DBCC CHECKDB was run for all databases across my estate
  • Make us of sp_whoisActive and Glenn Berry’s diagnostic queries straight from PowerShell
  • Write Pester Tests to validate your SQL Server environment
  • And much much more

Come and join me for a great day of PowerShell and SQL full of demos and useful solutions that you will be able to take back to your workplace. You will improve your knowledge and skills, see how the modern DBA will work and have fun at the same time.

Who Are You?

You are a DBA, senior or junior, looking after 1 or 100,000 instances, a developer who interacts with SQL Server or an accidental DBA.

You are interested in improving your PowerShell skills for SQL Server or reducing the time you and your team spend administering SQL Server.

You have spent 1 day or 20 years working with SQL Server.

You know that you work in a field where automation is king and want to understand more of what is available.

You are interested in learning and improving your automation skill set.

What do you need?

All you need is yourself! We would recommend that you bring something to take notes with as well as a minimum.

All scripts and slides will be provided to you. If you wish to follow along with the demos you should have access to a machine with PowerShell v 5 or above with a SQL Server 2012 or above instance.

Modules/Topics

  • What is dbatools?
  • Finding Commands
  • Using Commands
  • Migrate an entire instance with one line of code – databases, users, jobs, schedules, credentials ,proxies, operators (The list goes on, it’s pretty much everything)
  • Restore an entire instance from a backup directory
  • Test your restores every day
  • Simply and easily find a stored procedure, trigger, view in a database even if you don’t know which instance it is on
  • Show who changed my database and what they did
  • Display the last time a successful DBCC CHECKDB was run for all databases across my estate
  • Make us of sp_whoisActive and Glenn Berry’s diagnostic queries straight from PowerShell
  • Write Pester Tests to validate your SQL Server environment

Attendee Pre-requisite (if any)

What do you need?

All you need is yourself! We would recommend that you bring something to take notes with as well as a minimum.

All scripts and slides will be provided to you. If you wish to follow along with the demos you should have access to a machine with PowerShell v 5 or above with a SQL Server 2012 or above instance.

Is this class being recorded?

Yes, this class will be recorded. 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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

Dates: Dec 7 & 8 2020

Timings:

EST 12 noon to 4.00 pm (UTC-5, New York)

CET 6.00 pm to 10.00 pm (UTC +1, Brussels)

IST 10.30 pm to 2.30 am (+1) (UTC +5.30, Bengaluru)

AEDT 4.00 am to 8.00 am (+1) (UTC +11, Sydney)

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.

The Beginner’s Guide To Advanced Performance Tuning

Pre-Con Title

The Beginner’s Guide To Advanced Performance Tuning

Track(s)

Development

Tags

#PerformanceTuning #Index #Query #Plan #T-SQL

Level

Basic

Trainer/Speaker

Erik Darling

Abstract

You’re new to SQL Server, and your job more and more is to fix performance problems, but you don’t know where to start.

You’ve been looking at queries, and query plans, and puzzling over indexes for a year or two, but it’s still not making a lot of sense.

Beyond that, you’re not even sure how to measure if your changes are working or even the right thing to do.

In this full day performance tuning extravaganza, you’ll learn about all the most common anti-patterns in T-SQL querying and indexing, and how to spot them using execution plans. You’ll also leave knowing why they cause the problems that they do, and how you can solve them quickly and painlessly.

If you want to gain the knowledge and confidence to tune queries so they’ll never be slow again, this is the training you need.

Modules/Topics

In this course we’ll be talking about how to read query plans to spot problems, query writing anti-patterns, what makes a good index, how parameterization works, and how to make sure your queries are reliably fast.

Attendee Pre-requisite (if any)

1-2 years working with SQL Server, knows how to write basic queries, the difference between clustered and nonclustered indexes, and how to find query plans.

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

Applying Forensic Accounting Techniques to Data Analysis in Python and SQL

Pre-Con Title

Applying Forensic Accounting Techniques To Data Analysis In Python and SQL

Track(s)

Data Science (AI/ML)

Tags

#Python #DataScience #ForensicAccounting #SQL #Jupyter #numpy #scikit-learn #EnsembleModeling

Level

Advanced

Trainer/Speaker

Kevin Feasel

Abstract

Forensic accountants and fraud examiners use a range of techniques to uncover fraudulent journal entries and illegal activities. As data professionals, most of us will never unravel a Bernie Madoff scheme, but we can apply these same techniques in our own environments to learn more about our data. This video will use a combination of SQL Server and the Python programming language to apply these fraud detection techniques and gain a better understanding of your data.

You will learn a variety of techniques to learn enough about your data to draw interesting inferences, starting with the use of basic analytical techniques, including regression analysis. From there, you will learn how to use cohort analysis to find outliers between groups, leading you on a data-driven approach to forensic investigation. Finally, you will review numeric techniques around data set validity, including rules around the distributions of the first and last digits in data sets.

Modules/Topics

  • Set up the envrionment, including all materials for learners to participate in certain labs. Introduce the problem space and explore the data set. Learners will know the problem we are trying to solve and have an understanding of the kinds of data at our disposal.
  • Perform summary, growth, and gap analyses. Learners will understand how to perform aggregate analyses of static data, as well as flow analyses of time-series data. Learners will additionally understand the importance of gap analysis for forensic accounting and the risks of using identity columns for accounting-critical sequences.
  • Perform a regression analysis. Learners will understand how to perform regression using techniques such as Ordinary Least Squares and Ridge regression. Learners will also understand the concept of collinearity and how it can harm our understanding of a regression result. Learners will additionally understand how to build ensemble regression models using tools like gradient boosting and random forests.
  • Perform cohort and time series analyses. Learners will understand how to slice data and track changes across relevant features, including time.
  • Perform numeric analysis of fact data. Learners will understand the relevance and importance of first-digit and last-digit analysis of data sets for fraud detection purposes.

Attendee Pre-requisite (if any)

Attendees should be familiar with SQL Server and the T-SQL programming language. Familiarity with Python and Jupyter Notebooks is also helpful, though not 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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

A to Z Azure Cosmos DB

Pre-Con Title

A To Z Azure Cosmos DB

Track(s)

Development

Tags

#NoSQL #CosmosDB #Azure #Cloud #Database

Level

Intermediate

Trainer/Speaker

Hasan Savran

Abstract

Azure Cosmos DB is battle tested non-relational database service by Microsoft. It is used by many mission critical applications, including Xbox, Office 365, Azure and Skype.

This workshop will help you take a more in-depth look at Azure Cosmos DB’s architecture, features and tools. We will start with an overview of Azure Cosmos DB’s infrastructure and architecture, then explore its main features and benefits. Additionally, we will use Cosmos DB Emulator for development purposes. In addition, we will look at the Data Migration tool to import and transform data as well as cover stored procedures, available SDKs, and Rest API of Cosmos DB. For the closing of this session we will configure Change Feed functionality using Azure  Functions.

Modules/Topics

  • History, Infrastructure and Architecture of Cosmos DB
  • What does Multi-Model mean?
  • Understanding Consistency Levels
  • Why Partitioning is crucial?
  • Managing Indexes in Cosmos DB.
  • Cosmos DB Constraints
  • Pricing
  • Using Cosmos DB Emulator
  • Querying Cosmos DB with SQL API
  • Setting up TTL
  • Data Type Problems of JSON
  • Creating Stored Procedures
  • How to Import&Transform Data
  • Available SDKs and Rest API
  • Spatial Data in Cosmos DB
  • Configuring Change Feed
  • Using Vs Code extension with Cosmos DB
  • Connecting to Cosmos DB From SQL Server 2019

Attendee Pre-requisite (if any)

The Instructor/Trainer has not specified any pre-requisites.

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

Dates: Dec 7 & 8 2020

Timings:

EST 5.00 pm to 9 pm (UTC-5, New York)

CET 11.00 pm to 3.00 am (+1) (UTC +1, Brussels)

IST 3.30 am (+1) to 7.30 am (+1) (UTC +5.30, Bengaluru)

AEDT 9.00 am (+1) to 1.00 pm (+1) (UTC +11, Sydney)

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.

Machine Learning for Developers

Pre-Con Title

Machine Learning For Developers

Track(s)

Data Science (AI/ML)

Tags

#MachineLearning #DataScience #AzureML #ML.NET #MLOps

Level

Advanced

Trainer/Speaker

Anupama Natarajan

Abstract

If you are a developer and new to Machine Learning and would like to learn ML from Fundamentals to Advanced, then this session is for you. This course will start with an introduction to Machine Learning and walk you through the Machine Learning process. You will get to learn the different types of ML Algorithms and how to use the right algorithm for the right problem with some real-world scenario examples. Then we will delve into the creating Machine Learning models using Azure Machine Learning Service and finally we will wrap up the session with some ML best practices you must consider.

Modules/Topics

Introduction to Machine Learning

  • What is Machine Learning?
  • Machine Learning Challenges
  • Benefits of Machine Learning
  • How to determine Machine Learning Use Cases in your organisation?

Machine Learning Fundamentals

  • Machine Learning Process
  • Machine Learning Algorithms and Patterns
  • Machine Learning Life Cycle
  • How to choose the right algorithm for the right problem?

Advanced Machine Learning

  • Introduction to Azure ML Studio
  • Machine Learning Models using Python Notebooks
  • Create ML models using drag-and-drop tool
  • ML models using Automated Machine Learning
  • Machine Learning models using VS Code
  • Introduction to ML.NET

Machine Learning Best Practices

  •  Models Optimization
  • Enterprise Security and Governance
  • Responsible ML (Privacy, Fairness and Confidentiality)
  • MLOps and Monitoring

Attendee Pre-requisite (if any)

Prior knowledge with Azure Portal, C# or Python.

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

Defence in Depth – Securing your Platform in Azure SQL Database

Pre-Con Title

Defence In Depth – Securing Your Platform In Azure SQL Database

Track(s)

Architecture

Tags

#azure #sql #sqldatabase #security

Level

Advanced

Trainer/Speaker

Martin Cairney

Abstract

With more data security regulations coming into force globally, are we ensuring that our end-to-end data security is up to scratch? Security can be applied to our databases at various levels – from the infrastructure through the transport to the actual data itself.

This workshop will focus on Azure SQL Database and the security that can be applied both in the service itself and at the database level to reduce your risk of exposure.

Attendees will see how features such as Data Classification and Auditing can be combined to promote a defense in depth approach and implement an early warning system for unusual or inappropriate activities.

Modules/Topics

  • Azure Policies
  • ARM Templates
  • Firewalls and Connectivity
  • Advanced Threat Protection
  • Auditing
  • Monitoring
  • Authentication
  • Encryption
  • Data Classification
  • Database Permissions

Attendee Pre-requisite (if any)

  • Familiarity with the Azure Portal and Azure services in general
  • Familiarity with ARM Templates
  • Understanding of the JSON format
  • Writing PowerShell scripts
  • Writing T-SQL queries

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

SQL Server Performance Tuning – Fast Track

Pre-Con Title

SQL Server Performance Tuning – Fast Track

Track(s)

Data Administration

Tags

#Performance #SQLServer #Tuning #Troubleshooting #Query Tuning

Level

Intermediate

Trainer/Speaker

Amit R S Bansal

Abstract

One fine day you realize that you have to start tuning SQL Server for better performance. The need might have arisen from a recent performance issue, or the barrage of support tickets that are filling your inbox, or maybe your boss assigned this to you after realizing that SQL Server performance troubleshooting is not his cup of tea. Irrespective of the reason, the challenge is upon you to identify, diagnose and fix a variety of performance issue that is plaguing your SQL Server environment.

Performance troubleshooting can be categorized as proactive, real-time & reactive. If a well-defined methodology is followed during the proactive phase, you will have to fire-fight less during the real-time troubleshooting phase and you will have a lot of meaningful performance data to work within the reactive phase, which will further help you in preventing performance cases.

Join this demo-filled, full-day class, where you will learn the three approaches of SQL Server performance troubleshooting & tuning. You will learn the practical way, exactly like how you would troubleshoot in the real world with lots of code and scripts. Amongst many takeaways, here are some interesting ones:

  • Develop a performance troubleshooting methodology for the real-world
  • Learn how to benchmark and baseline (and also take away a framework, ready-to-use)
  • Analyzing and troubleshooting common wait types
  • Proactive, reactive and real-time CPU troubleshooting
  • Troubleshooting IO performance bottlenecks
  • Tracking SQL Server memory consumption and fixing OOM errors
  • Dealing with Tempdb madness
  • Top 6 query tuning techniques that will solve 75% of performance issues (real-world query tuning)
  • Top 3 indexing strategies that will fix 60% indexing woes
  • Get rid of deadlocks (yes, you hear it right)
  • SQL Server 2019 performance enhancements
  • In total, there will be five modules comprising of more than 55 demos, all from the real-world. Yes, a lot of content and the class will be fast-paced. The pre-con will focus on recent versions of SQL Server. All demos will be shown on SQL Server 2019. You will walk away with all the demo scripts, most of them being production-ready. You will also get PDF version of the content.

Modules/Topics

Module 1: SQL Server Wait Types & Statistics

  1. Query Lifecycle
  2. Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads
  3. Common Wait Types in SQL Server, identification & diagnosis

Module 2: The Holy Trinity – CPU, Memory, IO

  1. Identifying, troubleshooting & tuning workload patterns that cause excessive CPU
  2. Identifying, troubleshooting & tuning workload patterns that cause excessive Memory Usage
  3. Identifying, troubleshooting & tuning workload patterns that cause excessive IO

Module 3: Query Execution & Query Plan Analysis

  1. Statistics & Cardinality Estimation
  2. Reading & Analysing Execution Plans
  3. Important Iterators

Module 4: Query Tuning

  1. Rewriting Transact-SQL
  2. Optimizing Stored Procedures
  3. Solving Parameter Sniffing Issues
  4. Parametrization Best Practices
  5. Tips with Procedural Code

Module 5: Index Tuning

  1. Demystifying Common Myths with Indexes
  2. Indexing Strategies
  3. Index Fragmentation
  4. Real-World Index Tuning Examples

Module 6: Dealing with Deadlocks

  1. SQL Server Concurrency, Isolation Levels, Locking Granularity & Hierarchy
  2. Common Deadlock Types
  3. Deadlock Best Practices
  4. Practical Deadlock Troubleshooting & Diagnosis

Attendee Pre-requisite (if any)

Pre-requisite: You need to have at least two years of genuine SQL Server experience to gain maximum from this pre-con.

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 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.