Microsoft R for the SQL Server Professional
€300 – €545
Microsoft R for the SQL Server Professional

Microsoft R for the SQL Server Professional

Event Information

Share this event

Date and Time

Location

Location

Microsoft Auditorium, EPDC2

South County Business Park

Leopardstown

18 Dublin (Luas Stop: Central Park)

Ireland

View Map

Event description

Description

This workshop covers working with Microsoft R using SQL Server Data. It covers the basics of the R language, using R with SQL Server Databases, and using SQL Server R Services in a solution.

In this workshop you’ll cover a series of modules that guide you from understanding an analytics workload, the Cortana Intelligence Suite Process, the foundations of data transfer and storage, data source documentation, storage and processing using various tools. You’ll also learn how to work through a real-world scenario using the Cortana Intelligence Suite tools, including the Microsoft Azure Portal, PowerShell, and Visual Studio, among others.

You’ll also cover a series of modules that guide you from an introduction to the R programming environment, the Cortana Intelligence Suite Process, the Cortana Intelligence Suite Platform, to the Microsoft R platforms including: Microsoft Open R, the Microsoft R Client, Microsoft R Server, SQL Server with R Services, R in Azure ML, and HDInsight with R. Final lab is an SQL Server R Services solution in Transact-SQL.

Audience:
Technical professionals who are familiar with Transact-SQL who need to learn more about using R in the Microsoft R ecostructure, and need to know how the components work, how to develop and use a solution using R Code in and with SQL Server databases.

Pre-Requisites:
If you want to use a Virtual Machine in Azure, prior to coming to class you will need:
• A subscription to Microsoft Azure (this may be provided through your company or as part of your invitation – you must have this enabled prior to class – you will be using Azure throughout the course, for all labs, work and exercises)
• You can use your MSDN subscription – https://azure.microsoft.com/en-us/pricing/member-offers/msdn-benefits/
• Your employer may provide Azure resources to you, but make sure you check to see if you can deploy assets and that they know you’ll be using their subscription in the class.
• Optionally, you may receive instructions in your class invitation.
• We’ll be using the Data Science Virtual Machine in Azure for the course. (You do NOT need to set it up ahead of time) It has all of the tools you will need to work with the materials. Make sure you’re able to use the Remote Desktop Protocol (RDP) from your system to be able to work through the labs.

If you would like to work the tools locally, you should install (prior to class):
• Visual Studio – the Community Edition (free) is acceptable – Version 2015 preferable (https://www.visualstudio.com/en-us/products/visual-studio-community-vs.aspx)
• SQL Server 2016 (or higher) Developer Edition with ALL features and options selected
• Power BI Desktop Installed (https://powerbi.microsoft.com/en-us/desktop/ )
• Install the Microsoft R Client: http://aka.ms/rclient/download with the R tools for Visual Studio

It’s also a good idea to have a general level of predictive and classification Statistics, and a basic understanding of Machine Learning

Agenda:
• Process and Platform, Environment Configuration
• Data Discovery and Ingestion
• Data Preparation
• Modeling for Machine Learning and Data Mining
• Key Concepts in R
• The Microsoft R Platform
• R Client Options
• Operationalize Microsoft R Solutions
• Creating a Microsoft R Solution

Modules:
• Process and Platform, Environment Configuration
• Data Discovery and Ingestion
• Data Preparation
• Modeling for Machine Learning and Data Mining
• Key Concepts in R
• The Microsoft R Platform
• R Client Options
• Operationalize Microsoft R Solutions
• Creating a Microsoft R Solution

Concepts Covered:
• The Data Science Process, CIS Platform components, Tools installation and overview
• Data sourcing, Feature selection techniques, Data cataloging, Data Ingestion, Data Exploration
• Data selection, including Features, Dimension reduction, Data processing, Data transformation and augmentation
• Algorithm selection and application, Parameter selection and adjustment
• The R Interactive Environment, Data Structures, Functions, Libraries (Packages) and Code Flow
• The Microsoft R ecosystem
• Working with Client Options
• Planning, deploying, managing, and monitoring a Microsoft R platform
• Walking through a complete 6-step solution - SQL Server R Services focused

Technologies covered:
• The Data Science Process, Azure Portal, ADC Interface, Visual Studio Interface (and RTVS)
• Azure Machine Learning Interface, Azure PowerShell, Azure Storage Explorer
• Azure Data Catalog, Azure Storage, Techniques for discovery
• R
• The Microsoft R ecosystem
• SQL Server Stored Procedures, R Tools for Visual Studio, Azure ML
• R Tools for Visual Studio, other R clients demonstrated
• The Data Science Process as it is used in the Microsoft R Platform - SQL Server R Services as an example

Skills Taught:
• Understand the CIS Process (General level), Understand CIS Components (General Level), Set up and configure the development environment
• Understand when to use each component within CIS
• Basic R coding
• Choose, install, configure and use the proper R environment for a given solution
• Connect to a Microsoft R platform from various client tools, run code locally and operationalize on server
• Understand how to plan, deploy, manage, tune and monitor a Microsoft R solution
• Deploy code to a Microsoft R Server, including SQL Server

Schedule
• Registration is 08:15 to 08:15
• Class is 09:00am to 18:00pm with coffee and lunch breaks

Buck Woody (blog | twitter) works on the Microsoft Machine Learning and Data Science Team, using data and technology to solve business and science problems. With over thirty years of professional and practical experience in computer technology, he is also a popular speaker at many conferences around the world; the author of over 650 articles and seven books on database and Machine Learning technologies, teaches Database courses and sits on the Data Science Board at the University of Washington, and specializes in data analysis techniques.

Share with friends

Date and Time

Location

Microsoft Auditorium, EPDC2

South County Business Park

Leopardstown

18 Dublin (Luas Stop: Central Park)

Ireland

View Map

Save This Event

Event Saved