starweaver-logo
LOG INGET STARTED
LOG INGET STARTED
  • Browse
  • Doing

  • On Air
  • Channels
  • Career Paths
  • LEARNING

  • Courses
  • Certifications
  • Journeys
  • Test Prep
  • CONNECTING

  • How It Works
  • Community
  • Techbytes
  • Podcasts
  • Leaderboards
  • SUPPORT

  • Support & FAQs
  • Starweaver for Business
  • Starweaver for Campus
  • Teach with Starweaver
footer-brand-logo
  • COMPANY
  • About Us
  • Support and Knowledge Base
  • Policies & Terms
  • Contact
  • CONTENT
  • Courses
  • Certifications
  • Journeys
  • Test Prep
  • Meet the Gurus
  • Techbytes
  • FOR ORGANIZATIONS
  • Starweaver for Business
  • Starweaver for Campus
  • Catalogue
  • Pricing
  • Private Classes
  • PARTNER WITH US
  • Instructors & Teachers
  • Books, Writing & Publishing
  • FOLLOW US
    • facebook
    • twitter
    • linkedin
    • pinterest
    • instagram
    • youtube
Our trademarks include Starweaver®, Make genius happen™, Education you can bank on®, People are your most important assets!®, Body of Knowledge™, StarLabs™, LiveLabs™, Journeys™
© Starweaver Group, Inc. All Rights Reserved.
  1. Courses
  2. >
  3. Microsoft SQL Server: Performance Tuning Essentials

Microsoft SQL Server: Performance Tuning Essentials

This course provides a hands-on approach to optimizing SQL Server performance, blending interactive discussions, real-world scenarios, and practical exercises.

Luca Berton
Luca Berton
Data Science | intermediate | 2 hours |   Published: Feb 2025
In partnership with: Coursera

    Discussions

Overview

1KSTUDENTS*
97.7%RECOMMEND*

This course includes:

  • 2 hours of on-demand video  
  • Certificate of completion  
  • Direct access/chat with the instructor 
  • 100% self-paced online 

This course offers a hands-on approach to optimizing SQL Server performance, combining interactive discussions, real-world exercises, and industry-relevant projects. Leveraging both traditional learning and virtual tools, it provides engaging demonstrations, quizzes, and comprehensive reading materials. You’ll explore query tuning, indexing strategies, and database optimization techniques to enhance efficiency, minimize downtime, and ensure seamless application performance. By the end of this course, you'll be equipped with practical skills to optimize databases, boost efficiency, and tackle real-world challenges with confidence

Skills You Will Gain

SQL Server
Database efficiency
SQL Server troubleshooting
Indexing strategies
Query tuning techniques

Learning Outcomes (At the end of this program you will be able to)

  • Analyze and tune SQL queries to enhance SQL performance and reduce application latency. 
  • Evaluate effective database index and maintenance task strategies to improve efficiency. 
  • Monitor the performance of troubleshooting techniques used for resolving common SQL server issues.  
  • Apply best practices for SQL Server performance to ensure consistent and reliable operations. 

Prerequisites

Basic knowledge of SQL, database management, and query optimization will be helpful. Familiarity with complex queries, indexing, execution plans, wait statistics, and performance tuning concepts is recommended.

Who Should Attend

Database Administrators, IT Professionals, Data Analysts, and Technical Managers involved in SQL Server management, performance optimization, and database efficiency. 

Curriculum

Instructors

Frequently Asked Questions

How much do the courses at Starweaver cost?

We offer flexible payment options to make learning accessible for everyone. With our Pay-As-You-Go plan, you can pay for each course individually. Alternatively, our Subscription-Based plan provides you with unlimited access to all courses for a monthly or yearly fee.

Do you offer any certifications upon completion of a course at Starweaver?

Yes, we do offer a certification upon completion of our course to showcase your newly acquired skills and expertise.

Does Starweaver offer any free courses or trials?

No, we don't offer any free courses, but we do offer 5-day trial only on our subscriptions-based plans.

Are Starweaver's courses designed for beginners or advanced students?

Our course is designed with three levels to cater to your learning needs - Core, Intermediate, and Advanced. You can choose the level that best suits your knowledge and skillset to enhance your learning experience.

What payment options are available for Starweaver courses?

We accept various payment methods such as major credit cards, PayPal, wire transfer, and company purchase orders. For more information related to payments contact customer support.

Do you offer refunds?

Yes, we do offer a 100% refund guarantee for our courses within a specified time frame. If you are not satisfied with the course, contact our customer support team to request a refund with your order details. Some restrictions may apply.

*Where courses have been offered multiple times, the “# Students” includes all students who have enrolled. The “%Recommended” shown is also based on this data.
1Module 1: Fundamentals of SQL Server Query Performance Optimization
2Module 2: Advanced SQL Server Performance Techniques
3Module 3: Database Maintenance and Optimization

Segment 05 - Database Maintenance

Segment 06 - Monitoring Performance of Troubleshooting Techniques

Segment 07 - Troubleshooting Performance Problems

Segment 08 - Database Maintenance and Optimization

Segment 09 - Examining Strategies for Backup and Restoration

Segment 10 - Database Security Best Practices

Segment 11 - Congratulations and Continuous Learning Journey

Segment 01 - Introduction and Welcome

Segment 02 - Exploring Query Tuning Basics

Segment 03 - Planning Query Execution

Segment 04 - Identifying Indexing Strategies

Luca Berton

Luca Berton

With over 15 years of experience in the ever-evolving world of technology, He has established themselves as a skilled Ansible Automation Engineer, seamlessly integrating advancements in Cloud Computing, Linux, and Data Analysis to drive impactful change. His career journey has spanned a range of roles, from crafting software quality pipelines at Red Hat to orchestrating Smart City solutions at City Green Light. Throughout, they have demonstrated an unwavering commitment to excellence and a passion for challenging the status quo to propel enterprises forward.

As Vice President of Infrastructure at JPMorgan Chase & Co., He have led transformative automation initiatives using Ansible technology, paving the way for a future-ready corporate infrastructure. During their tenure at Red Hat as an Ansible Technical Support Engineer, they adeptly navigated complex challenges, ensuring customer success and satisfaction. Their experience also includes orchestrating IoT solutions at Gemmo S.p.A. and architecting scalable Amazon EC2 Linux instances at Studio Storti Srl, consistently delivering innovative, tailored solutions that push technological boundaries.

Their expertise is rooted in a robust educational foundation and a relentless pursuit of knowledge. They hold a Bachelor’s degree in Computer Science from Università degli Studi di Padova and a High School Diploma in Computer Science from ITIS F. Severi - Padova. Furthering their technical acumen, they earned a Nanodegree in Mobile Web Development from Udacity, achieved through a prestigious Google Developer EMEA scholarship. This continuous commitment to staying at the forefront of technological advancements underscores his dedication to excellence.

VIEW MY CHANNEL