# KodeKloud: Beta Courses DP-900: Microsoft Azure Data Fundamentals

## DP-900: Microsoft Azure Data Fundamentals

### Introduction

- [Course Overview](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Introduction/Course-Overview/page.md): This course provides an understanding of Azures data storage options and prepares you for the DP-900 certification.
- [Course Introduction](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Introduction/Course-Introduction/page.md): This course covers storing and managing data in Azure, aligning with DP-900 certification exam objectives.

### File-Based Storage

- [File Based Storage](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/File-Based-Storage/File-Based-Storage/page.md): This article explores storing and managing file-based data in Azure for the DP-900 Microsoft Azure Data Fundamentals certification.
- [Solutions for File Based Storage](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/File-Based-Storage/Solutions-for-File-Based-Storage/page.md): This guide explores Azure’s file-based storage offerings, including Storage Accounts, governance, performance tiers, and geo-redundant storage for disaster recovery.
- [Demo Create Azure Storage Account](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/File-Based-Storage/Demo-Create-Azure-Storage-Account/page.md): This guide explains how to provision an Azure Storage Account through the Azure portal with steps for configuration.
- [Azure Files](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/File-Based-Storage/Azure-Files/page.md): Azure Files is a cloud-based file-share service offering SMB and NFS shares for legacy applications and containerized workloads.
- [Demo Files Shares](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/File-Based-Storage/Demo-Files-Shares/page.md): This article provides a step-by-step guide to configuring an Azure File Share, including creation, performance adjustment, quota management, and access control.
- [Container Blob Storage](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/File-Based-Storage/Container-Blob-Storage/page.md): Azure Blob Storage offers scalable object storage with robust security, tiered pricing, and data management features for managing files in the cloud.
- [Demo Containers](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/File-Based-Storage/Demo-Containers/page.md): This guide teaches how to create and manage Azure Blob Containers, including setting up a Storage Account and managing access and uploads.
- [Roles and Responsibilities](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/File-Based-Storage/Roles-and-Responsibilities/page.md): This article outlines the roles and responsibilities for managing file-based storage on Azure, emphasizing security and least privilege access.

### Structured Data

- [Structured Data Solutions](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Structured-Data/Structured-Data-Solutions/page.md): This article explores structured data solutions in Azure, focusing on migration, database management, and serverless options for relational databases.
- [Demo Creating Azure SQL](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Structured-Data/Demo-Creating-Azure-SQL/page.md): This article provides a step-by-step guide to provisioning an Azure SQL Database through the Azure portal.
- [Normalizing Data](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Structured-Data/Normalizing-Data/page.md): This article explains the importance of data normalization in relational databases and how to design an efficient, normalized database schema.
- [Creating Relationships](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Structured-Data/Creating-Relationships/page.md): This article explores defining and leveraging relationships between tables in structured data to model real-world business transactions.
- [Demo Normalized Tables](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Structured-Data/Demo-Normalized-Tables/page.md): This walkthrough explores normalized tables in Azure SQL Database using SQL Server Management Studio for visualizing schemas and relationships.
- [Other DBMS Features](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Structured-Data/Other-DBMS-Features/page.md): This article covers essential RDBMS features like indexes, views, and stored procedures that enhance performance and simplify database management.
- [Querying and Updating Data](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Structured-Data/Querying-and-Updating-Data/page.md): This article provides a practical guide to querying and updating data using SQL, covering its sublanguages and commands.
- [Demo Running SQL Statements](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Structured-Data/Demo-Running-SQL-Statements/page.md): Learn to run basic T-SQL statements in Azure SQL Database using Azure Data Studio, including connecting, exploring, and executing queries.
- [Costs and Benefits](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Structured-Data/Costs-and-Benefits/page.md): This article evaluates the costs and benefits of relational databases compared to alternative storage solutions for structured data management.
- [Roles and Responsibilities](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Structured-Data/Roles-and-Responsibilities/page.md): This article outlines roles, responsibilities, and permission models in relational database management to ensure data security, integrity, and availability.

### Semi-Structured Data

