Apply Intermediate SQL Server Administration Techniques

Grow your skills with Coursera Plus for $239/year (usually $399). Save now.

Apply Intermediate SQL Server Administration Techniques

This course is part of Apply SQL Server Database Management & Analytics Specialization

Instructor: EDUCBA

Included with

Learn more

7 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

7 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Configure and manage SQL Server environments using system tables, views, and T-SQL.
Implement backup, recovery, automation, and policy management for reliable operations.
Analyze performance issues using DBCC commands, DMVs, execution plans, and profiling tools.

Skills you'll gain

Server Administration

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Apply SQL Server Database Management & Analytics Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 7 modules in 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.

This module introduces the scope of the MS SQL Server Intermediate course and builds foundational understanding of SQL Server internals, system tables, and database creation using T-SQL for administrative control.

What's included

9 videos4 assignments

9 videos Total 68 minutes

Course Overview and Objectives 4 minutes
SQL Server Architecture Overview 5 minutes
SQL Server Tools and Environment 8 minutes
System Tables: Introduction 10 minutes
System Tables: Practical Usage 8 minutes
Using BCP Command 11 minutes
Creating Databases Using T-SQL 9 minutes
Database Creation Options and Settings 5 minutes
DBCC Commands: Fundamentals 7 minutes

4 assignments Total 60 minutes

Course Orientation & Overview 10 minutes
Exploring SQL Server System Tables 10 minutes
Database Creation Fundamentals 10 minutes
Course Foundations & SQL Server Internals 30 minutes

This module focuses on maintaining database integrity through DBCC commands and implementing reliable backup strategies to ensure data protection and recoverability.

What's included

9 videos4 assignments

9 videos Total 61 minutes

DBCC Commands: Integrity Checks 8 minutes
Advanced DBCC Commands 7 minutes
DBCC Commands for Maintenance 8 minutes
Database Backup Basics 7 minutes
Full Database Backup Techniques 8 minutes
Backup Strategies and Types 5 minutes
Backup Compression and Security 7 minutes
Managing Backup History 5 minutes
Importing and Exporting Data 5 minutes

4 assignments Total 60 minutes

Understanding DBCC Commands 10 minutes
Backup Basics in SQL Server 10 minutes
Advanced Backup Concepts 10 minutes
Database Consistency & Maintenance Commands 30 minutes

This module covers data transfer techniques, backup automation, policy enforcement, and introduces replication concepts for controlled data distribution.

What's included

9 videos4 assignments

9 videos Total 78 minutes

Data Transfer Using SSMS 9 minutes
Automated Backup Configuration 6 minutes
Backup Scheduling and Monitoring 11 minutes
Policy-Based Management Overview 7 minutes
Creating and Applying Policies 5 minutes
Managing Policy Compliance 6 minutes
Creating Differential Backup and Restoration 10 minutes
SQL Data Replication 13 minutes
Configuring Replication 10 minutes

4 assignments Total 60 minutes

Importing and Exporting Data 10 minutes
Policy-Based Management 10 minutes
Differential Backup & Replication Basics 10 minutes
Data Movement & Backup Automation 30 minutes

This module explains SQL Server replication architecture, including configuration, publications, subscriptions, and monitoring replication-related activity.

What's included

9 videos4 assignments

9 videos Total 70 minutes

Replication Monitoring and Management 6 minutes
SQL Logs 7 minutes
Installing Replication Components 6 minutes
Configuring Replication Services 8 minutes
Creating Publication and Subscription 10 minutes
More on Publication and Subscription 10 minutes
Checking Activity Monitor 7 minutes
SQL Server Agent Architecture 9 minutes
SQL Server Agent Configuration 7 minutes

4 assignments Total 60 minutes

Replication Configuration 10 minutes
Publication and Subscription 10 minutes
Monitoring Server Activity 10 minutes
SQL Server Replication Architecture 30 minutes

This module focuses on automating administrative tasks using SQL Server Agent and monitoring query performance using profiling and optimization fundamentals.

What's included

9 videos4 assignments

9 videos Total 73 minutes

Creating Jobs and Alerts 11 minutes
Check the Job Activity 10 minutes
SQL Server Profiler Basics 8 minutes
Advanced SQL Server Profiler 7 minutes
Execution Plans: Introduction 7 minutes
Analyzing Query Execution Plans 7 minutes
Dynamic Management Views (DMVs) Overview 9 minutes
Performance Analysis Using DMVs 5 minutes
Query Optimization Using Hints 8 minutes

4 assignments Total 60 minutes

SQL Server Jobs and Alerts 10 minutes
SQL Server Profiler Deep Dive 10 minutes
Query Optimization Fundamentals 10 minutes
Job Automation & Performance Monitoring 30 minutes

This module explores advanced query tuning techniques using hints, Dynamic Management Views, system views, and profiling tools for performance diagnostics.

What's included

9 videos4 assignments

9 videos Total 65 minutes

Advanced Optimizer Hints 7 minutes
Query Hints: Practical Usage 6 minutes
Query Hint Scenarios 10 minutes
Server-Level DMVs 5 minutes
Database-Level DMVs 7 minutes
Advanced DMV Analysis 6 minutes
System Views and Metadata 8 minutes
Managing System Views 8 minutes
SQL Server Profiler Review 9 minutes

4 assignments Total 60 minutes

Query and Optimizer Hints 10 minutes
Working with DMVs 10 minutes
System Views & Profiling 10 minutes
Query Tuning & Dynamic Management Views 30 minutes

This module covers advanced performance analysis techniques and modern SQL Server features including execution plans, In-Memory OLTP, and Business Intelligence integration.

What's included

11 videos4 assignments

11 videos Total 90 minutes

Profiler Performance Analysis 6 minutes
DMVs for Server Events 7 minutes
Monitoring Server Events 7 minutes
Performance Tools in the Database 10 minutes
Displaying the Execution Plan 11 minutes
Setting Alter Database 11 minutes
In Memory OLGP 8 minutes
Creating a Table with the Primary Key 8 minutes
Select Object Property 8 minutes
Business Intelligence Part for the Database Technology 8 minutes
Retrieving SQL Server 6 minutes

4 assignments Total 60 minutes

Advanced Profiling & Server Events 10 minutes
Performance Analysis Tools 10 minutes
Modern SQL Server Capabilities 10 minutes
Advanced Performance & Modern SQL Server Features 30 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

EDUCBA

1,050 Courses 249,779 learners

Offered by

EDUCBA

Explore more from Data Management

Packt
Intermediate Oracle Database Administration
Course
EDUCBA
Apply SQL Server Database Management & Analytics
Specialization
EDUCBA
Design and Implement SQL Server Databases
Course
Packt
The Ultimate T-SQL And Microsoft SQL Server Bootcamp
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.