Description
Training objective: The learner will discover the server architecture, its configuration, and monitoring of its operation. They will also know how to manage storage spaces, automate tasks, and perform backups and restorations.
Learning Objectives
- Create backup and reorganization plans
- Install and configure Microsoft SQL Server
- Implement continuous monitoring of the database for modifications and performance
- Verify backup procedures and recover databases
- Set up a database and organize data file storage
- Automate and organize routine administration tasks
- Assign permissions and access controls on the server and databases, manage certificates
Target Audience
Database Administrators
Administrators
Operations Managers
System Engineers
Prerequisites
Strong knowledge of SQL Server usage
Ability to manipulate databases
Strong knowledge of the SQL language
Basic knowledge of Windows administration
Program Outline
Informations
Duration
5 jour(s)
35h
Tarif
3250 € HT
HT
Similar Trainings
IA & Data
Cloud Migration
2 jour(s)
Sur demande
IA & Data
AI Agents – Designing Autonomous Systems with LangChain and LangGraph – Advanced
3 jour(s)
Sur demande
IA & Data
European AI Act — Understanding your obligations and ensuring compliance — Beginner level
1 jour(s)
Sur demande
IA & Data
Data Analysis with Microsoft Power BI (4-167)
3 jour(s)
2200 € HT