This course focuses on performance optimization and scalability in application development. You'll learn key techniques like caching, query optimization, and load balancing while using Microsoft Copilot to improve application code and database query performance.

Performance Optimization and Scalability

Performance Optimization and Scalability
This course is part of multiple programs.
This course is part of multiple programs

Instructor: Microsoft
Access provided by Vivekananda Global University
2,651 already enrolled
12 reviews
Recommended experience
Recommended experience
Beginner level
No prior experience is required for this course.
12 reviews
Recommended experience
Recommended experience
Beginner level
No prior experience is required for this course.
Skills you'll gain
Tools you'll learn
Details to know

Add to your LinkedIn profile
See how employees at top companies are mastering in-demand skills

Build your subject-matter expertise
- 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 from Microsoft

There are 4 modules in this course
Efficient caching strategies are critical for improving application performance and reducing database load. This module introduces the concept of caching and its significance in optimizing .NET Core applications. Learners will explore in-memory caching and distributed caching implementations, understand cache expiration and invalidation strategies, and identify best practices for integrating caching mechanisms. By the end of this module, participants will be able to leverage caching effectively to enhance application responsiveness and scalability.
What's included
22 videos17 readings12 assignments3 ungraded labs3 plugins
22 videos• Total 90 minutes
- Course Introduction: Performance Optimization and Scalability• 2 minutes
- Instructor Introduction• 2 minutes
- The What’s What of the Course• 3 minutes
- Completing the Guided Labs• 4 minutes
- Introducing the AI Tool: Microsoft Copilot• 3 minutes
- How to Be Successful in This Program• 5 minutes
- Introduction to the Project• 4 minutes
- Introduction to Caching Strategies With .NET Core• 1 minute
- What is Caching?• 3 minutes
- How Caching Enhances Performance• 3 minutes
- In-Memory Caching Overview• 4 minutes
- Distributed Caching Overview• 3 minutes
- Configuring In-Memory Caching• 5 minutes
- Managing Cache Operations With IMemoryCache• 4 minutes
- Implementing In-Memory Caching in .NET• 4 minutes
- Setting Up Redis for Distributed Caching• 8 minutes
- Managing Data With Redis• 6 minutes
- Configuring Redis Caching in .NET• 7 minutes
- Overview of Cache Expiration Strategies• 3 minutes
- Implementing Cache Expiration Policies in .NET• 6 minutes
- Applying Cache Expiration Policies in .NET• 8 minutes
- Conclusion: Caching Strategies With .NET Core• 1 minute
17 readings• Total 270 minutes
- Course Syllabus: Performance Optimization and Scalability• 10 minutes
- Completing the Guided Labs• 30 minutes
- Microsoft Tools for Back-End Development• 10 minutes
- Activity: Identifying Real-World Caching Opportunities - Answer Key• 10 minutes
- Core Concepts of Caching• 10 minutes
- Activity: Comparing Cached and Non-Cached Data Retrieval - Answer Key• 30 minutes
- In-Memory vs. Distributed Caching: Use Cases and Trade-offs• 10 minutes
- Activity: Designing a Caching Strategy - Answer Key• 10 minutes
- Implementing and Managing In-Memory Caching in .NET• 10 minutes
- You Try It! Implementing In-Memory Caching in .NET - Answer Key• 30 minutes
- Activity: Planning Redis Integration - Answer Key• 10 minutes
- You Try It! Configuring Redis Caching in .NET - Answer Key• 30 minutes
- Activity: Reflect on Cache Synchronization Challenges - Answer Key• 10 minutes
- Using Redis for Distributed Caching• 10 minutes
- Activity: Designing Expiration Policies - Answer Key• 10 minutes
- You Try It! Applying Cache Expiration Policies in .NET - Answer Key• 30 minutes
- Best Practices for Cache Expiration in .NET• 10 minutes
12 assignments• Total 345 minutes
- Graded Quiz: Caching Strategies With .NET Core• 50 minutes
- Activity: Identifying Real-World Caching Opportunities• 30 minutes
- Practice Quiz: Basic Cashing Concepts• 20 minutes
- Activity: Comparing Cached and Non-Cached Data Retrieval• 30 minutes
- Practice Quiz: Caching Strategies: In-Memory and Distributed Caching• 20 minutes
- Activity: Designing a Caching Strategy• 30 minutes
- Practice Quiz: Implementing In-Memory Caching• 25 minutes
- Activity: Planning Redis Integration• 30 minutes
- Activity: Reflect on Cache Synchronization Challenges• 30 minutes
- Practice Quiz: Configuring Distributed Caching• 25 minutes
- Activity: Designing Expiration Policies• 30 minutes
- Practice Quiz: Managing Cache Expiration Policies• 25 minutes
3 ungraded labs• Total 180 minutes
- You Try It! Implementing In-Memory Caching in .NET• 60 minutes
- You Try It! Configuring Redis Caching in .NET• 60 minutes
- You Try It! Applying Cache Expiration Policies in .NET• 60 minutes
3 plugins• Total 90 minutes
- Guided Lab: Implementing In-Memory Caching in .NET• 30 minutes
- Guided Lab: Configuring Redis Caching in .NET• 30 minutes
- Guided Lab: Applying Cache Expiration Policies in .NET• 30 minutes
Database performance is a crucial factor in ensuring efficient application operation. This module covers query optimization techniques that improve database responsiveness. Learners will explore various indexing strategies, query performance analysis tools, and optimization techniques for handling complex queries. Additionally, best practices for maintaining efficient database queries will be discussed. By mastering these techniques, developers can enhance the performance of their applications and minimize resource consumption.
What's included
14 videos11 readings11 assignments2 ungraded labs2 plugins
14 videos• Total 63 minutes
- Introduction to Optimizing Database Queries• 1 minute
- What is Query Optimization?• 4 minutes
- How Databases Optimize Queries Automatically• 3 minutes
- Introduction to Indexing• 4 minutes
- Indexing Trade-offs and Challenges• 4 minutes
- Creating Clustered and Non-Clustered Indexes in SQL• 7 minutes
- Evaluating the Impact of Indexes on Query Performance• 4 minutes
- Applying Indexing Techniques to Optimize Queries• 7 minutes
- Identifying Bottlenecks in SQL Queries• 6 minutes
- Optimization Techniques for Complex SQL Queries• 4 minutes
- Optimizing Complex SQL Queries• 4 minutes
- Identify Best Practices for Writing Efficient SQL Queries.• 6 minutes
- Continuous Query Optimization in Production• 7 minutes
- Conclusion: Optimizing Database Queries• 1 minute
11 readings• Total 110 minutes
- Activity: Identifying Elements in a Query Execution Plan - Answer Key• 10 minutes
- Understanding Query Optimization Principles• 10 minutes
- Activity: Designing an Indexing Strategy - Answer Key• 10 minutes
- Activity: Predicting the Impact of Indexes - Answer Key• 10 minutes
- You Try It! Applying Indexing Techniques to Optimize Queries - Answer Key• 10 minutes
- Applying Indexing Techniques for Query Optimization• 10 minutes
- Activity: Identifying Bottlenecks in Query Plans - Answer Key• 10 minutes
- You Try It! Optimizing Complex SQL Queries - Answer Key• 10 minutes
- Optimizing SQL Queries for Performance• 10 minutes
- Activity: Optimizing Query Structure - Answer Key• 10 minutes
- Query Optimization Checklist• 10 minutes
11 assignments• Total 320 minutes
- Graded Quiz: Optimizing Database Queries• 50 minutes
- Activity: Identifying Elements in a Query Execution Plan• 30 minutes
- Practice Quiz: Introduction to Query Optimization Principles• 20 minutes
- Activity: Designing an Indexing Strategy• 30 minutes
- Practice Quiz: Indexing Strategies for Query Optimization• 20 minutes
- Activity: Predicting the Impact of Indexes• 30 minutes
- Practice Quiz: Applying Indexing Techniques for Query Optimization• 30 minutes
- Activity: Identifying Bottlenecks in Query Plans• 30 minutes
- Practice Quiz: Analyzing and Optimizing SQL Queries• 30 minutes
- Activity: Optimizing Query Structure• 30 minutes
- Practice Quiz: Best Practices for Query Optimization• 20 minutes
2 ungraded labs• Total 120 minutes
- You Try It: Applying Indexing Techniques to Optimize Queries• 60 minutes
- You Try It! Optimizing Complex SQL Queries• 60 minutes
2 plugins• Total 60 minutes
- Guided Lab: Applying Indexing Techniques to Optimize Queries• 30 minutes
- Guided Lab: Optimizing Complex SQL Queries• 30 minutes
Building applications that can handle increasing loads without performance degradation is a key aspect of back-end development. This module focuses on the principles and architectural patterns that support scalability, including load balancing, traffic management, and asynchronous processing. Learners will gain insights into designing systems that effectively scale to meet growing user demands. By the end of this module, participants will be equipped with best practices for creating robust and scalable applications.
What's included
14 videos13 readings11 assignments3 ungraded labs2 plugins
14 videos• Total 56 minutes
- Introduction to Designing Scalable Applications• 1 minute
- Introduction to Scalability• 4 minutes
- Scalability vs. Performance• 2 minutes
- Microservices Architecture• 4 minutes
- Event-Driven Architecture• 4 minutes
- Stateless Design and Load Balancing• 4 minutes
- Integrating Caching and Asynchronous Tasks into Architecture• 6 minutes
- Introduction to Load Balancing Concepts• 4 minutes
- Configuring Load Balancing With Nginx• 6 minutes
- Implementing Load Balancing in a Simulated Environment• 6 minutes
- Introduction to Asynchronous Processing Concepts• 3 minutes
- Configuring Asynchronous Tasks With Queues• 5 minutes
- Implementing Asynchronous Tasks in .NET• 5 minutes
- Conclusion: Designing Scalable Applications• 2 minutes
13 readings• Total 130 minutes
- Activity: Compare Horizontal and Vertical Scaling - Answer Key• 10 minutes
- Understanding Scalability and Performance• 10 minutes
- Scalable Patterns in Microservices and Event-Driven Design• 10 minutes
- Activity: Create a High-Level Architecture Plan - Answer Key• 10 minutes
- Activity: Designing a Scalable System Architecture - Answer Key• 10 minutes
- You Try It! Designing a Scalable System Architecture - Answer Key• 10 minutes
- Designing for Scalability: Architecture Best Practices• 10 minutes
- Activity: Plan a Load Balancing Configuration - Answer Key• 10 minutes
- You Try It! Implementing Load Balancing in a Simulated Environment - Answer Key• 10 minutes
- Implementing Load Balancing for Scalability• 10 minutes
- Activity: Design an Asynchronous Workflow - Answer Key• 10 minutes
- You Try It! Implementing Asynchronous Tasks in .NET - Answer Key• 10 minutes
- Implementing Asynchronous Processing for Scalable Applications• 10 minutes
11 assignments• Total 315 minutes
- Graded Quiz: Designing Scalable Applications• 50 minutes
- Activity: Compare Horizontal and Vertical Scaling• 30 minutes
- Practice Quiz: Understanding Scalability Principles• 25 minutes
- Practice Quiz: Architectural Patterns for Scalability• 15 minutes
- Activity: Create a High-Level Architecture Plan• 30 minutes
- Activity: Designing a Scalable System Architecture• 30 minutes
- Practice Quiz: Designing Scalable Architecture• 25 minutes
- Activity: Plan a Load Balancing Configuration• 30 minutes
- Practice Quiz: Implementing Load Balancing Solutions• 25 minutes
- Activity: Design an Asynchronous Workflow• 30 minutes
- Practice Quiz: Implementing Asynchronous Processing in .NET• 25 minutes
3 ungraded labs• Total 180 minutes
- You Try It! Designing a Scalable System Architecture• 60 minutes
- You Try It! Implementing Load Balancing in a Simulated Environment• 60 minutes
- You Try It! Implementing Asynchronous Tasks in .NET• 60 minutes
2 plugins• Total 30 minutes
- Guided Lab: Implementing Load Balancing in a Simulated Environment• 0 minutes
- Guided Lab: Implementing Asynchronous Tasks in .NET• 30 minutes
AI-powered tools like Microsoft Copilot can significantly enhance performance optimization in software development. This module provides hands-on experience in using Microsoft Copilot to analyze and improve application code and database performance. Learners will explore how Copilot assists in identifying performance bottlenecks, optimizing database queries, and implementing comprehensive performance enhancements. By leveraging AI-driven insights, developers can streamline optimization processes and improve application efficiency.
What's included
13 videos5 readings9 assignments1 peer review
13 videos• Total 55 minutes
- Introduction to Using Microsoft Copilot for Optimizing Code and Database Performance• 1 minute
- Refactoring With Copilot• 3 minutes
- Using Copilot for AI-Powered Code Analysis• 6 minutes
- Identifying Patterns in SQL Queries for Optimization• 5 minutes
- How Copilot Enhances Query Performance• 3 minutes
- Demonstrating AI-Supported Query Refactoring• 3 minutes
- Identifying Performance Bottlenecks with Copilot• 6 minutes
- Implementing Copilot’s Optimization Suggestions• 7 minutes
- Overview of Debugging Strategies With Copilot• 4 minutes
- Using Copilot to Identify and Resolve Errors• 8 minutes
- Planning a Performance Optimization Project• 3 minutes
- Analyzing Code and Query Bottlenecks with Copilot• 4 minutes
- Course Conclusion: Performance Optimization and Scalability• 2 minutes
5 readings• Total 110 minutes
- Activity: Assess Refactoring Suggestions - Answer Key• 10 minutes
- Applying AI-Driven Code Refactoring Techniques• 30 minutes
- Activity: Compare Query Versions with Copilot’s Feedback - Answer Key• 10 minutes
- Activity: Performance Tuning With Copilot Recommendations - Answer Key• 30 minutes
- Activity: Error Detection Practice - Answer Key• 30 minutes
9 assignments• Total 240 minutes
- Activity: Draft an Optimization Strategy• 30 minutes
- Activity: Assess Refactoring Suggestions• 30 minutes
- Practice Quiz: Leveraging Microsoft Copilot for Code Optimization• 20 minutes
- Activity: Compare Query Versions with Copilot’s Feedback• 30 minutes
- Activity: Query Optimization With Microsoft Copilot• 30 minutes
- Activity: Performance Tuning With Copilot Recommendations• 30 minutes
- Activity: Application Code Optimization With Copilot• 30 minutes
- Activity: Error Detection Practice• 10 minutes
- Activity: Debugging Application Code With Copilot• 30 minutes
1 peer review• Total 60 minutes
- Final Project Submission: Optimization Project• 60 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

Offered by

Offered by

Our goal at Microsoft is to empower every individual and organization on the planet to achieve more. In this next revolution of digital transformation, growth is being driven by technology. Our integrated cloud approach creates an unmatched platform for digital transformation. We address the real-world needs of customers by seamlessly integrating Microsoft 365, Dynamics 365, LinkedIn, GitHub, Microsoft Power Platform, and Azure to unlock business value for every organization—from large enterprises to family-run businesses. The backbone and foundation of this is Azure.
Why people choose Coursera for their career

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.
¹ Some assignments in this course are AI-graded. For these assignments, your data will be used in accordance with Coursera's Privacy Notice.