Introduction to SQL Server 2022 data virtualization

  • Module
  • 8 Units
Beginner
Database Administrator
Data Engineer
Administrator
SQL Server

Learn about data virtualization, enhanced Polybase features in SQL Server 2022, and how to use Polybase to access and query external data.

Learning objectives

After you complete this module, you:

  • Understand the benefits and principles of data virtualization.
  • Know what PolyBase is and how to use its capabilities.
  • Are familiar with object storage solutions and SQL Server 2022 support for S3-compatible object storage.
  • Know how to install and configure PolyBase on SQL Server 2022.
  • Know how to access and query external data by using PolyBase in SQL Server 2022.

Prerequisites

  • Basic working knowledge of SQL Server 2022
  • Fundamental knowledge of T-SQL and SQL query execution
  • SQL Server 2022 installed
  • SQL Server Management Studio (SSMS) installed