- All
- Favorite
- Popular
- Most rated
Optimize vacuum in Azure Database for PostgreSQL
Azure Database for PostgreSQL uses vacuum and autovacuum to remove rows that have been marked as soft-deleted after an update or deletion.
Understand concurrency in PostgreSQL
Azure Database for PostgreSQL is a multi-user relational database solution. The increase in users brings a risk of conflicts and so it is important to understand the concurrency systems that are in place.
Procedures and functions in PostgreSQL
PostgreSQL supports stored procedures and functions to make SQL queries reusable. In this module, you learn how to create and run stored procedures and functions.
Understand client-server communication in PostgreSQL
PostgreSQL is a client-server system, which allows many clients to connect to a central server. In this module, you learn how PostgreSQL manages connections from clients, and look at some common PostgreSQL client tools.
Explore SQL Server 2022 capabilities
Learn about SQL Server 2022 enhancements, including:
Understand the built-in query intelligence enhancements of SQL Server 2022
Learn about and use the Intelligent Query Processing feature enhancements in SQL Server 2022.
Introduction to SQL Server 2022 data virtualization
Learn about data virtualization, enhanced Polybase features in SQL Server 2022, and how to use Polybase to access and query external data.
Understand client-server communication in MySQL
Learn about connection handling in MySQL, back up and restore, and the client interface options available for MySQL.
Explore MySQL Architecture
Explore the component parts of MySQL, and learn how to find your way around Azure Database for MySQL.
Use system catalogs and system views in PostgreSQL
System information is known as metadata and is stored in system catalogs in Azure Database for PostgreSQL. In addition to directly accessing system catalogs, you can access system views.
Work with MySQL Databases on Azure
Azure Database for MySQL is a fully managed database platform. In this learning path you'll find out how to manage and optimize Azure Database for MySQL. After completing this learning path, you'll be able to:
Configure and migrate to Azure Database for PostgreSQL
Azure Database for PostgreSQL is a Platform as a Service database service in the Microsoft cloud. It bases itself on the PostgreSQL open-source relational database and includes built-in high availability, automatic backup and restore, as well as comprehensive security features. The pay-as-you-go pricing model provides predictable performance and near-instant scaling. In this learning path, you learn the main features of PostgreSQL and how they work in Azure Database for PostgreSQL. You learn about the different Azure Database for PostgreSQL implementation options, and how to configure a server for your needs.
Understand concurrency in MySQL
Learn about concurrency in MySQL, including how to limit the number of connections, and when to use thread pools.
Explore query performance optimization
Read and understand various forms of execution plans. Compare estimated vs actual plans. Learn how and why plans are generated. Understand the purpose and benefits of the Query Store.
Understand the MySQL storage engine
Learn about MySQL's pluggable storage engine model, common storage engines, and storage engines supported by Azure Database for MySQL.
Understand PostgreSQL query processing
The Azure Database for PostgreSQL server receives SQL queries and returns the relevant results. Each SQL query goes through several stages in order to return the correct results as quickly as possible.
Explore PostgreSQL architecture
PostgreSQL is an open-source relational database system that is available as an Azure service. In this module, you learn about the PostgreSQL architecture, and how to manage different aspects of Azure Database for PostgreSQL.
Tune queries in Azure Database for PostgreSQL
Database management systems (DBMSs) need systems to understand the data and the queries that are running against this data. It's important to understand how performance tuning works and how you can assess performance metrics.
Understand write-ahead logging
Azure Database for PostgreSQL is an ACID compliant database service. Write-ahead logging ensures changes are both atomic and durable. In this module, you learn how Azure Database for PostgreSQL implements write-ahead logging.
Configure and manage Azure Database for PostgreSQL
Azure Database for PostgreSQL employs system catalogs and views to manage metadata efficiently. Understanding these can significantly enhance database performance and streamline the administration of PostgreSQL systems.
Secure Azure Database for PostgreSQL
Azure Database for PostgreSQL includes comprehensive security features including encryption, authentication, and granting permissions to database users. In this module, you learn about the security features of Azure Database for PostgreSQL.
Secure MySQL
Learn about security and encryption in Azure Database for MySQL.
Introduction to SQL Server 2022 T-SQL enhancements
Learn the new and improved SQL Server 2022 functions that will enhance the querying and creation of T-SQL objects.
Migrate to Azure Database for PostgreSQL flexible server
Azure Database for PostgreSQL Flexible Server supports data migration from PostgreSQL servers. This module covers online and offline migration tools and methods, helping you choose the right approach for your scenario.
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.