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