Microsoft Azure Data Fundamentals [DP-900] Full Course

Name: Microsoft Azure Data Fundamentals [DP-900] Full Course
Rating: 4.3 (28 reviews)

Created byK21 Academy

Last updated 12/2021

English

English [Auto],

What you'll learn

Students will learn the fundamentals of database concepts in a cloud environment, and get basic skilling in cloud data services.
Identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented on Azure.
Explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Azure.
Learn non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure.
Learn the processing options available for building data analytics solutions in Azure.
Explore Azure Synapse Analytics, Azure Databricks, Azure HDInsight, and Power BI.

Course content

7 sections • 29 lectures • 5h 33m total length

Course Overview11:59
Explore four Azure data modules—core data concepts, relational data in Azure, non-relational data in Azure, and the modern data module—plus hands-on labs and 100+ DP-900 practice questions.
For Quick Support0:28
Thanks for your purchase. You made the best decision to register for Microsoft Azure Data Fundamentals [DP-900] Full Course.

Join WhatsApp Group For Quick Support:

Download WhatsApp on phone from App Store (If you don't already have it) then click below link to join group for instant support (please don't share this with anyone else it's just for my VIP members like you)

https://chat.whatsapp.com/L4YKU0vYcTw4BFVMNswwn2

I & My Team Are Here To Help You :

I am beyond excited to get started. If you have any questions before you dive in, don’t hesitate to ask in WhatsApp group or in QnA section and you'll get a quick response.

I can't wait to see you inside Training portal, Happy Learning!
How To Register For A Free Azure Cloud Account18:48
Register a free Microsoft Azure cloud account and explore a 12-month free tier with credits to practice hands-on labs and build apps, databases, storage, networking, and active directory.
Activity Guide: Register for Azure Cloud0:16

Explore core data concepts25:53
Explore core data concepts, including relational and non-relational data, data ingestion, transformation, analytics, data visualization, and batch and streaming processing; transactional versus analytical workloads.
Explore roles and responsiblities in the world of data10:48
Describe concepts of relational data15:06
Describe concepts of relational data and relational databases. Explore tables of rows and columns, entities and relationships, and the role of keys, indexes, and views in joins and data warehousing.
Explore concepts of non-relational data18:54
Explore the characteristics and uses of non-relational data, including schema-free storage for multiple entities, with formats like JSON and Avro, stored in Cosmos DB for web, mobile, and gaming analytics.
Explore concepts of data analytics9:11
Explore concepts of data analytics, including data ingestion and processing, ETL and ERP pipelines, data visualization, reporting, and the five analytics types: descriptive, diagnostic, predictive, prescriptive, and cognitive.
Create SQL Database13:03
Learn to create an Azure SQL database in the portal, set up a resource group, enable access, choose a sample database, and load data into tables using the BCP utility.
Activity Guide (Lab 1A): Create Azure SQL Database0:07

Explore relational data services & provisioning and deploying relational db28:00
Explore Azure relational data services and provisioning and deploying relational databases, including IaaS, PaaS, elastic pools, and managed instances.
Query relational data in Azure26:49
Learn to query relational data in Azure with sql, using select, insert, update, and delete, and explore dml, ddl, and dcl concepts through the Azure portal and data studio.

Explore non-relational data services in Azure45:08
Explore provisioning and deploying non-relational data services on Azure16:06
Learn how to provision and deploy non-relational data services on Azure, including Cosmos DB accounts, databases, and containers, with throughput, partition keys, and multi-region considerations.
Manage non-relational data stores in Azure27:47
Create Storage Account7:51
Create a storage account to hold unstructured data using block blobs, containers, and tables; upload data and mount a shared location as network attached storage.
Provisioning Cosmos DB11:29
Provision a Cosmos DB through scripts, creating a resource group, Cosmos DB account, database, and container, then insert 4000 documents and explore data with the data explorer.
Provisioning Data Lake0:51
Provision a data lake by enabling the hierarchical namespace on the storage account to transform it into an hdfs-compatible data lake, enabling big data clusters in Asia.
Activity Guide: Create an Azure Storage Account0:15
Activity Guide: Create an Azure Cosmos Database0:19
Activity Guide: Create an Azure Data Lake0:07

Examine components of a modern data warehouse9:50
Explore the components of a modern data warehouse in Azure. Learn ingestion, storage, processing, and reporting with Azure Synapse Analytics and Power BI.
Explore data ingestion in Azure7:12
Explore data ingestion in Azure using Data Factory to load data from multiple locations, including storage accounts and data lakes, with pipelines, linked services, datasets, and copy activities.
Explore data storage and processing in Azure3:28
Explore data storage and processing with Azure Synapse Analytics, Databricks, Spark, Hadoop, Kafka, Hive, Storm, Data Factory, and data lake to build a hybrid data pipeline.
Get started building with Power BI2:00
Power BI demo12:05
Install Power BI desktop, sign up, and sign in via Active Directory workaround; build sunglass sales dataset, merge with state abbreviations, and publish a map and charts in Power BI.
Activity Guide: Power BI Demo0:09

Requirements

This is fundamental course and so no prerequisite is required.

Description

This course is intended for IT professionals 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.
This course will prepare you to take up Data Engineer, Data Analyst, and Database Administrator roles. You will explore the roles, tasks, and responsibilities in the world of data. You will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Microsoft Azure.
You will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores, and the processing options available for building data analytics solutions in Microsoft Azure. You will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight and learn what Power BI is, including its building blocks and how they work together.
This course will prepare you to take the DP-900: Microsoft Azure Data Fundamentals exam. Upon completion of the course, you can go for the Microsoft Azure Data Fundamentals Certification Exam.

Learners will engage in interactive exercises throughout this program that offers opportunities to practice and implement what they are learning. They use the Microsoft Free Account. This a free azure account that allows learners to explore Microsoft Azure and get hands-on with live Microsoft Azure resources and services.

If you're looking to change your career, this would be a good entry point into cloud computing on the data side.

Who this course is for:

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.

Microsoft Azure Data Fundamentals [DP-900] Full Course

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 32min

Module 1: Explore core data concepts7 lectures • 1hr 33min

Module 2: Explore relational data in Azure2 lectures • 55min

Module 3: Explore non-relational data in Azure9 lectures • 1hr 50min

Module 4: Explore modern data warehouse analytics in Azure6 lectures • 35min

Quizzes0

THANK YOU1 lecture • 10min

Requirements

Description

Who this course is for: