Migrate Open Source Data Workloads to Azure (authorized training course DP 070T00) Training Course
About This Course
This course is designed to help students gain a comprehensive understanding of Azure SQL Database and the necessary steps to migrate MySQL and PostgreSQL workloads to Azure SQL Database.
Audience Profile
The primary audience for this course consists of database developers who are planning to migrate their MySQL or PostgreSQL workloads to Azure SQL DB. Additionally, MySQL/PostgreSQL administrators will benefit from this course by gaining insight into the features and advantages of Azure SQL DB.
At Course Completion
By the end of this course, students will have learned how to:
- Migrate on-premises MySQL databases to Azure SQL DB for MySQL
- Migrate on-premises PostgreSQL databases 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
Successful students start this role with a fundamental knowledge of cloud computing concepts and experience with open source relational database management systems.
Specifically:
- Working with PostgreSQL and/or MySQL
- Using backup and recovery techniques with open source data
- SQL administration
Need help picking the right course?
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)
Assimilable form of classes
Marek - Uniwersytet Szczecinski
Course - AZ-104T00-A: Microsoft Azure Administrator
Related Courses
MS-20487: Developing Microsoft Azure and Web Services (authorized training course)
35 HoursAbout This Course
In this course, students will gain the skills to design and develop services that can access local and remote data from a variety of sources. They will also learn how to develop and deploy these services in hybrid environments, encompassing both on-premises servers and Microsoft Azure.
Audience Profile
Primary: .NET developers who are interested in learning how to develop and deploy services to hybrid environments.
Secondary: .NET developers with experience in web application development who are looking to explore the creation of new applications or the migration of existing ones to Microsoft Azure.
At Course Completion
Upon completing this course, students will be able to:
- Explain the fundamental concepts of service development and data access strategies using the .NET platform.
- Understand the Microsoft Azure cloud platform and its offerings in compute, data, and application hosting.
- Design and develop a data-centric application using Visual Studio 2017 and Entity Framework Core.
- Create, implement, and consume HTTP services with ASP.NET Core.
- Extend HTTP services using ASP.NET Core.
- Host services both on-premises and in Microsoft Azure.
- Deploy services to both on-premises and cloud environments, and manage the interfaces and policies for their services.
- Select a data storage solution, cache, distribute, and synchronize data effectively.
- Monitor, log, and troubleshoot services efficiently.
- Understand 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 for designing Azure AI solutions by creating a customer support chatbot that leverages artificial intelligence from the Microsoft Azure platform. This includes utilizing language understanding and pre-built AI capabilities available in Azure Cognitive Services.
Microsoft Azure AI Fundamentals (authorized training course AI 900T00)
7 HoursAbout This Course
This course delves into the foundational concepts of artificial intelligence (AI) and explores the various Microsoft Azure services that can be utilized to develop AI solutions. It is not intended to turn students into professional data scientists or software developers but rather to enhance their understanding of common AI applications and equip them with the skills to identify suitable Azure services for these tasks. The course combines instructor-led sessions with online resources from the Microsoft Learn platform (https://azure.com/learn). Practical exercises are based on modules from the Learn platform, and students are encouraged to use this content as reference material to reinforce their learning and delve deeper into specific topics.
Audience Profile
The Azure AI Fundamentals course is tailored for anyone interested in understanding the types of solutions that artificial intelligence (AI) can enable and the services available on Microsoft Azure to create these solutions. No prior experience with Microsoft Azure is required, but a basic familiarity with computer technology and the Internet is assumed. Some concepts covered in the course involve a basic understanding of mathematics, such as interpreting charts. The course includes hands-on activities that involve data manipulation and running code, so a foundational knowledge of programming principles will be beneficial.
At Course Completion
Upon completing this course, you will be able to:
- Describe the workloads and considerations involved in artificial intelligence (AI).
- Explain the fundamental principles of machine learning on Azure.
- Discuss the features of computer vision tasks on Azure.
- Outline the capabilities of Natural Language Processing (NLP) workloads on Azure.
- Describe the features of conversational AI tasks on Azure.
AZ-020: Microsoft Azure solutions for AWS developers (authorized training course)
21 HoursAbout This Course
This three-day course is designed to guide AWS (Amazon Web Services) developers through the process of creating end-to-end solutions in Microsoft Azure. Throughout the course, you will learn how to build Azure App Service Web Apps and Azure Functions, utilize blob or Cosmos DB storage for your solutions, implement secure cloud solutions that include user authentication and authorization, manage APIs, develop event- and message-based solutions, and monitor, troubleshoot, and optimize your Azure applications. You will gain a deeper understanding of how developers use Azure services, with a particular focus on the features and tasks that differ from AWS, helping you effectively transition to developing applications hosted on Azure.
Audience Profile
This course is intended for experienced AWS developers who are interested in expanding their skills into Azure development.
AZ-104T00-A: Microsoft Azure Administrator
28 HoursThis course equips IT Professionals with the skills to manage their Azure subscriptions effectively, secure identities, administer infrastructure, configure virtual networking, establish connections between Azure and on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, deploy web apps and containers, back up and share data, and monitor the overall solution.
This course is designed for Azure Administrators. The role of an Azure Administrator involves implementing, managing, and monitoring identity, governance, storage, compute, and virtual networks in a cloud environment. Azure Administrators are responsible for provisioning, sizing, monitoring, and adjusting resources as needed to ensure optimal performance.
AZ-204T00: Developing solutions for Microsoft Azure (authorized training course)
35 HoursAbout This Course
This course is designed to guide developers through the process of creating comprehensive solutions on Microsoft Azure. Participants will gain insights into implementing Azure compute solutions, developing Azure Functions, managing and deploying web apps, utilizing Azure storage for application development, setting up authentication and authorization mechanisms, and securing their applications using KeyVault and Managed Identities. The curriculum also delves into connecting and consuming both Azure services and third-party services, integrating event- and message-based models into their solutions, and covers the essential aspects of monitoring, troubleshooting, and optimizing Azure solutions.
Audience Profile
- This course is tailored for developers who are interested in Azure development or aiming to pass the Microsoft Azure Developer Associate certification exam.
AZ-400T00-A: Designing and Implementing Microsoft DevOps solutions
35 HoursThis course equips participants with the knowledge and skills required to design and implement DevOps processes and practices. It covers planning for DevOps, using source control, scaling Git for enterprise needs, consolidating artifacts, designing a dependency management strategy, managing secrets, implementing continuous integration, setting up a container build strategy, designing a release strategy, configuring a release management workflow, implementing deployment patterns, and optimizing feedback mechanisms.
Audience profile
This course is designed for individuals who are interested in designing and implementing DevOps processes or preparing to pass the Microsoft Azure DevOps Solutions certification exam.
Job role: DevOps Engineer
Preparation for exam: AZ-400
Skills gained
- Plan the transformation with shared goals and timelines
- Select a project and identify key metrics and KPIs
- Create a team and establish an agile organizational structure
- Design a tool integration strategy
- Develop a license management plan (e.g., for Azure DevOps and GitHub users)
- Design a strategy for end-to-end traceability from work items to functional software
- Create an authentication and access strategy
- Design a strategy for integrating on-premises and cloud resources
- Explain the benefits of using Source Control
- Describe Azure Repos and GitHub
- Migrate from TFVC to Git
- Manage code quality, including technical debt, with tools like SonarCloud
- Build organizational knowledge on 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
- Promote inner source practices across the organization using Git
- Explain the role of Azure Pipelines and its components
- Configure agents for use in Azure Pipelines
- Understand the importance of continuous integration
- Implement continuous integration with Azure Pipelines
- Define Site Reliability Engineering (SRE)
- Design processes to measure end-user satisfaction and analyze user feedback
- Design processes to automate application analytics
- Manage alerts and minimize irrelevant or non-actionable alerts
- Conduct blameless retrospectives and foster a just culture
- Define an infrastructure and configuration strategy, along with the appropriate tools for a release pipeline and application infrastructure
- Implement compliance and security in your application infrastructure
- Discuss 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 assess package security and license ratings
AZ-500T00-A: Microsoft Azure Security Technologies
28 HoursThis course equips IT Security Professionals with the knowledge and skills necessary to implement security controls, maintain an organization's security posture, and identify and address security vulnerabilities. It covers security for identity and access management, platform protection, data and applications, and security operations.
Audience profile
This course is designed for Azure Security Engineers who are preparing to take the associated certification exam or who perform security tasks in their daily jobs. It is also beneficial for engineers looking to specialize in securing Azure-based digital platforms and play a crucial role in protecting an organization's data.
Skills gained
- Implement enterprise governance strategies, including role-based access control, Azure policies, and resource locks.
- Set up an Azure AD infrastructure, including users, groups, and multi-factor authentication.
- Deploy Azure AD Identity Protection, incorporating risk policies, conditional access, and access reviews.
- Manage Azure AD Privileged Identity Management for both Azure AD roles and Azure resources.
- Configure Azure AD Connect, covering authentication methods and on-premises directory synchronization.
- Establish perimeter security measures using Azure Firewall.
- Implement network security strategies, such as Network Security Groups and Application Security Groups.
- Enforce host security practices, including endpoint protection, remote access management, update management, and disk encryption.
- Secure container environments with Azure Container Instances, Azure Container Registry, and Azure Kubernetes.
- Utilize Azure Key Vault for managing certificates, keys, and secrets.
- Implement application security measures, including app registration, managed identities, and service endpoints.
- Ensure storage security through shared access signatures, blob retention policies, and Azure Files authentication.
- Secure databases with authentication, data classification, dynamic data masking, and always encrypted features.
- Leverage Azure Monitor for connected sources, log analytics, and alerts.
- Utilize Azure Security Center to manage policies, recommendations, and just-in-time virtual machine access.
- Implement Azure Sentinel for workbooks, incident management, 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. They will acquire basic skills in using cloud data services and build a solid foundation in Microsoft Azure's cloud data services. The curriculum covers core data concepts such as relational, non-relational, big data, and analytics, with a focus on their implementation in Microsoft Azure. Students will delve into the roles, tasks, and responsibilities associated with data management. They will explore various relational data offerings, including how to provision and deploy relational databases, and learn how to query relational data using cloud solutions provided by Microsoft Azure. The course also covers non-relational data offerings, the provisioning and deployment of non-relational databases, and the use of non-relational data stores within Azure. Additionally, students will explore the processing options available for building data analytics solutions in Azure, including Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. They will also learn about Power BI, its components, and how these components work together to create insightful visualizations.
Audience Profile
This course is designed for individuals who are interested in learning the basics of database concepts in a cloud environment, gaining essential skills in cloud data services, and building a strong foundation in Microsoft Azure's cloud data services.
At Course Completion
Upon completing this course, students will be able to:
- Describe key data concepts within the context of Azure
- Explain the principles of relational data in Azure
- Understand non-relational data concepts in Azure
- Identify the components of a modern data warehouse in Azure
Microsoft Certified: Azure Administrator Associate Exam Preparation (AZ-104)
28 HoursThis instructor-led, live training in Uzbekistan (online or onsite) is designed to help participants prepare for the Microsoft Azure Administrator Associate (AZ-104) certification exam.
The course covers the skills required to manage Azure resources, including Azure virtual machines, storage solutions, and Azure network management.
Microsoft Certified: Azure Developer Associate Exam Preparation (AZ-204)
35 HoursThis instructor-led, live training in Uzbekistan (online or onsite) is designed to help participants prepare for the Microsoft Azure Developer Associate (AZ-204) certification exam.
The course covers the concepts of developing Azure solutions, including Azure compute, storage, and security features. It provides a comprehensive introduction to Azure development, including tools and services for building, testing, and deploying applications.
Microsoft Certified: Azure Security Engineer Associate Exam Preparation (AZ-500)
35 HoursThis instructor-led, live training in Uzbekistan (online or onsite) is designed to help participants prepare for the Microsoft Azure Security Engineer Associate (AZ-500) certification exam.
The course covers various security topics related to Azure, including identity and access management, platform protection, data and application protection, and operations management.
Microsoft Certified: Azure Fundamentals Exam Preparation (AZ-900)
14 HoursThis instructor-led, live training in Uzbekistan (online or onsite) is designed to help participants prepare for the Microsoft Azure Fundamentals (AZ-900) certification exam.
The course covers the basic concepts of cloud computing and Azure services. It provides a comprehensive introduction to Azure, including its architecture, pricing and support, and the most commonly used Azure services.
Windows Server 2019 Hybrid and Azure IaaS (authorized training course WS 012T00)
21 HoursThis three-day course is primarily designed for IT professionals who have experience managing on-premises Windows Server environments. The aim is to prepare these professionals for planning, implementing, and managing environments that incorporate Azure IaaS-hosted Windows Server workloads. The course delves into leveraging the hybrid capabilities of Azure, migrating both virtual and physical server workloads to Azure IaaS, and effectively managing and securing Azure VMs running Windows Server 2019.