DP-900 Azure Data Fundamentals hands on course with sims

Watch this to learn how assignments work in the course. Use open link in new tab to access simulations, complete them, and note that assignment checks don't affect course completion; videos matter for the certificate.

Learn how to create a free Azure account, start free, claim $200 credit for 30 days, and explore free services and virtual machines in portal.azure.com.

Convert your Azure account from a personal to a business name using Microsoft Entra ID, sign in with the new user principal name, and resolve sign-in and password reset steps.

Activate a Microsoft Entra ID P2 license and explore free trial options in the admin portal and marketplace. Understand regional availability and how to proceed if a trial isn't accessible.

Explore structured data as organized, schema-defined information stored in tables or CSVs. Learn how predefined schemas, CSV formats, and SQL enable easy querying and precise, error-reduced data management.

Explore semi-structured data in the Azure data fundamentals course, with a flexible schema, where tagged, self-describing formats like XML, JSON, and YAML support hierarchical, metadata-driven data from diverse sources.

Unstructured data lacks a predefined model, spanning text, images, videos, and audio. It requires flexible storage and access to manage volume, variety, and complexity.

Explore common data file formats, including csv, xml, json, yaml, parquet, avro, and orc, and understand their structures, storage patterns, and use cases for efficient data processing.

Learn how relational databases store data in tables with rows and columns, linked by relationships, using SQL, DDL and DML, with ACID integrity and transaction logs.

Create an Azure SQL database using the platform option, with resource group, database name, and server; configure authentication, basic tier, local redundancy, networking, and add the AdventureWorks sample.

Install the free SQL Server Management Studio (SSMS) to connect to a SQL Server and manage your SQL database on Windows.

Learn to connect to a SQL database with SSMS, including selecting database engine, using the server name and SQL Server authentication credentials, then verify sample data in the LP database.

Explore non-relational NoSQL databases as a data storage option, covering document, columnar, key-value, graph, time-series, and object stores, with Cosmo, Azure's NoSQL database, offering fast, scalable, SQL-compatible querying.

Create an Azure Cosmos DB for NoSQL in portal.azure.com. Configure resource group, account name, location, and capacity mode, with the free tier of 1000 request units and 25 GB storage.

Connect to an Azure Cosmos database by signing in, select your subscription and database, then create a sample container and explore the sample data.

Learn to redo simulations after completing an assignment by navigating to summary, returning to the assignment, opening instructions, and accessing the simulation link anytime.

Explore the acid properties—atomicity, consistency, isolation, durability—and how high throughput, low latency, concurrency control, and real-time processing ensure scalable, durable transactional workloads with recovery mechanisms and transaction logs.

Explore analytical workloads by examining databases, tables, normalization, and data transformation, then visualize insights with Power BI and scale with Azure Synapse Analytics and data lakes.

Identify the database administrator's roles, including design and implementation, maintenance, security management, performance optimization, backup and recovery, and stakeholder collaboration. Explore cloud-based options such as Azure SQL or Cosmos DB.

Explore how a data analyst understands relational and non-relational data, analyzes patterns, and builds visualizations and analytical models using Azure Synapse and Power BI with governance and security.

learn how to grant permissions for a data analyst from within the database, bypassing the resource group IAM blade, so team members can read data and perform analysis.

Explore the features of relational data through a normalized schema with customers, products, orders, and line items, using primary keys and foreign keys to ensure data integrity and efficient querying.

Normalizing data from unnormalized spreadsheets to a four-table database (customers, products, orders, line items) with primary and foreign keys, enabling queries while ensuring referential integrity and reducing redundancy.

Set up an Azure virtual machine with SQL Server on Windows Server 2022 to host databases and gain full control over the operating system, including management using SSMS.

Learn core SQL concepts on a Microsoft SQL Server, including select, where, order by, insert, delete, update, and creating databases and tables using SQL Server Management Studio.

Explore common database objects like views, stored procedures, and indexes, and learn how to create and use them to query data efficiently in SQL.

Explore the Azure SQL family, comparing Azure SQL Database, SQL Managed Instance, and SQL Server on VMs, highlighting differences in management, scalability, maintenance, and use cases.

Explore Azure database services for open source systems, including MySQL, MariaDB, and PostgreSQL, as a platform as a service with automatic backups, scaling, and compatibility for relational and non-relational data.

Explore storage accounts as the core for blobs, file shares, queues, tables, and disks in Azure, with standard general-purpose version two as the common option.

Create an Azure storage account in the portal, selecting East US and standard v2 with appropriate redundancy, then configure security, networking, and tiered storage options from hot to archive.

Secure an Azure storage account by using IAM/RBAC access control, network restrictions and private endpoints, SAS tokens, and encryption with Azure Key Vault or customer managed keys.

Learn how to use Azure blob storage to store unstructured data in a storage account, organize with containers, manage access levels, and serve large files over http rest.

Learn how to use Azure file shares as a file server, map drives with smb, manage tiers, and connect via vpn or expressroute while noting port 445 is blocked.

Explore Azure table storage as a schema-free NoSQL data store in a storage account, using partition and row keys to organize entities.

Explore real-world use cases for Azure Cosmos DB, including global applications, real-time analytics, ecommerce catalogs, gaming, IoT, mobile and web apps, financial services, and healthcare.

Explore Azure Cosmos DB APIs for NoSQL and link up with technologies using SQL API, Postgres, MongoDB, Cassandra, Table, and Gremlin graph APIs, delivering high availability and low latency.

Delete the existing Cosmos DB by removing its resource group in the Azure portal, then confirm deletion to prepare for the next video.

Create an Azure Cosmos DB for NoSQL in the portal, configure resource group and account name, choose east us and local redundant backup, then review and create the database.

Add data to Azure Cosmos DB for NoSQL, create a retail database and inventory container, set category as the partition key, and run SQL-like queries to view item sizes.

Delete all resource groups in Azure portal to reset the lab environment, remove unnecessary resources, and avoid using Azure credit while preparing for the next section.