DP-900 Microsoft Azure Data Fundamentals Training - OEM Certkit

• Language: English
• Audience: The target audience for this course are individuals who want to learn the fundamentals of dataBasics concepts in a cloud environment, acquire basic skills in cloud data services and build their basic knowledge of cloud data services within Microsoft Azure.
• Required knowledge level: some basic knowledge of computing and Internet concepts
• Course duration: 17:11 (depending on personal speed)
• Online access: 24/7, 365 days after activation
• Award Winning E-learning
• Contact with instructor by email and chat ( Online Mentor)
• Complete training for the official Exam
• User-friendly environment
• Certificate of Participation included

DP-900 Microsoft Azure Data Fundamentals training

The DP-900 Microsoft Azure Data Fundamentals training is offered as part of a special certification package. This package provides one year of access to a groundbreaking E-Learning environment that makes passing the exam easy. You will be trained by certified instructors in a secure learning portal (LMS). The package also includes a 24/7 Online Mentor, challenging tests and the ability to view all tips & tricks.

Moreover, the official trail exam is always guaranteed to be available and you will receive a certificate of participation after the training. As an additional option, there is also the possibility of Livelabs (at an additional cost).

Course content

In this CertKit, students will learn the fundamentals of dataBasics 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 dataBasicss, and querying relational data through cloud data solutions with Microsoft Azure. They will explore non-relational data offerings, provisioning and deploying non-relational dataBasicss, 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.

Prerequisites

Prerequisite certification is not required before taking this course. Successful Azure Data Fundamentals students start with some basic awareness of computing and Internet concepts, and an interest in extracting insights from data.
Experience using a web browser, such as Microsoft Edge.
Familiarity with basic data-related concepts, such as working with tables of data in a spreadsheet and
visualizing data using charts.

Course outcome

In this course, you will learn 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.

Who should attend

The audience for this course is individuals who want to learn the fundamentals of dataBasics concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure.

CertKit content

DP-900 Azure Data Fundamentals: Data Workloads

Course: 1 Hour, 7 Minutes

• Course Overview
• Workload Management
• Data Solutions
• Data Storage
• Transactional Workloads
• Analytical Workloads
• Azure Batch
• Azure Real Time Processing
• Batch Data vs. Streaming Data
• Relational Databases
• Course Summary

DP-900 Azure Data Fundamentals: Data Analytics

Course: 1 Hour, 27 Minutes

• Course Overview
• Azure Data Explorer
• Visualizing Data with Azure Data Explorer
• Data Analytics and Reporting
• SQL Server Reporting Services
• Identifying Data Chart Types
• Analytic Techniques
• Stream Analytics
• Identifying Stream Analytics Data Types
• Using Azure Storage Services
• Processing ELT Data
• Processing ETL Data
• Course Summary

DP-900: Azure Data Fundamentals: Relational Data Workloads

Course: 1 Hour, 21 Minutes

• Course Overview
• Characteristics of Relational Data
• Data Store Models
• Using Indexes in a Relational Database
• Using Views in a Relational Database
• Azure Relational Delivery Models
• Azure PaaS
• Azure IaaS
• Azure SaaS
• Online Transaction Processing
• Online Analytical Processing
• Course Summary

DP-900 Azure Data Fundamentals: Relational Data Management

Course: 1 Hour, 44 Minutes

• Course Overview
• Deploying Relational Data
• Azure SQL Database
• Azure SQL Database Security Features
• Using Azure AD Authentication
• Using Azure Data Studio
• Using Azure SQL Server Management Studio
• Using the sqlcmd Utility
• Azure SQL Server
• Azure SQL Managed Instance
• Azure Synapse Analytics
• Azure SQL Connectivity Errors
• Azure SQL Connectivity Issues
• Course Summary

DP-900 Azure Data Fundamentals: Provisioning & Configuring Relational Data Services

Course: 1 Hour, 8 Minutes

• Course Overview
• Provisioning Relational Data Services
• Provisioning SQL Database
• Provisioning PostgreSQL
• Provisioning MySQL
• Provisioning MariaDB
• Configuring Azure SQL Database
• Configuring PostgreSQL
• Configuring MySQL
• Configuring MariaDB
• Course Summary

