icon
logo
    Loading...

    DP-900: Microsoft Azure Data Fundamentals

    Minimum cohort size: 10 learners
    Book a free consultation to enroll & feel free to bring a friend along!

    Overview

    icon

    Minimum cohort size: 10 learners
    Book a free consultation to enroll & feel free to bring a friend along!

    course-icon

    Course

    org-logo

    DP-900: Microsoft Azure Data Fundamentals

    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.

    Benefit from instructor-led preparation for the DP-900 certification exam with tips, tricks, guidance, and mentored support.

    Online Live Classes

    Beginner Level

    Mentor Support

    flag-icon

    Starts on

    When 10 learners enroll

    time-icon

    Estimated Time

    1 day, online
    8 hours/day
    fee-icon

    Fee

    $555

    Minimum cohort size: 10 learners
    Book a free consultation to enroll & feel free to bring a friend along!

    DP-900: Azure Data Fundamentals is a one-day course designed specifically for individuals who are new to database and cloud data services using Microsoft Azure. This course is suitable for people who are looking to switch their career into the field of database and data in the cloud or cloud computing. DP-900 training provides foundational-level knowledge on database including relational and non-relational databases, modern data warehouse, big data, and analytics in Azure.

    You will learn about the database fundamentals of a cloud environment, cloud data services basics, and cloud data services within Azure. You will be introduced to important data concepts, including relational, nonrelational, big data, and analytics, and you will be given insights on how these are implemented with Azure. You will be introduced to its applicability so that you can deploy a relational database and a nonrelational data store. Plus, you will explore various processing methods for data analytics in Azure, Azure Synapse Analytics, Azure HDInsight, and Power BI including its building blocks and how the blocks work.

    Overall, this course will prepare you for taking the DP-900 Azure Data Fundamentals certification exam. It will give you the base you need for higher-level role-based certifications including Data Analyst Associate, Azure Data Engineer Associate, or Azure Database Administrator Associate. Entry to the exam is not included. However, you will get a clear overview of the Microsoft certification process, plus you will get lessons and useful information.

    This course comprises 9 purposely designed modules that take you on a carefully defined learning journey.

    It is an instructor-led course which runs to a fixed schedule, with set start and finish dates. It is driven forward by your instructor and features live sessions that are aired at a set time. You will, however, have time to complete certain activities at your own pace outside of the live sessions.

    The materials for each module are accessible from the start of the course and will remain available for the duration of your enrollment. Methods of learning and assessment will include reading material, hands-on labs and online exam questions.

    As part of our mentoring service you will have access to valuable guidance and support throughout the course. We provide a dedicated discussion space where you can ask questions, chat with your peers, and resolve issues.

    Once you have successfully completed the course, you will earn your Certificate of Completion.

    You will be able to:

    • Describe core data concepts
    • Identify considerations for relational data on Azure
    • Describe considerations for working with non-relational data on Azure
    • Describe an analytics workload on Azure

    • Individuals who want to prepare for the Microsoft DP-900 certification exam.
    • Individuals who want to learn the fundamentals of database concepts in a cloud environment, and cloud data services within Microsoft Azure.
    • Aspiring Data Analysts and Data Engineers.
    • Business Intelligence professionals.
    • Professionals working as Data analysts and cloud computing engineers.

    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.

    Specifically:

    • 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.
    • A willingness to learn through hands-on exploration.

    This course will help you to prepare for the DP-900: Microsoft Azure Data Fundamentals certification exam.

    It is ideal for 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.

    • You will learn to identify and describe core data concepts such as relational, non-relational, big data, and analytics.
    • You will explore how this technology is implemented with Microsoft Azure.
    • You will explore relational data offerings, provisioning and deploying relational databases, and querying relational data.
    • You will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure.
    • You will explore the processing options available for building data analytics solutions in Azure, Azure Synapse Analytics, Azure Databricks, and Azure HDInsight.
    • You will learn what Power BI is, including its building blocks and how they work together.

    When you take this course, you will also get information and guidance on the Microsoft certification process, knowledge checks and practice questions, and useful tips on how to pass the exam.

    Course Outline

    Introduction
    Grading Scheme
    Pre-Requisite
    Exam and Certification Details

    null

    Identify data formats
    Explore file storage
    Explore databases
    Explore transactional data processing
    Explore analytical data processing

    null

    null

    Explore job roles in the world of data
    Identify data services

    null

    null

    Understand relational data
    Understand normalization
    Explore SQL
    Describe database objects

    null

    null

    Describe Azure SQL services and capabilities
    Describe Azure services for open-source databases
    Exercise: Explore Azure relational database services

    null

    null

    Explore Azure blob storage
    Explore Azure DataLake Storage Gen2
    Explore Azure Files
    Explore Azure Tables
    Exercise: Explore Azure Storage

    null

    null

    Describe Azure Cosmos DB
    Identify Azure Cosmos DB APIs
    Exercise: Explore Azure Cosmos DB

    null

    null

    Describe data warehousing architecture
    Explore data ingestion pipelines
    Explore analytical data stores
    Exercise: Explore data analytics in Azure with Azure Synapse Analytics

    null

    null

    Understand batch and stream processing
    Explore common elements of stream processing architecture
    Explore Azure Stream Analytics
    Exercise: Explore Azure Stream Analytics
    Explore Apache Spark on Microsoft Azure
    Exercise: Explore Spark Streaming in Azure Synapse Analytics
    Explore Azure Data Explorer
    Exercise: Explore Azure Synapse Data Explorer

    null

    null

    Describe Power BI tools and workflow
    Describe core concepts of data modeling
    Describe considerations for data visualization
    Exercise – Explore fundamentals of data visualization with Power BI

    null

    Instructions

    All Labs

    null

    null

    Why Learn with SkillUp Online?

    We believe every learner is an individual and every course is an opportunity to build job-ready skills. Through our human-centered approach to learning, we will empower you to fulfil your professional and personal goals and enjoy career success.

    tick

    Reskilling into tech? We’ll support you.

    tick

    Upskilling for promotion? We’ll help you.

    tick

    Cross-skilling for your career? We’ll guide you.

    icon

    Personalized Mentoring & Support

    1-on-1 mentoring, live classes, webinars, weekly feedback, peer discussion, and much more.

    icon

    Practical Experience

    Hands-on labs and projects tackling real-world challenges. Great for your resumé and LinkedIn profile.

    icon

    Best-in-Class Course Content

    Designed by the industry for the industry so you can build job-ready skills.

    icon

    Job-Ready Skills Focus

    Competency building and global certifications employers are actively looking for.

    FAQs

    DP-900: Microsoft Azure Data Fundamentals provides learners with an understanding of core data concepts and their implementation using Microsoft Azure data services. This course is designed for individuals who are seeking to work with data in the cloud. During the course, learners explore databases, the cloud environment, cloud data services, and apply their knowledge of cloud data services in Microsoft Azure. This course helpful in preparing learners for other Azure role-based certifications. Please note that though Microsoft Azure DP-900 certification will be useful for preparing for these role-based certifications, DP-900 certification is not a prerequisite for any of them.

    Yes. Learners seeking to take this course should be able to work with relational and non-relational data on Azure. Experience with different kinds of data workloads, such as transactional or analytical, will be an advantage.

    After taking this DP-900 course and passing the DP-900 exam, you will earn your Microsoft certification. With this, you will be able to work with data on the cloud and provide AI solutions on Azure. You will also understand Azure Machine Learning services and the databases supported by Azure.

    You can take the following steps to become Microsoft certified in DP-900:

    Step 1: Complete the recommended training for DP-900 with SkillUp Online, a Microsoft authorized training partner.

    Step 2: After completing the training, visit Microsoft's official website. Register for the DP-900 Microsoft Azure Data Fundamentals exam, and schedule it with Pearson VUE.

    Step 3: Take the exam, pass it, and earn your DP-900 certificate.

    Yes, absolutely. There are no restrictions, if you have the basic background experience, are willing to learn, and have an interest in the subject. The DP-900 Microsoft Azure Data Fundamentals exam is an entry-level exam for graduates or people looking to change the direction of their career to the cloud.

    DP-900 : Microsoft Azure Data Fundamentals Certification Course
    certificate

    Type of certificate

    Certificate of completion

    course

    About this course

    09 Modules

    01 Skill

    includes

    Includes

    Discussion space

    04 Labs

    09 Knowledge checks

    02 Practice exams

    03 Projects

    create

    Create

    Virtual machine

    Relational and non-relational databases

    Data visualization

    Azure Synapse Analytics workspace

    exercises

    Exercises to explore

    Use SQL to query Azure SQL Database

    Provision Azure relational database services

    Provision non-relational Azure data services

    Upload, download, and query data in a non-relational data store

    Create an Azure Synapse Analytics workspace and analyze data

    Tour and use the Power BI service

    You’ll learn with these experts

    profile-image

    Microsoft

    This course is led by experienced Microsoft Certified Trainers (MCTs).

    Newsletters & Updates

    Subscribe to get the latest tech career trends, guidance, and tips in your inbox.