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.
By the end of the course, you will be able to…
Define the concepts and importance of caching, query optimization, and principles of scalability in application performance
Explain how to implement in-memory and distributed caching, indexing strategies, and architectural patterns for scalability
Describe techniques for analyzing query performance, load balancing, traffic management, and best practices for caching, query optimization, and scalable applications
Optimize performance using Microsoft Copilot, focusing on application code and database queries
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分钟
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分钟
Optimizing Database Queries
第 2 单元•小时 后完成
单元详情
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分钟
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分钟
Designing Scalable Applications
第 3 单元•小时 后完成
单元详情
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分钟
Using Microsoft Copilot for Optimizing Code and Database Performance
第 4 单元•小时 后完成
单元详情
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分钟
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.
When will I have access to the lectures and assignments?
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.
What will I get if I subscribe to this Certificate?
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.