Master Class: Microsoft SQL Server (SQLS22MC)

Fast Lane Benelux B.V.

This course has been retired and replaced by the course (!) .

Price
from €4,995
Level
Higher professional education (hbo)
Kind
Training
Subject
Automation and IT

More information and registration at Fast Lane Benelux B.V.

Description

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 opt...

Start dates

Start End Place Price
14 December 2026 18 December 2026 Online €4,995