Pre-Conference Trainings

Migrating Your On-Premise Database To Azure SQLDB/Managed Instance – Why and How?

DBA/CLOUD

Sunil Agarwal (Read Sunil Agarwal’s Speaker Announcement)

Watch Sunil Agarwal talking about his Pre-Con

Many businesses are evaluating if they should migrate their IT infrastructure and/or applications to the cloud. Common concerns range from security, performance, pricing, and just the uneasiness with the new way of running IT as they may no longer have the full control. This workshop focuses on

• Why: Azure is good step forward providing reduced cost, agility of deployment and built-in intelligence to minimize operational complexities to give you a competitive advantage.

• How: Azure provides you intuitive tools to evaluate your workload/application and then migrate them to Azure target of your choice.

• Sample use cases and customer case studies

• Azure overview

• SQLDB and Elastic Pools

• Managed Instance

• Application Certification in Cloud (DBCompat)

• Data Migration Assistant (DMA)

• Data Migration Service (DMS)

• Database Experimentation Assistant (DEA)

• Intelligent Cloud

• Decision matrix for the right azure data platform

• I understand the Azure offerings and how it can help my organization to reduce cost and be more agile

• I understand the tools available to migrate my on-premise database to Azure

• I understand how intelligent cloud will make managing databases easier

• SQLDB and Elastic Pools

• Managed Instance

• Scaling up/down

• DMA tool to evaluate the source database

• DMS to migrate your database to Azure

• Intelligent Cloud to identify common performance issues

• Good understanding of SQL Server and some familiarity with Azure

• Level 200-300, exclusive content from Sunil Agarwal

• 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 🙂

August 07, 2018

9:00 am to 5:00 pm IST

Hotel Radisson Blu (Formerly Park Plaza)
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2018 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 From Rookie To Rock Star

Business Intelligence & Analytics

Reza Rad (Read Reza Rad’s Speaker Announcement)

Watch Reza Rad talking about his Pre-Con

In this training course you will learn Power BI from beginner to advance. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about Power BI Desktop, Power BI Website (Service), and components of Power BI which are; Get and Transform (or Power Query), Modeling (or Power Pivot), and Visualization. You will also learn about Power Query Formula Language (Called M informally), and DAX from beginner to deep dive. This course is designed to give you an end to end view of Power BI, so you be able to use Power BI straight away after this course in your everyday challenges for data analysis.

This course is designed with heaps of live demos, you will learn all the concepts through demos. The content of this course is coming from the most popular parts of the Power BI from Rookie to Rock Star book live for you.

Module 1: Introduction to Power BI

Power BI is the newest Microsoft Business Intelligence and Data Analysis tool. In this module we will go through basics of this product, and introduce all five components of Power BI (Power Query, Power Pivot, Power View, Power Map, and Power Q&A). You will see some demos and introduction about Power BI desktop, Office 365 Power BI subscription, and Power BI website, and mobile apps. You will see some basic demos of how easy to use is Power BI in some scenarios.

• Introduction to Power BI: What is Power BI?

• Power BI Desktop; The First Experience

• Power BI Website; You’ll Need Just a Web Browser

• Introduction to Power BI Components: Power Query, Power Pivot, Power

• View, Power BI Service, and Power Q&A.

Module 2: Getting Data

Getting Data is the first experience of working with Power BI. You can connect to many data sources on-premises or on cloud. For some data sources you can have a live or direct connection, for some connection works offline. For some connections you need a gateway or connector to be installed. In this module you will learn everything about get data experience of Power BI.

• What is Power Query: Introduction to Data Mash-Up Engine of Power BI

• Get Started with Power Query: Movies Data Mash-Up

• Power BI Get Data from Excel: Everything You Need to Know

• File Sources

• Folder as a Source

• Database Sources

• Analysis Services Connection

• Get Data from Azure SQL Database

• Software as A Source

• Web Source

Module 3: Power Query for Data Transformation

Data analysis and BI world starts from data extraction and transformation. Power Query is the data transformation engine of Power BI. Power Query comes as part of Excel 2016, or as an add-in for Excel 2013 and 2010. Power Query is also part of Power BI Desktop. In this module you will learn about all different version of Power Query, their similarities, and differences, as well as configuration and requirements of using them.

