DP-900 Microsoft Azure Data Fundamentals

Upcoming Schedules:

• 2nd September 2024 – Monday
• 23^rd September 2024 - Monday
• 14th October 2024 – Monday
• 28^th October 2024 - Monday
• 18th November 2024 – Monday
• 9th December 2024 – Monday
• 16^th December 2024 – Monday

Course Overview:

The "Microsoft Azure Data Fundamentals" course provides participants with foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services. This course is designed to help individuals understand the basics of database concepts in a cloud environment, data services on Azure, and essential data analytics tasks. It prepares participants for the DP-900 certification exam.

Target Audience:

This course is ideal for beginners, IT professionals, database administrators, data professionals, and anyone who wants to learn the fundamentals of data and how they are managed using Microsoft Azure.

Prerequisites:

There are no specific prerequisites for this course. However, a basic understanding of core data concepts and working knowledge of relational databases can be helpful.

What's Included :

• 1 day instructor-led training
• Official Study guide
• Labs (as required) for hands-on learning
• Certified Trainer delivering the class
• Case studies of implementations
• Hands-on projects & exercises 
• Q&A sessions and troubleshooting exercises

Module 1: Introduction to Core Data Concepts

• Understanding data types (structured, semi-structured, unstructured)
• Core data concepts: relational, non-relational, big data, and analytics
• Basic operations for relational and non-relational data

Module 2: Introduction to Azure Data Services

• Overview of Microsoft Azure
• Introduction to Azure data services and architecture
• Navigating the Azure portal and understanding Azure pricing

Module 3: Relational Data on Azure

• Fundamentals of relational data and databases
• Introduction to Azure SQL Database and Azure Database for MySQL, PostgreSQL
• Basic operations with Azure SQL Database
• Hands-on lab: Creating and querying a relational database in Azure

Module 4: Non-Relational Data on Azure

• Fundamentals of non-relational data
• Introduction to Azure Cosmos DB and its APIs (SQL, MongoDB, Cassandra, Gremlin, Table)
• Basic operations with Azure Cosmos DB
• Hands-on lab: Implementing a non-relational database solution with Azure Cosmos DB

Module 5: Data Analytics and Visualization

• Introduction to data analytics concepts
• Overview of Azure Synapse Analytics, Azure HDInsight, and Azure Databricks
• Introduction to Power BI for data visualization
• Hands-on lab: Creating data visualizations with Power BI

Module 6: Modern Data Warehousing

• Concepts of data warehousing and ETL processes
• Introduction to Azure Data Factory and data integration
• Using Azure Synapse Analytics for data warehousing
• Hands-on lab: Building a data warehouse solution with Azure Synapse Analytics

Module 7: Data Governance and Compliance

• Introduction to data governance concepts
• Understanding Azure Data Catalog and Azure Purview
• Data privacy and compliance considerations in Azure
• Hands-on lab: Implementing data governance with Azure Purview

This course outline provides a structured learning path for understanding and utilizing Azure data services, ensuring participants are well-prepared for the DP-900 certification exam.