May 2020
Beginner to intermediate
1h 3m
English
on-demand course
SQL Server 2019 Big Data Clusters Crash Course: Installing and Using a Big Data Cluster for Data Analysis
with Buck Woody
Closed Captioning available in English
Overview
Learn the architecture and implementation of Microsoft’s latest SQL Server capability - Big Data Clusters. Combine SQL Server for data, PolyBase for data virtualization, Data Pools for scale-out data processing, and Spark with HDFS for scalable non-relational data processing and analysis.
Database professionals who are curious about SQL Server 2019’s flagship feature. For those who want to get started in querying and analyzing massive amounts of data using Spark and HDFS clusters while taking advantage of their SQL Server investment.
You’ll begin this video with a quick overview of the big data space, along with an easy-to-understand introduction to containers, Kubernetes, Spark, and HDFS. You’ll put those pieces together by planning and deploying your own cluster. Then it’s on to operationalizing the cluster through problem-solving with Transact-SQL, PolyBase, data processing at scale, and working with Spark and HDFS.
What You Will Learn
- Understand big data technologies such as Spark and HDFS
- Deploy a Big Data Cluster on a Kubernetes environment in Azure
- Implement PolyBase queries to bring in data from external sources
- Run Transact-SQL statements and process relational data at scale
- Execute Spark jobs and machine learning from within SQL Server 2019
- Implement basic security protocols to protect your data from theft
Who This Video Is For
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.