Video description
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
Table of contents
- Overview 00:02:10
- The Big Data Landscape 00:09:21
- Architecture and Installation 00:12:16
- Data Ingestion and Transact-SQL 00:07:50
- Data Virtualization with PolyBase 00:09:38
- Creating a Data Mart with Scaled Relational Data 00:05:28
- Running Spark Jobs in Big Data Clusters 00:10:07
- Security Considerations 00:05:01
- How to Keep Learning 00:01:04
- Wrap Out 00:00:27
Product information
- Title: SQL Server 2019 Big Data Clusters Crash Course: Installing and Using a Big Data Cluster for Data Analysis
- Author(s):
- Release date: May 2020
- Publisher(s): Apress
- ISBN: 978148426021
You might also like
video
SQL Server 2019 Big Data Clusters Crash Course: Installing and Using a Big Data Cluster for Data Analysis
Learn the architecture and implementation of Microsoft’s latest SQL Server capability - Big Data Clusters. Combine …
book
SQL Server 2019 Revealed: Including Big Data Clusters and Machine Learning
Get up to speed on the game-changing developments in SQL Server 2019. No longer just a …
book
SQL Server Big Data Clusters: Data Virtualization, Data Lake, and AI Platform
Use this guide to one of SQL Server 2019’s most impactful features—Big Data Clusters. You will …
book
Processing Big Data with Azure HDInsight: Building Real-World Big Data Systems on Azure HDInsight Using the Hadoop Ecosystem
Get a jump start on using Azure HDInsight and Hadoop Ecosystem components. As most Hadoop and …
