Migrate Open Source Data Workloads to Azure (authorized training course DP 070T00) Training Course
About This Course
This course empowers students to understand Azure SQL Database and provides the knowledge necessary to migrate MySQL and PostgreSQL workloads to Azure SQL Database.
Audience Profile
The primary audience consists of database developers planning to migrate their MySQL or PostgreSQL database workloads to Azure SQL DB. The secondary audience includes MySQL and PostgreSQL administrators seeking to gain awareness of the features and benefits offered by Azure SQL DB.
At Course Completion
Upon completing this course, students will have learned:
- How to migrate on-premises MySQL workloads to Azure SQL DB for MySQL
- How to migrate on-premises PostgreSQL workloads to Azure SQL DB for PostgreSQL
Course Outline
Module 1: Migrate to Azure SQL DB for MySQL & PostgreSQL
Module 2: Migrate on-premises MySQL to Azure SQL DB for MySQL
Module 3: Migrate on-premises PostgreSQL to Azure SQL DB for PostgreSQL
|
Requirements
Students who successfully complete this role should possess a foundational understanding of cloud computing concepts and practical experience with open-source relational database management systems.
Specifically, students should be proficient in:
- Working with PostgreSQL and/or MySQL
- Applying backup and recovery techniques for open-source data
- SQL administration
Open Training Courses require 5+ participants.
Migrate Open Source Data Workloads to Azure (authorized training course DP 070T00) Training Course - Booking
Migrate Open Source Data Workloads to Azure (authorized training course DP 070T00) Training Course - Enquiry
Migrate Open Source Data Workloads to Azure (authorized training course DP 070T00) - Consultancy Enquiry
Testimonials (1)
Everything, is a new platform for me and everything was interesting.
Sergiu
Course - AZ-104T00-A: Microsoft Azure Administrator
Upcoming Courses
Related Courses
MS-20487: Developing Microsoft Azure and Web Services (authorized training course)
35 HoursAbout This Course
Through this course, learners will acquire the skills to design and build services that retrieve local and remote data from diverse sources. Additionally, participants will learn how to develop and deploy these services within hybrid environments, spanning on-premises servers and Microsoft Azure.
Audience Profile
Primary audience: .NET developers seeking to learn service development and deployment to hybrid environments.
Secondary audience: .NET developers with experience in web application development who are interested in building new applications or migrating existing ones to Microsoft Azure.
At Course Completion
Upon finishing this course, students will be able to:
- Explain fundamental concepts of service development and data access strategies within the .NET platform.
- Describe the Microsoft Azure cloud platform, including its compute, data, and application hosting capabilities.
- Design and develop data-centric applications using Visual Studio 2017 and Entity Framework Core.
- Design, implement, and consume HTTP services using ASP.NET Core.
- Extend HTTP services through ASP.NET Core.
- Host services both on-premises and in Microsoft Azure.
- Deploy services to on-premises and cloud environments while managing their interfaces and policies.
- Select appropriate data storage solutions and manage caching, distribution, and synchronization of data.
- Monitor, log, and troubleshoot services effectively.
- Describe claim-based identity concepts and standards, and implement authentication and authorization using Azure Active Directory.
- Create scalable service applications.
40511-G: Microsoft Cloud Workshop: Continuous delivery in Azure DevOps
7 HoursIn this whiteboard design session, you will learn how to design a solution with a combination of Azure Resource Manager templates and Azure DevOps to enable continuous delivery with several Azure PaaS services.
At the end of this workshop, you will be better able to build templates to automate cloud infrastructure and reduce error-prone manual processes. In addition, you'll create an Azure Resource Manager (ARM) template to provision Azure resources, configure continuous delivery with Azure DevOps, configure Application Insights into an application, and create an Azure DevOps project and Git repository.
Designing and Implementing an Azure AI Solution (authorized training course AI 100T01)
21 HoursAcquire the essential skills to design Azure AI solutions by constructing a customer support chatbot that leverages artificial intelligence from the Microsoft Azure platform. This includes implementing language understanding and utilizing pre-built AI capabilities provided by Azure Cognitive Services.
Microsoft Azure AI Fundamentals (authorized training course AI 900T00)
7 HoursAbout This Course
This course provides an overview of fundamental concepts related to artificial intelligence (AI) and the Microsoft Azure services available for developing AI solutions. Rather than aiming to train students to become professional data scientists or software developers, the course focuses on building awareness of common AI workloads and enabling participants to identify the appropriate Azure services to support those workloads. Designed as a blended learning experience, it combines instructor-led training with online materials hosted on the Microsoft Learn platform (https://azure.com/learn). The course includes hands-on exercises based on Learn modules, and students are encouraged to use Learn content as a reference to reinforce their classroom learning and explore topics in greater depth.
Audience Profile
The Azure AI Fundamentals course is designed for individuals interested in understanding the types of solutions that artificial intelligence (AI) enables, as well as the Microsoft Azure services used to build them. Prior experience with Microsoft Azure is not required, but a basic familiarity with computer technology and the Internet is assumed. Some concepts covered require a fundamental understanding of mathematics, such as the ability to interpret charts. Since the course includes hands-on activities involving data manipulation and code execution, a foundational knowledge of programming principles will be beneficial.
At Course Completion
After completing this course, you will be able to:
- Describe AI workloads and key considerations
- Describe the fundamental principles of machine learning on Azure
- Describe the features of computer vision workloads on Azure
- Describe the features of Natural Language Processing (NLP) workloads on Azure
- Describe the features of conversational AI workloads on Azure
Building AI Cloud Apps with Microsoft Azure
35 HoursThis instructor-led, live training in Slovakia (online or onsite) is tailored for intermediate to advanced professionals seeking to build and deploy AI-enhanced cloud applications on Microsoft Azure.
Upon completion of this training, participants will be capable of:
- Developing event-driven and serverless applications using Azure Functions.
- Managing Azure storage resources and virtual machines.
- Deploying and scaling web applications via Azure App Service and Docker containers.
- Integrating artificial intelligence, machine learning, and natural language processing capabilities through Azure AI Services.
- Utilizing GitHub Copilot to support AI-driven cloud application development.
AZ-020: Microsoft Azure solutions for AWS developers (authorized training course)
21 HoursAbout This Course
This three-day program is designed to equip AWS (Amazon Web Services) developers with the knowledge required to build comprehensive end-to-end solutions on Microsoft Azure. Throughout the course, participants will construct Azure App Service Web Apps and Azure Functions, utilize blob storage or Cosmos DB within their solutions, and implement secure cloud architectures that incorporate user authentication and authorization. The curriculum also covers API management and the development of event- and message-driven solutions. Participants will gain skills in monitoring, troubleshooting, and optimizing Azure solutions. The focus is on understanding how developers leverage Azure services, with particular emphasis on features and tasks that differ from AWS, and what these differences imply for application development on the Azure platform.
Audience Profile
This course is intended for AWS developers with professional experience who are looking to transition to or expand their skills in Azure development.
AZ-104T00-A: Microsoft Azure Administrator
28 HoursThis course equips IT Professionals with the skills to manage Azure subscriptions, secure identities, administer infrastructure, configure virtual networking, connect Azure with on-premises environments, manage network traffic, implement storage solutions, create and scale virtual machines, deploy web apps and containers, back up and share data, and monitor overall solutions.
Designed for Azure Administrators, this training covers the implementation, management, and monitoring of identity, governance, storage, compute, and virtual networks within cloud environments. Azure Administrators will learn to provision, size, monitor, and adjust resources as needed.
AZ-204T00: Developing solutions for Microsoft Azure (authorized training course)
35 HoursAbout This Course
This course instructs developers on how to build comprehensive end-to-end solutions within Microsoft Azure. Students will gain proficiency in implementing Azure compute resources, creating Azure Functions, deploying and managing web applications, and developing solutions that leverage Azure storage. The curriculum also covers the implementation of authentication and authorization mechanisms, as well as securing solutions through the use of KeyVault and Managed Identities. Additionally, students will learn to connect to and utilize both Azure and third-party services, incorporating event-driven and message-based architectures into their designs. The course concludes with guidance on monitoring, troubleshooting, and optimizing Azure-based solutions.
Audience Profile
- This course is designed for students interested in Azure development or preparing to pass the Microsoft Azure Developer Associate certification exam.
AZ-400T00-A: Designing and Implementing Microsoft DevOps solutions
35 HoursThis course equips learners with the knowledge and skills necessary to design and implement DevOps processes and practices. Participants will learn how to plan for DevOps adoption, utilize source control, scale Git for enterprise environments, consolidate artifacts, design dependency management strategies, manage secrets, implement continuous integration, establish container build strategies, design release strategies, set up release management workflows, implement deployment patterns, and optimize feedback mechanisms.
Audience Profile
This course is ideal for students interested in designing and implementing DevOps processes or those preparing for the Microsoft Azure DevOps Solutions certification exam.
Job Role: DevOps Engineer
Exam Preparation: AZ-400
Skills Gained
- Plan for transformation using shared goals and timelines
- Select projects and identify key project metrics and Key Performance Indicators (KPIs)
- Create teams and establish agile organizational structures
- Design tool integration strategies
- Design license management strategies (e.g., for Azure DevOps and GitHub users)
- Develop strategies for end-to-end traceability from work items to working software
- Design authentication and access strategies
- Design strategies for integrating on-premises and cloud resources
- Describe the benefits of using Source Control
- Describe Azure Repos and GitHub
- Migrate from TFVC to Git
- Manage code quality, including technical debt, SonarCloud, and other tooling solutions
- Build organizational knowledge regarding code quality
- Explain how to structure Git repositories
- Describe Git branching workflows
- Leverage pull requests for collaboration and code reviews
- Leverage Git hooks for automation
- Use Git to foster inner source across the organization
- Explain the role of Azure Pipelines and its components
- Configure agents for use in Azure Pipelines
- Explain why continuous integration matters
- Implement continuous integration using Azure Pipelines
- Define Site Reliability Engineering
- Design processes to measure end-user satisfaction and analyze user feedback
- Design processes to automate application analytics
- Manage alerts and reduce meaningless and non-actionable alerts
- Carry out blameless retrospectives and create a just culture
- Define an infrastructure and configuration strategy and appropriate toolset for a release pipeline and application infrastructure
- Implement compliance and security in your application infrastructure
- Describe the potential challenges with integrating open-source software
- Inspect open-source software packages for security and license compliance
- Manage organizational security and compliance policies
- Integrate license and vulnerability scans into build and deployment pipelines
- Configure build pipelines to access package security and license ratings
AZ-500T00-A: Microsoft Azure Security Technologies
28 HoursThis course equips IT security professionals with the essential knowledge and skills required to implement security controls, maintain an organization’s security posture, and identify and resolve security vulnerabilities. The curriculum covers identity and access security, platform protection, data and application security, and security operations.
Audience profile
This course is designed for Azure Security Engineers who intend to take the associated certification exam or who perform security-related tasks in their daily roles. It is also beneficial for engineers aiming to specialize in securing Azure-based digital platforms and playing a pivotal role in safeguarding an organization’s data.
Skills gained
- Implement enterprise governance strategies, including role-based access control, Azure policies, and resource locks.
- Deploy an Azure AD infrastructure comprising users, groups, and multi-factor authentication.
- Configure Azure AD Identity Protection, including risk policies, conditional access, and access reviews.
- Set up Azure AD Privileged Identity Management for Azure AD roles and Azure resources.
- Implement Azure AD Connect, covering authentication methods and on-premises directory synchronization.
- Deploy perimeter security strategies, such as Azure Firewall.
- Establish network security strategies, including Network Security Groups and Application Security Groups.
- Enforce host security strategies, including endpoint protection, remote access management, update management, and disk encryption.
- Secure container environments, including Azure Container Instances, Azure Container Registry, and Azure Kubernetes.
- Utilize Azure Key Vault for managing certificates, keys, and secrets.
- Implement application security strategies, including app registration, managed identities, and service endpoints.
- Secure storage using shared access signatures, blob retention policies, and Azure Files authentication.
- Secure databases through authentication, data classification, dynamic data masking, and Always Encrypted.
- Deploy Azure Monitor for connected sources, log analytics, and alerts.
- Configure Azure Security Center with policies, recommendations, and just-in-time virtual machine access.
- Set up Azure Sentinel, including workbooks, incidents, and playbooks.
DP 900: Microsoft Azure Data Fundamentals (authorized training course)
7 HoursAbout This Course
In this course, students will gain an understanding of fundamental database concepts within a cloud environment, acquire basic skills in cloud data services, and establish a solid foundation in Azure cloud data services. Participants will identify and explain core data concepts, including relational, non-relational, big data, and analytics, while exploring how these technologies are implemented using Microsoft Azure. The course covers the roles, tasks, and responsibilities associated with data management. Students will investigate relational data offerings, learn to provision and deploy relational databases, and query relational data through cloud data solutions in Azure. Additionally, they will explore non-relational data offerings, including the provisioning and deployment of non-relational databases and data stores in Azure. The curriculum also addresses processing options for developing data analytics solutions in Azure, with a focus on Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Finally, students will discover what Power BI is, including its key components and how they function together.
Audience Profile
This course is designed for individuals who wish to learn the fundamentals of database concepts in a cloud environment, acquire basic skills in cloud data services, and build foundational knowledge of cloud data services within Microsoft Azure.
At Course Completion
Upon completing this course, students will be able to:
- Describe core data concepts in Azure
- Explain concepts of relational data in Azure
- Explain concepts of non-relational data in Azure
- Identify components of a modern data warehouse in Azure
Windows Server 2019 Hybrid and Azure IaaS (authorized training course WS 012T00)
21 HoursThis three-day course is designed primarily for IT Professionals with experience in managing on-premises Windows Server environments. Its goal is to equip professionals with the skills needed to plan, implement, and manage environments that incorporate Azure IaaS-hosted Windows Server-based workloads. The curriculum explores leveraging Azure's hybrid capabilities, migrating virtual and physical server workloads to Azure IaaS, and managing and securing Azure VMs running Windows Server 2019.