DP-900 Azure Data Fundamentals hands on cour…

We really hope you'll agree, this training is way more than the average course on Udemy.

Have access to the following:

Training from an instructor of over 25 years who has trained thousands of people and also a Microsoft Certified Trainer
Lecture that explains the concepts in an easy to learn method for someone that is just starting out with this material
Instructor led hands on and simulations to practice that can be followed even if you have little to no experience

TOPICS COVERED INCLUDING HANDS ON LECTURE AND PRACTICE TUTORIALS:

Introduction

Welcome to the course
Understanding the Microsoft Environment
Having a Solid Foundation of Active Directory Domains
Having a Solid Foundation of RAS, DMZ, and Virtualization
Having a Solid Foundation of the Microsoft Cloud Services
Order of concepts covered in the course

Setting up for hands on

IMPORTANT Using Assignments in the course
Creating a free Azure Account
Activating Entra ID P2 license

Describe ways to represent data

Features of structured data
Features of semi-structured
Features of unstructured data

Identify options for data storage

Understanding formats for data files
Relational databases as a type of data storage
Creating a relational database in Azure using Microsoft SQL
Installing SQL Server Management Studio (SSMS) for connecting to SQL
Connecting to a SQL database with SSMS
Non-relational databases as a type of data storage
Creating a non-relational database in Azure using Microsoft Cosmos
Connecting to a Microsoft Cosmos database

Describe common data workloads

Features of transactional workloads
Features of analytical workloads

Identify roles and responsibilities for data workloads

Responsibilities for database administrators
Permissions in Azure regarding a database administrator
Responsibilities for data engineers
Permissions in Azure regarding a data engineers
Responsibilities for data analysts
Permissions regarding a data analysts

Describe relational concepts

Features of relational data
Normalization and why it is used
Creating an Azure VM with Microsoft SQL server
Using common structured query language (SQL) statements
A look at common database objects

Describe relational Azure data services

Azure SQL Family: Azure SQL Database, SQL Managed Instance, SQL Server on VMs
Azure database services for open-source database systems

Describe capabilities of Azure storage

Understanding the capabilities of Azure storage accounts
Creating a storage account to explore Blob, File, & Table storage capabilities
Securing a Azure storage account
Utilizing Azure Blob storage
Utilizing Azure File storage
Utilizing Azure Table storage

Describe capabilities and features of Azure Cosmos DB

Use cases for Azure Cosmos DB
Understanding the Azure Cosmos DB APIs
Deleting the existing Cosmos DB before moving on
Creating a new Cosmos DB account for NoSQL
Adding and querying data within a Cosmos DB for NoSQL
Cleaning up our lab environment to this point

Describe common elements of large-scale analytics

Considerations for data ingestion and processing
Understanding Azure Data Lake storage
Creating an Azure Data Lake storage account
Understanding Azure Databricks
Visualizing Azure Synapse Analytics
Registering Azure Synapse as a resource provider in Azure
Setting up a SQL DB and server for use with Azure Synapse Analytics
Creating a Azure Synapse workspace and Data Lake Storage account
Concepts of SQL Pool usage with Azure Synapse Analytics
Purposes of Azure HDInsight
Understanding Azure Data Factory
Setting up an Azure Data Factory resources
Using Azure Data Factory to copy data into Azure Synapse Analytics <AZ-305>

Describe consideration for real-time data analytics

Understanding the difference between batch and streaming data
Concepts of Azure Stream Analytics
Creating an Azure Stream Analytics job for real-time analytics
Benefits of using Apache Spark
Cleaning up the existing resources before moving on

Describe data visualization in Microsoft Power BI

Capabilities of Power BI
Downloading and installing Power BI Desktop
Creating a database with data for testing Power B
Connecting Power BI to a SQL database and performing an import
Features of data models in Power BI
Using the appropriate visualizations for data

What's inside

Learning objectives

Learn the concepts and perform hands on activities needed to pass the dp-900 exam
Gain a tremendous amount of knowledge involving data processing in microsoft azure

Get loads of hands on experience with microsoft azure data processing technologies!
Utilize hands on simulations that can be access anytime, anywhere!