DP-900 Azure Data Fundamentals: Azure SQL Querying Techniques

Course: 1 Hour, 7 Minutes

• Course Overview
• Structured Query Language
• Using Data Definition Language
• Using Data Manipulation Language
• Querying Azure SQL Database Using Azure Portal
• Querying Azure SQL Database Using SSMS
• Querying Azure SQL Database Using Data Studio
• Querying Azure SQL Database Using sqlcmd Utility
• Querying Relational Data in PostgreSQL
• Querying Relational Data in MySQL
• Querying Relational Data in MariaDB
• Course Summary

DP-900 Azure Data Fundamentals: Non-relational Data Workloads

Course: 53 Minutes

• Course Overview
• Characteristics of Non-relational Data
• Non-relational vs. Relational Data
• Types of Non-relational Data
• CSV and JSON Files for Non-relational Data
• Requirements of Non-relational Data Stores
• Free-form Text for Search
• Time Series Solutions
• Course Summary

DP-900 Azure Data Fundamentals: Non-relational Data Services

Course: 55 Minutes

• Course Overview
• Provisioning Non-relational Data Services
• Configuring Non-relational Data Services
• Provisioning Other Non-relational Data Services
• Azure Table Storage
• Azure Blob Storage
• Managing Azure Blob Storage
• Azure File Storage
• Managing Azure File Storage
• Course Summary

DP-900 Azure Data Fundamentals: Azure Cosmos DB

Course: 1 Hour, 27 Minutes

• Course Overview
• Azure Cosmos DB
• Azure Cosmos DB Resource Model
• Provisioning Cosmos DB
• Configuring Cosmos DB
• Querying Azure Cosmos DB
• Azure Cosmos DB API
• Using Core (SQL) API for Cosmos DB
• Using Azure Cosmos DB API for MongoDB
• Using Cassandra API Azure in Cosmos DB
• Using Azure Table API in Cosmos DB
• Using Gremlin API in Cosmos DB
• Course Summary

DP-900 Azure Data Fundamentals: Non-relational Data Management

Course: 1 Hour, 27 Minutes

• Course Overview
• Deploying Non-relational Data Using Azure Portal
• Deploying Non-relational Data Using Azure Resource Manager Templates
• Deploying Non-relational Data Using Azure PowerShell
• Deploying Non-relational Data Using Azure CLI
• Cosmos DB Firewall
• Cosmos DB Authentication
• Cosmos DB Security
• Using Azure Cosmos DB Explorer
• Cosmos DB Geo-replication
• Cosmos DB IP Access Control Policy Issues
• Cosmos DB .NET SDK Issues
• Cosmos DB Java SDK Issues
• Course Summary

DP-900 Azure Data Fundamentals: Azure Analytics Workloads

Course: 1 Hour

• Course Overview
• Azure Synapse Analytics Architecture
• Using the Azure Synapse SQL Pool
• Data Warehouse Units
• Transactional and Analytic Workloads
• Batch and Real Time Data Processing
• Using Azure Portal to Create a Synapse SQL Pool
• Using Azure PowerShell to Create a Synapse SQL Pool
• Warehousing Workloads
• Data Warehouse Solutions
• Using Azure Data Lake Analytics
• Course Summary

DP-900 Azure Data Fundamentals: Modern Data Warehousing

Course: 1 Hour, 8 Minutes

• Course Overview
• Modern Data Warehousing
• Benefits of Data Warehousing
• Modern Data Warehousing Architecture
• Azure Data Factory
• Azure Data Lake
• Azure Databricks
• Azure Analysis Services
• Azure HDInsight
• Azure Distributed Data Engineering Toolkit
• Course Summary

DP-900 Azure Data Fundamentals: Azure Data Ingestion & Processing

Course: 1 Hour, 13 Minutes

• Course Overview
• Azure Data Loading for Synapse SQL Pools
• Azure Data Factory Pipelines and Activities
• Creating an Azure Data Factory UI
• Using the Azure Data Factory Copy Data Tool
• Using the Azure Synapse Analytics PolyBase
• Using SQL Server Integration Services
• Using Azure Databricks
• Loading Data into Azure Synapse Analytics
• Loading Data Using Azure Data Lake
• Course Summary

