Power BI Service Reporting and Dashboarding End-to-End

   Business Intelligence & Advanced Analytics

   Reid Havens & Siva Harinath

In this one-day session you will learn about the Power BI service and how to publish and share effective reports and dashboards. Mobile delivery of content will also be covered.

This session will appeal to those new to the Power BI service, and also for those already working with the Power BI service (this session will be ideal for filing in any gaps in your knowledge). Note that this session does not include topics for Power BI Desktop data modeling—these are covered in the Day 2 pre-con session.

• Introducing the Power BI Service

• Creating datasets

• Creating reports

• Assembling dashboards

• Sharing Power BI content

• Work productively with the Power BI service

• Create rich, interactive reports

• Leverage proven report design principals to express data appropriately

• Assemble compelling dashboards

• Effectively share Power BI content

• End-to-end demos will reinforce all key theory presented.

• Level 200-300, exclusive content from Reid Havens & Siva Harinath

• Gain real-world knowledge, get real-world exposure packed with real-world demos and examples

• 8 hours of interaction with the Master

• Lunch, Snacks, Tea/Coffee & loads of fun!

• And may be some surprise goodies 🙂

  19 August 2019 (Monday)

   9:00 am to 5:00 pm IST

   Radisson Blu
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2019 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, full-day classes.

