- All
- Favorite
- Popular
- Most rated
Plan and implement a high availability and disaster recovery environment
Data must be available when needed. Configure, test and manage a solution for high availability and disaster recovery using Azure tools and SQL Server tools.
Validate your skills architecting solutions for customers and products
In this workshop you're analyzing and architecting solutions based on a series of sheets in a planning workbook. You're choosing the company to use, so we've given you detail based on industry standards.
Build reports using Power BI within Azure Synapse Analytics
In this module, you will learn how you can build Power BI reports from within Azure Synapse Analytics.
Integrate Azure Synapse Analytics with Azure Data and AI services
Learn how Azure Synapse Analytics integrates with other Azure Data and AI services.
Implement Azure Arc-enabled SQL Managed Instance in your hybrid environment
Learn how to work with Azure Arc enabled servers, data services and Kubernetes.
Transform data by implementing pivot, unpivot, rollup, and cube
Learn how to transform data using Transact-SQL.
Explore IaaS and PaaS solutions for high availability and disaster recovery
Deploy Windows Server Failover Cluster and availability groups in Azure and hybrid environments. Configure temporal tables, geo-replication, and auto-failover groups.
Program with Transact-SQL
Learn how to use programming techniques in your Transact-SQL.
Automate deployment of database resources
Explore multiple deployment models available on Azure. Use Azure Resource Manager (ARM) templates and Bicep files for deploying Azure SQL resources. Understand how to use PowerShell and Azure CLI for automation purposes.
Write advanced Transact-SQL queries
Learn how to use advanced Transact-SQL features to fetch and transform data in your databases.
Manage the analytics development lifecycle
This learning path introduces the foundational components of implementing lifecycle management techniques for Power BI assets. This learning path helps you prepare for the Azure Enterprise Data Analyst Certification.
Automate database tasks for Azure SQL
Scripting repetitive tasks in Azure SQL for regular maintenance jobs and multi-instance administration. Automation of error and resource alerts. Configuration of notifications for failures.
Explore performance-based design
Explore normalization for relational databases. Investigate the impact of proper datatype usage. Compare types of indexes.
Implement error handling with Transact-SQL
Transact-SQL is a powerful declarative language that lets you explore and manipulate your database. As the complexity of your programs increase, so does the risk of errors occurring.
Optimize query performance in Azure SQL
Analyze individual query performance and determine where improvements can be made. Explore performance-related Dynamic Management Objects. Investigate how indexes and database design affect queries.
Implement compliance controls for sensitive data
Explore data classification capabilities and degrees of confidentiality. Implement security options to maintain private data safe, including Azure SQL auditing, Microsoft Defender for SQL, row-level security, Dynamic Data Masking and Azure SQL Database Ledger.
Create tables, views, and temporary objects
Learn how to use Transact-SQL to create tables, views, and temporary objects for your databases.
Manage Azure PaaS tasks using automation
Explore automation for Azure SQL platform. Configure elastic jobs, explore Azure Automation, and evaluate different strategies for monitoring automation tasks.
Combine query results with set operators
Learn how to use Transact-SQL to combine query results.
Write queries that use window functions
Learn how to use window functions in Transact-SQL.
Create and manage SQL Agent jobs
Explore SQL automation for scheduled tasks, and automatic alerts for SQL Server and Azure SQL Managed Instance.
Create stored procedures and user-defined functions
Learn how to use Stored procedures to group T-SQL statements so they can be used and reused whenever needed. You may need to execute stored procedures that someone else has created or create your own.
Back up and restore databases
Plan and implement policy for recovering data if user errors occur or the technology fails. Explore various options for how and where to back up and restore databases.
Describe performance monitoring
Compare Azure, and on-premises tools for monitoring and measuring performance. Determine critical metrics. Understand the purpose of a baseline for comparative analysis. Configure extended event sessions for tracing activities.
In-Depth Exploration of Microsoft Learn
Microsoft Learn is an innovative online educational platform developed by Microsoft, designed to offer a wide range of free, interactive learning opportunities. It caters to individuals looking to enhance their knowledge and skills across various technological fields such as cloud computing, artificial intelligence, data science, and software development. Since its launch, Microsoft Learn has become a crucial resource for professionals aiming to stay ahead in the technology sector.Origins and Evolution of Microsoft Learn
Launched with the mission to make high-quality education accessible to everyone, Microsoft Learn initially focused on Microsoft’s core technologies, including Azure and Microsoft 365. Over time, the platform has broadened its scope to cover a wide array of topics, reflecting the ever-evolving tech landscape and diverse learner needs. This evolution has established Microsoft Learn as a central hub for tech education.Impact on Online Education
Microsoft Learn has transformed online education by integrating interactive and hands-on learning experiences. The platform’s key contributions include:- Hands-On Learning: Provides practical scenarios to apply knowledge.
- Interactive Elements: Includes labs, quizzes, and exercises that engage users actively.
- Personalized Learning Paths: Tailors educational experiences to individual goals and interests.
Key Features and Advantages
Microsoft Learn offers several notable features:- Free Access to Learning Resources: Enjoy comprehensive educational content without any cost, making high-quality learning accessible to all.
- Interactive Learning Experience: Engage with hands-on labs, quizzes, and real-world scenarios to apply and retain knowledge effectively.
- Extensive Course Catalog: Explore a wide range of courses in cloud computing, artificial intelligence, data science, and more.
- Personalized Learning Paths: Follow guided paths tailored to your career goals and interests for a customized learning journey.
- Certification Preparation: Access resources and practice tests to help prepare for Microsoft certification exams and enhance your professional credentials.
- Practical Application: Build confidence and proficiency through practical exercises that simulate real-world challenges.
- Integration with Microsoft Ecosystem: Utilize the latest tools and technologies within Microsoft’s ecosystem to stay updated with industry trends.
- Continuous Learning Support: Benefit from regularly updated content that reflects the latest advancements in technology.