SQLS22MCMTMaster ClassMT-SQLS22MC2.1<p>Knowledge in the following areas is desirable:</p> <ul> <li>Basic understanding of administrative tasks</li><li>Basic knowledge of relational databases</li><li>Basic knowledge of the TSQL language</li></ul><p>The primary target group is administrators who want to install, administer and operate Microsoft SQL Server 2022 in their company.</p> <p>This course is also suitable for developers who create applications based on MS SQL Server 2022.</p><h5>Overview of MS SQL Server 2022 components</h5> <h5>Installation and configuration of MS SQL Server 2022</h5><ul> <li>Overview of the installation requirements</li><li>Installing SQL Server 2022 online and unattended</li><li>Best practice configuration of MS SQL Server 2022</li></ul> <h5>Creating databases</h5><ul> <li>Creating and customizing SQL Server databases from a performance and scaling perspective</li><li>Partitioning databases</li><li>Implementing Stretch Database</li></ul> <h5>Security of SQL Server 2022</h5><ul> <li>Create and manage logins, users</li><li>Creating server and database roles</li><li>Working with schemas</li><li>Assigning permissions</li></ul> <h5>Backing up and restoring SQL databases</h5><ul> <li>Getting to know the different backup types</li><li>Creating a backup concept</li></ul> <h5>Setting up maintenance tasks</h5><ul> <li>Introduction to indexes (clustered, non-clustered, columnstore index)</li><li>Maintenance strategies for indexes, statistics and database shrinking</li><li>Defining maintenance plans</li><li>Managing maintenance tasks in the SSIS DB</li></ul> <h5>Automation of SQL Server 2022</h5><ul> <li>Creating jobs and warnings</li><li>Defining proxies</li><li>Automation monitoring</li></ul> <h5>Troubleshooting SQL Server 2022</h5><ul> <li>Reasons of performance bottlenecks</li><li>Getting to know the tools performance monitoring, profiler, extended events, database optimization advisor, data collector, query store, performance dashboard</li><li>Strategic analysis and troubleshooting of performance bottlenecks</li><li>Auto tuning of the SQL server</li></ul> <h5>Introduction to hybrid SQL server operation with the cloud</h5><h5>Overview of MS SQL Server 2022 components</h5> <h5>Installation and configuration of MS SQL Server 2022</h5><ul> <li>Overview of the installation requirements</li><li>Installing SQL Server 2022 online and unattended</li><li>Best practice configuration of MS SQL Server 2022</li></ul> <h5>Creating databases</h5><ul> <li>Creating and customizing SQL Server databases from a performance and scaling perspective</li><li>Partitioning databases</li><li>Implementing Stretch Database</li></ul> <h5>Security of SQL Server 2022</h5><ul> <li>Create and manage logins, users</li><li>Creating server and database roles</li><li>Working with schemas</li><li>Assigning permissions</li></ul> <h5>Backing up and restoring SQL databases</h5><ul> <li>Getting to know the different backup types</li><li>Creating a backup concept</li></ul> <h5>Setting up maintenance tasks</h5><ul> <li>Introduction to indexes (clustered, non-clustered, columnstore index)</li><li>Maintenance strategies for indexes, statistics and database shrinking</li><li>Defining maintenance plans</li><li>Managing maintenance tasks in the SSIS DB</li></ul> <h5>Automation of SQL Server 2022</h5><ul> <li>Creating jobs and warnings</li><li>Defining proxies</li><li>Automation monitoring</li></ul> <h5>Troubleshooting SQL Server 2022</h5><ul> <li>Reasons of performance bottlenecks</li><li>Getting to know the tools performance monitoring, profiler, extended events, database optimization advisor, data collector, query store, performance dashboard</li><li>Strategic analysis and troubleshooting of performance bottlenecks</li><li>Auto tuning of the SQL server</li></ul><h5>Introduction to hybrid SQL server operation with the cloud</h5>Knowledge in the following areas is desirable: - Basic understanding of administrative tasks - Basic knowledge of relational databases - Basic knowledge of the TSQL languageThe primary target group is administrators who want to install, administer and operate Microsoft SQL Server 2022 in their company. This course is also suitable for developers who create applications based on MS SQL Server 2022.Overview of MS SQL Server 2022 components Installation and configuration of MS SQL Server 2022 - Overview of the installation requirements - Installing SQL Server 2022 online and unattended - Best practice configuration of MS SQL Server 2022 Creating databases - Creating and customizing SQL Server databases from a performance and scaling perspective - Partitioning databases - Implementing Stretch Database Security of SQL Server 2022 - Create and manage logins, users - Creating server and database roles - Working with schemas - Assigning permissions Backing up and restoring SQL databases - Getting to know the different backup types - Creating a backup concept Setting up maintenance tasks - Introduction to indexes (clustered, non-clustered, columnstore index) - Maintenance strategies for indexes, statistics and database shrinking - Defining maintenance plans - Managing maintenance tasks in the SSIS DB Automation of SQL Server 2022 - Creating jobs and warnings - Defining proxies - Automation monitoring Troubleshooting SQL Server 2022 - Reasons of performance bottlenecks - Getting to know the tools performance monitoring, profiler, extended events, database optimization advisor, data collector, query store, performance dashboard - Strategic analysis and troubleshooting of performance bottlenecks - Auto tuning of the SQL server Introduction to hybrid SQL server operation with the cloudOverview of MS SQL Server 2022 components Installation and configuration of MS SQL Server 2022 - Overview of the installation requirements - Installing SQL Server 2022 online and unattended - Best practice configuration of MS SQL Server 2022 Creating databases - Creating and customizing SQL Server databases from a performance and scaling perspective - Partitioning databases - Implementing Stretch Database Security of SQL Server 2022 - Create and manage logins, users - Creating server and database roles - Working with schemas - Assigning permissions Backing up and restoring SQL databases - Getting to know the different backup types - Creating a backup concept Setting up maintenance tasks - Introduction to indexes (clustered, non-clustered, columnstore index) - Maintenance strategies for indexes, statistics and database shrinking - Defining maintenance plans - Managing maintenance tasks in the SSIS DB Automation of SQL Server 2022 - Creating jobs and warnings - Defining proxies - Automation monitoring Troubleshooting SQL Server 2022 - Reasons of performance bottlenecks - Getting to know the tools performance monitoring, profiler, extended events, database optimization advisor, data collector, query store, performance dashboard - Strategic analysis and troubleshooting of performance bottlenecks - Auto tuning of the SQL server Introduction to hybrid SQL server operation with the cloud5 days4995.004990.004995.004995.004995.004995.005435.004160.007500.00