Power Query uses a graphical user interface to apply transformations on the dataset. However, Power Query works with a functional scripting language behind the scenes. The key to learn Power Query is learning the functional language called M. There are many features in M that are not available in the Power Query GUI. In this module you will learn how to understand M, and how to write M scripts even from scratch. You will learn writing custom functions in M as well as many other useful features.
The content that you will learn in this module includes but not limited to;

• Different versions of Power Query

• Power Query Introduction

• Query Editor

• Transformation GUI

• Row Transformations

• Column Transformations

• Data Type

• Adding Column

• Text Transformations

• Number Column Calculations

• Date and Time Calculations

• Data types, Lists, Records, and tables in M

• M built-in functions

• Generators in M

• Writing Custom Functions

• Error handling

• Advanced Data Transformations with M

Module 4: Data Modelling and DAX

Power Pivot is xVelocity in-memory data modelling engine of the Power BI. Modelling effectively is the key of high performance BI solution. In this module you will learn basics of Power Pivot such as creating relationships, and calculated members, as well as advanced best practices and DAX expressions. DAX is Data Analytical eXpression language. DAX has similar structure to excel functions, but it is different. In this module you will learn DAX from beginner to advance. You will learn basic functions as well as complex functions and scenarios of using them in real world challenges.
The content that you will learn in this module includes but not limited to;

• Power Pivot xVelocity engine basics and concepts

• Relationships in Power BI

• Best practices

• Introduction to DAX

• Calculated Columns

• Measures

• Calculated Tables

• Row Context vs Set Context

• Advanced calculations using Calculate functions

• Time Intelligence Functions

• DAX Advanced

Module 5: Data Visualization

Data Visualization is the front end of any BI application, this is the user view point of your system. It is critical to visualize measures, and dimensions effectively so the BI system could tell the story of the data clearly. In this module you will learn conceptual best practices of data visualizations which is valid through all data visualization tools. You will learn about visual components in Power BI Desktop. You will learn how to create effective charts, and dashboards using these tools as well as best practices for working with these tools. You will learn about interactivity of charts, using visuals, formatting, filters and slicers, Analytics, special charts such as Scatter, Waterfall, and Custom Visuals.
The content that you will learn in this module includes but not limited to;

• Power BI Desktop Visualization

• Custom Visuals in Power BI Desktop

• Formatting Visuals in Power BI Desktop

• Waterfall Chart

• Built-in Charts and Graphs in Power BI

• Sorting, Filtering, and categorization

• KPIs

• Maps and Geo-Spatial Visualization

• Scatter Chart

Module 6: Gateways

To access on-premises data source from Power BI you need to setup, install, and configure gateways. There are two types of gateways. In this section you will learn what are differences between different gateways, and what are use cases for using each. You will learn tips and techniques for configuring gateway. You will learn how to set up a gateway to connect to on-premises file data sources, SQL Server database, and Analysis Services live connection. at the end of this section Gateway won’t be a beast for you anymore, you can tackle it with confidence.
The content that you will learn in this module includes but not limited to;

• Two Types of Gateway

• Personal Gateway

• On-Premises Gateway

• Architecture of Gateway

• Performance Considerations

• on-premises file data source

• on-premises SQL Server data source

• DirectQuery vs Import Data vs Live Connection

• Live SSAS Tabular Connection

Module 7: Power BI Service, Administration & Security

Power BI components can be deployed into different environments such as Power BI website. In this module we will go through deployment options, Configurations and requirements for publishing reports. You will learn how to deploy your Power BI files into Power BI website. you will also learn how to build dashboards in the website, and how to work with Mobile Apps for Apple, Android and Windows Phone. You will also learn how to set up security for your data, You will learn sharing architecture for reports, and you will learn about Administration privileges on Power BI account.
The content that you will learn in this module includes but not limited to;

• Power BI Service Features

• Design best practices for Power Q&A

• Admin Portal

• Groups and Work Spaces

• Power BI Apps

• Sharing Architecture

• Row Level Security

• Schedule Refresh

• You will understand all components of Power BI

• You will be able to create a Power BI solution for your data analysis challenge in real world

• You will learn all about Power BI Desktop with a lot of demos

• You will learn how to develop a report with the best visualization

• You will learn about data transformation and preparation in Power BI

• You will learn about advanced M scripting in Power Query

• You will learn deep dive DAX tips in Power BI

• You will learn about different architecture plans of Power BI

