|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-2022-whats-new/
课程评论：没有评论
Coursera 课程 SQL Server 2022：新功能 - 新增和增强功能 课程总结： 本课程全面介绍了 SQL Server 2022 的主要新功能和增强功能。通过一系列视频讲座和分步实时演示，您将深入了解 SQL Server 2022 的各项重要特性，包括： * **混合数据平台演进：** 了解 SQL Server 如何演变为混合数据平台，以及 Azure 集成功能在历次版本中的增加情况。 * **业务连续性功能：** 学习双向高可用/灾难恢复到 Azure SQL 托管实例、容器化可用性组等业务连续性方面的增强功能。 * **安全功能：** 探索 SQL Server Ledger/区块链分类账表以及其他与安全相关的特性，并通过实时演示深入理解。 * **性能优化：** 掌握查询存储增强功能和内置智能查询处理增强功能（如参数敏感计划优化），并通过实际演示加深理解。 * **其他重要功能：** 了解 Azure Synapse Link、管理功能与增强以及 T-SQL 增强等其他关键更新。 * **实践与应用：** 学习如何在 Windows 上安装和使用 SQL Server 2022，遵循最佳实践，并了解如何开始使用这些新功能。 **课程目标：** 完成课程后，您将能够： * 理解 SQL Server 的发展历程及其作为混合数据平台的意义。 * 熟练安装和使用 SQL Server 2022，并掌握最佳实践。 * 清晰掌握 SQL Server 2022 在业务连续性、安全性、性能及其他方面的新功能和增强。 * 了解如何实际应用这些新特性。 **先修知识：** * 具备 SQL Server 早期版本的基本知识。 * 了解基本的数据库原理。 **课程特色：** * 3 小时高质量视频讲座，包含实时演示和指导。 * 每个章节提供用于知识测试的实用测验。 * 提供可下载的实用资源。 * 课程结束时包含模拟测试。 * 可通过问答区向讲师提问。 * 完成课程可获得证书。
In this course, you will learn all about the new major features and enhancements in SQL Server 2022. Via a comprehensive set of video lectures, enriched with step by step live demonstrations, you will learn about all the major features and enhancements in SQL Server 2022, such as: Bidirectional HA/DR to Azure SQL Managed Instance, Contained Availability Groups, SQL Server Ledger/Blockchain Ledger Tables and other security-related features, Query Store enhancements, Built-in Intelligent Query Processing Enhancements such as Parameter Sensitive Plan Optimization, Azure Synapse Link, T-SQL enhancements and much more. MORE ABOUT THE COURSE:SQL Server 2022, is the most Azure-enabled release of SQL Server yet. Besides the many new features and enhancements for the on-premises Database Engine, it also includes a large number of significant Azure integration features. In this course, we will be discussing all these, in order to get a clear picture about all the new features and enhancements in this version of SQL Server, that is SQL Server 2022.We will begin the course by discussing about, how SQL Server evolved to a hybrid data platform, by listing the Azure integration features that were added in each release of SQL Server up to the 2022 version. Then, we will start discussing about the new features and enhancements, by first discussing about the Business Continuity features and enhancements such as Bidirectional HA/DR to Azure SQL Managed Instance, Contained Availability Groups and other related enhancements. Right after these, we will be discussing about the security features and enhancements. To this end, among other, we will be talking about SQL Server ledger tables and see a relevant live demonstration. In the next section, we will be discussing about the Performance Features and Enhancements in SQL Server 2022, and more precisely, about the Query Store enhancements and Built-in Intelligent Query Processing enhancements and see some interesting live demonstrations on Query Store and Parameter Sensitive Plan Optimization.Last but not least, we will be discussing about other features and enhancements, such as: Azure Synapse Link, Management Features & Enhancements and T-SQL Enhancements.AFTER THE COURSE:After completing the course, you will know:How SQL Server evolved over the years and why this release, makes SQL Server a hybrid data platformHow to install and use SQL Server 2022 on Windows along with following the best practicesWhat are the new Business Continuity Features and Enhancements in SQL Server 2022What are the new Security Features and Enhancements in SQL Server 2022What are the new Performance Features and Enhancements in SQL Server 2022Other significant new features and enhancements in SQL Server 2022, such as main T-SQL enhancements, Azure Synapse Link, Management Features & Enhancements, etc. How you can start using many of these new features and enhancementsPREREQUISITES:Basic SQL Server knowledge in prior versions of SQL ServerBasic database principlesTHIS COURSE OFFERS:3 hours of high-quality video lectures with live demonstrations and guidesUseful quizzes for testing your knowledge on each sectionUseful downloadable resourcesA practice test in the end of the courseAbility to ask the instructor questions related to the course via the Q & A sectionCertificate on course completion