- [Introduction](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Semi-Structured-Data/Introduction/page.md): This article discusses the advantages and limitations of semi-structured data in e-commerce, highlighting its benefits for handling high-volume transactions.
- [Table Storage](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Semi-Structured-Data/Table-Storage/page.md): Azure Table Storage is a managed NoSQL key-value store designed for massive scale with a flexible schema and high transaction throughput.
- [Demo Table Storage](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Semi-Structured-Data/Demo-Table-Storage/page.md): Learn to create and manage Table Storage in Azure for structured, non-relational data.
- [Roles and Responsibilities](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Semi-Structured-Data/Roles-and-Responsibilities/page.md): This article explores the roles and responsibilities for managing Azure Table Storage, focusing on user access, performance optimization, and schema design.

### Cosmos DB

- [Introduction](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Cosmos-DB/Introduction/page.md): This article provides an overview of Azure Cosmos DB, highlighting its global distribution, multi-model APIs, and key features for data management.
- [Configuring Cosmos DB](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Cosmos-DB/Configuring-Cosmos-DB/page.md): This guide explains how to create and optimize an Azure Cosmos DB account for global, low-latency applications, covering various configuration aspects.
- [Application Programming Interfaces APIs](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Cosmos-DB/Application-Programming-Interfaces-APIs/page.md): This article explores the five supported APIs in Azure Cosmos DB and guides users on selecting the appropriate interface for their workloads.
- [Demo Create Cosmos DB Account](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Cosmos-DB/Demo-Create-Cosmos-DB-Account/page.md): Learn to provision an Azure Cosmos DB account, configure a NoSQL database, enable global distribution, and insert your first document using Data Explorer.
- [Roles and Responsibilities](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Cosmos-DB/Roles-and-Responsibilities/page.md): This lesson covers key roles in planning, configuring, and maintaining an Azure Cosmos DB account along with best practices and main takeaways.

### Analyzing Data

- [Introduction](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Analyzing-Data/Introduction/page.md): This article introduces Online Analytical Processing (OLAP) and its role in data analysis, including data preparation and case studies using Azure services.
- [Processing Modes](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Analyzing-Data/Processing-Modes/page.md): This article compares batch, streaming, and hybrid data processing modes for effective analytics solution architecture.
- [Integrated Solutions](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Analyzing-Data/Integrated-Solutions/page.md): This article covers integrated solutions for ETL/ELT, data warehousing, and analytics using Azure Synapse Analytics and related technologies.
- [Demo Azure Synapse Analytics](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Analyzing-Data/Demo-Azure-Synapse-Analytics/page.md): Step-by-step guide for provisioning an Azure Synapse Analytics workspace, covering creation, security configuration, deployment, and exploration of resources.
- [Extracting and Transforming](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Analyzing-Data/Extracting-and-Transforming/page.md): This lesson focuses on the extract and transform phases of ETL using Azure Data Factory, a cloud-native data integration service.
- [Demo Data Factory](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Analyzing-Data/Demo-Data-Factory/page.md): This article provides a step-by-step guide to create an Azure Data Factory pipeline for copying a CSV file from Blob Storage to Data Lake.
- [Storing Data](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Analyzing-Data/Storing-Data/page.md): This lesson explores the storing phase of the data pipeline in Azure, focusing on optimal storage solutions for analytics and batch processing.
- [Analyzing Data](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Analyzing-Data/Analyzing-Data/page.md): This article covers tools and frameworks for analyzing data using Azure services, including querying, open-source engines, and integration with Azure HDInsight.
- [Reporting](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Analyzing-Data/Reporting/page.md): This module explores reporting through Microsoft Power BI, covering data analysis from ingestion to distribution.
- [Common Visualizations](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Analyzing-Data/Common-Visualizations/page.md): This article discusses various data visualization techniques used in analytics to convey insights effectively.
- [Demo Power BI Report](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Analyzing-Data/Demo-Power-BI-Report/page.md): This tutorial teaches how to connect Power BI Desktop to an Azure SQL Database, import data, and create a report showing product counts by country/region.
- [Power BI Service](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Analyzing-Data/Power-BI-Service/page.md): Power BI Service is a platform for sharing, collaborating, and automating data refresh on Power BI reports, focusing on secure distribution and user access.
- [Roles and Responsibilities](https://notes.kodekloud.com/docs/DP-900-Microsoft-Azure-Data-Fundamentals/Analyzing-Data/Roles-and-Responsibilities/page.md): This article defines core roles in data analysis and recaps essential concepts learned in the module.