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
Save on skills that make you shine with 40% off 3 months of Coursera Plus. Save now
Performance Optimization and Scalability
This course is part of multiple programs.
This course is part of multiple programs
Instructor: Microsoft
2,988 already enrolled
Included with
Gain insight into a topic and learn the fundamentals.
4.8
14 reviews
Beginner level
Recommended experience
Recommended experience
Beginner level
No prior experience is required for this course.
5 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
4.8
14 reviews
Beginner level
Recommended experience
Recommended experience
Beginner level
No prior experience is required for this course.
5 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
Skills you'll gain
- Category: AI IntegrationsAI Integrations
- Category: Performance TuningPerformance Tuning
- Category: Performance TestingPerformance Testing
- Category: Distributed ComputingDistributed Computing
- Category: Memory ManagementMemory Management
- Category: Microsoft CopilotMicrosoft Copilot
- Category: Application DesignApplication Design
- Category: Software Design PatternsSoftware Design Patterns
- Category: Load BalancingLoad Balancing
- Category: Application Performance ManagementApplication Performance Management
- Category: ScalabilityScalability
- Category: SQLSQL
- Category: Software ArchitectureSoftware Architecture
- Category: Database ManagementDatabase Management
Tools you'll learn
- Category: Query LanguagesQuery Languages
Details to know
Shareable certificate
Add to your LinkedIn profile
Taught in English
Build your subject-matter expertise
This course is available as part of
When you enroll in this course, you'll also be asked to select a specific program.
- 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
- 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
- Graded Quiz: Caching Strategies With .NET Core•50 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
- 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
- Graded Quiz: Optimizing Database Queries•50 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
- 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
- Graded Quiz: Designing Scalable Applications•50 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
Microsoft
288 Courses•2,510,457 learners
Offered by
Microsoft
Offered by
Microsoft
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.
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."
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 Certificate, 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.
¹ Some assignments in this course are AI-graded. For these assignments, your data will be used in accordance with Coursera's Privacy Notice.