SQL Server TrackCourse 3 of 7

Microsoft SQL Server Database Administration

This course provides a thorough foundation for effectively managing and maintaining SQL Server environments. Starting with installation and data storage configuration, the course covers security management, backup and recovery strategies, automation using SQL Server Agent, performance monitoring, and high availability solutions to ensure resilient and scalable SQL Server deployments.

28 hours · 19 sessionsCAD $427Beginner to AdvancedHands-On Learning
Enrol in This Course

What you'll learn

  • Install and configure SQL Server with optimised storage settings
  • Implement robust security and user authorisation measures
  • Design and manage backup and recovery strategies for data protection
  • Automate routine administrative tasks and configure alerts
  • Monitor and troubleshoot SQL Server performance and connectivity issues

Prerequisites

SQL Server Database Development recommended. Basic Windows Server knowledge helpful.

Part of the SQL Server Track

Master Microsoft's enterprise database platform.

7 courses · approx. 20–28 weeksBeginner to Advanced
View full track

Course Modules

14 modules · instructor-led, hands-on delivery

01Installing and Configuring SQL Server
02SQL Server Data Storage Configuration
03Security in SQL Server
04Database Recovery Models
05Database Backup
06Database Restore
07Extended Events and SQL Trace
08SQL Server Automation and Notification
09SQL Server Instance Monitoring
10Common Troubleshooting
11Import and Export Data
12Introduction to Enterprise Data Architecture
13Resource Management
14Introduction to High Availability

Other courses in this track

01
Microsoft SQL Server Querying Data16 hours · 11 sessionsCAD $275
02
Microsoft SQL Server Database Development34 hours · 22 sessionsCAD $519
03

Microsoft SQL Server Database Administration(current)

28 hours · 19 sessionsCAD $427
04
05
Microsoft SQL Server Security and Protection13 hours · 9 sessionsCAD $325

Ready to Enrol?

CAD $427 · Get in touch and we'll get you started in Microsoft SQL Server Database Administration.

Send an Enquiry