Explore SQL Server 2022 capabilities
- Offered byMicrosoft
Explore SQL Server 2022 capabilities at Microsoft Overview
Duration | 6 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
Explore SQL Server 2022 capabilities at Microsoft Course details
- Introduction to SQL Server 2022
- Understand hybrid data platform on SQL Server 2022
- Understand the built-in query intelligence enhancements of SQL Server 2022
- Explore new capabilities in security, scalability, and availability in SQL Server 2022
- Introduction to SQL Server 2022 data virtualization
- Introduction to SQL Server 2022 T-SQL enhancements
- Learn about SQL Server 2022 enhancements, including:
- Hybrid capabilities with the cloud and on-premises
- Performance and data virtualization improvements
- Improved security and availability
- Enhanced analytics capabilities
Explore SQL Server 2022 capabilities at Microsoft Curriculum
Introduction to SQL Server 2022
Introduction
Deployment options, licensing, and feature differences in SQL Server 2022
Build a hybrid data platform with SQL Server 2022
Gain performance insights when you need it and accelerate performance with no code changes
Power your application with an industry proven database engine with security, scalability, and availability
Use SQL Server 2022 as a data hub querying files and backup/restore to object storage providers
Learn how developers can use new T-SQL language enhancements
Summary
Understand hybrid data platform on SQL Server 2022
Introduction
Ensure Business Continuity with Azure SQL Managed Instance
Simplify management with Azure Arc-enabled SQL Server
Near real-time analytics with Azure Synapse Link for SQL
Secure with Azure Active Directory authentication
Microsoft Purview access policies for SQL Server
Knowledge check
Summary
Understand the built-in query intelligence enhancements of SQL Server 2022
Introduction
Memory grant feedback
Exercise - Memory grant feedback persistence in SQL Server 2022
Parameter Sensitive Plan optimization
Exercise - Parameter Sensitive Plan
Degree of Parallelism (DOP) feedback
Exercise - Degree of Parallelism feedback
Summary
Explore new capabilities in security, scalability, and availability in SQL Server 2022
Introduction
Ledger in SQL Server 2022
Exercise - Ledger
Learn about the security enhancements in SQL Server 2022
Enhancements in SQL Server 2022 to help scalability
Availability enhancements in SQL Server 2022
Summary
Introduction to SQL Server 2022 data virtualization
Introduction
Introduction to PolyBase
Understand credentials and data sources with PolyBase
Exercise - Query Parquet file
Exercise - Use data virtualization to connect to Azure SQL Database
CREATE EXTERNAL TABLE as SELECT (CETAS)
Exercise - CREATE EXTERNAL TABLE as SELECT
Summary
Introduction to SQL Server 2022 T-SQL enhancements
Introduction
Create index and resumable constraint enhancements
Named window definition with the SELECT WINDOW clause
Enhance expression comparisons with IS [NOT] DISTINCT FROM
Time and series functions enhancements
String and other functions enhancements
New and improved JSON functions
New aggregation functions
New bit manipulation functions
Summary
Explore SQL Server 2022 capabilities at Microsoft Entry Requirements
- Basic working knowledge of SQL Server, including deployment, security, query processing, and high availabilityFundamental knowledge of the T-SQL languageBasic knowledge of Azure concepts, including subscriptions, resource groups, Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS)
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?