Learn how you can connect SQL Server 2022 and Azure SQL to external data, work with CSV, Parquet, Delta, leverage SQL metadata functions and procedures to help with schema discovery and search capabilities. Understand how Create External Tables (CET) and Create External Table as Select (CETAS) can be used to create your very own data tiering solution to offload your read-only data and reduce database maintenance time. Understand how external tables and best practices folder architecture can make it easy to work with large amounts of data.
