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: 15:12 (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

Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about large-scale data warehousing, real-time analytics, and data visualization.

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:
• Explore core data concepts
• Explore data roles and services
• Explore fundamental relational data concepts
• Explore relational database services in Azure
• Explore Azure Storage for non-relational data
• Explore fundamentals of Azure Cosmos DB
• Explore fundamentals of large-scale data analytics
• Explore fundamentals of real-time analytics
• Explore fundamentals of data visualization

Who should attend:

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.

CertKit content

DP-900 - Azure Data Fundamentals: Structured Data

Course: 42 Minutes

• Course Overview
• Data Classification
• Structured Data
• Structured Data Use Cases
• Structured Data Formats
• Processing Azure XML Files
• Storing, Querying, and Indexing JSON Data in SQL Server
• Course Summary

DP-900 - Azure Data Fundamentals: Semi-Structured & Unstructured Data

Course: 44 Minutes

• Course Overview
• Semi-Structured Data
• Semi-Structured Data Use Cases
• Indexing Nested JSON Blobs in Azure
• Unstructured Data
• Unstructured Data Use Cases
• Storing Unstructured Data
• Using Azure Blob Storage with Unstructured Data
• Course Summary

DP-900 - Azure Data Fundamentals: Azure Data Storage

Course: 1 Hour

• Course Overview
• Azure Data Storage
• Data Store Models
• Using Azure Table Storage
• Utilizing Azure Queue Storage
• Exploring Blob Storage
• Creating Azure SMB File Shares
• Building an Azure SQL Database
• Making an Azure Synapse Data Explorer Pool
• Azure IoT Hub5
• Course Summary

DP-900 - Azure Data Fundamentals: Data Storage Considerations

Course: 38 Minutes

• Course Overview
• Data Store
• Data Store Selection
• Big Data Storage
• NoSQL Database Storage
• Database Scenarios
• Data Pipeline Orchestration
• Data Transfer Options
• Course Summary

DP-900 - Azure Data Fundamentals: Azure Analysis Services

Course: 42 Minutes

• Course Overview
• Azure Analysis Services
• Using Azure Analysis Services
• Azure Analysis Services Model Addition
• Azure Analysis Services Role Configuration
• Workload Roles
• Online Analytical Processing (OLAP)
• Online Analytical Processing (OLAP) Use Cases
• Azure Online Analytical Processing (OLAP)
• Course Summary

DP-900 - Azure Data Fundamentals: Analytical Workloads

Course: 47 Minutes

• Course Overview
• Power BI Desktop Connection
• SQL Server with Columnstore Indexes
• SQL Server Analysis Services (SSAS)
• SQL Server Analysis Services (SSAS) Installation
• Data Analytics Workloads
• Azure Stream Analytics
• Creating Stream Analytics Jobs
• Course Summary

DP-900 - Azure Data Fundamentals: Online Transaction Processing (OLTP)

Course: 36 Minutes

• Course Overview
• Online Transaction Processing (OLTP)
• Online Transaction Processing (OLTP) Best Practices
• Online Transaction Processing (OLTP) Use Cases5
• In-Memory OLTP
• In-Memory OLTP Scenarios
• Memory-Optimized Tables
• Course Summary

DP-900 - Azure Data Fundamentals: Relational & Non-Relational Databases

Course: 1 Hour, 29 Minutes

• Course Overview
• Relational vs. Non-Relational Databases
• Relational Databases
• Popular Relational Databases
• Relational Databases Benefits
• Relational Databases Use Cases
• Data Normalization
• Normal Forms
• Database Query Languages
• Data Partitioning Strategies
• Non-Relational Databases
• Non-Relational Data Types
• Azure Non-Relational Databases
• NoSQL Database Selection
• Course Summary

DP-900 - Azure Data Fundamentals: Azure Database for MySQL & PostgreSQL

Course: 44 Minutes

• Course Overview
• Azure Database for MySQL
• Creating MySQL Flexible Servers
• Setting Up MySQL Server for Azure Database Management
• Azure Database for MySQL Options
• Creating a MySQL Server Using the Azure CLI
• Azure Database for PostgreSQL
• Creating ARM Templates for PostgreSQL Deployments
• Course Summary

DP-900 - Azure Data Fundamentals: Azure SQL Database

Course: 38 Minutes

• Course Overview
• Azure SQL Database
• Azure SQL Managed Instance
• Azure Database Services
• Creating an Azure Database
• Connecting to Azure Databases
• Configuring In-Memory OLTP in Azure SQL Database
• SQL Server on Azure VM
• Course Summary

DP-900 - Azure Data Fundamentals: SQL Server on Azure VM

Course: 1 Hour, 13 Minutes

• Course Overview
• SQL Server on Azure VM
• Creating an Azure SQL Managed Instance Creation
• Using Azure SQL Managed Instance Restoration
• SQL Server on Azure Virtual Machines
• Hosting SQL Server on an Azure VM
• Connecting to SQL Server on Azure VMs
• SQL Server IaaS Extension
• Managing a SQL Server VM
• SQL Server VM Performance Best Practices
• Assessing SQL Server VM Configuration
• Migrating IBM DbB2 to SQL Server on an Azure VM
• Course Summary

DP-900 - Azure Data Fundamentals: Azure Blob Storage

Course: 1 Hour, 13 Minutes

• Course Overview
• Azure Storage
• Azure Blob Storage
• Azure Blob Storage Best Practices
• Azure Blob Storage Security
• Creating an Azure Blob Storage Account
• Azure Blob Storage Accounts
• Configuring an Azure Blob Storage Account
• Azure Blob Data Protection
• Azure Blob Storage Cost Management
• Azure Blob Storage Monitoring
• Monitoring Azure Storage
• Course Summary

DP-900 - Azure Data Fundamentals: Azure Data Lake Storage

Course: 45 Minutes

• Course Overview
• Data Lake Storage
• Data Lake Storage Best Practices
• Data Lake Storage Architecture
• Data Lake Storage Access Control
• Data Lake Storage Access Control Lists (ACLs)
• Managing Data Lake Storage Access Control Lists
• Using the CLI to Manage Data Lake Storage
• Course Summary

DP-900 - Azure Data Fundamentals: Azure File Shares

Course: 1 Hour, 16 Minutes

• Course Overview
• Mounting an SMB File Share
• Mounting an NFS File Share
• SMB Azure File Share Migration
• NFS Azure File Share Migration
• Azure File Share Authentication
• Azure File Share Authorization
• Azure File Share Data Protection
• Setting Up Azure File Share Backups
• Managing Azure File Share Restoration and Backups
• Azure File Share Redundancy
• Azure File Share Performance
• Course Summary

DP-900 - Azure Data Fundamentals: Azure File Storage

Course: 48 Minutes

• Course Overview
• Azure File Storage
• Azure Files Planning
• Server Message Block (SMB) Azure File Shares
• Network File System (NFS) Azure File Shares
• Azure Files Architecture Best Practices
• Creating SMB Azure File
• Creating NFS Azure File Shares
• Monitoring Azure Files and Analyze Metrics
• Creating Azure Files Alerts
• Course Summary

DP-900 - Azure Data Fundamentals: Azure Table Storage

Course: 1 Hour, 5 Minutes

• Course Overview
• Azure Table Storage Key Concepts
• Azure Table Storage Partitioning Strategy
• Azure Table Storage Performance & Scalability
• Azure Table Storage Design Patterns8
• Azure Table Storage Best Practices
• Azure Table Storage Creation
• Azure Storage Account Creation
• Azure Storage Account Update
• Azure Storage Account Recovery
• Migrate Classic Accounts to Azure's Models
• Azure Storage Account Configuration Properties
• Manage Account Keys for Access to Azure Storage Accounts
• Course Summary

DP-900 - Azure Data Fundamentals: Azure Cosmos DB

Course: 52 Minutes

• Course Overview
• Azure Cosmos DB Key Concepts
• Azure Cosmos DB APIs
• Using APIs to Create NoSQL Databases
• Azure Cosmos Use Cases
• Vector Databases in Azure
• Azure Cosmos for NoSQL
• Azure Cosmos for NoSQL Backup & Restoration
• Creating NoSQL Databases in Azure Cosmos DB
• Course Summary

MeasureUp Exam Simulation

Hone your testing skills with MeasureUp Exam Simulation, an advanced tool that gives you a realistic exam experience. Practice with accurately modelled questions that mimic actual exams, allowing you to get used to the structure and pressure. With MeasureUp, you not only prepare for your exam, you also increase your chances of success.

• 110+ questions

Online mentor

The online mentor can answer all your specific technical questions via chat or email related to your studies.
Online Mentor is active for 90 days or 365 days - after activation!

Tips, Tricks & Links

Take advantage of our comprehensive collection of tips, tricks and links designed specifically to support your preparation for certification exams. These resources offer valuable insights and proven strategies to make your studies more effective. Enhance your learning experience and approach your exams with confidence!

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.