Learn the concepts and perform hands on activities needed to pass the dp-900 exam
Gain a tremendous amount of knowledge involving data processing in microsoft azure
Get loads of hands on experience with microsoft azure data processing technologies!
Utilize hands on simulations that can be access anytime, anywhere!

Syllabus

Having a Solid Foundation of RAS, DMZ, and Virtualization

Having a Solid Foundation of the Microsoft Cloud Services

DONT SKIP: The first thing to know about Microsoft cloud services

Career center

Learners who complete DP-900 Azure Data Fundamentals hands on course with sims will develop knowledge and skills that may be useful to these careers:

Database Administrator

A Database Administrator is crucial for managing and maintaining an organization's databases, ensuring their availability, performance, and security. This work involves tasks like installing, configuring, and upgrading database servers, as well as monitoring database health and implementing backup and recovery strategies. The DP-900 Azure Data Fundamentals course is exceptionally well-suited for someone pursuing this role, as it directly addresses responsibilities for database administrators, including permissions in Azure. You will gain hands-on experience with creating relational databases in Azure using Microsoft SQL and connecting with SQL Server Management Studio. Furthermore, the course delves into securing Azure storage accounts and understanding capabilities of Azure storage, all vital for a successful Database Administrator. This foundational knowledge in relational and non-relational databases within the Azure environment is highly relevant for establishing a strong career path.

See salaries and explore the career path for Database Administrator

Data Engineer

A Data Engineer builds and maintains the infrastructure for data processing, ensuring that data is readily available, reliable, and optimized for analytical and operational uses. This involves designing, constructing, installing, and managing data pipelines and data storage solutions. The DP-900 Azure Data Fundamentals course is an excellent starting point for aspiring Data Engineers, as it explicitly covers responsibilities for data engineers, including their permissions in Azure. You will gain practical experience with Azure Data Lake storage, Azure Databricks, Azure Synapse Analytics, Azure HDInsight, and critically, Azure Data Factory for data ingestion and processing. Understanding both relational and non-relational data storage, along with large-scale analytics concepts, provides a comprehensive foundation for designing robust data solutions. This course directly equips you with the fundamental Azure data processing technologies essential for this role.

See salaries and explore the career path for Data Engineer

Big Data Engineer

A Big Data Engineer designs, builds, and manages large-scale data processing systems and pipelines to handle massive volumes of data, often leveraging distributed computing frameworks. This role typically requires expertise in tools for ingesting, transforming, and storing big data. The DP-900 Azure Data Fundamentals course is highly relevant for aspiring Big Data Engineers, as it covers critical components of large-scale analytics in Azure. You will gain practical experience with Azure Data Lake storage, Azure Databricks, Azure Synapse Analytics (including SQL Pool usage), Azure HDInsight, and Azure Data Factory. The course also discusses considerations for real-time data analytics, concepts of Azure Stream Analytics, and the benefits of Apache Spark, all fundamental to big data processing. This comprehensive exposure to Azure's big data ecosystem is a strong start for this demanding career.

See salaries and explore the career path for Big Data Engineer

SQL Developer

A SQL Developer designs, develops, and maintains databases and queries using Structured Query Language. Their work involves creating tables, writing complex queries, stored procedures, and ensuring efficient data retrieval and storage. The DP-900 Azure Data Fundamentals course is an excellent resource for anyone aiming to become a SQL Developer, providing a strong practical foundation. You will gain extensive hands-on experience by creating relational databases in Azure using Microsoft SQL, installing SQL Server Management Studio, and connecting to SQL databases. The course meticulously covers using common SQL statements and understanding common database objects. Beyond basic SQL, it introduces the Azure SQL Family services, providing context for modern cloud-based SQL development. This concentrated focus on SQL within Azure is highly beneficial for this career path.

See salaries and explore the career path for SQL Developer

Data Analyst

