Database Admin · Online training

MSSQL DBA Training

Installing and configuring SQL Server, security, backup and restore, SQL Server Agent jobs, performance tuning and high availability options.

Level: Beginner to IntermediateDelivery: Online8 modules

Who should attend

Aspiring database administrators, support engineers, developers who manage SQL Server databases and system administrators who look after SQL Server instances.

Prerequisites

Basic T-SQL or SQL knowledge and basic familiarity with Windows. The course starts SQL Server administration from first principles.

Learning outcomes

  • Install, configure and secure a SQL Server instance for a practice environment.
  • Create and manage databases, files, logins, users, roles and permissions.
  • Choose recovery models and plan, run and test full, differential and transaction log backups and restores.
  • Automate routine administration with SQL Server Agent jobs, alerts and maintenance tasks.
  • Diagnose slow queries using execution plans, Dynamic Management Views and Query Store, and improve them with indexes and statistics.
  • Explain high availability and disaster recovery options such as log shipping and availability groups.

Detailed curriculum

8 modules
01Introduction to SQL Server and its architecture
  • The role of a database administrator and typical DBA responsibilities
  • SQL Server editions, versions and components
  • Instances, databases, system databases and their purpose
  • Storage engine basics: data files, log files, pages and extents
  • The transaction log, checkpoints and how SQL Server processes a query
02Installation, configuration and tools
  • Planning an installation: hardware, accounts and disks
  • Installing SQL Server and the management tools
  • SSMS, Azure Data Studio and SQL Server Configuration Manager
  • Instance configuration: memory, parallelism and TempDB settings
  • Patching, service packs and upgrade planning
03Databases, files and storage management
  • Creating databases, data files and filegroups
  • Autogrowth, file sizing and disk space monitoring
  • Schemas, tables, constraints and data types for administrators
  • Moving, detaching, attaching and renaming databases
  • Database compatibility levels and database-level options
04Security: logins, users, roles and permissions
  • Authentication modes, logins and database users
  • Server roles, database roles and custom roles
  • Granting, denying and revoking permissions
  • Schema ownership, contained databases and orphaned users
  • Encryption overview, auditing options and a security hardening checklist
05Backup, restore and recovery
  • Recovery models: simple, full and bulk-logged
  • Full, differential and transaction log backups
  • Restore sequences and point-in-time recovery
  • Backup verification, compression and backup strategy design
  • Corruption checks with DBCC CHECKDB and recovery planning
06Automation with SQL Server Agent and maintenance
  • SQL Server Agent: jobs, steps, schedules and operators
  • Alerts, Database Mail and notifications
  • Maintenance plans compared with scripted maintenance
  • Index and statistics maintenance strategy
  • Documenting and reviewing scheduled jobs
07Performance monitoring and tuning
  • Execution plans and how to read them
  • Indexes: clustered, nonclustered and covering indexes
  • Statistics and parameter-related plan issues
  • Dynamic Management Views, Query Store and Extended Events
  • Blocking, deadlocks, waits and TempDB contention
08High availability, disaster recovery and operations
  • Availability concepts: RPO, RTO and recovery objectives
  • Log shipping and database mirroring concepts
  • Failover clustering and Always On availability groups overview
  • Disaster recovery planning, testing and documentation
  • DBA runbooks, change management and an incident checklist

How you will practise

Learn through instructor-led sessions using realistic, live applications. Then apply each concept through guided assignments on a separate hands-on practice application, with feedback to help you build practical skills and confidence.

Practical exercises and labs

  • Install a SQL Server instance and configure memory, file locations and TempDB.
  • Create logins, users and roles for an application and test the permissions.
  • Take full, differential and log backups, then restore a database to a point in time after deliberate data loss.
  • Create SQL Server Agent jobs for backups, integrity checks and index maintenance, with failure alerts.
  • Capture a slow workload, read its execution plans and improve it using indexes and updated statistics.

Capstone project

Prepare and document a small production-style SQL Server environment for a sample application: installation notes, configuration choices, security design, a tested backup and restore plan, scheduled maintenance, a monitoring checklist and a tuning report with before-and-after evidence.

Tools and technologies

SQL Server (edition and version to be confirmed for each batch), SQL Server Management Studio (SSMS), Azure Data Studio, SQL Server Configuration Manager, SQL Server Agent, Dynamic Management Views, Query Store and Extended Events, on a Windows lab machine or virtual machine.

Assessment approach

  • Module-wise knowledge checks or short practical tasks.
  • Hands-on exercise review using an agreed checklist or rubric.
  • Final project demonstration and explanation of design decisions, test evidence or outputs, as applicable.
  • Completion criteria, attendance requirements and any certificate conditions must be separately approved and published by TrainingRite.

Schedule and fees

Upcoming batch schedules are shared by our TrainingRite team. Please submit an enquiry and our team will contact you by email or phone with the latest schedule. TrainingRite does not publish course fees or discounts on the website. Our counselling team will share the applicable course fee and other details with you by email or phone after you submit an enquiry.

Frequently asked questions

Who should join this course?

Aspiring database administrators, support engineers, developers who manage SQL Server databases and system administrators who look after SQL Server instances.

Do I need prior experience?

Basic T-SQL or SQL knowledge and basic familiarity with Windows. The course starts SQL Server administration from first principles.

Is the training online?

TrainingRite programmes are delivered online.

Will I get hands-on practice?

Sessions are instructor-led and use realistic applications. You then apply each concept through guided assignments on a separate practice application.

How can I enquire about fees and the next batch?

Fees and batch schedules are not published on the website. Submit the enquiry form on this page and our counselling team will share them with you by email or phone.

Related courses