- 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.
Explore Our Course Categories
- Cloud Computing: Microsoft provides comprehensive training on cloud technologies, including Azure, to help you master cloud deployment and management. These courses cover everything from basic concepts to advanced practices, ensuring you gain the skills needed to excel in the cloud computing field.
- Data Science: Dive into advanced techniques in data analysis, machine learning, and visualization with Microsoft’s powerful tools. These courses are designed to equip you with practical skills to interpret complex data and derive actionable insights, enhancing your capabilities in the data science domain.
- Software Development: Microsoft’s software development courses focus on programming languages and development frameworks. Gain hands-on experience in building and managing software applications, and learn advanced coding techniques to enhance your development skills.
- Cybersecurity: Master essential practices for protecting digital assets and managing security threats with Microsoft’s cybersecurity training. These courses cover various aspects of cybersecurity, from threat protection to risk management, preparing you to safeguard systems and data effectively.
- Productivity Tools: Enhance your efficiency with Microsoft Office 365 and other productivity tools through our specialized courses. Learn how to optimize your workflow and improve productivity in your daily tasks with Microsoft’s suite of applications.
Why Choose Microsoft Courses on EdCroma?
- Expert-Led Training: Each course is designed and delivered by Microsoft experts, ensuring high-quality instruction and practical application of skills.
- Comprehensive Learning Resources: Access a wide range of materials that support your learning journey, from beginner to advanced levels, and gain hands-on experience.
- Certification Opportunities: Pursue recognized certifications that validate your skills and enhance your career prospects.
- Informed Learning Choices: Benefit from detailed course comparisons, reviews, and insights to make well-informed decisions and select the best course for your professional growth.
Microsoft Corporation: Innovating the Future of Technology
Microsoft Corporation, founded by Bill Gates and Paul Allen in 1975, has grown to become one of the most valuable and influential technology companies in the world. Headquartered in Redmond, Washington, Microsoft is renowned for its innovative software products, including the Windows operating system, Microsoft Office suite, and the Azure cloud computing platform.History and Evolution
- Early Beginnings: Microsoft's journey began with the creation of a version of the BASIC programming language for the Altair 8800. This initial success paved the way for the development of MS-DOS, an operating system that became the foundation of the personal computer revolution.
- The Windows Revolution: The launch of Windows in 1985 marked a significant milestone, introducing a graphical user interface that revolutionized the way people interacted with computers.
- Expansion and Innovation: Throughout the 1990s and 2000s, Microsoft continued to innovate, expanding its product offerings to include the Office suite, Internet Explorer, and the Xbox gaming console. The company also entered the enterprise market with solutions like Windows Server, SQL Server, and Microsoft Dynamics.
Recent Developments
- A Cloud-First Transformation: In recent years, Microsoft has focused on cloud computing, artificial intelligence, and machine learning. Under the leadership of CEO Satya Nadella, who took over in 2014, Microsoft has transformed into a cloud-first company. The Azure cloud platform has become a key growth driver, offering a wide range of services, including virtual machines, databases, and AI tools.
- Commitment to Education: Microsoft’s commitment to education and professional development is evident in its extensive range of certification programs and training courses. Microsoft Learn, the company’s official learning platform, offers free and paid courses on various topics, including Azure, Microsoft 365, Dynamics 365, and Power Platform. These courses are designed to help individuals and organizations acquire the skills needed to succeed in today’s digital world.
Key Offerings on EdCromahttps://edcroma.com/
- Microsoft Azure Fundamentals: This course provides an introduction to cloud computing concepts and Azure services, making it ideal for beginners looking to start a career in cloud technology.
- Microsoft 365 Certified: Modern Desktop Administrator Associate: This certification course covers the skills required to deploy, configure, and manage Windows 10 and Microsoft 365 services.
- Data Science with Microsoft Azure: This advanced course focuses on data science techniques and tools, including machine learning and AI, using the Azure platform.
- Microsoft Power BI for Data Analytics: Learn how to leverage Power BI to create interactive data visualizations and reports that drive business insights.
Benefits of Microsoft Courses
- Industry Recognition: Microsoft certifications are highly regarded in the tech industry, validating your expertise and enhancing your career prospects.
- Hands-On Learning: Microsoft courses often include practical labs and real-world projects, allowing you to apply your knowledge in a meaningful way.
- Up-to-date Content: Microsoft regularly updates its courses to reflect the latest technological advancements and industry trends, ensuring that you stay current with your skills.
- Flexible Learning: Whether you prefer self-paced learning or instructor-led training, Microsoft offers a variety of formats to suit your needs.