Overview

Prepare for and pass the Azure Data Fundamentals Certification (DP-900) with this comprehensive 4-5 hour course. Dive deep into core data concepts, Azure Synapse Analytics, Data Lake storage, Power BI, relational databases, T-SQL, database security, Azure Tables, Cosmos DB, Hadoop systems, and ETL tools. Learn through detailed explanations of key topics, including data types, processing methods, analytics techniques, and various Azure services. Gain hands-on experience with practical follow-along sessions, exploring Power BI, Azure SQL, Blob storage, Cosmos DB, Databricks, and Synapse Analytics. Master essential skills for data professionals and confidently approach the DP-900 exam with this thorough, expertly-crafted training program.

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.