Connecting to SQL Server from Databricks

Focused View

Kishan Iyer

55:25

58 View

1. Course Overview

1. Course Overview.mp4

01:55

2. Creating a Databricks Workspace

1. Course Prerequisites and Outline.mp4

02:01

2. The Need for Tool Integrations.mp4

04:41

3. Linking Relational Databases with Databricks.mp4

04:49

4. Demo - Creating a Custom Virtual Network.mp4

03:20

5. Demo - Provisioning a Databricks Workspace.mp4

03:58

3. Running SQL Server in a Docker Container

1. An Overview of SQL Server and Docker.mp4

03:23

2. Demo - Provisioning a Virtual Machine.mp4

04:35

3. Demo - Setting Security Rules to Connect to a VM.mp4

05:47

4. Demo - Installing Docker and SQL Server on a VM.mp4

06:29

4. Querying SQL Server from Databricks

1. Linking Databricks and SQL Server.mp4

02:29

2. Demo - Initializing the SQL Server Database.mp4

04:24

3. Demo - Connecting to the Database from a Databricks Notebook.mp4

06:19

4. Course Summary and Related Content.mp4

01:15

Description

This course covers the steps involved in setting up a SQL Server instance and a Databricks workspace in the same virtual network, and querying the database from a notebook.

What You'll Learn?

Databricks is a versatile and powerful data platform which can help us perform a lot of processing, analysis and machine learning tasks. But it often needs to source its data from external storage systems, such as relational databases. In this course, Connecting to SQL Server from Databricks, you'll learn how the data in a SQL Server database can be accessed from a Databricks workspace. First, you'll explore provisioning a Databricks workspace in a custom virtual network. Next, you'll discover a number of connection rules to ensure that Databricks and SQL server can communicate with each other, and also enable connections to the database from a local SQL client. Finally, you'll learn how to query a table in the SQL Server database from a notebook in our Databricks workspace. Once you complete this course, you will become aware of the infrastructure set-up needed to ensure that two popular data platforms - Databricks and SQL Server - are able to communicate with one another, and can implement such a link in your own environment.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Microsoft SQL

Kishan Iyer

Instructor's Courses

I have a Masters in Computer Science from Columbia University and have worked previously as a developer and DevOps engineer. I now work at Loonycorn which is a studio for high-quality video content. My interests lie in the broad categories of Big Data, ML and Cloud.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.