Training: Azure Data Fundamentals (Exam: DP-900)
SQL Azure
25 uur
Engels (US)

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

Vanaf € 361,79 € 299,00

Vanaf € 361,79 € 299,00

Extra opties

1 x Training: Azure Data Fundamentals (Exam: DP-900)   + € 361,79 € 299,00
€ 299,00
Incl. BTW

Snel navigeren naar:

  • Informatie
  • Inhoud
  • Kenmerken
  • Meer informatie
  • Reviews
  • FAQ

Productinformatie

Met deze training ontwikkel je fundamentele vaardigheden om aan databaseconcepten in een cloudomgeving te kunnen bouwen binnen Microsoft Azure. Je gaat aan de slag met basis dataconcepten, zoals relationeel, niet-relationeel en het identificeren en beschrijven van big data.

Deze training is geschikt voor iedereen die wil leren over de grondbeginselen van databaseconcepten in een cloudomgeving. Basisvaardigheden in cloudgegevensservices willen opdoen en hun basiskennis van cloudgegevensservices binnen Microsoft Azure willen ontwikkelen.

Onderwerpen die aan bod komen:

  • Kernconcepten van data-analyse.
  • Business intelligence met behulp van Azure Data Explorer (cloudplatform voor big data-analyse).
  • Het inrichten van een Microsoft Azure SQL-database voor PostgreSQL, MySQL en MariaDB.
  • Data herkennen en toepassen met behulp van SQL, Data Definition Language en Data Manipulation Language.
  • Cosmos DB, een volledig beheerde NoSQL-database voor moderne app-ontwikkeling.
  • Data verwerkingsopties, bijvoorbeeld Azure HDInsight, Azure Databricks, Azure Synapse Analytics, Azure Data Factory.
  • Microsoft Power BI gebruiken om gegevens te optimaliseren, datasets te laden en dashboards te maken.

Deze Azure Data Fundamentals training kan worden gebruikt om jou voor te bereiden op andere Role-Based Azure-certificeringen, zoals Azure Database Administrator Associate of Azure Data Engineer Associate.

Inhoud van de training

Azure Data Fundamentals (Exam: DP-900)

25 uur

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.

Kenmerken

Engels (US)
25 uur
SQL Azure
180 dagen online toegang
HBO

Meer informatie

Extra product informatie 0
Doelgroep Data-analist
Voorkennis

Je hebt een basiskennis op het gebied van clouddatadiensten binnen Microsoft Azure.

resultaat

Na het afronden van deze training ben jij bekend met:

  • data concepten.
  • het werken met niet-relationele gegevens op Azure.
  • werken met relationele gegevens op Azure.
  • transactionele en Analyse-workloads op Azure.

Tevens bereidt deze training jou optimaal voor op het Azure Data Fundamentals DP-900 examen. Wanneer je slaag voor het examen ben jij Microsoft Certified: Azure Data Fundamentals.

Positieve reacties van cursisten

Ontwikkel je tot data analist

Service is echt heel goed. Snel, klantvriendelijk, weten waar ze over praten en denken met je mee met oplossingen. Daarnaast hebben ze ook een goed leerplatform om je studie te volgen en na elke module een korte toets om te zien hoeveel je ervan heb begrepen en je kan de status zien hoeveel tijd je hebt besteed aan je studie. Ik waardeer ze enorm en ik raad elke ICT'er aan om met hen in zee te gaan om je studie te volgen.

- Emilio Jones

Training: Introduction to SQL

Eén training geprobeerd en deze naar tevredenheid gevolgd. Een module werkte in eerste instantie niet, maar na contact opgenomen te hebben met klantenservice kreeg ik snel antwoord met een oplossing.

- Lars van der Spek

Training: Certified Ethical Hacker (CEHv12) - incl. examen

Eerste keer dat ik een online training heb gedaan en zou zo weer een training volgen via icttrainingen.nl

- Jerry Jialal

Training: Microsoft Managing Modern Desktops (exam MD-101)

Het resultaat van de groep is absoluut bevredigend. Ik ga in ieder geval geen ander meer bellen.

- Antoine Evertze, Sales Engineer bij Chubb

Training: PRINCE2® 6e editie Foundation- incl. examen

Als er wat is staan ze altijd voor me klaar. Ik word meteen geholpen als ik bel.

- E. Zeijlmans, P&O adviseur bij Parnassia Groep

Training: ITIL® 4 Foundation - incl. examen

Wij zijn gebaat bij mensen die bijblijven in hun vakgebied en continu getriggerd worden.

- W. van Uijthoven, IT manager bij gemeente Arnhem

Training: Excel 2013 Compleet

Ik heb al eens eerder een training gehad via icttrainingen.nl en dat was een erg leerzame, leuke ervaring. Nu heb ik via het werk een online cursus en deze lijkt tot nu toe ook erg leerzaam.

- Michelle Brierley

Hoe gaat het te werk?

1

Training bestellen

Nadat je de training hebt besteld krijg je bevestiging per e-mail.

2

Toegang leerplatform

In de e-mail staat een link waarmee je toegang krijgt tot ons leerplatform.

3

Direct beginnen

Je kunt direct van start. Studeer vanaf nu waar en wanneer jij wilt.

4

Training afronden

Rond de training succesvol af en ontvang van ons een certificaat!

Veelgestelde vragen

Veelgestelde vragen

Op welke manieren kan ik betalen?

Je kunt bij ons betalen met iDEAL, PayPal, Creditcard, Bancontact en op factuur. Betaal je op factuur, dan kun je met de training starten zodra de betaling binnen is.

Hoe lang heb ik toegang tot de training?

Dit verschilt per training, maar meestal 180 dagen. Je kunt dit vinden onder het kopje ‘Kenmerken’.

Waar kan ik terecht als ik vragen heb?

Je kunt onze Learning & Development collega’s tijdens kantoortijden altijd bereiken via support@icttrainingen.nl of telefonisch via 026-8402941.

Background Frame
Background Frame

Onbeperkt leren

Met ons Unlimited concept kun je onbeperkt gebruikmaken van de trainingen op de website voor een vast bedrag per maand.

Bekijk de voordelen

Heb je nog twijfels?

Of gewoon een vraag over de training? Blijf er vooral niet mee zitten. We helpen je graag verder. Daar zijn we voor!

Contactopties