A Data Analyst interprets complex datasets to identify trends, patterns, and insights that can inform business decisions. Their work involves collecting data, cleaning it, and then presenting findings through reports and visualizations. For individuals interested in becoming a Data Analyst, the DP-900 Azure Data Fundamentals course is highly beneficial. The course specifically outlines responsibilities for data analysts and their associated permissions within Azure. You will learn about data representation, common analytical workloads, and particularly, gain hands-on experience with Microsoft Power BI. This includes connecting Power BI to a SQL database, creating data models, and using appropriate visualizations to present insights effectively. Understanding how to work with structured, semi-structured, and unstructured data, coupled with practical visualization skills, provides a solid framework for embarking on a career as a Data Analyst.

See salaries and explore the career path for Data Analyst

Business Intelligence Developer

A Business Intelligence Developer specializes in transforming raw data into meaningful and actionable insights for businesses. They design and develop data warehouses, create reports, and build interactive dashboards to support decision-making. The DP-900 Azure Data Fundamentals course is particularly advantageous for individuals pursuing a career as a Business Intelligence Developer. It offers significant instruction on data visualization using Microsoft Power BI, including connecting to SQL databases, importing data, understanding data models, and utilizing appropriate visualizations. Furthermore, the course explores Azure Synapse Analytics, which is a key component for modern data warehousing, and covers concepts of SQL pool usage. The foundational understanding of relational data, SQL statements, and common data workloads like analytical workloads directly supports the development of robust BI solutions.

See salaries and explore the career path for Business Intelligence Developer

Data Warehouse Developer

A Data Warehouse Developer is responsible for designing, building, and maintaining an organization's data warehouse, which is a central repository of integrated data from one or more disparate sources. This involves ETL (Extract, Transform, Load) processes and schema design. The DP-900 Azure Data Fundamentals course is an excellent fit for a Data Warehouse Developer, as it covers many directly applicable technologies and concepts. You will gain experience with Azure Synapse Analytics, a powerful platform for data warehousing, and learn about setting up SQL DB and server for use with it. The course also covers Azure Data Factory for copying and ingesting data, a crucial ETL tool. Understanding relational data concepts, SQL statements, and various storage options provides a robust foundation for building and managing efficient data warehouses.

See salaries and explore the career path for Data Warehouse Developer

Data Migration Specialist

A Data Migration Specialist plans, executes, and verifies the transfer of data from one system to another, often from on-premises environments to cloud platforms. This role requires meticulous attention to detail and a deep understanding of source and target data systems. The DP-900 Azure Data Fundamentals course is highly beneficial for a Data Migration Specialist transitioning data to Azure. You will gain hands-on experience with various Azure data storage options, including relational databases (Azure SQL), non-relational databases (Azure Cosmos DB), and Azure storage accounts (Blob, File, Table storage). The course also covers data ingestion and processing with Azure Data Factory, a key tool for orchestrating data movement. This practical grounding in Azure's diverse data services makes the course an excellent foundation for effectively planning and executing data migrations.

See salaries and explore the career path for Data Migration Specialist

Azure Administrator

An Azure Administrator is responsible for implementing, monitoring, and maintaining Microsoft Azure solutions, including managing compute, storage, networking, and security. The role focuses on the operational aspects of cloud services. This course is highly relevant for aspiring Azure Administrators, as it offers extensive hands-on experience with core Azure services. You will learn about understanding the Microsoft Environment, creating and managing Azure accounts, and activating Entra ID. Crucially, the course covers creating relational databases in Azure, managing Azure storage accounts, and securing them, along with permissions in Azure regarding data roles. This direct engagement with Azure's infrastructure components and security practices provides a fundamental skillset for effectively managing Azure resources as an Azure Administrator.

See salaries and explore the career path for Azure Administrator

Cloud Engineer

A Cloud Engineer designs, implements, and manages cloud-based infrastructure and services, ensuring scalability, security, and efficiency. Their daily tasks often involve configuring virtual machines, managing storage, and deploying applications within cloud environments. The DP-900 Azure Data Fundamentals course provides a valuable introduction for someone aspiring to be a Cloud Engineer, especially within the Microsoft Azure ecosystem. It lays a solid foundation by covering the Microsoft Environment, Active Directory Domains, RAS, DMZ, Virtualization, and the Microsoft Cloud Services. You will gain practical experience creating a free Azure account, activating Entra ID, and working with Azure VMs, storage accounts, and various Azure data services. This comprehensive exposure to Azure's foundational components is directly relevant to establishing a strong career as a Cloud Engineer.

