Lorsque vous vous inscrivez à ce cours, vous êtes également inscrit(e) à cette Spécialisation.
Apprenez de nouveaux concepts auprès d'experts du secteur
Acquérez une compréhension de base d'un sujet ou d'un outil
Développez des compétences professionnelles avec des projets pratiques
Obtenez un certificat professionnel partageable
Il y a 4 modules dans ce cours
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.
Inclus
21 vidéos13 lectures12 devoirs3 laboratoires non notés3 plugins
Afficher les informations sur le contenu du module
21 vidéos•Total 88 minutes
Course Introduction: Performance Optimization and Scalability•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
13 lectures•Total 210 minutes
Course Syllabus: Performance Optimization and Scalability•10 minutes
Reference –Navigating the Guided Labs•30 minutes
Microsoft Tools for Back-End Development•10 minutes
Practice Quiz: Managing Cache Expiration Policies•25 minutes
Graded Quiz: Caching Strategies With .NET Core•50 minutes
3 laboratoires non notés•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
Optimizing Database Queries
Module 2•10 heures à terminer
Détails du module
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.
Inclus
13 vidéos6 lectures11 devoirs2 laboratoires non notés2 plugins
Afficher les informations sur le contenu du module
13 vidéos•Total 59 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
Identify Best Practices for Writing Efficient SQL Queries.•6 minutes
Continuous Query Optimization in Production•7 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.
Inclus
14 vidéos9 lectures11 devoirs3 laboratoires non notés2 plugins
Afficher les informations sur le contenu du module
14 vidéos•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
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
Using Microsoft Copilot for Optimizing Code and Database Performance
Module 4•8 heures à terminer
Détails du module
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.
Inclus
13 vidéos5 lectures9 devoirs1 évaluation par les pairs
Afficher les informations sur le contenu du module
13 vidéos•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
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 évaluation par les pairs•Total 60 minutes
Final Project Submission: Optimization Project•60 minutes
Obtenez un certificat professionnel
Ajoutez ce titre à votre profil LinkedIn, à votre curriculum vitae ou à votre CV. Partagez-le sur les médias sociaux et dans votre évaluation des performances.
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.
Pour quelles raisons les étudiants sur Coursera nous choisissent-ils pour leur carrière ?
Felipe M.
Étudiant(e) depuis 2018
’Pouvoir suivre des cours à mon rythme à été une expérience extraordinaire. Je peux apprendre chaque fois que mon emploi du temps me le permet et en fonction de mon humeur.’
Jennifer J.
Étudiant(e) depuis 2020
’J'ai directement appliqué les concepts et les compétences que j'ai appris de mes cours à un nouveau projet passionnant au travail.’
Larry W.
Étudiant(e) depuis 2021
’Lorsque j'ai besoin de cours sur des sujets que mon université ne propose pas, Coursera est l'un des meilleurs endroits où se rendre.’
Chaitanya A.
’Apprendre, ce n'est pas seulement s'améliorer dans son travail : c'est bien plus que cela. Coursera me permet d'apprendre sans limites.’
Do I need prior experience with databases or application development to take this course?
A basic understanding of application development and databases is recommended. Familiarity with concepts like querying and basic application architecture will help you get the most out of the caching, indexing, and optimization techniques covered in this course.
How does Microsoft Copilot help with performance optimization?
Microsoft Copilot assists by suggesting code improvements, identifying inefficiencies, and helping rewrite application code and database queries for better performance. Throughout the course you'll use Copilot hands-on to optimize real code and queries, making the learning experience practical and efficient.
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 Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, 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.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.