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
本课程是多个项目的一部分。

位教师: Microsoft
访问权限由 New York State Department of Labor 提供
2,754 人已注册
您将获得的技能
您将学习的工具
要了解的详细信息
了解顶级公司的员工如何掌握热门技能

积累特定领域的专业知识
- 向行业专家学习新概念
- 获得对主题或工具的基础理解
- 通过实践项目培养工作相关技能
- 通过 Microsoft 获得可共享的职业证书

该课程共有4个模块
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.
涵盖的内容
22个视频17篇阅读材料12个作业3个非评分实验室3个插件
22个视频• 总计90分钟
- Course Introduction: Performance Optimization and Scalability• 2分钟
- Instructor Introduction• 2分钟
- The What’s What of the Course• 3分钟
- Completing the Guided Labs• 4分钟
- Introducing the AI Tool: Microsoft Copilot• 3分钟
- How to Be Successful in This Program• 5分钟
- Introduction to the Project• 4分钟
- Introduction to Caching Strategies With .NET Core• 1分钟
- What is Caching?• 3分钟
- How Caching Enhances Performance• 3分钟
- In-Memory Caching Overview• 4分钟
- Distributed Caching Overview• 3分钟
- Configuring In-Memory Caching• 5分钟
- Managing Cache Operations With IMemoryCache• 4分钟
- Implementing In-Memory Caching in .NET• 4分钟
- Setting Up Redis for Distributed Caching• 8分钟
- Managing Data With Redis• 6分钟
- Configuring Redis Caching in .NET• 7分钟
- Overview of Cache Expiration Strategies• 3分钟
- Implementing Cache Expiration Policies in .NET• 6分钟
- Applying Cache Expiration Policies in .NET• 8分钟
- Conclusion: Caching Strategies With .NET Core• 1分钟
17篇阅读材料• 总计270分钟
- Course Syllabus: Performance Optimization and Scalability• 10分钟
- Completing the Guided Labs• 30分钟
- Microsoft Tools for Back-End Development• 10分钟
- Activity: Identifying Real-World Caching Opportunities - Answer Key• 10分钟
- Core Concepts of Caching• 10分钟
- Activity: Comparing Cached and Non-Cached Data Retrieval - Answer Key• 30分钟
- In-Memory vs. Distributed Caching: Use Cases and Trade-offs• 10分钟
- Activity: Designing a Caching Strategy - Answer Key• 10分钟
- Implementing and Managing In-Memory Caching in .NET• 10分钟
- You Try It! Implementing In-Memory Caching in .NET - Answer Key• 30分钟
- Activity: Planning Redis Integration - Answer Key• 10分钟
- You Try It! Configuring Redis Caching in .NET - Answer Key• 30分钟
- Activity: Reflect on Cache Synchronization Challenges - Answer Key• 10分钟
- Using Redis for Distributed Caching• 10分钟
- Activity: Designing Expiration Policies - Answer Key• 10分钟
- You Try It! Applying Cache Expiration Policies in .NET - Answer Key• 30分钟
- Best Practices for Cache Expiration in .NET• 10分钟
12个作业• 总计345分钟
- Activity: Identifying Real-World Caching Opportunities• 30分钟
- Practice Quiz: Basic Cashing Concepts• 20分钟
- Activity: Comparing Cached and Non-Cached Data Retrieval• 30分钟
- Practice Quiz: Caching Strategies: In-Memory and Distributed Caching• 20分钟
- Activity: Designing a Caching Strategy• 30分钟
- Practice Quiz: Implementing In-Memory Caching• 25分钟
- Activity: Planning Redis Integration• 30分钟
- Activity: Reflect on Cache Synchronization Challenges• 30分钟
- Practice Quiz: Configuring Distributed Caching• 25分钟
- Activity: Designing Expiration Policies• 30分钟
- Practice Quiz: Managing Cache Expiration Policies• 25分钟
- Graded Quiz: Caching Strategies With .NET Core• 50分钟
3个非评分实验室• 总计180分钟
- You Try It! Implementing In-Memory Caching in .NET• 60分钟
- You Try It! Configuring Redis Caching in .NET• 60分钟
- You Try It! Applying Cache Expiration Policies in .NET• 60分钟
3个插件• 总计90分钟
- Guided Lab: Implementing In-Memory Caching in .NET• 30分钟
- Guided Lab: Configuring Redis Caching in .NET• 30分钟
- Guided Lab: Applying Cache Expiration Policies in .NET• 30分钟
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.
涵盖的内容
14个视频11篇阅读材料11个作业2个非评分实验室2个插件
14个视频• 总计63分钟
- Introduction to Optimizing Database Queries• 1分钟
- What is Query Optimization?• 4分钟
- How Databases Optimize Queries Automatically• 3分钟
- Introduction to Indexing• 4分钟
- Indexing Trade-offs and Challenges• 4分钟
- Creating Clustered and Non-Clustered Indexes in SQL• 7分钟
- Evaluating the Impact of Indexes on Query Performance• 4分钟
- Applying Indexing Techniques to Optimize Queries• 7分钟
- Identifying Bottlenecks in SQL Queries• 6分钟
- Optimization Techniques for Complex SQL Queries• 4分钟
- Optimizing Complex SQL Queries• 4分钟
- Identify Best Practices for Writing Efficient SQL Queries.• 6分钟
- Continuous Query Optimization in Production• 7分钟
- Conclusion: Optimizing Database Queries• 1分钟
11篇阅读材料• 总计110分钟
- Activity: Identifying Elements in a Query Execution Plan - Answer Key• 10分钟
- Understanding Query Optimization Principles• 10分钟
- Activity: Designing an Indexing Strategy - Answer Key• 10分钟
- Activity: Predicting the Impact of Indexes - Answer Key• 10分钟
- You Try It! Applying Indexing Techniques to Optimize Queries - Answer Key• 10分钟
- Applying Indexing Techniques for Query Optimization• 10分钟
- Activity: Identifying Bottlenecks in Query Plans - Answer Key• 10分钟
- You Try It! Optimizing Complex SQL Queries - Answer Key• 10分钟
- Optimizing SQL Queries for Performance• 10分钟
- Activity: Optimizing Query Structure - Answer Key• 10分钟
- Query Optimization Checklist• 10分钟
11个作业• 总计320分钟
- Activity: Identifying Elements in a Query Execution Plan• 30分钟
- Practice Quiz: Introduction to Query Optimization Principles• 20分钟
- Activity: Designing an Indexing Strategy• 30分钟
- Practice Quiz: Indexing Strategies for Query Optimization• 20分钟
- Activity: Predicting the Impact of Indexes• 30分钟
- Practice Quiz: Applying Indexing Techniques for Query Optimization• 30分钟
- Activity: Identifying Bottlenecks in Query Plans• 30分钟
- Practice Quiz: Analyzing and Optimizing SQL Queries• 30分钟
- Activity: Optimizing Query Structure• 30分钟
- Practice Quiz: Best Practices for Query Optimization• 20分钟
- Graded Quiz: Optimizing Database Queries• 50分钟
2个非评分实验室• 总计120分钟
- You Try It: Applying Indexing Techniques to Optimize Queries• 60分钟
- You Try It! Optimizing Complex SQL Queries• 60分钟
2个插件• 总计60分钟
- Guided Lab: Applying Indexing Techniques to Optimize Queries• 30分钟
- Guided Lab: Optimizing Complex SQL Queries• 30分钟
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.
涵盖的内容
14个视频13篇阅读材料11个作业3个非评分实验室2个插件
14个视频• 总计56分钟
- Introduction to Designing Scalable Applications• 1分钟
- Introduction to Scalability• 4分钟
- Scalability vs. Performance• 2分钟
- Microservices Architecture• 4分钟
- Event-Driven Architecture• 4分钟
- Stateless Design and Load Balancing• 4分钟
- Integrating Caching and Asynchronous Tasks into Architecture• 6分钟
- Introduction to Load Balancing Concepts• 4分钟
- Configuring Load Balancing With Nginx• 6分钟
- Implementing Load Balancing in a Simulated Environment• 6分钟
- Introduction to Asynchronous Processing Concepts• 3分钟
- Configuring Asynchronous Tasks With Queues• 5分钟
- Implementing Asynchronous Tasks in .NET• 5分钟
- Conclusion: Designing Scalable Applications• 2分钟
13篇阅读材料• 总计130分钟
- Activity: Compare Horizontal and Vertical Scaling - Answer Key• 10分钟
- Understanding Scalability and Performance• 10分钟
- Scalable Patterns in Microservices and Event-Driven Design• 10分钟
- Activity: Create a High-Level Architecture Plan - Answer Key• 10分钟
- Activity: Designing a Scalable System Architecture - Answer Key• 10分钟
- You Try It! Designing a Scalable System Architecture - Answer Key• 10分钟
- Designing for Scalability: Architecture Best Practices• 10分钟
- Activity: Plan a Load Balancing Configuration - Answer Key• 10分钟
- You Try It! Implementing Load Balancing in a Simulated Environment - Answer Key• 10分钟
- Implementing Load Balancing for Scalability• 10分钟
- Activity: Design an Asynchronous Workflow - Answer Key• 10分钟
- You Try It! Implementing Asynchronous Tasks in .NET - Answer Key• 10分钟
- Implementing Asynchronous Processing for Scalable Applications• 10分钟
11个作业• 总计315分钟
- Activity: Compare Horizontal and Vertical Scaling• 30分钟
- Practice Quiz: Understanding Scalability Principles• 25分钟
- Practice Quiz: Architectural Patterns for Scalability• 15分钟
- Activity: Create a High-Level Architecture Plan• 30分钟
- Activity: Designing a Scalable System Architecture• 30分钟
- Practice Quiz: Designing Scalable Architecture• 25分钟
- Activity: Plan a Load Balancing Configuration• 30分钟
- Practice Quiz: Implementing Load Balancing Solutions• 25分钟
- Activity: Design an Asynchronous Workflow• 30分钟
- Practice Quiz: Implementing Asynchronous Processing in .NET• 25分钟
- Graded Quiz: Designing Scalable Applications• 50分钟
3个非评分实验室• 总计180分钟
- You Try It! Designing a Scalable System Architecture• 60分钟
- You Try It! Implementing Load Balancing in a Simulated Environment• 60分钟
- You Try It! Implementing Asynchronous Tasks in .NET• 60分钟
2个插件• 总计30分钟
- Guided Lab: Implementing Load Balancing in a Simulated Environment• 0分钟
- Guided Lab: Implementing Asynchronous Tasks in .NET• 30分钟
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.
涵盖的内容
13个视频5篇阅读材料9个作业1次同伴评审
13个视频• 总计55分钟
- Introduction to Using Microsoft Copilot for Optimizing Code and Database Performance• 1分钟
- Refactoring With Copilot• 3分钟
- Using Copilot for AI-Powered Code Analysis• 6分钟
- Identifying Patterns in SQL Queries for Optimization• 5分钟
- How Copilot Enhances Query Performance• 3分钟
- Demonstrating AI-Supported Query Refactoring• 3分钟
- Identifying Performance Bottlenecks with Copilot• 6分钟
- Implementing Copilot’s Optimization Suggestions• 7分钟
- Overview of Debugging Strategies With Copilot• 4分钟
- Using Copilot to Identify and Resolve Errors• 8分钟
- Planning a Performance Optimization Project• 3分钟
- Analyzing Code and Query Bottlenecks with Copilot• 4分钟
- Course Conclusion: Performance Optimization and Scalability• 2分钟
5篇阅读材料• 总计110分钟
- Activity: Assess Refactoring Suggestions - Answer Key• 10分钟
- Applying AI-Driven Code Refactoring Techniques• 30分钟
- Activity: Compare Query Versions with Copilot’s Feedback - Answer Key• 10分钟
- Activity: Performance Tuning With Copilot Recommendations - Answer Key• 30分钟
- Activity: Error Detection Practice - Answer Key• 30分钟
9个作业• 总计240分钟
- Activity: Draft an Optimization Strategy• 30分钟
- Activity: Assess Refactoring Suggestions• 30分钟
- Practice Quiz: Leveraging Microsoft Copilot for Code Optimization• 20分钟
- Activity: Compare Query Versions with Copilot’s Feedback• 30分钟
- Activity: Query Optimization With Microsoft Copilot• 30分钟
- Activity: Performance Tuning With Copilot Recommendations• 30分钟
- Activity: Application Code Optimization With Copilot• 30分钟
- Activity: Error Detection Practice• 10分钟
- Activity: Debugging Application Code With Copilot• 30分钟
1次同伴评审• 总计60分钟
- Final Project Submission: Optimization Project• 60分钟
获得职业证书
将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
位教师

提供方

提供方

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.
人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.
从 Computer Science 浏览更多内容
¹ 本课程的部分作业采用 AI 评分。对于这些作业,将根据 Coursera 隐私声明使用您的数据。





