DP 900: Microsoft Azure Data Fundamentals (authorized training course) Training Course
About This Course
This course is designed to introduce students to the essential principles of database management within a cloud environment, with a focus on foundational skills in cloud data services and Microsoft Azure. Students will gain an understanding of key data concepts such as relational databases, non-relational databases, big data, and analytics, and how these are applied using Microsoft Azure technology. They will delve into the roles, tasks, and responsibilities within the field of data management. Additionally, students will explore various relational database offerings in Azure, including their deployment and querying through cloud solutions. The course also covers non-relational databases and data storage options with Azure. Students will learn about different processing methods for creating data analytics solutions on Azure, such as Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Furthermore, they will be introduced to Power BI, including its components and how these elements function together.
Audience Profile
This course is intended for individuals interested in mastering the basics of database concepts within a cloud setting, acquiring fundamental skills in cloud data services, and establishing a solid foundation in Microsoft Azure's cloud data services.
At Course Completion
Upon finishing this course, students will be able to:
- Articulate core data concepts in Azure
- Elucidate the principles of relational databases within Azure
- Explain non-relational database concepts in Azure
- Distinguish components of a contemporary data warehouse in Azure
Course Outline
Module 1: Explore core data concepts
- Explore core data concepts
- Explore roles and responsiblities in the world of data
- Describe concepts of relational data
- Explore concepts of non-relational data
- Explore concepts of data analytics
Module 2: Explore relational data in Azure
- Explore relational data services in Azure
- Explore provisioning and deploying relational database services in Azure
- Query relational data in Azure
Module 3: Explore non-relational data in Azure
- Explore non-relational data services in Azure
- Explore provisioning and deploying non-relational data services on Azure
- Manage non-relational data stores in Azure
Module 4: Explore modern data warehouse analytics in Azure
- Examine components of a modern data warehouse
- Explore data ingestion in Azure
- Explore data storage and processing in Azure
- Get started building with Power BI
Requirements
Prerequisite certification is not required before taking this course. Successful Azure AI Fundamental students start with some basic awareness of computing and internet concepts, and an interest in using Azure AI services.
Specifically:
- Experience using computers and the internet.
- Interest in use cases for AI applications and machine learning models.
- A willingness to learn through hands-on exploration.
Need help picking the right course?
DP 900: Microsoft Azure Data Fundamentals (authorized training course) 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
Upcoming Courses
Related Courses
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.
Building AI Cloud Apps with Microsoft Azure
35 HoursThis instructor-led, live training in the UAE (online or onsite) is aimed at intermediate-level to advanced-level professionals who wish 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 the UAE (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-040T00: Automating Administration with PowerShell
35 HoursThis course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches.
AZ-104T00-A: Microsoft Azure Administrator
28 HoursThis training program equips IT Professionals with the skills to manage their Azure subscriptions, secure identities, oversee infrastructure administration, set up virtual networking, integrate Azure with on-premises locations, control network traffic, deploy storage solutions, launch and scale virtual machines, implement web apps and containers, safeguard and share data, and oversee the entire solution.
This course is designed for Azure Administrators. These administrators are responsible for implementing, managing, and monitoring identity, governance, storage, compute resources, and virtual networks within a cloud environment. They will also be tasked with provisioning, sizing, monitoring, and adjusting these resources as needed.
AZ-400T00-A: Designing and Implementing Microsoft DevOps solutions
35 HoursThis course equips participants with the knowledge and skills necessary for designing and executing DevOps processes and practices. Learners will gain insights into planning for DevOps, utilizing source control, scaling Git within an enterprise environment, consolidating artifacts, formulating a dependency management strategy, managing secrets, implementing continuous integration, establishing a container build approach, devising a release plan, setting up a release management workflow, executing deployment patterns, and enhancing feedback mechanisms.
Audience Profile
This course is ideal for individuals interested in designing and implementing DevOps processes or preparing to take the Microsoft Azure DevOps Solutions certification exam.
Job Role: DevOps Engineer
Preparation for Exam: AZ-400
Skills Acquired
- Create a shared vision and timeline for transformation
- Select a project, define project metrics, and Key Performance Indicators (KPIs)
- Establish an agile team structure and organizational framework
- Formulate a tool integration strategy
- Develop a license management plan (e.g., for Azure DevOps and GitHub users)
- Create a traceability strategy from work items to operational software
- Design an authentication and access control strategy
- Plan the integration of on-premises and cloud resources
- Understand the advantages of using Source Control
- Explain Azure Repos and GitHub
- Migrate from TFVC to Git
- Ensure code quality, including managing technical debt with SonarCloud and other tools
- Promote organizational understanding of code quality
- Detail how to structure Git repositories
- Explain Git branching workflows
- Leverage pull requests for collaboration and code reviews
- Utilize Git hooks for automation
- Use Git to foster internal open-source practices across the organization
- Understand the role of Azure Pipelines and its components
- Set up Agents for use in Azure Pipelines
- Explain the importance of continuous integration
- Implement continuous integration using Azure Pipelines
- Define Site Reliability Engineering
- Create processes to gauge end-user satisfaction and analyze user feedback
- Automate application analytics through designed processes
- Manage alerts, reducing non-actionable notifications
- Conduct blameless retrospectives and foster a just culture
- Define an infrastructure and configuration strategy along with the appropriate toolset for release pipelines and application infrastructure
- Incorporate compliance and security into your application infrastructure
- Identify challenges associated with integrating open-source software
- Evaluate open-source software packages for security and license compliance
- Administer 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 necessary knowledge and skills to enforce security measures, uphold an organization’s security stance, and detect and address security weaknesses. It covers areas such as identity and access management, platform protection, data and application security, and security operations.
Audience Profile
This course is designed for Azure Security Engineers preparing for the associated certification exam or those executing security tasks in their daily roles. It will also benefit engineers looking to specialize in securing Azure-based digital platforms and play a critical role in safeguarding an organization's data.
Skills Gained
- Implement enterprise governance strategies, including role-based access control, Azure policies, and resource locks.
- Create an Azure AD infrastructure encompassing users, groups, and multi-factor authentication.
- Set up Azure AD Identity Protection with risk policies, conditional access, and access reviews.
- Deploy Azure AD Privileged Identity Management for managing Azure AD roles and resources.
- Configure Azure AD Connect to include various authentication methods and on-premises directory synchronization.
- Enforce perimeter security measures using Azure Firewall.
- Apply network security strategies involving Network Security Groups and Application Security Groups.
- Ensure host security through endpoint protection, remote access management, update management, and disk encryption.
- Maintain container security with Azure Container Instances, Azure Container Registry, and Azure Kubernetes.
- Manage Azure Key Vault for certificates, keys, and secrets.
- Secure applications by registering apps, using managed identities, and setting up service endpoints.
- Protect storage through shared access signatures, blob retention policies, and Azure Files authentication.
- Safeguard databases with authentication methods, data classification, dynamic data masking, and always encrypted features.
- Utilize Azure Monitor for connected sources, log analytics, and alerts.
- Leverage Azure Security Center to manage policies, recommendations, and just-in-time virtual machine access.
- Operate Azure Sentinel for workbooks, incidents, and playbooks.
Microsoft Certified: Azure Administrator Associate Exam Preparation (AZ-104)
28 HoursThis instructor-led, live training in the UAE (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 the UAE (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 Solutions Architect Expert Exam Preparation (AZ-305)
28 HoursThis instructor-led, live training in the UAE (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 the UAE (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 the UAE (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 the UAE (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.
Microsoft Certified: Azure Data Engineer Associate Exam Preparation (DP-203)
35 HoursThis instructor-led, live training in the UAE (online or onsite) is designed to help participants prepare for the Microsoft Azure Data Engineer certification exam (DP-203).
The course covers the basics of Azure data services and how they can be used to process, store, and manage data in the cloud. Participants will learn how to create data processing solutions using Azure Data Factory, Azure Stream Analytics, and Azure Databricks, and how to work with NoSQL databases using Azure Cosmos DB.