See salaries and explore the career path for Cloud Engineer

Cloud Support Engineer

A Cloud Support Engineer assists users and organizations with technical issues related to their cloud infrastructure and services. This involves troubleshooting, problem resolution, and providing guidance on cloud best practices and configurations. For an aspiring Cloud Support Engineer specializing in Azure, the DP-900 Azure Data Fundamentals course provides a helpful foundational understanding of the Azure data ecosystem. It covers essential topics such as understanding the Microsoft Environment, creating Azure accounts, managing Entra ID, and working with various Azure data services like SQL databases, Cosmos DB, and Azure storage accounts. The hands-on simulations of creating and connecting to these services will directly enhance one's ability to diagnose and resolve common issues, making them more effective in a support role. This practical familiarity with Azure data components is a significant advantage.

See salaries and explore the career path for Cloud Support Engineer

Data Architect

A Data Architect designs the vision and strategy for an organization's data infrastructure, defining how data is collected, stored, processed, and consumed. This role requires a broad understanding of various data technologies and their optimal application. The DP-900 Azure Data Fundamentals course may be useful for aspiring Data Architects, as it provides a comprehensive overview of fundamental data concepts and technologies within Azure. You will explore different ways to represent data, identify various options for data storage (relational, non-relational, Azure storage accounts), and understand common data workloads. The course also delves into large-scale analytics, including Azure Data Lake storage, Azure Databricks, and Azure Synapse Analytics. This broad exposure to Azure's data ecosystem helps build a foundational understanding of the components a Data Architect would leverage and design.

See salaries and explore the career path for Data Architect

Solutions Architect

A Solutions Architect designs and oversees the implementation of complex technical solutions for businesses, ensuring they align with organizational goals and technical requirements. This often involves integrating various cloud services and platforms. The DP-900 Azure Data Fundamentals course may be useful for individuals targeting a Solutions Architect role, particularly one focused on data-centric solutions in Azure. It offers a foundational understanding of the Microsoft Cloud Services, Azure environment, and various data processing technologies. You will learn about relational and non-relational database services, Azure storage capabilities, and large-scale analytics components like Azure Synapse Analytics and Azure Data Factory. This breadth of exposure to Azure's data services and foundational cloud concepts helps in designing holistic and effective data solutions, which is a key responsibility for a Solutions Architect.

See salaries and explore the career path for Solutions Architect

Technical Consultant

A Technical Consultant advises clients on technology solutions, helping them implement systems that meet their business needs. This often involves assessing client requirements, recommending appropriate cloud services, and assisting with deployment and integration. The DP-900 Azure Data Fundamentals course may be useful for someone pursuing a Technical Consultant role, especially if specializing in data and cloud solutions. It provides a solid understanding of the Microsoft Cloud Services and a wide array of Azure data processing technologies, including relational and non-relational databases, Azure storage, and large-scale analytics services like Azure Synapse Analytics. This breadth of knowledge, combined with hands-on experience, enables a Technical Consultant to confidently discuss, recommend, and demonstrate Azure data solutions to clients, establishing credibility and practical expertise.

See salaries and explore the career path for Technical Consultant

DevOps Engineer

A DevOps Engineer works to bridge the gap between development and operations, focusing on automating and streamlining the software delivery lifecycle. This often involves managing cloud infrastructure, continuous integration, and continuous deployment pipelines. The DP-900 Azure Data Fundamentals course may be useful for an aspiring DevOps Engineer, particularly one working with Azure-based data solutions. While not a core DevOps course, it provides a crucial understanding of the Azure environment, cloud services, and data resources that a DevOps Engineer would need to provision, manage, and automate. Learning about creating Azure accounts, managing VMs, setting up Azure storage, and understanding permissions in Azure for data roles provides valuable context for automating infrastructure deployments and managing configurations for data-centric applications, forming a helpful baseline for success.

See salaries and explore the career path for DevOps Engineer