(MS) Microsoft SQL Server Database Administration Training

(MS) Microsoft SQL Server Database Administration Training

Course Category : Data Management

An intensive, practice-oriented programme enabling DBAs to install, configure, secure, monitor, and tune SQL Server—designing robust backup/restore strategies and high availability topologies aligned with enterprise best practices.
Duration: 5 Days
Level: Advanced.

Starts On

17 - August - 2026

Ends On

21 - August - 2026

Location

Portugal - Lisbon

Language

English

View the course details and register to enroll.

Register Now

View Course Introductory PDF

Targeted Audience

Aspiring and practising SQL Server DBAs.
Database developers and data analysts.
System administrators and infrastructure teams.
IT professionals focused on enterprise data management.
CS/IT graduates targeting a DBA career path.

Targeted Skills

SQL Server installation, configuration, and administration.
Backup/restore strategy and disaster recovery design.
Security hardening and permissions management.
Performance tuning, indexing, and query optimisation.
High availability architectures and business continuity.
Proactive monitoring, automation, and maintenance.
Effective use of SSIS/SSAS/SSRS and advanced T-SQL.

Expected Outcomes

Install and configure SQL Server to enterprise standards.
Design and implement resilient backup/restore policies.
Apply comprehensive server and database security controls.
Tune performance via indexing, execution plans, and monitoring.
Build HA/DR topologies aligned with business SLAs.
Implement maintenance, automation, and KPI-driven monitoring.
Write efficient T-SQL and leverage SSIS/SSAS/SSRS services.
Enforce compliance and protect sensitive information.

Training Topics Index

Engine architecture, editions, SSMS, and service layout.
Best-practice installation, instance setup, data/log/TempDB placement.
Critical server settings (MAXDOP, memory, TempDB, prudent trace flags).
Service/Agent/log management and lab hardening.

Authentication modes, Logins/Users/Roles, and securables.
Always Encrypted/column-level encryption, TDE, keys/certificates.
Auditing, Policy-Based Management, and compliance controls.
Least-privilege patterns, application isolation, and secret handling.

Recovery models, backup types, restore scenarios, and chaining.
Validating backups, test restores, and evidence-based DR drills.
High availability with Always On AGs, failover clustering, and log shipping.
Cross-site DR planning, RPO/RTO targets, and run-book rehearsals.

Wait statistics, locking/latching, I/O diagnostics, resource monitoring.
Index strategies, statistics maintenance, and execution plan analysis.
Query optimisation, plan cache insights, and TempDB tuning.
Maintenance jobs (DBCC, index care, history grooming) with automation.

Advanced T-SQL. procs, functions, triggers, performance patterns.
SSIS (ETL), SSRS (reporting), SSAS (analytics).
Data migration and upgrade strategy (SSMA/SSIS) with post-validation.
Database DevOps. source control, automated deployments, CI/CD.