Course: Azure Data Fundamentals (Exam: DP-900)

As low as

$0.00

$0.00 incl. vat

Online Training

1 x Course: Azure Data Fundamentals (Exam: DP-900) +

$0.00

$0.00 incl. vat

Proefexamen

1 x Practice exam Microsoft Azure Data Fundamentals (Exam: DP-900) +

$0.00

$0.00 incl. vat

$0.00

$0.00 incl. vat

duration: 25 hours |

Language: English (US) |

access duration: 180 days |

Details

In this training you will develop fundamental skills to build

database concepts in a cloud environment within Microsoft Azure.

You will work with core data concepts, such as relational,

non-relational and identifying and describing big data.

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.

Topics that are covered:

Core concepts of data analysis.
Business intelligence using Azure Data Explorer (cloud platform for big data analytics).
Setting up a Microsoft Azure SQL database for PostgreSQL, MySQL and MariaDB.
Recognize and apply data using SQL, Data Definition Language and Data Manipulation Language.
Cosmos DB, a fully managed NoSQL database for modern app development.
Data processing options, for example Azure HDInsight, Azure Databricks, Azure Synapse Analytics, Azure Data Factory.
Using Microsoft Power BI to optimize data, load datasets and create dashboards.

This Azure Data Fundamentals training can be used to prepare you for other Role-Based Azure certifications, such as Azure Database Administrator Associate or Azure Data Engineer Associate.

Result

After completing this training you will be familiar with:

core data concepts.
work with relational data on Azure.
work with non-relational data on Azure.
transactional and analytics workloads on Azure.

This training prepares you for the Azure Data Fundamentals DP-900 exam. When you pass the exam you are Microsoft Certified: Azure Data Fundamentals.

Prerequisites

You have a basic knowledge of cloud data services within Microsoft Azure.

Target audience

Data analist

Content

Azure Data Fundamentals (Exam: DP-900)

25 hours

DP-900 Azure Data Fundamentals: Data Workloads

Data workloads refer to the system's ability to handle and
process work. In this course, you'll learn about core data
workloads and workload management, including the need for data
solutions and the various types of data storage. You’ll then
explore transactional and analytical workloads, Azure Batch, and
real time processing. Finally, you’ll learn about the differences
between batch data and streaming data and the fundamentals of
relational data. This course is one in a collection that prepares
learners for Microsoft Azure Data Fundamentals (DP-900) exam.

DP-900 Azure Data Fundamentals: Data Analytics

Data analytics enables you to extract valuable insights from
data and uncover patterns. In this course, you'll learn about data
analytics core concepts. You'll examine data visualization,
including business intelligence and reporting using Azure Data
Explorer, a fully-managed big data analytics cloud platform. You'll
then learn about SQL Server Reporting Services, data chart types,
and different analytic techniques. You'll explore stream analytics
and the associated data types. Finally, you'll learn to use
extract, load, and transform data processing and also extract,
transform, and load data processing. This course is one of a series
that prepares you for the Microsoft Azure Data Fundamentals
(DP-900) exam.

DP-900: Azure Data Fundamentals: Relational Data Workloads

Relational data is stored in tables, which allows users to
easily categorize and query the data. In this course, you'll learn
about the characteristics of relational data and different
relational databases. You'll explore how to use indexes and views
in a relational database, as well as the different delivery models
for relational data. Next, you'll examine Platform as a Service,
Infrastructure as a Service, and Software as a Service. Finally,
you'll learn about online transaction and analytical processing.
This course is one in a series that prepares learners for the
Microsoft Azure Data Fundamentals (DP-900) exam.

DP-900 Azure Data Fundamentals: Relational Data Management

Relational data management ensures cloud database systems are
versatile and functionable. In this course, you'll explore how to
work with relational data on Azure, including basic management
tasks for relational data such as SQL database and the security
features within. You'll then learn about Azure Data Studio, Azure
SQL Server Management Studio, SQL Server, and the sqlcmd utility.
Finally, you'll learn about SQL Managed Instance, Azure Synapse
Analytics, as well as different connectivity issues such as
authentication or firewall. This course is one in a series that
prepares learners for the Microsoft Azure Data Fundamentals
(DP-900) exam.

Azure Data Fundamentals: Provisioning & Configuring Relational Data Services

Azure database services are fully managed, which frees up
valuable time otherwise spent on managing them. In this course,
you'll learn how to provision relational data services and a
Microsoft Azure SQL Database. You’ll explore how to provision a
Microsoft Azure SQL Database for PostgreSQL, MySQL, and MariaDB.
Next, you'll discover how to configure a Microsoft Azure SQL
Database. Finally, you’ll learn how to configure Azure Database for
PostgreSQL, MySQL, and MariaDB. This course is one in a series that
prepares learners for the Microsoft Azure Data Fundamentals
(DP-900) exam.

DP-900 Azure Data Fundamentals: Azure SQL Querying Techniques

Azure SQL is used for extracting and organizing data that is
stored in a relational database. In this course, you'll learn how
to recognize and apply data querying techniques using SQL, Data
Definition Language, and Data Manipulation Language. You’ll start
by learning about Structured Query Language including its uses,
features, and limitations. You’ll examine how to work with the Data
Definition Language and Data Manipulation Language. Next, you'll
learn how to query Azure SQL Database using the Azure portal, SSMS,
Data Studio, and the sqlcmd utility. Finally, you'll discover how
to query relational data in PostgreSQL, MySQL, and MariaDB. This
course is one in a series that prepares learners for the Microsoft
Azure Data Fundamentals (DP-900) exam.

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

