Welcome to Microsoft SQL Server: Performance Tuning Essentials, a practical and insightful course taught by Luca Berton, a member of the Starweaver Instructor Team and a recognized expert in automation and database efficiency.
This intermediate-level course is tailored for:
- Database Administrators (DBAs)
- IT Professionals
- Data Analysts
- Technical Managers
If you’re responsible for maintaining high-performance SQL Server environments, this course is for you.
Enroll Now
What You’ll Learn
- ✅ Analyze and tune SQL queries to reduce latency
- ✅ Implement effective indexing and maintenance strategies
- ✅ Monitor and troubleshoot SQL Server performance issues
- ✅ Apply best practices for consistent operations
Course Content Overview
This course includes 11 videos, 5 readings, 1 assignment, and 1 peer review to give you real-world SQL tuning experience.
- Introduction and Welcome
- Exploring Query Tuning Basics
- Planning Query Execution
- Identifying Indexing Strategies
- Database Maintenance
- Monitoring Performance of Troubleshooting Techniques
- Troubleshooting Performance Problems
- Database Maintenance and Optimization
- Examining Strategies for Backup and Restoration
- Database Security Best Practices
- Congratulations and Continuous Learning Journey
Supplementary Readings
- Course Overview
- Case Study: Poor Indexing Strategy
- Comprehensive Guide to SQL Server Optimization
- Stored Procedure Performance Case Study
- SQL Query Tuning in SQL Server
Assignments & Peer Reviews
- Performance Tuning Essentials Assignment (20 minutes)
- Peer Review Project: SQL Server Optimization
Discussion Prompts
- The Role of Indexing and Maintenance in SQL Server Performance
- Advanced Optimization: Benefits and Challenges
Certificate
Upon successful completion, earn a shareable Coursera certificate to showcase your SQL Server tuning skills.
This course was last updated in December 2024 and is included with Coursera Plus.
About the Instructor
Luca Berton is a seasoned instructor in automation and systems performance with 6 published courses and thousands of learners. His engaging teaching style and practical examples make this course both effective and enjoyable.
Ready to optimize your SQL Server like a pro?
Join the course and boost your database performance today.
Enroll Now