Migrate Open Source Data Workloads to Azure (authorized training course DP 070T00) Training Course
About This Course
This course equips learners with a comprehensive understanding of Azure SQL Database, providing essential guidance on migrating MySQL and PostgreSQL workloads to the Azure SQL Database platform.
Audience Profile
The primary audience comprises database developers planning to transition their MySQL or Postgres database workloads to Azure SQL DB. The secondary audience includes MySQL and Postgres administrators seeking to enhance their awareness of the features and benefits offered by Azure SQL DB.
At Course Completion
Upon completing this course, students will have acquired the ability to:
- Migrate on-premises MySQL environments to Azure SQL DB for MySQL
- Migrate on-premises PostgreSQL environments 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 should commence this module with foundational knowledge of cloud computing concepts and practical experience with open-source relational database management systems.
Specifically, candidates should possess:
- Proficiency in working with PostgreSQL and/or MySQL
- Experience in applying backup and recovery techniques to open-source data
- Competency in 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)
Examples and their usage
Dariusz Frycz - WASKO SPOLKA AKCYJNA
Course - AZ-040T00: Automating Administration with PowerShell
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, participants will acquire the skills to design and develop services that interact with local and remote data from diverse sources. Additionally, learners will master the process of deploying services to hybrid environments, encompassing both on-premises servers and Microsoft Azure.
Audience Profile
Primary: .NET developers seeking to learn how to create services and deploy them within hybrid environments.
Secondary: .NET developers with prior web application development experience who are interested in building new applications or migrating existing ones to Microsoft Azure.
At Course Completion
Upon finishing this course, students will be equipped to:
- Explain the fundamental concepts of service development and data access strategies using the .NET platform.
- Describe the Microsoft Azure cloud platform, along with its compute, data, and application hosting offerings.
- Design and develop data-centric applications utilizing Visual Studio 2017 and Entity Framework Core.
- Design, implement, and consume HTTP services using ASP.NET Core.
- Extend HTTP services via ASP.NET Core.
- Host services both on-premises and within Microsoft Azure.
- Deploy services to on-premises and cloud environments, and manage their service interfaces and policies.
- Select appropriate data storage solutions, and manage data caching, distribution, and synchronization.
- Monitor, log, and troubleshoot services.
- 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 required to design Azure AI solutions by constructing a customer support chatbot leveraging artificial intelligence on the Microsoft Azure platform. This includes implementing language understanding capabilities and utilising pre-built AI functionalities available through 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 the Microsoft Azure services available for building AI solutions. The program is not intended to train students to become professional data scientists or software developers; instead, it aims to build awareness of common AI workloads and the ability to identify appropriate Azure services to support them. Designed as a blended learning experience, the course combines instructor-led training with online materials 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 a reference 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 that artificial intelligence (AI) enables, and the Microsoft Azure services available to create them. No prior experience with Microsoft Azure is required, though a basic familiarity with computer technology and the Internet is assumed. Some concepts covered require a basic understanding of mathematics, such as the ability to interpret charts. The course includes hands-on activities involving data work and code execution, so a knowledge of fundamental programming principles will be helpful.
At Course Completion
After 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 live, instructor-led training in Kenya (online or onsite) is designed for intermediate to advanced professionals aiming 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.
AZ-040T00: Automating Administration with PowerShell
35 HoursThis course equips learners with the essential knowledge and skills required to administer and automate Windows server environments using PowerShell. Participants will develop the ability to identify and construct the necessary commands to execute specific tasks. Furthermore, students will learn to build scripts for advanced operations, such as automating routine activities and generating reports. The course provides prerequisite skills applicable to a wide array of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. Aligning with this objective, the course does not concentrate on a single product; however, Windows Server serves as the primary example platform for the techniques taught, as it is the common foundation for these products.
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 sites, manage network traffic, implement storage solutions, create and scale virtual machines, deploy web apps and containers, back up and share data, and monitor your solutions.
This course is designed for Azure Administrators. The Azure Administrator manages, implements, and monitors identity, governance, storage, compute, and virtual networks within a cloud environment. The Azure Administrator provisions, sizes, monitors, and adjusts resources as necessary.
AZ-140T00: Configuring and Operating Microsoft Azure Virtual Desktop
28 HoursThis course equips Azure administrators with the skills to plan, deliver, and manage virtual desktop experiences and remote applications for any device on Azure. Through a combination of demonstrations and hands-on labs, students will deploy virtual desktop environments and applications on Azure Virtual Desktop, learning to optimize them for multi-session virtual environments.
AZ-500T00-A: Microsoft Azure Security Technologies
28 HoursThis training equips IT Security Professionals with the essential knowledge and skills 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 are preparing for the associated certification exam or who handle security tasks in their daily work. 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 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, learners will gain an understanding of database concepts within a cloud setting, acquire foundational skills in cloud data services, and develop a solid grasp of cloud data services on Microsoft Azure. Participants will identify and describe essential data concepts, including relational, non-relational, big data, and analytics, and examine how these technologies are applied using Microsoft Azure. The course also covers the roles, tasks, and responsibilities associated with the data field. Students will investigate relational data solutions, including provisioning and deploying relational databases, as well as querying relational data through Azure cloud solutions. Additionally, learners will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores within Microsoft Azure. The curriculum also addresses the processing options available for constructing data analytics solutions in Azure, including Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Finally, students will learn about Power BI, its core components, and how they function together.
Audience Profile
This course is designed for individuals seeking to understand the fundamentals of database concepts in a cloud environment, acquire basic proficiency in cloud data services, and build foundational knowledge of cloud data services within Microsoft Azure.
At Course Completion
Upon finishing 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 intensive three-day programme is designed for IT professionals who possess hands-on experience in managing on-premises Windows Server environments. It aims to equip these professionals with the skills needed to plan, implement, and manage infrastructures that incorporate Azure IaaS-hosted Windows Server workloads. Key topics include leveraging Azure’s hybrid capabilities, migrating virtual and physical server workloads to Azure IaaS, and effectively managing and securing Azure virtual machines running Windows Server 2019.