Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

freeCodeCamp

Azure Data Fundamentals Certification (DP-900) - Full Course to PASS the Exam

via freeCodeCamp

Overview

This course covers Azure Data Fundamentals Certification preparation, focusing on data concepts, Azure Synapse, Data Lake, Account Storage, Power BI, Relational Databases, T-SQL, and Database Security. The course aims to teach data-related roles, common tools, data types, processing methods, data structures, data lakes, BI tools, SQL, database security, and more. The teaching method includes lectures on various topics related to Azure data services and technologies. The course is intended for individuals looking to obtain the Azure Data Fundamentals Certification and enhance their knowledge of Azure data services and tools.

Syllabus

Auzre Core Data Related Services.
Types of Cloud Computing.
Azure Data Related Roles.
Database Administrator Common tools.
Data Engineering Common tools.
Data Analyst Common tools.
Data Overview.
Introduction to Data.
Data documents.
Data sets.
Data types.
Schema vs Schemaless.
Query and Querying.
Batch vs Stream processing.
Relational data.
Relational data Relationships.
Row store vs Column store.
Database Index.
Data Integegrity vs Data Corruption.
Normalized vs Denomralized data.
Pivot table.
Strongly consistent vs Eventually consistent.
Synchronus vs Asynchronous.
Non relational data.
Data source.
Data store.
Database.
Data warehouse.
Data mart.
Data lakes.
Data lakehouse.
Data structures.
Unstructured data.
Semi structured.
Semi structured Data Structures.
Semi structure JSON.
semi structure ORC.
semi structure Parquets.
semi structure AVRO.
Structured Data.
Data mining.
Data mining methods.
Data wrangling.
Ddata modeling.
ETL vs ELT.
Data analytics.
Key performance indicators KPI.
Data Analytic Techniques.
Microsoft One Drive.
Microsoft Sharepoint.
Data Core Concepts CheatSheet.
Azure Synapse Analytics.
Sypanse SQL and pools.
Synapse Key Features.
Azure Data Lake Gen 2.
Polybase.
Synapse ELT.
Azure Data Lake Analytics.
Azure Sypanse and Data Lakes CheatSheet.
Azure Blob Storage.
Azure Files.
Azure Storage Accounts CheatSheet.
Business Intelligence.
Power BI.
Power BI Visualizations.
Power BI Embedded.
Power BI Interactive Reports.
Power BI Service and Dashboards.
Reports vs Dashboards.
Paginated Reports.
Power BI CheatSheet.
Structured Query Language.
OLAP vs OLAP.
Open Source Relational Databases.
Read Replicas.
Citus Postgres Hyperscale.
Azure SQL Family.
Elastic pools.
Relational Databases CheatSheet.
T SQL.
Data Defintion Language.
Data Manipulation Language.
Data Query Language.
Data Control Language.
Transaction Control Langauge.
SQL Document Comparsions.
T SQL CheatSheet.
Connectivity Architecture.
Database Authentication.
Network Connectivity.
Azure Defender for SQL.
Azure Database Server Firewalls.
Always Encrypted.
Role Based Access Controls.
Transparent Data Encryption.
Dynamic Data Masking.
Private Links.
Database Security Cheatsheet.
Key Value Store.
Document Store.
Mongo DB.
Graph Database.
Apache Tinkerpop and Gremlin.
Azure Tables.
Azure Cosmos DB.
Azure Table Account Storage vs Cosmos DB.
Azure Tables and CosmosDB CheatSheet.
Apache Hadoop.
Apache Kafka.
HDInsights.
Hadoop CheatSheet.
Apache Spark.
Azure Databricks.
Apache Spark and Databricks CheatSheet.
SQL Server Management Studio.
SQL Server Data Tools.
Azure Data Studio.
Azure Data Factory.
SQL Server Integration Services.
ETL and SQL Tools CheatSheet.
Install and Use Power BI.
Launch Azure SQL and Use Data Studio.
Use Azure SQL as data source in Power BI.
Use SSMS to perform a query on Azure SQL.
Create Blob and File storage.
Explore CosmosDB various NoSQL engines.
Create a ELT job from Azure SQL to Blob Storage.
Explore Azure Databricks.
Explore Azure Synapse Analytics.
Cleanup.

Taught by

freeCodeCamp.org

Reviews

Start your review of Azure Data Fundamentals Certification (DP-900) - Full Course to PASS the Exam

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.