Book Image

Hands-On SQL Server 2019 Big Data Clusters with Spark [Video]

By : Jess Dale Dela Cruz
Book Image

Hands-On SQL Server 2019 Big Data Clusters with Spark [Video]

By: Jess Dale Dela Cruz

Overview of this book

<p>A SQL server big data cluster is a cluster of Linux containers orchestrated by Kubernetes. Starting with SQL Server 2019, SQL server big data clusters allow you to deploy scalable clusters of SQL Server, Spark, and HDFS containers running on Kubernetes. This enables you to read, write, and process big data from T-SQL or Spark, allowing you to easily combine and analyze high-value relational data with high-volume big data.</p> <p>In this course, you’ll get up and running with SQL Server 2019 big data clusters. With the help of examples based on a real-world scenario, you’ll see how SQL Server big data clusters provide the flexibility in your interactions with big data. We’ll begin by covering the architecture and concepts of SQL Server 2019 big data clusters. Then, after deploying a big data cluster on your Kubernetes cluster, you’ll learn how to query external data sources, query data from multiple external data sources through the cluster, and load your data into a data pool of SQL Server 2019.</p> <p>By the end of the course, you’ll be well-versed in managing SQL Server 2019 big data clusters with Spark.</p> <p>You can find the code for this course at:<br /><a href="https://github.com/PacktPublishing/Hands-On-SQL-Server-2019-Big-Data-Clusters-with-Spark" target="_blank">https://github.com/PacktPublishing/Hands-On-SQL-Server-2019-Big-Data-Clusters-with-Spark</a></p> <h1>Style and Approach</h1> <p>This course will guide you through providing the best pointers on SQL Server 2019 Big Data Clusters with Spark.</p>
Table of Contents (6 chapters)
Chapter 4
Loading of Data Using SQL Server 2019 Big Data Cluster with Spark
Content Locked
Section 3
Load Data Pool with SQL
In this video, we will learn how to use Azure Data Studio to load data. - Run Transact-SQL command using Azure Data Studio to insert data - Run Transact-SQL command using Azure Data Studio to retrieve the data