July 2020
Intermediate
59m
English
on-demand course
Microsoft PolyBase Concepts and Configuration: Binding SQL Server and Other Platforms into a Single Data Source
with Kevin Feasel
Closed Captioning available in English
Overview
This video provides an overview of PolyBase, Microsoft's technology for data virtualization. Modern data platform environments require that we deal with an increasingly heterogeneous array of technologies spanning the SQL and NoSQL worlds, including SQL Server, Oracle, Teradata, Hadoop, Spark, MongoDB, and more. Whether you are a database developer or administrator, application developer, business analyst, or data scientist, the allure of data virtualization through PolyBase is obvious: one central location where data may be queried regardless of where it lives.
You will learn from this video the high-level concepts associated with PolyBase, starting with its origins and key benefits. You will see how to install and configure PolyBase for SQL Server 2019, and how to prepare for integration with various data platform technologies. From there, you will learn the three key concepts and external object types in PolyBase: external data sources, external file formats, and external tables. Finally, after understanding each of the three external object types, you will see how Microsoft makes it easy to write queries in one consistent language to access data from a variety of data sources, including from competing database brands.
What You Will Learn
- Become familiar with the concept of data virtualization
- Discover where PolyBase fits in the SQL Server ecosystem
- Configure your SQL Server environment to work with PolyBase
- Specify configuration options for connecting to a Hadoop cluster
- Understand how external data sources, file formats, and tables work
- Query from many data sources at once using a single, T-SQL query
Who This Video Is For
Data platform specialists working on multiple data platforms who want to use one unifying language to tie those platforms together. For SQL Server and T-SQL professionals wanting to seamlessly query from other and even competing platforms using their preferred language. For data professionals wanting to combine the power of SQL Server with that of Hadoop.
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.