Azure Data Fundamentals Certification (DP-900) - Full Course to PASS the Exam
Offered By: freeCodeCamp
Course Description
Overview
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
Related Courses
Microsoft Azure Data Fundamentals DP-900 Exam PrepMicrosoft via Coursera Preparing for DP-900: Microsoft Azure Data Fundamentals Exam
Microsoft via Coursera DP-900: Microsoft Azure Data Fundamentals Course - Feb 2024
Udemy DP-900: Microsoft Azure Data Fundamentals in a Weekend
Udemy DP-900 Microsoft Azure Data Fundamentals Certification
Udemy