Microsoft PolyBase Concepts and Configuration: Binding SQL Server and Other Platforms into a Single Data Source
MP4 | Video: AVC 1920 x 1080 | Audio: AAC 44 Khz 2ch | Duration: 0034 | 323.15 MB

Genre: eLearning | Language: English
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