Migrate Open Source Data Workloads to Azure (authorized training course DP 070T00) Training Course
About This Course
This course equips students with a comprehensive understanding of Azure SQL Database and provides detailed guidance on the requirements for migrating MySQL and PostgreSQL workloads to Azure SQL Database.
Audience Profile
The primary audience for this course consists of database developers who intend to migrate their MySQL or PostgreSQL database workloads to Azure SQL Database. The secondary audience includes MySQL and PostgreSQL administrators seeking to gain awareness of the features and benefits offered by Azure SQL Database.
At Course Completion
Upon completing 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 participants entering this role should possess a foundational understanding of cloud computing concepts and hands-on experience with open-source relational database management systems.
Specifically, familiarity with the following areas is expected:
- Working with PostgreSQL and/or MySQL
- Applying backup and recovery techniques with open-source data
- SQL administration
Need help picking the right course?
uzbekistan@nobleprog.com or +919818060888
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
Related Courses
MS-20487: Developing Microsoft Azure and Web Services (authorized training course)
35 HoursAbout This Course
In this course, students will learn how to design and develop services that access local and remote data from various sources. Students will also learn how to develop and deploy services to hybrid environments, including on-premises servers and Microsoft Azure.
Audience Profile
Primary: .NET developers who want to learn how to develop services and deploy them to hybrid environments.
Secondary: .NET developers with Web application development experience who are exploring developing new applications or porting existing applications to Microsoft Azure.
At Course Completion
After completing this course, students will be able to:
- Describe the basic concepts of service development and data access strategies using the .NET platform.
- Describe the Microsoft Azure cloud platform and its compute, data, and application hosting offerings.
- Design and develop a data-centric application using Visual Studio 2017 and Entity Framework Core.
- Design, implement, and consume HTTP services using ASP.NET Core.
- Extend HTTP services using ASP.NET Core.
- Host services on-premises and in Microsoft Azure.
- Deploy services to both on-premises and cloud environments and manage the interface and policy for their services.
- Choose a data storage solution, cache, distribute, and synchronize data.
- Monitor, log, and troubleshoot services.
- Describe claim-based identity concepts and standards, and implement authentication and authorization with 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 discover how to design a solution leveraging a combination of Azure Resource Manager templates and Azure DevOps to enable continuous delivery across several Azure PaaS services.
By the conclusion of this workshop, you will be equipped to build templates that automate cloud infrastructure and minimize error-prone manual processes. Furthermore, you will create an Azure Resource Manager (ARM) template to provision Azure resources, configure continuous delivery with Azure DevOps, integrate Application Insights into an application, and establish an Azure DevOps project along with a Git repository.
Designing and Implementing an Azure AI Solution (authorized training course AI 100T01)
21 HoursAcquire the essential knowledge required for designing Azure AI solutions by constructing a customer support chatbot utilizing artificial intelligence from the Microsoft Azure platform. This includes leveraging language understanding capabilities and pre-built AI functionality available through Azure Cognitive Services.
Microsoft Azure AI Fundamentals (authorized training course AI 900T00)
7 HoursAbout This Course
This course introduces fundamental concepts related to artificial intelligence (AI) and the services available in Microsoft Azure for building AI solutions. It is not intended to train students to become professional data scientists or software developers; rather, it aims to raise awareness of common AI workloads and equip learners with the ability to identify appropriate Azure services to support them. The course is structured as a blended learning experience, combining instructor-led sessions with online resources on the Microsoft Learn platform (https://azure.com/learn). The hands-on exercises are based on Learn modules, and students are encouraged to use Learn content as reference material to reinforce classroom learning and explore topics in greater depth.
Audience Profile
The Azure AI Fundamentals course is designed for anyone interested in understanding the types of solutions artificial intelligence (AI) enables and the Microsoft Azure services that can be used to create them. No prior experience with Microsoft Azure is required; however, a basic familiarity with computer technology and the Internet is expected. Some concepts covered in the course require a foundational understanding of mathematics, such as the ability to interpret charts. The course includes practical activities involving data handling and code execution, so a basic knowledge of programming principles will be beneficial.
At Course Completion
Upon completing this course, you will be able to:
- Describe AI workloads and key considerations
- Explain the fundamental principles of machine learning on Azure
- Outline the features of computer vision workloads on Azure
- Outline the features of Natural Language Processing (NLP) workloads on Azure
- Outline the features of conversational AI workloads on Azure
AZ-020: Microsoft Azure solutions for AWS developers (authorized training course)
21 HoursAbout This Course
This three-day course is designed to help AWS (Amazon Web Services) developers prepare and build comprehensive end-to-end solutions on Microsoft Azure. Throughout the training, you will learn to create Azure App Service Web App solutions and Azure Functions, utilize blob storage or Cosmos DB, and implement secure cloud architectures that feature user authentication and authorization. You will also gain expertise in API management, developing event- and message-based architectures, as well as monitoring, troubleshooting, and optimizing your Azure deployments. The curriculum focuses on how developers leverage Azure services, highlighting key features and tasks that differ from AWS, and exploring what these distinctions mean for you when building applications hosted on Azure.
Audience Profile
This course is intended for experienced AWS developers who are looking to transition into or expand their skills in Azure development.
AZ-104T00-A: Microsoft Azure Administrator
28 HoursThis course empowers IT professionals to effectively manage Azure subscriptions, safeguard identities, oversee infrastructure, configure virtual networks, link Azure with on-premises environments, handle network traffic, deploy storage solutions, build and scale virtual machines, establish web applications and containers, safeguard and share data, and monitor overall solution performance.
Designed for Azure Administrators, this training covers the implementation, management, and monitoring of identity, governance, storage, compute, and virtual networks within a cloud environment. Azure Administrators will learn to provision, size, monitor, and optimize resources as needed.
AZ-204T00: Developing solutions for Microsoft Azure (authorized training course)
35 HoursAbout This Course
This course equips developers with the skills needed to build comprehensive end-to-end solutions in Microsoft Azure. Learners will gain expertise in implementing Azure compute resources, creating Azure Functions, and managing web applications. The curriculum covers developing solutions with Azure storage, enforcing authentication and authorization protocols, and securing applications using Key Vault and Managed Identities. Additionally, students will learn how to integrate Azure services and third-party solutions, incorporating event-driven and message-oriented architectures. The course also emphasizes monitoring, troubleshooting, and optimizing Azure-based solutions.
Audience Profile
- This course is designed for individuals interested in Azure development or those preparing to pass the Microsoft Azure Developer Associate certification exam.
AZ-400T00-A: Designing and Implementing Microsoft DevOps solutions
35 HoursThis course delivers the essential knowledge and skills required 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, develop container build strategies, design release strategies, establish release management workflows, implement deployment patterns, and optimize feedback mechanisms.
Audience profile
This course is designed for students interested in designing and implementing DevOps processes or preparing for the Microsoft Azure DevOps Solutions certification exam.
Target job role: DevOps Engineer
Exam preparation: AZ-400
Skills gained
- Plan transformations using shared goals and timelines.
- Select projects and define key performance indicators (KPIs) and metrics.
- Establish team and agile organizational structures.
- Design strategies for tool integration.
- Develop license management strategies for tools such as Azure DevOps and GitHub.
- Create end-to-end traceability strategies linking work items to deployed software.
- Design authentication and access control strategies.
- Formulate strategies for integrating on-premises and cloud resources.
- Explain the benefits of using source control.
- Describe Azure Repos and GitHub functionalities.
- Migrate from TFVC to Git.
- Manage code quality, including technical debt, using SonarCloud and other tools.
- Build organizational knowledge regarding code quality.
- Explain Git repository structuring best practices.
- Describe Git branching workflows.
- Utilize pull requests for collaboration and code reviews.
- Use Git hooks to drive automation.
- Apply Git to foster inner-sourcing across the organization.
- Explain the role and components of Azure Pipelines.
- Configure agents for use within Azure Pipelines.
- Explain the importance of continuous integration.
- Implement continuous integration using Azure Pipelines.
- Define Site Reliability Engineering (SRE).
- Design processes to measure end-user satisfaction and analyze feedback.
- Design processes to automate application analytics.
- Manage alerts and eliminate non-actionable notifications.
- Conduct blameless retrospectives and cultivate a just culture.
- Define infrastructure and configuration strategies along with appropriate toolsets for release pipelines and application infrastructure.
- Implement compliance and security within application infrastructure.
- Describe challenges associated 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 knowledge and skills necessary to implement security controls, maintain an organization’s security posture, and identify and remediate security vulnerabilities. The curriculum covers security for identity and access, platform protection, data and applications, and security operations.
Audience profile
This course is designed for Azure Security Engineers who plan to take the associated certification exam or who handle security tasks in their daily roles. It is also beneficial for engineers looking to specialize in providing security for 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.
- Implement an Azure AD infrastructure including users, groups, and multi-factor authentication.
- Implement Azure AD Identity Protection including risk policies, conditional access, and access reviews.
- Implement Azure AD Privileged Identity Management including Azure AD roles and Azure resources.
- Implement Azure AD Connect including authentication methods and on-premises directory synchronization.
- Implement perimeter security strategies including Azure Firewall.
- Implement network security strategies including Network Security Groups and Application Security Groups.
- Implement host security strategies including endpoint protection, remote access management, update management, and disk encryption.
- Implement container security strategies including Azure Container Instances, Azure Container Registry, and Azure Kubernetes.
- Implement Azure Key Vault including certificates, keys, and secrets.
- Implement application security strategies including app registration, managed identities, and service endpoints.
- Implement storage security strategies including shared access signatures, blob retention policies, and Azure Files authentication.
- Implement database security strategies including authentication, data classification, dynamic data masking, and always encrypted.
- Implement Azure Monitor including connected sources, log analytics, and alerts.
- Implement Azure Security Center including policies, recommendations, and just in time virtual machine access.
- Implement 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 learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Microsoft Azure. They will explore the roles, tasks, and responsibilities in the world of data. The students will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Microsoft Azure. They will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure. Students will explore the processing options available for building data analytics solutions in Azure. They will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Students will learn what Power BI is, including its building blocks and how they work together.
Audience Profile
The audience for this course is individuals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure.
At Course Completion
After 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
Microsoft Certified: Azure Administrator Associate Exam Preparation (AZ-104)
28 HoursThis instructor-led, live training in Uzbekistan (online or onsite) is designed to assist participants in preparing 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 on-site) is designed to assist participants in preparing for the Microsoft Azure Developer Associate (AZ-204) certification exam.
The curriculum covers the core concepts of developing Azure solutions, including Azure compute, storage, and security features. It provides a thorough introduction to Azure development, encompassing the tools and services necessary for building, testing, and deploying applications.
Microsoft Certified: Azure Solutions Architect Expert Exam Preparation (AZ-305)
28 HoursThis instructor-led, live training in Uzbekistan (online or onsite) is designed to help participants prepare for the Microsoft Azure Solutions Architect Expert (AZ-305) certification exam.
The course covers advanced concepts of cloud computing and Azure services. It provides a comprehensive introduction to Azure solutions architecture, including its principles, components, and services. Participants will also learn how to design and deploy Azure solutions using best practices and industry standards.
Microsoft Certified: Azure DevOps Engineer Exam Preparation (AZ-400)
35 HoursThis instructor-led, live training in Uzbekistan (online or onsite) is designed to help participants prepare for the Microsoft Azure DevOps Engineer certification exam (AZ-400).
The course covers the basics of DevOps practices and how they can be implemented on the Azure platform. Participants will learn how to use Azure DevOps to manage code, build and release pipelines, and implement continuous integration and continuous delivery (CI/CD) practices.
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.