• You can design the best architecture for your Power BI solution

• You will learn all about gateways and configuring it

• You will learn about sharing and all different methods of it

• You will learn about implementing Row Level Security in advanced scenarios

This course is full of demos. Every module has more than five or six demos. Every sub item in every module will be explained through a demo.

• You Don’t need to know anything about Power BI. This course takes you from the beginner level to the advanced level.

• If you are new to Power BI, or even new to the concept of Business Intelligence, this course is for you. Or even if you are an advanced Power BI user and developer, This course has a lot of deep dive examples which takes you through the most powerful features of Power BI. In any level of understanding from Power BI, you will get benefits from this course.

• Level 200-300, exclusive content from Reza Rad

• 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 🙂

August 07, 2018

9:00 am to 5:00 pm IST

Hotel Radisson Blu (Formerly Park Plaza)
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2018 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 Day Of Intelligent Data Integration With SSIS And ADF

DEV/BIA/CLOUD

Andy Leonard (Read Andy Leonard’s Speaker Announcement)

Watch Andy Leonard talking about his Pre-Con

Intelligent Data Integration

What is Intelligent Data Integration? SSIS packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM (Data Integration Lifecycle Management), executed using an SSIS Framework.

Attend a day of training focused on intelligent data integration delivered by an experienced SSIS consultant who has also led an enterprise team of several ETL developers during multiple projects that spanned 2.5 years. And delivered.

Attendees will learn:

• a holistic approach to data integration design.

• a methodology for enterprise data integration that spans development through operational support.

• a gentle introduction to Azure Data Factory version 2 Integration Runtime (SSIS in the Cloud).

Topics include:

• SSIS Design Patterns

• Executing SSIS in the Enterprise

• Custom SSIS Execution Frameworks

• DevOps and SSIS

• Azure Data Factory version 2 Integration Runtime

• SSIS Design Patterns

• Executing SSIS in the Enterprise

• Custom SSIS Execution Frameworks

• DevOps and SSIS

• Azure Data Factory version 2 Integration Runtime

• A holistic approach to data integration design.

• A methodology for enterprise data integration that spans development through operational support.

• How to leverage the Azure Data Factory version 2 Integration Runtime (SSIS in the Cloud).

• Gathering SSIS baseline performance statistics

• SSIS Design Patterns for Performance

• Custom SSIS Catalog Execution

• Building an SSIS Framework

• Using Biml to Manage SSIS Framework Metadata

• Introduction to Azure Data Factory version 2 Integration Runtime

• Familiarity with SSIS.

• Level 200-300, exclusive content from Andy Leonard

• 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 🙂

August 07, 2018

9:00 am to 5:00 pm IST

Hotel Radisson Blu (Formerly Park Plaza)
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2018 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 Cosmos DB Workshop

BIG DATA

Madhan Gajendran, Manish Sharma, Sandeep Unnimadhavan, Kapil Raja Durga and Arun Khetarpal

This workshop is aimed at introducing Azure Cosmos DB, Microsoft’s planet scale database that provides turnkey global distribution, elastic scale (both storage and throughput), low latency access, well defined consistency levels, multi-model APIs all backed by comprehensive SLAs and lowest total cost of ownership. In this workshop, we will talk about Azure Cosmos DB’s foundational capabilities, demonstrate them by building an application, go over tips and best practices to get the maximum performance and conclude with some real world use cases.

• Core capabilities of Azure Cosmos DB

• Building applications using Azure Cosmos DB

• Migrating Mongo/C*/Gremlin applications/data to Azure Cosmos DB

• Using Cosmos DB as analytical datastore using Spark

• Performance tips and best practices

• Real world Use Cases

• What Azure Cosmos DB is and what applications should use it?

• How to build new applications using Azure Cosmos DB?

• How to migrate existing applications to Azure Cosmos DB?

• How to build real time analytics pipeline on top of Azure Cosmos DB

• Cosmos DB Query Playground

• Elastic Scale

• Replicate Data Globally

• Cosmos DB Mongo API via Robo 3T

• Cosmos DB Graph via Azure Portal

• Azure Notebooks + Cosmos DB

• Level 200-300, exclusive content from Madhan Gajendran & team

• 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 🙂

August 07, 2018

9:00 am to 5:00 pm IST

Hotel Radisson Blu (Formerly Park Plaza)
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2018 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.

