Migrate Open Source Data Workloads to Azure (authorized training course DP 070T00) Training Course
About This Course
This course equips students with a solid understanding of Azure SQL Database and guides them through the requirements for migrating MySQL and PostgreSQL workloads to Azure SQL Database.
Audience Profile
The primary target audience for this course consists of database developers who intend to migrate their MySQL or Postgres database workloads to Azure SQL DB. The secondary audience includes MySQL/Postgres administrators seeking to gain awareness of the features and benefits of Azure SQL DB.
At Course Completion
Upon completing this course, students will have learned how to:
- Migrate on-premises MySQL to Azure SQL DB for MySQL
- Migrate on-premises PostgreSQL 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 undertake this role should begin with a foundational understanding of cloud computing concepts and hands-on experience with open-source relational database management systems.
Specifically:
- Working with PostgreSQL and/or MySQL
- Utilising backup and recovery techniques with open-source data
- SQL administration
Need help picking the right course?
southafrica@nobleprog.co.za or +27 (0)10 005 5793
Migrate Open Source Data Workloads to Azure (authorized training course DP 070T00) Training Course - Enquiry
Testimonials (2)
Everything, is a new platform for me and everything was interesting.
Sergiu
Course - AZ-104T00-A: Microsoft Azure Administrator
The details and the presentation style.
Cristian Mititean - Accenture Industrial SS
Course - Azure Machine Learning (AML)
Related Courses
MS-20487: Developing Microsoft Azure and Web Services (authorized training course)
35 HoursAbout This Course
This course teaches students how to design and build services that retrieve local and remote data from diverse sources. Learners will also acquire the skills to develop and deploy services across hybrid environments, covering both on-premises servers and Microsoft Azure.
Audience Profile
Primary: .NET developers looking to learn service development and deployment in hybrid environments.
Secondary: .NET developers with Web application development experience who are interested in creating new applications or migrating existing ones to Microsoft Azure.
At Course Completion
Upon finishing this course, students will be able to:
- Explain the fundamental concepts of service development and data access strategies within the .NET platform.
- Describe the Microsoft Azure cloud platform along with its compute, data, and application hosting offerings.
- Design and build a data-focused application using Visual Studio 2017 and Entity Framework Core.
- Design, implement, and consume HTTP services using ASP.NET Core.
- Extend HTTP services with ASP.NET Core.
- Host services in on-premises settings and within Microsoft Azure.
- Deploy services to on-premises and cloud environments, managing their interfaces and policies.
- Select appropriate data storage solutions, and manage caching, distribution, and synchronization of data.
- Monitor, log, and troubleshoot services.
- Explain claim-based identity concepts and standards, implementing authentication and authorization via 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 expertise required to design Azure AI solutions by constructing a customer support chatbot powered by artificial intelligence on the Microsoft Azure platform. The curriculum covers language comprehension and the utilisation of pre-built AI capabilities within Azure Cognitive Services.
Microsoft Azure AI Fundamentals (authorized training course AI 900T00)
7 HoursAbout This Course
This course provides an introduction to the core concepts of artificial intelligence (AI) and highlights the Microsoft Azure services available for developing AI solutions. It is not intended to train students to become professional data scientists or software developers; instead, it aims to raise awareness of typical AI workloads and equip learners with the ability to identify suitable Azure services for those tasks. Designed as a blended learning experience, the course combines instructor-led sessions with online resources on the Microsoft Learn platform (https://azure.com/learn). The practical exercises are derived from Learn modules, and students are encouraged to use Learn content as a reference to reinforce classroom learning and explore topics in greater depth.
Audience Profile
The Azure AI Fundamentals course is tailored for anyone eager to understand the types of solutions enabled by artificial intelligence (AI) and 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 expected. Some course concepts 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, knowledge of basic programming principles will be beneficial.
At Course Completion
Upon completing this course, you will be able to:
- Describe Artificial Intelligence workloads and considerations
- Describe fundamental principles of machine learning on Azure
- Describe features of computer vision workloads on Azure
- Describe features of Natural Language Processing (NLP) workloads on Azure
- Describe features of conversational AI workloads on Azure
Building AI Cloud Apps with Microsoft Azure
35 HoursThis instructor-led, live training in Nigeria (available online or onsite) is designed for intermediate to advanced-level professionals who aspire to build and deploy AI-powered cloud applications using Microsoft Azure.
By the end of this training, participants will be able to:
- Develop event-driven and serverless applications using Azure Functions.
- Manage Azure storage solutions and virtual machines.
- Deploy and scale web applications using Azure App Service and Docker containers.
- Integrate AI, machine learning, and natural language processing using Azure AI Services.
- Leverage GitHub Copilot to assist in AI-driven cloud application development.
Azure Machine Learning (AML)
21 HoursThis instructor-led, live training in Nigeria (online or onsite) is aimed at engineers who wish to use Azure ML's drag-and-drop platform to deploy Machine Learning workloads without having to purchase software and hardware and without having to worry about maintenance and deployment.
By the end of this training, participants will be able to:
- Write highly-accurate machine learning models using Python, R, or zero-code tools.
- Leverage Azure's available data sets and algorithms to train and track machine learning and deep-learning models.
- Use Azures interactive workspace to collaboratively develop ML models.
- Choose from different Azure-supported ML frameworks such as PyTorch, TensorFlow, and scikit-learn.
AZ-104T00-A: Microsoft Azure Administrator
28 HoursThis programme 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 solutions.
Designed for Azure Administrators, this course 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 adjust resources as necessary.
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. Participants will learn to implement Azure compute resources, develop Azure Functions, and manage web applications. The curriculum covers the development of solutions leveraging Azure storage, the implementation of authentication and authorization mechanisms, and the securing of solutions through KeyVault and Managed Identities. Additionally, students will learn to connect with and utilize both Azure and third-party services, incorporating event-driven and message-based architectures into their solutions. The course also addresses the monitoring, troubleshooting, and optimization of Azure solutions.
Audience Profile
- This course is designed for individuals interested in Azure development or those preparing for 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 gain the ability to plan for DevOps adoption, utilize source control, and scale Git for enterprise environments. The curriculum covers consolidating artifacts, designing dependency management strategies, managing secrets, implementing continuous integration, establishing container build strategies, and designing release strategies. Additionally, students will 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 preparing for the Microsoft Azure DevOps Solutions certification exam.
Job role: DevOps Engineer
Preparation for exam: AZ-400
Skills gained
- Plan the transformation by establishing shared goals and timelines
- Select projects and identify relevant metrics and Key Performance Indicators (KPIs)
- Create teams and agile organizational structures
- Design a strategy for tool integration
- Design a license management strategy (e.g., for Azure DevOps and GitHub users)
- Design a strategy for end-to-end traceability from work items to working software
- Design an authentication and access strategy
- Design a strategy 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 via SonarCloud and other tooling solutions
- Build organizational knowledge on code quality
- Explain how to structure Git repos
- 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 to implement security controls, sustain an organization’s security posture, and identify and remediate vulnerabilities. It covers security for identity and access, platform protection, data and applications, and security operations.
Audience profile
This course is ideal for Azure Security Engineers preparing for the associated certification exam or those handling security tasks in their daily roles. It is also beneficial for engineers seeking to specialize in securing Azure-based digital platforms and playing a key 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, covering 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, covering 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 Programme
In this programme, participants will acquire a solid understanding of database principles within cloud environments, develop essential skills in cloud data services, and build a strong foundational knowledge of cloud data offerings on Microsoft Azure. Learners 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 also covers the various roles, tasks, and responsibilities within the data industry. Participants will examine relational data services, learn how to provision and deploy relational databases, and query relational data through cloud data solutions on Azure. Additionally, the programme explores non-relational data offerings, including the provisioning and deployment of non-relational databases and data stores on Azure. Students will investigate the processing options available for creating data analytics solutions in Azure, focusing on Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Finally, participants will gain insight into Power BI, understanding its key components and how they function together.
Target Audience
This programme is designed for individuals seeking to understand the fundamentals of database concepts in cloud environments, gain basic proficiency in cloud data services, and establish a foundational knowledge of cloud data services within the Microsoft Azure ecosystem.
Learning Outcomes
Upon completing this programme, participants will be able to:
- Outline core data concepts in Azure
- Explain relational data concepts in Azure
- Explain non-relational data concepts in Azure
- Identify the components of a modern data warehouse in Azure
Windows Server 2019 Hybrid and Azure IaaS (authorized training course WS 012T00)
21 HoursThis three-day programme is designed mainly for IT professionals who already have experience managing on-premises Windows Server environments. Its goal is to equip participants with the skills needed to plan, implement, and manage settings that incorporate Azure IaaS-hosted Windows Server workloads. The content explores how to utilise Azure’s hybrid capabilities, how to move virtual and physical server workloads to Azure IaaS, and how to manage and secure Azure VMs running Windows Server 2019.