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

Prepare for the Azure Data Fundamentals Certification and pass! ✏️ Course developed by Andrew Brown of ExamPro. Check out the ExamPro YouTube channel: https://www.youtube.com/ExamProChannel 🔗 ExamPro Cloud Obsessed Certification Training: https://www.exampro.co ☁️ Data Concepts 🎤 (0:10:12) Auzre Core Data Related Services 🎤 (0:14:55) Types of Cloud Computing 🎤 (0:16:56) Azure Data Related Roles 🎤 (0:18:42) Database Administrator Common tools 🎤 (0:20:27) Data Engineering Common tools 🎤 (0:21:43) Data Analyst Common tools 🎤 (0:22:26) Data Overview 🎤 (0:23:43) Introduction to Data 🎤 (0:24:32) Data documents 🎤 (0:25:30) Data sets 🎤 (0:28:31) Data types 🎤 (0:32:15) Schema vs Schemaless 🎤 (0:34:09) Query and Querying 🎤 (0:35:54) Batch vs Stream processing 🎤 (0:38:30) Relational data 🎤 (0:40:35) Relational data Relationships 🎤 (0:42:07) Row store vs Column store 🎤 (0:43:44) Database Index 🎤 (0:45:05) Data Integegrity vs Data Corruption 🎤 (0:47:11) Normalized vs Denomralized data 🎤 (0:48:32) Pivot table 🎤 (0:50:10) Strongly consistent vs Eventually consistent 🎤 (0:51:33) Synchronus vs Asynchronous 🎤 (0:53:29) Non relational data 🎤 (0:54:29) Data source 🎤 (0:55:41) Data store 🎤 (0:56:32) Database 🎤 (0:57:56) Data warehouse 🎤 (0:59:39) Data mart 🎤 (1:00:36) Data lakes 🎤 (1:01:42) Data lakehouse 🎤 (1:03:12) Data structures 🎤 (1:04:02) Unstructured data 🎤 (1:04:47) Semi structured 🎤 (1:06:10) Semi structured Data Structures 🎤 (1:07:16) Semi structure JSON 🎤 (1:08:11) semi structure ORC 🎤 (1:09:39) semi structure Parquets 🎤 (1:10:35) semi structure AVRO 🎤 (1:11:25) Structured Data 🎤 (1:11:56) Data mining 🎤 (1:13:02) Data mining methods 🎤 (1:14:28) Data wrangling 🎤 (1:15:31) Ddata modeling 🎤 (1:17:18) ETL vs ELT 🎤 (1:19:18) Data analytics 🎤 (1:20:14) Key performance indicators KPI 🎤 (1:21:23) Data Analytic Techniques 🎤 (1:23:02) Microsoft One Drive 🎤 (1:24:20) Microsoft Sharepoint 🎤 (1:25:49) Data Core Concepts CheatSheet ☁️ Azure Synapse and Data Lake 🎤 (1:33:36) Azure Synapse Analytics 🎤 (1:35:26) Sypanse SQL and pools 🎤 (1:37:19) Synapse Key Features 🎤 (1:38:31) Azure Data Lake Gen 2 🎤 (1:40:03) Polybase 🎤 (1:40:50) Synapse ELT 🎤 (1:41:51) Azure Data Lake Analytics 🎤 (1:43:05) Azure Sypanse and Data Lakes CheatSheet ☁️ Account Storage 🎤 (1:44:25) Azure Blob Storage 🎤 (1:45:20) Azure Files 🎤 (1:47:14) Azure Storage Accounts CheatSheet ☁️ Power BI 🎤 (1:48:07) Business Intelligence 🎤 (1:48:40) Power BI 🎤 (1:51:29) Power BI Visualizations 🎤 (1:53:13) Power BI Embedded 🎤 (1:54:02) Power BI Interactive Reports 🎤 (1:55:36) Power BI Service and Dashboards 🎤 (1:56:47) Reports vs Dashboards 🎤 (1:57:47) Paginated Reports 🎤 (1:58:57) Power BI CheatSheet ☁️ Relational Databases 🎤 (2:00:38) Structured Query Language 🎤 (2:01:48) OLAP vs OLAP 🎤 (2:03:14) Open Source Relational Databases 🎤 (2:06:01) Read Replicas 🎤 (2:07:10) Citus Postgres Hyperscale 🎤 (2:08:03) Azure SQL Family 🎤 (2:10:30) Elastic pools 🎤 (2:11:45) Relational Databases CheatSheet ☁️ T SQL 🎤 (2:14:12) T SQL 🎤 (2:15:40) Data Defintion Language 🎤 (2:16:43) Data Manipulation Language 🎤 (2:18:02) Data Query Language 🎤 (2:19:08) Data Control Language 🎤 (2:19:36) Transaction Control Langauge 🎤 (2:20:22) SQL Document Comparsions 🎤 (2:21:10) T SQL CheatSheet ☁️ Database Security 🎤 (2:22:01) Connectivity Architecture 🎤 (2:23:13) Database Authentication 🎤 (2:24:41) Network Connectivity 🎤 (2:25:19) Azure Defender for SQL 🎤 (2:25:54) Azure Database Server Firewalls 🎤 (2:27:00) Always Encrypted 🎤 (2:27:47) Role Based Access Controls 🎤 (2:28:48) Transparent Data Encryption 🎤 (2:29:49) Dynamic Data Masking 🎤 (2:31:02) Private Links 🎤 (2:31:57) Database Security Cheatsheet ☁️ Azure Tables Cosmos DB 🎤 (2:34:13) Key Value Store 🎤 (2:35:40) Document Store 🎤 (2:36:33) Mongo DB 🎤 (2:38:35) Graph Database 🎤 (2:39:42) Apache Tinkerpop and Gremlin 🎤 (2:41:23) Azure Tables 🎤 (2:42:45) Azure Cosmos DB 🎤 (2:44:40) Azure Table Account Storage vs Cosmos DB 🎤 (2:46:39) Azure Tables and CosmosDB CheatSheet ☁️ Hadoop Systems 🎤 (2:48:29) Apache Hadoop 🎤 (2:49:57) Apache Kafka 🎤 (2:50:53) HDInsights 🎤 (2:52:05) Hadoop CheatSheet ☁️ Azure and Databricks 🎤 (2:53:21) Apache Spark 🎤 (2:55:04) Azure Databricks 🎤 (2:57:16) Apache Spark and Databricks CheatSheet ☁️ ELT and SQL Tools 🎤 (2:58:46) SQL Server Management Studio 🎤 (2:59:37) SQL Server Data Tools 🎤 (3:00:58) Azure Data Studio 🎤 (3:01:48) Azure Data Factory 🎤 (3:02:59) SQL Server Integration Services 🎤 (3:04:08) ETL and SQL Tools CheatSheet ☁️ Follow Alongs 🎤 (3:05:38) Install and Use Power BI 🎤 (3:08:17) Launch Azure SQL and Use Data Studio 🎤 (3:34:53) Use Azure SQL as data source in Power BI 🎤 (3:44:20) Use SSMS to perform a query on Azure SQL 🎤 (3:47:37) Create Blob and File storage 🎤 (3:57:36) Explore CosmosDB various NoSQL engines 🎤 (4:27:08) Create a ELT job from Azure SQL to Blob Storage 🎤 (4:33:06) Explore Azure Databricks 🎤 (4:39:49) Explore Azure Synapse Analytics 🎤 (4:44:47) Cleanup