DP-900: Azure Data Fundamentals in Just 3.5 Hours!

Discover how data drives modern business by collecting, analyzing, and storing valuable information with software technologies and platforms to inform critical business decisions.

Explore how data formats shape storage, encoding, and interpretation by classifying data as structured, semi-structured, or unstructured, with examples like tabular data and JSON documents.

Explore data storage fundamentals, comparing local file systems and cloud-based centralized storage, and differentiate file stores from databases while considering file formats for structured, semi-structured, and unstructured data.

Compare relational SQL databases with NoSQL non-relational systems, exploring how structured schemas with tables, rows, and columns contrast with flexible, scalable key-value, document, column family, and graph databases.

Understand azure IaaS and PaaS, where providers manage data centers and hardware, and users do not manage the infrastructure; IaaS gives OS and app control, PaaS handles OS and runtime.

Explore Microsoft SQL Server based database services in Azure, including SQL Server on Azure virtual machines, Azure SQL Managed Instance, Azure SQL Database, and Azure SQL Edge.

Explore how SQL Server runs on Azure Virtual Machines, enabling lift-and-shift migrations, hybrid deployments, and scalable resources with infrastructure as a service for cloud and on-premises databases.

Discover Azure SQL Managed Instance, a fully managed cloud database with built-in high availability and SQL Server Enterprise compatibility, supporting both SQL Server logins and Microsoft Entra ID integrated logins.

Explore Azure SQL Database as a platform as a service, comparing single database and elastic pool configurations. Learn how serverless options, resource scaling, and high availability support variable workloads.

Create any Azure service by obtaining an Azure account with a subscription. Follow the article in the next lesson to set up a free Azure account.

Create an Azure SQL database in the Azure portal by configuring a new database and server, selecting authentication options, and enabling sample data for a development environment.

Explore how SQL enables querying and manipulating data in relational databases. Learn why SQL defines database structure and remains the go-to language for relational data.

Explore SQL fundamentals by querying an Azure SQL DB with the select statement, using select star and selecting specific columns from a schema-qualified table in the query editor.

Filter data with the where clause to retrieve records for Active Life Choice and select only the needed columns, such as first name, last name, company name, and email.

Explore the order by clause in a select statement to sort the company name column in ascending and descending order, with practical query execution.

Learn how to remove duplicates and retrieve unique values using the select distinct statement, filtering with in and not in, and handling null titles in SQL queries.

Apply the sql case statement to create a price group from the product list price, labeling as low, medium, or high, and review top thousand product rows.

Learn SQL aggregations by calculating max, min, and sum of the list price in the products table, and alias the results for clear insight.

Explore how to use group by with aggregations to count products per category and compute net and gross sales by sales order ID.

Learn how the having clause filters aggregated net sales after grouping by sales order ID, using sum(line total), and why where cannot filter aggregates.

Explore how to join the sales order detail and product tables to retrieve product names and gross sales using inner, left, right, and full outer joins.

Use subqueries to find products that haven't made any sale by filtering the product table against the sales order detail table, identifying unsold product IDs and names.

Learn how the partition by clause ranks sales orders by subtotal within each status and order date using row_number over partition by status and order date, ordered by subtotal descending.

Create a new price_group table from the existing products table by selecting product ID, name, and a case statement that assigns price_group.

Create a table named persons in the sales ELT schema with an autoincrementing person_id not null, then insert data using insert into for last name, first name, address, and city.

Learn to use the SQL update statement to reclassify headsets by changing the parent product category id for headsets, using set and where, then verify with a select query.

Explore how SQL indexes speed up query retrieval by using an index to locate rows quickly, and distinguish clustered from non-clustered indexes in SQL Server.

Explore how a clustered index sorts data using a b-tree, with root, intermediate, and leaf nodes, and learn to create and drop custom clustered indexes with ascending or descending order.

Learn how non-clustered indexes store pointers separately from data using a B-tree, support multiple indexes per table, and speed queries on the name column in Azure SQL DB.

Explore what a SQL view is: a virtual table based on a query result that does not store data, offering simplified queries, data abstraction, security options, and reusable saved queries.

Discover SQL stored procedures as pre-compiled, server-side units that encapsulate logic, support parameters, security, and transactions, enabling reusable, efficient operations and reduced network traffic in Azure SQL database.

Compare MySQL, MariaDB, and PostgreSQL as relational databases with distinct strengths. Explore Azure data services supporting the systems and enabling on-premises to Azure migrations with minimal changes.

Azure database for MySQL, a fully managed PaaS in the Azure cloud, offers pay-as-you-go pricing, high availability, global scalability, security, automatic backups, and robust monitoring.

Discover the Azure database for MariaDB, a managed MariaDB offering, with high availability, automatic backups, point in time restore up to 35 days, and inclusive pay as you go pricing.

Explore Azure Database for PostgreSQL, a platform-as-a-service in Azure cloud offering availability, performance, scaling, security, and administrative benefits. Learn about flexible server deployment and query monitoring to optimize PostgreSQL workloads.

Discover why relational databases can be rigid and costly to tune, and learn NoSQL data models such as documents, graphs, key-value stores, and column family stores through Azure Cosmos DB.

Explore Azure Cosmos DB, a highly scalable database that supports multiple APIs for storing and querying data with familiar interfaces, featuring automatic indexing, partitioning, and multi-region writes for global access.

Explore Azure Cosmos DB's serverless, distributed architecture and API options, including SQL and NoSQL models, with engines for PostgreSQL, MongoDB, Cassandra, and Gremlin graph.

Unlock Azure file storage, offering highly available, durable, and scalable, fully managed file shares for shared storage across multiple virtual machines or containers.

Explore Azure Data Lake Storage Gen2, built on blob storage with a hierarchical namespace, enabling directory-based organization, single-step renames and deletes, and fine-grained access controls for secure, cost-efficient analytics.

Explore access control lists in Azure Data Lake Storage Gen2, covering access and default ACLs, and how read, write, and execute permissions govern files and directories.

Explore online transaction processing and online analytical processing, understand ACID properties, and learn why separate OLTP and OLAP databases optimize performance for analytics.