Master Class: Microsoft SQL Server (SQLS22MC)
- Tijdsduur
Master Class: Microsoft SQL Server (SQLS22MC)
Opleiderscore:
Startdata en plaatsen
Fast Lane biedt haar producten standaard aan in de volgende regio's: Utrecht
Beschrijving
Master Class: Microsoft SQL Server (SQLS22MC)
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
- …
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
Master Class: Microsoft SQL Server (SQLS22MC)
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...
The 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 serve...
Fast Lane werkt met Nederlandse trainers die didactische vaardigheden combineren met veel practische ervaring.
Blijf op de hoogte van nieuwe ervaringen
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.