DP-900 Azure Data Fundamentals: Azure Data Visualization

Course: 1 Hour, 14 Minutes

• Course Overview
• Microsoft Power BI
• Using Microsoft Power BI Data Optimization
• Using Microsoft Power BI Datasets
• Using Microsoft Power BI Dashboards
• Using Microsoft Power BI Paginated Reporting
• Using Microsoft Power BI to Publish Reports
• Using Microsoft Power BI Interactive Reporting
• Using Microsoft Power BI Visualizations
• Microsoft Power BI Workflows
• Microsoft Power BI Security and Administration
• Course Summary

MeasureUp Exam simulation
150+ questions
Tips & Tricks

What is DP-900 Microsoft Azure Data Fundamentals training?

The DP-900 Microsoft Azure Data Fundamentals training is a course that focuses on Azure data fundamentals. The goal is to provide participants with knowledge and skills in data management and analysis in the Azure cloud environment. The course covers topics such as data concepts, data modeling, data storage options and data analysis tools.

It is suitable for professionals interested in working with data in Azure, such as data analysts and database managers. Completion of the course provides the opportunity to take the DP-900 exam and validate knowledge.

10 benefits if DP-900 Microsoft Azure Data Fundamentals

1. Fundamental understanding of Azure data concepts: You will gain a solid foundation of knowledge about Azure data and its capabilities.
2. Acknowledgementof your expertise: Passing the DP-900 exam demonstrates that you have the necessary knowledge and skills in Azure data.
3. Enhanced career opportunities: The DP-900 certification can strengthen your resume and make you more attractive to employers seeking Azure data experts.
4. Access to advanced Azure data certifications: The DP-900 exam can serve as a stepping stone to more advanced certifications within the Azure data domain.
5. Hands-on experience with Azure data: While preparing for the exam, you will gain hands-on experience with Azure data solutions and services.
6. Deeper understanding of data management: You will develop a thorough understanding of data management principles and practices in the context of Azure.
7. Ability to advise customers: With the knowledge you gain from the training, you will be able to advise customers on the use of Azure data solutions.
8. Increase your value to organizations: Your DP-900 certification will allow you to add value to organizations through effective deployment of Azure data solutions.
9. Access to exclusive resources: As a certified professional, you may have access to exclusive Azure resources, such as forums and communities.
10. Personal growth and development: Passing the DP-900 exam allows you to continue your personal growth and development by further expanding your expertise in Azure data.

Why is DP-900 Microsoft Azure Data Fundamentials important?

DP-900 is important because it provides fundamental training in Microsoft Azure Data, which is an essential component of modern IT architecture and data management. This training allows participants to understand and apply the basics of cloud computing and data management on Azure platforms, giving them a competitive advantage in the job market.

In addition, passing the DP-900 exam is a requirement for certain Azure-related certifications, such as the Microsoft Certified: Azure Data Fundamentals certification. This can help improve credibility and increase job opportunities in the IT sector.

Why OEM Office Elearning Menu?

OEM Office Elearning Menu has years of experience in providing online courses and training. From Excel, Word and Outlook to high professional ICT training for Cisco, AWS, CompTIA and more. 

OEM is an official Microsoft Partner, CertiPort Partner and EC-Council Partner. With over 1000 courses from more than 200 brands, our offer is suitable for every PC user. Whether you are a first time PC user starting up Word for the first time, or an ICT professional wanting to know more about Data Security; OEM has the right course or training for you. Missing a training? Let us know and we will gladly look at the options together.

Each completed course provides you with an official certificate of participation. This is personal and specifically addressed to the student. Every Incompany training course automatically delivers a certificate of participation. For each E-learning course you need to have completed at least 70% of the practical assignments to receive a certificate of participation.

OEM - Learn to Work

Choose from 1000+ training courses from 200+ brands for your personal and business development. 

An Excel course, Word course or even a full Office course always comes in handy. We deal with Microsoft programs on a daily basis and it will save you a lot of time to master them properly.

We also have training courses for ICT professionals at OEM Office Elearning Menu. For example, you will learn to deal with databases, servers, learn programming or even become a certified ethical hacker. Learn everything online through E-learning, through course books, walk-in trainings or through Incompany trainings within the company you work for.