
Structured, semi-structured, and unstructured data: definitions, features, and examples for recognizing different data representations.
Common data file formats (CSV, JSON, XML, Parquet) and main database types: relational (SQL) and non-relational (NoSQL).
Explore normalization and the first three normal forms, learning how primary keys and atomic columns reduce data redundancy in relational databases.
Explore Azure resource manager ARM templates for automating SQL database deployments beyond portal. Download templates, script repeated deployments, and see resources, storage accounts, and dependencies, with Bicep as an abstraction.
Learn relational query tools for Azure data, including the Azure portal query editor, Azure Data Studio, SQL Server Management Studio, and the SQL command line utility.
Explore Azure Table storage as a non-relational, semi-structured data store with entities identified by partition key and row key, offering flexible properties and no foreign keys.
Compare relational and non-relational databases in azure, and learn how to select cosmos db, data warehouse, and storage for IoT and analytics, guided by normalization and data integrity concepts.
Cosmos DB can be moved from public internet to a private network using firewalls and allowlists. Access relies on primary, secondary, or read-only keys.
Explore the modern data warehouse architecture, from diverse data sources and ingestion with Azure Data Factory to data lake, Azure Databricks, Synapse Analytics, Analysis Services, and Power BI.
LEARN AZURE DATABASE AND DATA PROCESSING TECHNOLOGIES IN ONE DAY!
The course is completely up-to-date with new requirements.
Up-to-date with the latest requirements for November 2024.
Complete preparation for the new DP-900 Azure Data Fundamentals exam.
The content of this exam was updated for the January 2024 changes.
Describe core data concepts (25-30%)
Describe how to work with relational data on Azure (20-25%)
Describe how to work with non-relational data on Azure (15-20%)
Describe an analytics workload on Azure (25-30%)
This brand-new course completely covers the DP-900 exam from start to finish. Always updated with the latest requirements. This course goes over each requirement of the exam in detail. If you have no background in databases and want to learn about them and want to learn more about database concepts and services within Azure, or have some background in databases and want to progress eventually to an Azure Data Engineer or Data Analyst type role, this course is a great resource for you.
Microsoft Azure is still the fastest-growing large cloud platform. The opportunities for jobs in cloud computing are still out there, and finding well-qualified people is the #1 problem that businesses have.
If you're looking to change your career, this would be a good entry point into cloud computing on the data side.
Sign up today!
Added English, Spanish, and Portuguese closed captions.