Leading Edge Data Science with Microsoft Tools

DATA SCIENCE

Dr. Leila Etaati (Read Leila Etaati’s Speaker Announcement)

In this one-day workshop, the following will be covered:

• An introduction to Machine Learning

• Machine Learning & Cloud – Machine Learning using a data science virtual machine that is a pre-installed and configured VM with several popular tools that are commonly used for data analytics and machine learning.

• Machine Learning & Azure Data lake – How to use Azure ML workbench as an integrated-end-to-end data science and advanced analytics solution to prepare data, develop experiments, and deploy models at the cloud scale.

• Machine Learning On-Premise – how to do Machine Learning self-service BI tools like Power BI using R codes.

• How to set up SQL Server 2017 for writing R or Python code and the best practices.

• Data science in Cloud: how to set up and use data science virtual machine

• Data science in Cloud: how to use machine learning in Azure data lake.

• Data science in Cloud: how to do machine learning and data analysis using Azure ML workbench

• Data science on-premise: how to set up Power BI for using Machine learning

• Data science on-premise: how to set up SQL Server 2017 for writing R or Python codes

• Data science Virtual Machine

• Azure ML workbench

• R and Python

• Power BI and R

• SQL Server and R

• Azure data lake

• Advanced Analytics

• Set up Data Science Virtual Machine

• Machine learning inside Azure data lake

• Writing R in Power BI

• Machine Learning in SQL Server 2017

• To follow the demos and cases, it is better they bring their own laptop and they have admin access. However, the presentation will be in a way that if they just want to listen then can follow it.

• Level 200-300, exclusive content from Leila Etaati

• 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 🙂

August 07, 2018

9:00 am to 5:00 pm IST

Hotel Radisson Blu (Formerly Park Plaza)
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2018 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.

Troubleshoot And Optimize SQL Server Like A Pro!

DBA/DEV

Dmitri Korotkevitch (Read Dmiri Korotkevitch’s Speaker Annoucement)

Watch Dmitri Korotkevitch talking about his Pre-Con

System Troubleshooting and Performance Tuning are always considered to be very challenging tasks. Different problems tend to mask each other degrading performance and affecting user experience in the system.

In this one-day training class, Dmitri (MVP, MCM and author of “Pro SQL Server Internals”) will demonstrate the set of techniques he uses while performing system analysis and performance troubleshooting. Dmitri will show how various issues present themselves in the systems, explain why those issues occur and how to diagnose and address them.

You will learn how to identify and optimize inefficient queries, address concurrency and blocking issues, reduce excessive CPU load, and improve tempdb performance and disk and transaction log throughput. You will see common configuration, database design and code mistakes and understand how to avoid them.

• SQL Server Execution Model and Wait Statistics Analysis

• Inefficient queries: how to detect and optimize; patterns to avoid

• Concurrency and blocking issues

• Query execution, compilation and plan caching issues

• Miscellaneous issues: latch contention, tempdb issues, t-log throughput, I/O latency, parallelism overhead, etc.

• SQL Server and Database configuration best practices

• Learn how to identify and address common issues in the systems based on Wait Statistics, DMV, xEvents, Performance Counters, DB Schema analysis and other techniques

• Understand how to identify and tune inefficient queries and indexes

• Learn how to address concurrency issues in the system

• Learn how to address other miscellaneous issues (high CPU, bad tempdb performance, t-log and I/O latency, plan caching and others)

• Understand SQL Server configuration best practices

The demos will cover multiple common problems (one by one) demonstrating:

• How problems present themselves in the system (waits, dmvs, perf counters, etc)

• How to confirm that problems actually exist

• How to address the problems

• Level 200-300, exclusive content from Dmitri Korotkevitch

• 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 🙂

August 07, 2018

9:00 am to 5:00 pm IST

Hotel Radisson Blu (Formerly Park Plaza)
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2018 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 Intelligence Applications Using The Microsoft AI Platform

DATA SCIENCE/ARTIFICIAL INTELLIGENCE

Dr. Leila Etaati (Read Leila Etaati’s Speaker Announcement)

