Apply Intermediate SQL Server Administration Techniques
About this course
By the end of this course, learners will be able to configure SQL Server environments, maintain database integrity, automate administrative tasks, analyze performance bottlenecks, and apply modern SQL Server features to support enterprise workloads. Learners will gain hands-on expertise in working with system tables and views, creating and managing databases using T-SQL, implementing robust backup and recovery strategies, and enforcing standards through Policy-Based Management. This intermediate-level course is designed for professionals who already understand SQL fundamentals and want to advance into SQL Server administration, performance tuning, and operational reliability. Through practical demonstrations and real-world scenarios, learners will explore DBCC commands, data import/export techniques, replication architecture, SQL Server Agent automation, and performance analysis using execution plans, DMVs, and profiling tools. What makes this course unique is its strong focus on SQL Server internals and operational decision-making, rather than basic query writing. Learners will develop job-ready skills used by database administrators and data engineers to monitor, optimize, and manage SQL Server systems at scale. Completing this course equips learners with the confidence to handle complex database environments, troubleshoot performance issues, and support business-critical SQL Server deployments effectively.
75/100
CourseAsk score
- What the provider tells you
- 39/45
- Who stands behind it
- 20/35
- How complete the listing is
- 16/20
Scores how much the provider publishes and who stands behind it — not how well it is taught.
What you'll learn
- configure SQL Server environments
- maintain database integrity
- automate administrative tasks
- analyze performance bottlenecks
- work with system tables and views
- create and manage databases using T-SQL
- implement backup and recovery strategies
- enforce standards through Policy-Based Management
Course objectives
- develop job-ready skills for monitoring and optimizing SQL Server systems
- troubleshoot performance issues effectively
- support enterprise workloads with advanced SQL Server features
Price shown by Coursera — confirm on their site.
Enroll on CourseraYou'll be redirected to Coursera to complete enrollment.
- Listed & compared by CourseAsk
- English · 0
Udemy
Coursera
Compared on these lists
Where this course ranks against the alternatives.