• Owing to time constraints, 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 (labs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

   Practical SQL Server Performance Troubleshooting & Tuning

   Database Administration

   Amit Bansal

Practical SQL Server Performance Troubleshooting & Tuning Pre-Con is designed for the working SQL Server professionals, Developers, Database Administrators & Architects who have relevant experience with SQL Server and only needs practical examples of performance troubleshooting & tuning that can be applied in applications & production right away. In this full-day training, participants will see relevant, crisp, real-world examples of tuning SQL Server performance.

An 8-hour, 100% demo-oriented delivery on SQL Server Performance Troubleshooting & Tuning. Basic to Intermediate level, covering important aspects.

• SQL Server Wait Types & Statistics

  • Query Lifecycle

  • Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads

  • Common Wait Types in SQL Server, identification & diagnosis

• The Holy Trinity – CPU, Memory, IO

  • Identifying, troubleshooting & tuning workload patterns that cause excessive CPU

  • Identifying, troubleshooting & tuning workload patterns that cause excessive Memory Usage

  • Identifying, troubleshooting & tuning workload patterns that cause excessive IO

• Query Execution & Query Plan Analysis

  • Statistics & Cardinality Estimation

  • Reading & Analysing Execution Plans

  • Important Iterators

• Query Tuning

  • Rewriting Transact-SQL

  • Optimizing Stored Procedures

  • Solving Parameter Sniffing Issues

  • Parametrization Best Practices

  • Tips with Procedural Code

• Index Tuning

  • Demystifying Common Myths with Indexes

  • Indexing Strategies

  • Index Fragmentation

  • Real-World Index Tuning Examples

• Dealing with Deadlocks

  • SQL Server Concurrency, Isolation Levels, Locking Granularity & Hierarchy

  • Common Deadlock Types

  • Deadlock Best Practices

  • Practical Deadlock Troubleshooting & Diagnosis

• Practical, Real-World Examples

• All Demo Scripts

• Loads of learning that can be applied into production right-away

• Complete 8-hr content is demo packed

• At least two years of genuine working experience with SQL Server

• Level 200-300, exclusive content from Amit Bansal

• Gain real-world knowledge, get real-world exposure packed with real-world demos and examples

• 8 hours of interaction with the Master

• Lunch, Snacks, Tea/Coffee & loads of fun!

• And may be some surprise goodies 🙂

 19 August 2019 (Monday)

   9:00 am to 5:00 pm IST

   Radisson Blu
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2019 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, full-day classes.

• Owing to time constraints, 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 (labs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

Architecting a Modern Analytics Solution – Start To Finish

  Business Intelligence & Advanced Analytics

 Joey D’Antoni

 This full-day session will focus on principles and practices for architecting modern analytics/BI/DW systems in Azure. We will discuss Azure fundamentals, implementation strategies, key decision points, and lessons learned from customer projects. Understanding of cloud design patterns to reduce cost and increase flexibility will be a key focus. Reference architectures will be presented which address scenarios such as real-time data ingestion vs. batch loads, data virtualization vs. data integration, schema on read vs. schema on write, SQL on Hadoop, high data volumes, varying file formats, enabling data science, and machine learning. Demos will include building an end to end environment from the ground up. Students will have input into the design and help make decisions based on business requirements. Approximately 30% of the day will be demos, 50% presentation, and 20% open discussion and questions.

We will discuss technologies including Azure SQL Database, Azure SQL Data Warehouse, Azure Data Lake Store, Cosmos DB, Azure Data Lake Analytics, U-SQL, Azure Storage, Azure Data Factory, Azure Databricks, Spark, Hive, HDInsight, Azure Analysis Services, PolyBase, Elastic Queries, Azure Event Hub, Azure Stream Analytics, Machine Learning Services, Azure Machine Learning, Azure Cognitive Services, Power BI, PowerShell, and Azure Virtual Machines. Attendees of this session will gain a broad understanding of the fundamentals for designing data solutions in Azure, techniques for navigating the wide variety of platform choices in Azure, and suggestions for developing sound architectural systems.

• A broad understanding of the fundamentals for designing data solutions in Azure

• How to choose the right solution for analyzing your data.

• Patterns for data ingestion both in real-time and batch

• Using big data tools and techniques in Azure

•  Real-time data ingestion with stream analytics

•  Data flow scenarios with Azure Data Factory and Power BI

•  Working with Azure SQL Data Warehouse

•  Use of Databricks and Spark

•  Ingesting files from Azure Data Lake

   NA

• Level 200-300, exclusive content from Joey D’Antoni

• Gain real-world knowledge, get real-world exposure packed with real-world demos and examples

• 8 hours of interaction with the Master

• Lunch, Snacks, Tea/Coffee & loads of fun!

• And may be some surprise goodies 🙂

 19 August 2019 (Monday)

   9:00 am to 5:00 pm IST

   Radisson Blu
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2019 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, full-day classes.

• Owing to time constraints, 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 (labs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

Building Machine Learning Solutions with Azure Machine Learning

  Data Science

   Ginger Grant

The ability to both understand and implement Machine Learning [ML] Data Science techniques are skills in great demand by organizations. This session describes the primary use cases for using ML, data shaping techniques and data preparation, algorithm selection, machine learning model development and implementation of the solution. Demonstrations will illustrate how to create ML solutions by implementing the concepts covered for understanding and implementing ML algorithms. Using Azure Machine Learning, Microsoft’s tool for creating and implementing machine learning solutions, attendees will see demonstrations on how to implement ML solutions which they can use in their environment. Different methods for how to create a solution are explored, including writing algorithms in R and Python with Jupyter Notebooks as well as using the Azure Machine Learning drag and drop interface.

• • Introduction to Data Science concepts

  • Understanding Machine Learning Classes and Algorithms

  • Data Manipulation for Machine Learning

  • Deep dive into Algorithm Evaluation

  • Evaluating Solutions

  • Using R to create Machine Learning Solutions

  • Coding Machine Learning Solutions with Python

  • Visualizing Results in Machine Learning

  • Implementing a Machine Learning Solution

• Acquire the knowledge needed to know when machine learning models can be used effectively.

• Recognize some of the common machine learning algorithms.

• Understand the selection process in determining which algorithm to use.

• Learn the process workflow and techniques required to creating solutions.

• Gain a basic understanding of R and when it is the right selection for machine learning.

• Determine why you might want to write code using Jupyter notebooks and the benefits it can provide.

• Absorb the basics of Python and what the appropriate use cases are for using it to create a solution.

• Comprehend why result visualization is important and what meaning they should convey.

• Be able to evaluate the success of an experiment.

• Learn how to take completed models and implement them in a production environment.

• Implementing Concepts in Azure Machine Learning

• Creating a Binary Classification model

• Applied Data manipulation in a machine learning algorithm

• Using Linear Regression

• Binary Model Performance

• Regression Model Performance

• R with Jupyter Notebooks

• Implementing Machine Learning Solutions in Python

• Visualizing Cluster Analysis

• Creating a callable machine learning Web Service

• Implementing a solution in code

• Level 200-300, exclusive content from Ginger Grant

• Gain real-world knowledge, get real-world exposure packed with real-world demos and examples

• 8 hours of interaction with the Master

• Lunch, Snacks, Tea/Coffee & loads of fun!

• And may be some surprise goodies 🙂

 19 August 2019 (Monday)

   9:00 am to 5:00 pm IST

   Radisson Blu
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2019 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, full-day classes.

• Owing to time constraints, 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 (labs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

Azure Infrastructure

Cloud

   Denny Cherry

In this daylong session, we’ll review all the various infrastructure components that make up the Microsoft Azure platform. When it comes to moving SQL Server systems into the Azure platform having a solid understanding of the Azure infrastructure will make migrations successful and making support solutions much easier.

Designing your Azure infrastructure properly from the beginning is extremely important. An improperly designed and configured infrastructure will provide performance problems, manageability problems, and can be difficult to resolve without downtime.

With the introduction of multiple Azure data centers now available in India, many companies will begin moving services from data centers into the Azure and a solid foundation is a key to successful migrations.

• The Azure Data Centers

• Subscription Design

• Azure Resource Manager

• Azure Storage Overview and Architecture

• Authentication

• Networking

• Cross-Premises Connectivity

• Global Load Balancing

• Architecture Patterns

• VMs

• AD in IaaS

• AAD

• Hybrid Identity

• Best Practices for SQL Solutions

• Azure Compute

• Scale Sets

• Open Source in Azure

• Azure Security Features

• Role Based Access Controls

• Monitoring

• Service Monitoring

• Op Insights

• Application Insights

• Microsoft Azure has a variety of different components, many of the components do similar things to each other. In this session we’ll review many of these components, why we should be using them, and when we should be using them, and how to set these components up for the maximum scale.

• Creating storage accounts

• Creating a Shared Access Signature

• Creating a vNET and Subnets

• Creating a Network Security Group

• Setting up Cross Network Connectivity

• Setting up an Availability Set to support a SQL Server Availability Group

• Setting up Availability Zones

• Creating VMs using Managed Storage

• Creating VMs using Availability Sets

• Creating VMs using Availability Zones

NA

• Level 200-300, exclusive content from Denny Cherry

• Gain real-world knowledge, get real-world exposure packed with real-world demos and examples

• 8 hours of interaction with the Master

• Lunch, Snacks, Tea/Coffee & loads of fun!

• And may be some surprise goodies 🙂

 19 August 2019 (Monday)

   9:00 am to 5:00 pm IST

   Radisson Blu
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2019 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, full-day classes.

• Owing to time constraints, 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 (labs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

   Power BI Desktop Data Modeling End-to-End

   Business Intelligence & Advanced Analytics

   Peter Myers & Siva Harinath

In this one-day session 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. Also, a strong foundation in Data Analysis Expressions (DAX) will be presented.

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

• 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

• Choose the right model development mode

• Use Power Query to access and prepare data

• Create and configure data model relationships

• Improve and enhance the data model design with hierarchies and reporting properties

• Add business logic with DAX calculations

• Enforce permissions to ensure users only see the right data

• End-to-end demos will reinforce all key theory presented.

• Level 200-300, exclusive content from Peter Myers & Siva Harinath

• Gain real-world knowledge, get real-world exposure packed with real-world demos and examples

• 8 hours of interaction with the Master

• Lunch, Snacks, Tea/Coffee & loads of fun!

• And may be some surprise goodies 🙂

 20 August 2019 (Tuesday)

   9:00 am to 5:00 pm IST

   Radisson Blu
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2019 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, full-day classes.

• Owing to time constraints, 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 (labs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

Developing Your First Artificial Intelligence (AI) Application

  Data Science/Artificial Intelligence

   Anupama Natarajan

Want to upskill, or kick start your career in Artificial Intelligence and not sure where to start? Then this pre-con is for you. In this pre-con I will introduce you to Artificial Intelligence (AI) and the powerful intersection of data, cloud and AI tools. You will get to learn about different AI platforms (Microsoft, Google and AWS) for developing Intelligent AI solutions. We will then deep dive into developing intelligent AI applications using Microsoft AI Platform consuming 3 major sets of capabilities: Pre-Built AI, Custom AI and Conversational AI.

This demo filled pre-con will showcase how to use AI to solve real-world business problems.
Come to this session and I can guarantee that you will take back enough knowledge to develop your first intelligent AI application using the Microsoft AI stack.

• Introduction to AI

  • What is Artificial Intelligence (AI)?

  • Goals of AI

  • Types of Intelligence

  • Domain of AI

  • Applications of AI

  • Key Terminologies

• AI Platforms

  • Introduction to Microsoft AI

  • Introduction to Amazon AI

  • Introduction to Google AI

• Pre-Built AI

  • Introduction to Azure Cognitive Services

  • Cognitive Services Catalogue

  • Working with Cognitive Services (Acquire, Process and Response)

  • Cognitive Services Pricing & SLA

• Custom AI

  • Introduction to Azure Machine Learning

  • Using Azure Machine Learning Workbench

  • Getting started with Visual Studio Code Tools for AI

  • Data Preparation and Transformation

  • Develop and Operationalise Models

• Conversational AI

  • Getting started with Azure Bot Framework v4

  • Designing and understanding Bot Patterns

  • Developing your first bot

  • Add Authentication to your bot

  • Add Intelligence to your bot

• Understanding of Artificial Intelligence

• Comparison of different AI Platforms

• Develop AI solutions using Pre-Built AI Services

• Gain knowledge on Azure Machine Learning Services & Tools

• Learn how to design and develop Intelligent Bots

• Using Computer Vision and Face Recognition API to extract information and emotion from Images

• Using Custom Vision API to create Image Classification Model

• Knowledge Mining using Azure Cognitive Search

• Azure Machine Learning in Real World Scenarios

• Developing Intelligent bots using Azure Bot Framework integrating with Azure Active Directory, Graph API, LUIS and QnA Maker

• Basic understanding of C#

• Basic knowledge of Azure

• Level 200-300, exclusive content from Anupama Natarajan

• Gain real-world knowledge, get real-world exposure packed with real-world demos and examples

• 8 hours of interaction with the Master

• Lunch, Snacks, Tea/Coffee & loads of fun!

• And may be some surprise goodies 🙂

20 August 2019 (Tuesday)

   9:00 am to 5:00 pm IST

   Radisson Blu
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2019 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, full-day classes.

• Owing to time constraints, 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 (labs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

  Automation, Builds & Containers For DevOps – The ABCD’s Of Deploying Scalable Database Solutions

   Cloud

   Hamish Watson

In this all-day training session that is based on using the Azure platform – you will learn the importance of getting your database code into version control, how various tools can be used for automated build processes that will then feed into an automated deployment process for your database.
Database upgrades are often the most complicated part of your deployment process, so having a robust deployment path and checks before getting to production is very important.

The demonstrations will take a system and deploy it in a DevOps pipeline utilizing many industry tools, such as Git source control, SQL Server Data Tools (SSDT), Redgate tools, Azure DevOps, docker containers, kubernetes clusters and including the Azure platform.

The demonstrations will showcase alternative Open Source Software (OSS) methods that can help achieve a Continuous Delivery deployment pipeline, including a clever pre-production verification process for ensuring your production deployment will succeed.

• Introduce DevOps principles

• Introduce Azure SQL Database and Azure SQL Managed Instance

• Introduce Containers for databases and running SQL Server in Azure Kubernetes Service

• DevOps for the Database: Source control and connecting a database to it

• Infrastructure as Code & Continuous Integration: Automating database build in Azure from source control

• Test Driven Development – why you need to unit test your database

• How to implement Continuous Delivery across multiple environments

• Creating a Database Deployment Pipeline using Azure, containers and DevOps

• How DevOps can make a valuable difference in deploying database changes to your production systems

• DevOps tooling choices and what questions to ask while making the choice

• Why Azure is a great cloud based platform for your database and provides reduced cost and deployment agility.

• Real-world use case for running SQL Server on docker containers and kubernetes in Azure.

• How a lot of DevOps processes can be performed for free using Open Source Software.

The precon training is very heavily focused on LIVE demonstrations. Attendees will learn a lot about DevOps and the various ways it can accelerate your software deployments.

These demonstrations will showcase:

• Demo of various methods to get your database into source control – both free and paid utilities.

• Demo of how to use the Azure portal (Azure PowerShell and Azure ChoudShell) to commission infrastructure using code and configuring database solutions – Azure SQL Database, Azure SQL Managed Instances, SQL Server running on an Azure VM.

• Demo of multiple DevOps products involved in an end-to-end on-premises SQL Server based solution

• Demo of building an end-to-end cloud-based data platform

• Demo of automated builds and automated deployments using Azure and DevOps

• Demo of Open Source utilities used to commission infrastructure

• Demo of Open Source utilities used to commission SQL Server running on docker containers

• Demo of running a kubernetes cluster for your applications and SQL Server

• Demo of automated unit testing your SQL Server code in a DevOps process

• Good understanding of SQL Server.

• Level 200-300, exclusive content from Hamish Watson

• Gain real-world knowledge, get real-world exposure packed with real-world demos and examples

• 8 hours of interaction with the Master

• Lunch, Snacks, Tea/Coffee & loads of fun!

• And may be some surprise goodies 🙂

20 August 2019 (Tuesday)

   9:00 am to 5:00 pm IST

   Radisson Blu
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2019 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, full-day classes.

• Owing to time constraints, 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 (labs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

   Supervised and unsupervised Machine Learning with Python

   Data Science

   Damian Widera

The workshop is dedicated to you all who would like to learn the beauty of Machine Learning. You will learn what is the difference between supervised and unsupervised techniques and how to make use of them. You will see which type of learning is called exploration and which one requires a clear defined target.

You will see how classification and regression processes works (for supervised Machine Learning) and how we can create clustering in our data (for unsupervised Machine Learning). I will also show you how to tune the model manually and automatically.

And I can say even more – believe me or not but there is something in between those two approaches!

• Introduction to Machine Learning

• Data Preparation Techniques – how to deal with missing values, mappings, categorical data

• Supervised Machine Learning

  • Parametric models – linear regression from scratch

  • A game – Naïve Bayes in practice – we will play with cracked coins (it is really a game, no coding)

  • Non-parametric models – k-Nearest Neighbors from scratch

  • Briefly explain other models like decision trees and logistic regression

• Unsupervised Machine Learning

  • Clustering fundamentals and evaluation metrics

  • Briefly explain other models – fuzzy c-means, soft clustering and gaussian mixture

  • Anomaly detection as a practical example

  • Can we go deeper? Neural Networks?

• Semi-supervised Machine Learning – bonus!

• What are the steps in the machine learning process

• How to prepare a data set before the analysis is started

• How to perform a data analysis process using Python and various machine learning algorithms

• How to choose a proper machine learning algorithm for each type of problem

• How to score (evaluate) your model

• Get the data source

• Prepare / clean – up the data

• kNN model in practice and how to tune it

• Linear regression in practice and what does stochastic gradient descent means

• Anomaly detection

• Neural Networks primer

This workshop is designed for both beginners with some programming experience or experienced developers looking to make the jump to Data Science! You should have a knowledge of math on a high school level to understand the algorithms that I am going to present.

• Level 200-300, exclusive content from Damian Widera

• Gain real-world knowledge, get real-world exposure packed with real-world demos and examples

• 8 hours of interaction with the Master

• Lunch, Snacks, Tea/Coffee & loads of fun!

• And may be some surprise goodies 🙂

  20 August 2019 (Tuesday)

   9:00 am to 5:00 pm IST

   Radisson Blu
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2019 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, full-day classes.

• Owing to time constraints, 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 (labs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

 Evolving Your Data Platform For The Cloud

   Cloud

   John Q. Martin

The cloud has given us many opportunities to improve our data platform systems. However, the way we build solutions for the cloud and how we get the most out of it means we need to evolve how we approach it. Understanding the limitations of the different options for Managed Instance, Azure SQL Database, or Azure VMs will help us understand how to architect solutions.

We will look at how to design our infrastructure, where to place our applications as well as how we should be building our applications to get the most out of cloud data platforms.

• What options are there for SQL Server in the Azure cloud.

• Designing cloud data platforms, IaaS VMs or PaaS (Azure SQL DB or Managed Instance)

• The differences between IaaS and PaaS

• High Availability and Disaster Recovery in the cloud

• Application design patterns to get the most from cloud data platforms

• Summary with Q&A

• How to get the most out of cloud data platform with SQL Server

• Understand the SQL Server options in Azure and when to use them

• How to design and build HA/DR in the cloud

• Understand the application patterns for use in the cloud

• Key limitations of SQL Server in the cloud

• Configuring Azure cloud prerequisites for using SQL Server

• Deploy SQL Server in IaaS VMs

• Deploy Azure SQL Database in Azure

• Deploy Managed Instance in Azure

• Configure High Availability for IaaS, SQLDB, and Managed Instance

• Configure Disaster Recovery for IaaS, SQLDB, and Managed Instance

• Demonstrate how performance can be impacted by different workloads and some optimization options.

• Basic understanding of SQL Server

• Level 200-300, exclusive content from John Q. Martin

• Gain real-world knowledge, get real-world exposure packed with real-world demos and examples

• 8 hours of interaction with the Master

• Lunch, Snacks, Tea/Coffee & loads of fun!

• And may be some surprise goodies 🙂

  20 August 2019 (Tuesday)

   9:00 am to 5:00 pm IST

   Radisson Blu
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2019 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, full-day classes.

• Owing to time constraints, 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 (labs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

Tuning Your Workloads For The Cloud With Azure SQL Database

   DBA/DEV

   John Q. Martin

Performance tuning has always been an important requirement for DBAs and Developers working with SQL Server. When moving to the cloud this is even more important, by being great at tuning workloads you can save your employer real money. Now we can put a price on the performance tuning that we do!

I will walk you through the key considerations for how to use Azure SQL Database and the important skills you need to learn to performance tune Azure SQL Database. Starting with setting up Azure SQL Database Correctly, all the way through to capturing performance data and then how to make your code fly.

• Setting up Azure SQL Database correctly

• How to collect performance data to see what you need to tune

• Getting the database schema right

• Writing good queries for the cloud

• Reporting Vs OLTP considerations

• Tuning your application

• Summary with Q&A

• How to setup Azure SQL Database correctly to have a solid foundation to build on

• How to setup the tools that you need for capturing data you need for performance tuning

• The importance of good database schema

• How to improve application performance with better design.

• Setting up Azure SQL Database

• Capturing Extended Events with Azure SQL Database

• Setting up and using Query Store in Azure SQL Database

• How designing the database correctly will improve performance

• How to improve application performance with batching and caching

NA

• Level 200-300, exclusive content from John Q. Martin

• Gain real-world knowledge, get real-world exposure packed with real-world demos and examples

• 8 hours of interaction with the Master

• Lunch, Snacks, Tea/Coffee & loads of fun!

• And may be some surprise goodies 🙂

   21 August 2019 (Wednesday)

   9:00 am to 5:00 pm IST

   Radisson Blu
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2019 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, full-day classes.

• Owing to time constraints, 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 (labs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

Building Data Science Solutions Using Azure Data Bricks

   Business Intelligence & Advanced Analytics

   Ginger Grant

Databricks is a very popular environment for developing data science solutions. More and more companies are interested in Databricks as it is very simple to set up and contains a collaborative workspace for working with a team of people. In this session you will see how to create Machine Learning Solutions with multiple workflows starting with ETL, to data exploration, model experimentation, and lastly to a production release of a data science solution.

Today, more and more development is performed on very large datasets. Attendees will learn how to use Apache Spark, which is part of Databricks, to rapidly analyze lots of data. Learn how to use Databricks to reduces operational complexity to create solutions which can be scaled up or down depending on the amount of data needed to process without having to change the underlying code.

Python, Jupyter Notebooks, and Apache Spark are the technologies used to create solutions within this session. No experience is required with these technologies, as all topics will be introduced as they are the tools needed to create data science solutions. The step-by-step demos will provide all you need to know to implement Databricks.

• • Introduction to Databricks environment

  • Hadoop and Apache Spark Basics

  • Jupyter Notebooks and Python Foundations

  • Machine Learning Data Requirements

  • Data extraction and Understanding with Spark

  • Creating Machine Learning Models

  • Evaluating Machine Learning Models

  • Production Machine Learning Pipelines in Databricks

  • Machine Learning Data Processing with Databricks

• At the end of the data attendees will understand how to use the unified analytical platform of Databricks to create a Data Science Solution

• Understand how and when to use Jupyter Notebooks

• Implement a Machine Learning solution into a production environment

• Schedule Jobs with Databricks and handle unexpected issues

• Create scalable analytic solutions which can scale to meet increasing data needs

• Understand how to use Apache Spark

• Demo Databricks

• Moving Data into Databricks

• Python in Jupyter Notebooks

• Shaping and Cleaning Data with Python

• Preprocessing data with Apache Spark

• Applying Data Science Concepts to the data in Databricks

• Evaluating the results of the Machine Learning models

• Building Machine Learning Pipelines in Databricks

• Demo all the concepts covered to create start to finish solution

• Level 200-300, exclusive content from Ginger Grant

• Gain real-world knowledge, get real-world exposure packed with real-world demos and examples

• 8 hours of interaction with the Master

• Lunch, Snacks, Tea/Coffee & loads of fun!

• And may be some surprise goodies 🙂

  21 August 2019 (Wednesday)

   9:00 am to 5:00 pm IST

   Radisson Blu
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2019 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, full-day classes.

• Owing to time constraints, 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 (labs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

 Back to The Future: Modernizing Your ETL Solution in The Cloud with SSIS in Azure Data Factory

   Business Intelligence & Advanced Analytics

   Sandy Winarko

This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR) that will allow you to lift & shift/modernize/upgrade your ETL solution in the cloud. We will first show you how to provision Azure-SSIS IR – dedicated ADF servers for lifting & shifting SSIS workloads – with your SSIS projects/packages stored in SSIS catalog (SSISDB) hosted by Azure SQL Database server/Managed Instance or in local file shares/Azure Files and extend it with custom/Open Source/3rd party components. We will also show you how to configure Azure-SSIS IR to access data on premises using Windows authentication, Virtual Network (VNet) injection, Self-Hosted IR as proxy, etc. Preserving your skillsets, you can then use the familiar SQL Server Data Tools (SSDT)/SQL Server Management Studio (SSMS) to design/deploy/configure/execute/monitor your SSIS packages in the cloud just like you do on premises. Next, we will guide you to modernize your ETL workflows by invoking/scheduling SSIS package executions as first-class activities in ADF pipelines and combining/chaining them with other activities, allowing you to leverage ADF connectivity (+80 connectors), store secrets in Azure Key Vault (AKV), connect using Azure Active Directory (AAD) authentication with ADF managed identity, automatically provision Azure-SSIS IR on demand/just in time, trigger jobs/runs by file arrivals/deletions, splice built-in/custom/Open Source/3rd party data transformations, such as Power Query Source, Data Quality (Matching/Cleansing) components, etc. And finally, you will learn about the licensing model for ISVs to develop their paid/premium SSIS components/extensions and join the growing 3rd party ecosystem for SSIS in ADF.

• Lifting & Shifting your ETL workflow with SSIS in ADF

• Modernizing your ETL workflow with SSIS in ADF

• Extending your ETL workflow with SSIS in ADF

• You can lift & shift your existing ETL workflow with little/no changes using SSIS in ADF

• You can modernize your ETL workflow as first-class SSIS activities in ADF pipelines

• You can extend your ETL workflow with custom/Open Source/3rd party components using SSIS in ADF

• Lifting & shifting your ETL workloads with SSIS in ADF – Configure Azure-SSIS IR to access data on premises using Windows authentication, Virtual Network (VNet) injection, Self-Hosted IR as proxy, etc.

• Modernizing your ETL workflows with SSIS in ADF – Leverage ADF connectivity (+80 connectors), store secrets in Azure Key Vault (AKV), connect using Azure Active Directory (AAD) authentication with ADF managed identity, automatically provision Azure-SSIS IR on demand/just in time, trigger jobs/runs by file arrivals/deletions, etc.

• Extending your ETL workflows with SSIS in ADF – Splice built-in/custom/Open Source/3rd party data transformations, such as Power Query Source, Data Quality (Matching/Cleansing) components, etc.

NA

• Level 200-300, exclusive content from Sandy Winarko

• Gain real-world knowledge, get real-world exposure packed with real-world demos and examples

• 8 hours of interaction with the Master

• Lunch, Snacks, Tea/Coffee & loads of fun!

• And may be some surprise goodies 🙂

  21 August 2019 (Wednesday)

   9:00 am to 5:00 pm IST

   Radisson Blu
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2019 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, full-day classes.

• Owing to time constraints, 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 (labs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

  App in a Day using Microsoft Power Platform

   Business Intelligence & Advanced Analytics

   Siva Harinath

 Experience the possibilities of building great business apps without writing code at this training for IT and Business decision makers!

As a business leader, you want to react quickly to the changing market and cannot stay dependent on developing a software solution to do that. You want the ability to build a solution to meet your business needs swiftly. With the Microsoft Power Platform, you can build great business apps without writing code.

Digitize business processes, work more efficiently and become more paperless

• With PowerApps, you will enable power-users in line of business roles to easily build and deploy custom business apps in both Canvas and Model-driven style of apps.

 Easily connect all your applications and share data

• With Common Data Service for Apps, you can easily bring your data together and quickly create powerful apps using a compliant and scalable data service and app platform integrated right into PowerApps.

 Automate and optimize your business processes

• Finally, with Microsoft Flow as your business service, your line of business specialists and IT pros can build automated workflows intuitively.

At the end of the training, you will be able to

• Create custom business applications without writing code.

• Learn how to build sophisticated business processes and complex data relationships within your applications.

• Learn how to connect your app to a variety of data sources to bring it to life.

• Share your apps inside your organization securely.

• Introduction to Power Platform

• PowerApps Canvas Apps and Lab Introduction

• Canvas Apps Deep-drive

• Common Data Service for Apps Deep-dive

• Model-driven Apps Deep-drive

• Microsoft Flow Deep-drive

• How to build apps using Power Apps

• Learn about Common Data Service and centralizing your data

• How to automate your business work flows using Microsoft Flow

   Includes a lots of demos.

   NA

• Level 200-300, exclusive content from Siva Harinath

• Gain real-world knowledge, get real-world exposure packed with real-world demos and examples

• 8 hours of interaction with the Master

• Lunch, Snacks, Tea/Coffee & loads of fun!

• And may be some surprise goodies 🙂

  21 August 2019 (Wednesday)

   9:00 am to 5:00 pm IST

   Radisson Blu
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2019 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, full-day classes.

• Owing to time constraints, 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 (labs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

A Deep Dive On Microsoft Azure Data Platform

 DBA/Cloud

 Joey D’Antoni

Azure offers many options for data platform solutions. Whether its CosmosDB, Azure SQL Database or Managed Instance, or other offerings like Azure SQL Data Warehouse, it can be hard to determine what is the right fit for your application. In this all day session, you will learn about all of the Azure Data Platform service offerings, their basic architecture, and a deep dive on how each is architected and how high availability and disaster recovery work for each service. You will also learn about how balance performance and price in each of these services. Additionally, you will learn how security works with Azure Active Directory for each service

• Understanding Azure Architecture

  • Platform as a Service General Arch

  • Networking and Naming

  • Azure Active Directory Security Overview

• Azure SQL Database, Postgres, and MySQL

  • Availability

  • Elastic Pools

  • Performance

• Azure SQL Database Managed Instance

  • Performance

  • Gen Purpose vs Business Critical

  • Networking

  • Data Migration Services

• Azure SQL Data Warehouse

  • Workload Modelling

  • Difference between workloads with Azure SQL DB

  • T-SQL Differences

• Cosmos DB

  • Use cases

  • Costing model

  • Availability

• Cloud Data Architecture

  • Caching

  • CDNs

  • Availability in code

• Understanding of how to build a data architecture for a cloud application

• Understanding why it may be necessary to use multiple data stores for the same application

• Understanding the cost/performance balance of cloud applications

• Configuration of AAD administrators

• Automatic Tuning in Azure SQL DB

• Deploying Managed Instance and Network

• Deploying Cosmos DB with sample app

   Basic understanding of Azure Data Platform

• Level 200-300, exclusive content from Joey D’Antoni

• Gain real-world knowledge, get real-world exposure packed with real-world demos and examples

• 8 hours of interaction with the Master

• Lunch, Snacks, Tea/Coffee & loads of fun!

• And may be some surprise goodies 🙂

  21 August 2019 (Wednesday)

   9:00 am to 5:00 pm IST

   Radisson Blu
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2019 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, full-day classes.

• Owing to time constraints, 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 (labs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

HADR – SQL Server & Azure

 DBA

 Denny Cherry

 In this session, we’ll walk through the needs and process to set up a Hybrid Always On Availability Group using servers on premises for production and servers in Azure for Disaster Recovery.

 We’ll be looking at high availability and disaster recovery tuning requirements, troubleshooting steps and various best practices for Always On Availability Groups in SQL Server 2017.

• Networking and Active Directory Requirements

• Quorum Options for Azure

• Setup and Configuration of a multi-site Windows Cluster

• Setup and Configuration of a multi-site SQL Server Availability Group

• Troubleshooting Always On Availability Groups

•  Networking Requirements

•  Active Directory Requirements

•  Quorum Options

•  Windows requirements

•  SQL Server requirements

•  Settings up the Azure Networking

•  Windows Quorum

•  The configuration of a Windows Cluster

•  The Configuration of a SQL Server Availability Group

•  Troubleshooting an Always On Availability Group

   NA

• Level 200-300, exclusive content from Siva Harinath

• Gain real-world knowledge, get real-world exposure packed with real-world demos and examples

• 8 hours of interaction with the Master

• Lunch, Snacks, Tea/Coffee & loads of fun!

• And may be some surprise goodies 🙂

  21 August 2019 (Wednesday)

   9:00 am to 5:00 pm IST

   Radisson Blu
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2019 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, full-day classes.

• Owing to time constraints, 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 (labs, demos, scripts, etc, as shared by instructor) to practice at their convenience.