In this one-day classroom training, I will focus on AI-oriented services such as Azure Bot Services, Azure Search, and Cognitive Services. The main aim of this pre-con is to teach different ways by which one can create smart applications by using some predefined tools to writing some codes in R or Python. A brief description about the Machine Learning concepts will be provided. Audience will learn about how to set up the cognitive services, they will also get familiar with the main services such as face recognition, text analytics and so forth. They will learn how to set up a Bot service and how to use text analytics or other services like Bing search on it. Moreover, they will learn how to set up Azure search to enhance the searching data in their application and reduce complexity. In addition, if they want to develop their own machine learning models using R or Python, they can develop the code inside .Net framework. Finally, if they already developed a model in Azure ML, they will learn how to use the related API inside the .Net framework to create a smart application.

• Machine Learning Concepts and Usage

• Cognitive Services such as Face-recognition, Text Analysis (topic and keyword extraction, semantic analysis)

• Azure Search for Application

• Bot Services and how it able to use Cognitive services

• Azure ML and its API usage in .Net

• R and Python in .Net

• Audience will learn what is cognitive services and how to set it up

• Audience will learn about different modules like face recognition, text Analytics, Bing search

• Audience will learn how to embed these predefined components into .Net applications, Azure bots, Power BI and so forth.

• Audience will learn how to create Azure ML web services and then how to include that into an application

• They will learn how to write R code inside .Net using RTVS

• They will learn about Azure Search which is a search-as-a-service solution

• How to use and create API for different services in cognitive application

• How to create a smart Bot using Visual studio Bot Framework .NET.

• How to set up Azure search application and enhance the Power BI search data in your application

• How to write and develop their own Machine Learning models using Azure ML and then use it in .Net

• How to write R codes inside .Net to create smart applications

• It is good o be familiar with basic of .Net programming and one language such as c#.

• Level 200-300, exclusive content Dr. Leila Etaati

• 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 🙂

August 08, 2018

9:00 am to 5:00 pm IST

Hotel Radisson Blu (Formerly Park Plaza)
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2018 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.

Linux For The SQL Server DBA – A Brave New World

DBA/Open Source

Joey D’Antoni (Read Joey D’Antoni’s Speaker Announcement)

With the brave new world of SQL Server on Linux, it is important for SQL Server professionals to have good understanding of the platform so they can best advise their employers. Even though it is early days for SQL Server on Linux. In this all day session you will learn about the Linux operating system, how to use it, and how to master it, and how to best deploy SQL Server on the Linux platform.
You will learn about topics including:

• Operating system architecture

• Security Model

• File manipulation

• Common commands and using them together

• Bash and Korn shells

• Shell scripting

• File systems and Volume Managers

• Clustering in Linux

The SQL Server specific topics that you will learn about include:

• Monitoring O/S performance

• Proper SQL Server configuration

• Automating deployment

• Deploying High Availability and Disaster Recovery

• New Features in New Releases of SQL Server

If you have limited Linux experience and want to come up to speed, this session will be perfect for you. Attendees will take home lab manual to take the learning home.

• Why Did Microsoft Release SQL Server on Linux

• Installing and Configuring SQL Server on Linux

• Understanding Linux Architecture and commands

• Manipulating Files and Taking Backups

• High Availability and Disaster Recovery for SQL Server on Linux

• Monitoring SQL Server and Operating System Performance

• New Features in SQL Server

• Understand similarities between SQL Server on Windows and Linux

• Understand how to operate the Linux OS

• The basics of shell scripts

• How to monitor performance on Linux

• Installing SQL Server on Linux

• Building an Availability Group in Linux

• PSSDiag collection on Linux

• SQL vNext New Features

• Level 300-400, exclusive content from Joey

• 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 🙂

August 08, 2018

9:00 am to 5:00 pm IST

Hotel Radisson Blu (Formerly Park Plaza)
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2018 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 R For Everyone

DATA SCIENCE

Steph Locke (Read Steph Locke’s Speaker Announcement)

The one-day training takes you through the following topics – fundamentals of R, R for ETL, producing reports, and doing data science. Starting with some simple data manipulation, we’ll quickly progress to tools that can make an immediate impact in your day job.

For ETL, we’ll look at ways to import and export data, transform it, and apply data quality checks along the way.

For producing reports we’ll see how we can build web reports, PDFs, and interactive dashboards.

For data science, we’ll look at how R supports you along the process.

By the end of the day, you’ll know some R (including some advanced stuff!) that you can add to your toolbelt.

• Data Manipulation Fundamentals

• R for ETL

• R for Reporting

• R for Data Science

• Basic R skills in analyzing tabular data

