Principals

Overview

In this DP-900T00 course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. 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.

img-course-overview.jpg

What You'll Learn

  • Identify common data formats
  • Describe options for storing data in files
  • Describe options for storing data in databases
  • Describe characteristics of transactional data processing solutions
  • Describe characteristics of analytical data processing solutions
  • Identify common data professional roles
  • Identify common cloud services used by data professionals
  • Identify characteristics of relational data
  • Define normalization
  • Identify types of SQL statement
  • Identify common relational database objects
  • Identify options for Azure SQL services
  • Identify options for open-source databases in Azure
  • Provision a database service on Azure
  • Describe features and capabilities of Azure blob storage
  • Describe features and capabilities of Azure Data Lake Gen2
  • Describe features and capabilities of Azure file storage
  • Describe features and capabilities of Azure table storage
  • Provision and use an Azure Storage account
  • Describe key features and capabilities of Azure Cosmos DB
  • Identify the APIs supported in Azure Cosmos DB
  • Provision and use an Azure Cosmos DB instance
  • Identify common elements of a data analytics solution
  • Describe key features for data ingestion pipelines
  • Identify common types of analytical data store and related Azure services
  • Describe platform-as-a-service (PaaS) data analytics solutions in Azure
  • Provision Azure Synapse Analytics and use it to ingest, process, and query data
  • Describe features of Microsoft Fabric - a software-as-a-service (SaaS) solution for data analytics
  • Use Microsoft Fabric to ingest and analyze data
  • Compare batch and stream processing
  • Describe common elements of streaming data solutions
  • Describe features and capabilities of Azure Stream Analytics
  • Describe features and capabilities of Spark Structured Streaming on Azure
  • Describe features and capabilities of Azure Synapse Data Explorer
  • Describe a high-level process for creating reporting solutions with Microsoft Power BI
  • Describe core principles of analytical data modeling
  • Identify common types of data visualization and their uses
  • Create an interactive report with Power BI Desktop

Who Should Attend

The audience for DP-900T00 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.

img-who-should-learn.png

Prerequisites

Please review the prerequisites listed for each module in the course content and click on the provided links for more information.

Learning Journey

Coming Soon...

1. Explore core data concepts

Data powers the digital transformation that is sweeping across organizations and society in general. But what is "data", and how is it represented and used?

Click here to know more

2. Explore data roles and services

Data professionals perform distinct roles in building and managing software solutions, and work with multiple technologies and services to do so.

Click here to know more

3. Explore fundamental relational data concepts

Relational database systems are a common way to store and manage transactional and analytical data in organizations of any size around the world.

Click here to know more

4. Explore relational database services in Azure

Microsoft Azure provides multiple services for relational databases. You can choose the relational database management system that's best for your needs, and host relational data in the cloud.

Click here to know more

5. Explore Azure Storage for non-relational data

Azure Storage is a core service in Microsoft Azure that is commonly used to store non-relational data.

Click here to know more

6. Explore fundamentals of Azure Cosmos DB

Azure Cosmos DB provides a highly scalable store for non-relational data.

Click here to know more

7. Explore fundamentals of large-scale analytics

Organizations use analytics platforms to build large scale data analytics solutions that generate insights and drive success. Microsoft provides multiple technologies that you can combine to build a large scale data analytics solution.

Click here to know more

8. Explore fundamentals of real-time analytics

Learn about the basics of stream processing, and the services in Microsoft Azure that you can use to implement real-time analytics solutions.

Click here to know more

9. Explore fundamentals of data visualization

Learn the fundamental principles of analytical data modeling and data visualization, using Microsoft Power BI as a platform to explore these principles in action.

Click here to know more

Instructors

Scott Duffy

Bestselling Azure & TOGAF® Trainer, Microsoft Azure MVP

4.8 (4.1k)
|
10 Courses
profile-instructor-a.png
Scott Duffy

Bestselling Azure & TOGAF® Trainer, Microsoft Azure MVP

4.8 (4.1k)
|
10 Courses
profile-instructor-a.png

Skills measured

  • 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

Frequently Asked Questions (FAQs)

  • Why get Microsoft certified?

    Microsoft certifications validate your skills and expertise in Microsoft technologies and solutions, demonstrating your ability to design, implement, and manage cutting-edge technologies.

    These certifications are globally recognized and highly sought after by employers, as they signify your proficiency in using Microsoft products and services to drive innovation and solve business challenges.

    Microsoft-certified professionals are in high demand, opening doors to new career opportunities and higher earning potential.

  • What to expect for the examination?

    Microsoft certification exams are designed to assess your knowledge and skills in specific Microsoft technologies and solutions.

    Exams typically consist of multiple-choice, multiple-select, and case study questions, and some may include lab simulations to evaluate your practical skills.

    Note: Certification requirements and policies may be updated by Microsoft from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.

  • How long is Microsoft certification valid for?

    Most Microsoft role-based and specialty certifications are valid for one year from the date of passing the exam.

    To maintain your certification, you will need to renew it annually by passing a free online assessment on Microsoft Learn.

    However, Microsoft Applied Skills credentials and Fundamentals certifications do not expire.

    Note: Certification requirements and policies may be updated by Microsoft from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.

  • Why take this course with Trainocate?

    Here’s what sets us apart:

    - Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 16 countries (and counting!).

    - Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.

    - Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.

    - Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.

    - Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.

    - Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

Frequently Asked Questions

img-improve-career.jpg

Improve yourself and your career by taking this course.

img-get-info.jpg

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name
Email
Phone
I'm inquiring for
Inquiry Details

By providing your contact details, you agree to our Privacy Policy.