Introduction to Networking Fundamentals
Format
Self-paced
Price
£199
About the course
Develop practical database administration skills through a series of self-paced, hands-on labs focused on Microsoft SQL Server infrastructure, database security, backup and recovery, performance monitoring, and high availability.
The course introduces key administrative responsibilities, including data encryption, backup and connection encryption, database object permissions, security configuration, and SQL Server auditing to help protect sensitive information and maintain secure database environments.
Learners will explore database backup and recovery techniques, including piecemeal restoration of databases and file groups, restore options, and database integrity maintenance.
Additional labs cover monitoring database activity, configuring data collection and Utility Control Point (UCP), managing Query Store, using Trace and Extended Events, and administering indexes, statistics, and operators to support database performance and troubleshooting.
The course also addresses SQL Server management, log shipping, backups to Azure, availability groups, and failover clustering.
The labs connect database administration concepts with practical operational scenarios, helping learners understand how to secure database assets, recover from failures, monitor workloads, optimise performance, and maintain service availability.
Activities also reinforce the importance of auditing, proactive monitoring, reliable backup strategies, and implementing appropriate resilience measures across database infrastructure.
By completing the labs, learners will develop foundational skills in SQL Server security, encryption, permissions, auditing, backup and recovery, database integrity, performance monitoring, query optimisation, index and statistics management, log shipping, cloud backup, availability groups, and failover clustering.
The course provides a practical foundation for further study and professional development in SQL Server administration, database operations, and enterprise data infrastructure management.
The course introduces key administrative responsibilities, including data encryption, backup and connection encryption, database object permissions, security configuration, and SQL Server auditing to help protect sensitive information and maintain secure database environments.
Learners will explore database backup and recovery techniques, including piecemeal restoration of databases and file groups, restore options, and database integrity maintenance.
Additional labs cover monitoring database activity, configuring data collection and Utility Control Point (UCP), managing Query Store, using Trace and Extended Events, and administering indexes, statistics, and operators to support database performance and troubleshooting.
The course also addresses SQL Server management, log shipping, backups to Azure, availability groups, and failover clustering.
The labs connect database administration concepts with practical operational scenarios, helping learners understand how to secure database assets, recover from failures, monitor workloads, optimise performance, and maintain service availability.
Activities also reinforce the importance of auditing, proactive monitoring, reliable backup strategies, and implementing appropriate resilience measures across database infrastructure.
By completing the labs, learners will develop foundational skills in SQL Server security, encryption, permissions, auditing, backup and recovery, database integrity, performance monitoring, query optimisation, index and statistics management, log shipping, cloud backup, availability groups, and failover clustering.
The course provides a practical foundation for further study and professional development in SQL Server administration, database operations, and enterprise data infrastructure management.