• A good understanding of what is involved in using R for ETL

• Capable of building basic reports in R

• Able to support data scientists or start coding data science

• Tidyverse data pipelines

• Data Manipulation fundamentals

• Importing and exporting data

• Data transformation and quality checking

• Using rmarkdown

• Building flexdashboards

• Data preparation for data science

• Sampling

• Constructing models

• Evaluating models

• Publishing models in SQL Server

• Level 200-300, exclusive content from Steph Locke

• 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 🙂

August 08, 2018

9:00 am to 5:00 pm IST

Hotel Radisson Blu (Formerly Park Plaza)
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2018 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 A Scalable Data Architecture In Azure

CLOUD

Sanjay Mishra, Arvind Shyamsundar, Rama Ramani , Rangarajan Srirangam, Mandar Inamdar and Guru Charan B

Building a secured, scalable and resilient data architecture in Azure for all your data – from streaming to batch, from structured to unstructured, from big data to bigger data, from relational to non-relational. Typical enterprise data architecture involves all types data and processing requirements. This pre-con will cover general architecture patterns, technologies (Microsoft or Open Source) involved, and how to pick the right solution for specific needs, and how to stitch them together in a secured, resilient and scalable way to build the end-to-end solution. We will cover wide variety customer needs and corresponding technology solutions ranging from Azure Storage, Azure Data Lake, Cosmos DB, Azure HDInsight, Azure SQL DB, Azure SQL DW, Azure Databricks, and so on, plus corresponding open source and 3rd-party technologies.

• Architecture Patterns

• Building a “data lake” in Azure

• Building an enterprise data warehouse in Azure

• ETL in the cloud

• Streaming and Batch solutions: Hot Path and Cold Path

• Solutions for Interactive Query

• Security, Performance, Scale, Resiliency, Disaster Recovery

• Putting it all together

• How do customer build data architecture in Azure

• Technology choices and what questions to ask while making the choice

• Achieving perf and scale needs for data solutions

• Designing for Security and Resiliency

• Demo of multiple individual products involved in an end-to-end solution

• Demo of building several end-to-end architectures

• Demo of setting up secured and resilient solutions

• Basic understanding of Azure

• Level 200-300, exclusive content from Sanjay Mishra and AzureCAT Team

• 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 🙂

August 08, 2018

9:00 am to 5:00 pm IST

Hotel Radisson Blu (Formerly Park Plaza)
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2018 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.

Zero To Analysis Services

BIA

Peter Myers (Read Peter Myers’ Speaker Announcement)

Watch Peter Myers talking about his Pre-Con

Get the know-how you need to deliver state-of-the-art data models with Microsoft Analysis Services in SQL Server and Azure. This pre-conference session will teach you the theory behind Analysis Services model development and demonstrate how to design, develop, deploy, and manage them. It will also provide an introduction to Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX), which let you enrich your data models with calculations and data access permissions.

You will learn about the two development approaches: Multidimensional and Tabular. These different approaches give you choice and flexibility, but which should you choose? This preconference session will look at the benefits and limitations of each approach in detail so that you can make an informed decision on which approach is best for your circumstances.

• Introducing Analysis Services

• Developing a Multidimensional Model

• Developing a Tabular Model

• Comparing Model Development Approaches

• Design, develop, deploy and manage multidimensional databases

• Design, develop, deploy and manage tabular databases

• Choose the appropriate approach when developing an Analysis Services project

• End-to-end multidimensional model (cube) development

• End-to-end tabular model development

• This preconference session is targeted at BI developers with an interest in data analysis, and equally for non-developers interested to understand and evaluate the data modeling capabilities of Analysis Services. There is no requirement to have any experience with Analysis Services.

• Level 200-300, exclusive content from Peter Myers

• 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 🙂

August 08, 2018

9:00 am to 5:00 pm IST

Hotel Radisson Blu (Formerly Park Plaza)
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2018 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.

High Availability & Disaster Recovery – SQL Server & Azure

DBA

Denny Cherry (Read Denny Cherry’s Speaker Announcement)

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

• 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 🙂

August 08, 2018

9:00 am to 5:00 pm IST

Hotel Radisson Blu (Formerly Park Plaza)
90-4, Outer Ring Rd, Marathahalli Village, Marathahalli, Bengaluru, Karnataka 560037

• DPS 2018 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.