Non-relational databases use a storage model that is optimized
for the data being stored. In this course, you'll learn about
characteristics of non-relational data, including the different
types of non-relational data. You'll learn when to use
non-relational versus relational data. Next, you'll explore the use
of CSV and JSON files for non-relational data and the requirements
of non-relational data stores. You’ll examine free-form text for
search, including architecture and challenges. Finally, you'll
learn about time series solutions, including their benefits and
challenges. This course is one in a series that prepares learners
for the Microsoft Azure Data Fundamentals (DP-900) exam.

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

Non-relational data repositories can store data in its original
format and allow fast storage and retrieval access. In this course,
you'll learn about the non-relational data services, including
Azure Table Storage, Azure Blob Storage, and Azure File Storage.
You'll also learn how to provision and configure non-relational
data services and manage Azure Blob Storage and Azure File Storage.
This course is one in a series that prepares learners for the
Microsoft Azure Data Fundamentals (DP-900) exam.

DP-900 Azure Data Fundamentals: Azure Cosmos DB

Cosmos DB is a fully managed NoSQL database for modern app
development. In this course, you'll learn about non-relational data
offerings on Azure, including Cosmos DB and the different entities
in the resource model. You'll learn how to provision and configure
Cosmos DB and query data. Next, you'll explore the various Cosmos
DB APIs and learn how to use Core (SQL) API for Cosmos DB. Finally,
you'll examine how to use the Cosmos DB API, as well as how to use
the Cassandra, Azure Table, and Gremlin APIs in Cosmos DB. This
course is one in a series that prepares learners for Microsoft
Azure Data Fundamentals (DP-900) exam.

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

Non-relational data does not use SQL for queries and instead it
uses other programming languages and constructs to query the data.
This course covers basic management tasks for non-relational data,
including how to deploy data using the Azure portal, Azure Resource
Manager Templates, Azure PowerShell, and the Azure CLI. You'll
learn about Cosmos DB firewall, authentication, and other security
components. Finally, you'll explore Azure Cosmos DB Explorer and
Geo-replication, as well as various issues that may arise with
access control, .NET SDKs, and Java SDKs. This course is one in a
series that prepares learners for the Microsoft Azure Data
Fundamentals (DP-900) exam.

Azure Data Fundamentals: Azure Analytics Workloads

Azure Synapse Analytics is a limitless analytics service that
brings together data warehousing and big data analytics. In this
course, you will learn about analytics workloads, including Azure
Synapse Analytics, Azure Synapse SQL pool, Data Warehouse Units.
You'll also learn about the difference between transactional and
analytic workloads and batch and real time data processing. You'll
use Azure Portal and Azure PowerShell to create a Synapse SQL pool
and Azure Data Lake Analytics. You'll learn about data warehousing
workloads and when to use a data warehouse solution. Finally,
you'll learn about the different Azure Data Lake Analytics. This
course is one in a series that prepares learners for the Microsoft
Azure Data Fundamentals (DP-900) exam.

DP-900 Azure Data Fundamentals: Modern Data Warehousing

Modern data warehousing lets you bring your data together at any
scale and provide insights through analytics. This course, you’ll
learn about the components of a modern data warehouse and its
architecture and how it can benefit your organization. You’ll start
by learning about modern data warehousing, and then the data
warehousing architecture. You'll then learn about Azure Data
Factory, Azure Data Lake, and Azure Databricks. You’ll then go on
to explore Azure Analysis Services and Azure HDInsights. Finally,
you'll discover Azure Distributed Data Engineering Toolkit. This
course is one in a series that prepares learners for the Microsoft
Azure Data Fundamentals (DP-900) exam.

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

Data ingestion and processing allows your data to be assessed,
used, and analyzed. In this course, you’ll learn about Azure data
ingestion and processing, including loading strategies for Synapse
SQL Pools. You'll examine Azure data factory pipelines and
activities, as well as how to create an Azure data factory. Next,
you'll learn how to use the data factory copy data tool to copy
data. Finally, you'll explore how to use SQL Server Integration
Services, Azure Databricks, Azure Synapse Analytics, and Azure Data
Lake to ingest data. This course is one in a series that prepares
learners for the Microsoft Azure Data Fundamentals (DP-900)
exam.

DP-900 Azure Data Fundamentals: Azure Data Visualization

Power BI allows you to visualize your data and gain deeper
insight by creating interactive and immersive dashboards and
reports. In this course, you'll learn how to use Microsoft Power BI
to optimize data, load datasets, and create dashboards. Next,
you'll explore how to use Power BI for paginated and interactive
reports, as well as for publishing reports. You'll also examine how
to use the different types of Power BI visualizations. Finally,
you'll learn about workflows and Power BI security and
administration. This course is one in a series that prepares
learners for the Microsoft Azure Data Fundamentals (DP-900)
exam.

Course options

We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.

Optional practice exam (trial exam)

To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam.

Optional practice lab

To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediately. The lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience.

WHY_ICTTRAININGEN

Via ons opleidingsconcept bespaar je tot 80% op trainingen

Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo

Spar met medecursisten en profileer je als autoriteit in je vakgebied.

Ontvang na succesvolle afronding van je cursus het officiële certificaat van deelname van Icttrainingen.nl

Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers

Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten

Orderproces

Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.

What is included?

Certificate of participation	Yes
Monitor Progress	Yes
Award Winning E-learning	Yes
Mobile ready	Yes
Sharing knowledge	Unlimited access to our IT professionals community
Study advice	Our consultants are here for you to advice about your study career and options
Study materials	Certified teachers with in depth knowledge about the subject.
Service	World's best service

Platform

Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.

FAQ

Niet gevonden wat je zocht? Bekijk alle vragen of neem contact op.

Cursusnaam
Looptijd
Rentebedrag financiering
Totaal bedrag
Maandbedrag

Vendors

Professions