Course 40565-G: Microsoft Cloud Workshop: Modernizing Data Analytics with SQL Server 2019

Course Modality

Instructor-led (classroom)

Course Level

Advanced

Course Time

1 day

Course Language

English

Course Overview

In this workshop, you will gain a better understanding of how new features of SQL Server 2019 enables more Big Data and analytics capabilities through the use of Big Data Clusters, data virtualization and orchestration, query processing enhancements, and through better scalability through distributed storage and compute.

Prerequisites

There are no prerequisites for this course.

Intended Audience

This workshop is intended for Cloud Architects and IT professionals who have architectural expertise of infrastructure and solutions design in cloud technologies and want to learn more about Azure and Azure services as described in the ‘About this Course’ and ‘At Course Completion’ areas. Those attending this workshop should also be experienced in other non-Microsoft cloud technologies, meet the course prerequisites, and want to cross-train on Azure.

Why The DataTech Labs ?

Self-Paced Online Video

A 360-degree learning approach that you can adapt to your learning style

A 360-degree learning

Engage and learn more with these live and highly-interactive classes alongside your peers

24/7 Teaching Assistance

24/7 Teaching Assistance Keep engaged with integrated teaching

Online Practice Labs

Projects provide you with sample work to show prospective employers.

Applied Projects

Real-world projects relevant to what you’re learning throughout the program

Learner Social Forums

A support team focused on helping you succeed alongside a peer community

Skill Covered

At the end of this workshop, you will be better able:

Design a modernization plan for performing Big Data analytics using SQL Server 2019 capabilities
Build solutions for conducting advanced data analytics with scalable SQLServer2019 Big Data clusters

Get In Touch

Course Curriculum

Module 1

Whiteboard Design Session – Modernizing Data Analytics with SQL Server 2019

Lessons

Review the customer case study
Design a proof of concept solution
Present the solution

Module 2

Hands-On Lab – Modernizing Data Analytics with SQL Server 2019

Lessons

Using data virtualization
Using notebooks
Machine learning
Identify PII and GDPR-related compliance issues using Data Discovery & Classification in SSMS
Exploring intelligent query processing (QP) features
Monitoring the big data cluster

Reviews

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.